parametro in store procedure

[realbenny]

string db_conn_str = ConfigurationSettings.AppSettings["db_conn_str"];
				SqlConnection dataConnection = new SqlConnection();
				dataConnection.ConnectionString =db_conn_str;
				dataConnection.Open();
				SqlCommand dataCommand = new SqlCommand();
				dataCommand.Connection=dataConnection;
				dataCommand.CommandType = CommandType.StoredProcedure;
				dataCommand.CommandText = "Cemat_sp_CaricaDG_ProgressReport";
				DataSet ds = null;
				UserInfo ui = null;
				ui = new UserInfo();
				ds = ui.UserInformation();
				DataTable dtUI = ds.Tables["DT_USERINFORMATION"];

				SqlDataAdapter myCommand = new SqlDataAdapter(dataCommand.CommandText,dataConnection);
				
				dataCommand.Parameters.Add(new SqlParameter("@utente", SqlDbType.VarChar , 100));
				dataCommand.Parameters["@utente"].Value=dtUI.Rows[0].ItemArray[3].ToString();
				DataSet ds1 = new DataSet();
				myCommand.Fill(ds1, "Servizi");
				DataGrid1.DataSource=ds1.Tables["Servizi"].DefaultView;
				DataGrid1.DataBind();
				dataConnection.Close();

ho bisogno di passare il parametro @utente al dataadapter, come posso fare? x' così mi dice che manca il parametro @utente

[djciko]

perche' usi due command ? (datacommand e mycommand)

[realbenny]

sì infatti ho risolto