Hi, The procedure: ALTER PROCEDURE matthieu77.GetUserByName ( @Nom nvarchar ) AS SELECT UserID, Nom FROM Users WHERE Nom=@Nom RETURN The code that calls this proc: SqlParameter param = new SqlParameter ("@Nom",SqlDbType.NVarChar); param.Direction=ParameterDirection.Input; param.Value="Bonjour"; SqlDataAdapter ad = new SqlDataAdapter(); ad.SelectCommand = new SqlCommand(); ad.SelectCommand.Connection = sqlConnection1; ad.SelectCommand.CommandText = "GetUserByName"; ad.SelectCommand.CommandType =CommandType.StoredProcedure; ad.SelectCommand.Parameters.Add(param); ad.Fill(dataSet11,"Users"); DataGrid1.DataBind(); If I replace in the stored procedure Nom='Bonjour' it works fine. Regards, Matthieu

Hi, I'm doing ASP.NET application. What is the type of the SqlParameter.Value to call a stored procedure expecting a nvarchar parameter? I tried to simply use a string, but it fails (code compiles, but the stored procedure returns nothing). I tried also to cast the string to a SqlDbType.Nvarchar, but I didn't manage. Thanks for help, sorry if I'm not clear ... Matthieu

Hello, Here is my question: I have a DataGrid attached to a DataTable in a DataSet, filled with a Xml file. I display the DataGrid onto a web page. I would like to display only a set of the DataGrid columns. How can I suppress columns from a DataGrid ? I would like to add a new column to the datagrid, filled with data from a second DataTable in the dataSet, following a relation between the two tables (there is a key column ID and a column name in the second DataTable, and there is a column ID_L in the first DataTable, I want to replace each ID_L with the corresponding name). Thanks a lot for your help Matthieu

But what do I have to do to configue the application in IIS ? Thanks a lot, Matthieu

Hi, When trying to open an ASP.NET project (found on this site), I have the following error: Unable to open Web project 'Account'. The file path 'C:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\UserAccountLogin' does not correspond to the URL 'http://Localhost:/Account'. The two need to map to the same server location. HTTP Error 404: Object Not Found. What do I have to do to open this project in Visual Studio ? Regards, Matthieu

Hi, How can I clean the console in a C# console application ? (juste like the cls dos command). Regards, Matthieu

Hi, How to launch an external programm from the application, like the C commanc System ("filename") would do ? Regards, Matthieu

Hi, How can I add items in a ListBox ? Regards, Matthieu

Thanks Itanium, but that's not what I want to do. s1[0]="hello" s1[1]="world" s2[0]="good" s2[1]="luck" and I want to create a new string array like this: s1[0]="hello" s1[1]="world" s1[2]="good" s1[3]="luck" Thanks a lot for help Matthieu

Hi, First of all, I'm new on CodeProject, so quick introducing: my names is Matthieu, I'm 26yo and live in France. I start learning C# and I get stuck at the (easy?) following: I have 2 string arrays, and I want to copy the first at the end of the second. I used Array.CopyTo method but it fails because the destination array is not large enough. How can I increase the size of the dest string array ? Thanks a lot for help, Matthieu