Come utilizzare un DataAdapter con stored procedure e parametro

Voglio riempire un controllo DataGridView usando DataAdapter. Ma non so come farlo poiché sto usando una stored procedure con parametro. Qualcuno può citare un esempio per favore?

Ho capito! … hehe

protected DataTable RetrieveEmployeeSubInfo(string employeeNo) { SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); try { cmd = new SqlCommand("RETRIEVE_EMPLOYEE", pl.ConnOpen()); cmd.Parameters.Add(new SqlParameter("@EMPLOYEENO", employeeNo)); cmd.CommandType = CommandType.StoredProcedure; da.SelectCommand = cmd; da.Fill(dt); dataGridView1.DataSource = dt; } catch (Exception x) { MessageBox.Show(x.GetBaseException().ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cmd.Dispose(); pl.MySQLConn.Close(); } return dt; } 
  SqlConnection con = new SqlConnection(@"Some Connection String"); SqlDataAdapter da = new SqlDataAdapter("ParaEmp_Select",con); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@Contactid", SqlDbType.Int).Value = 123; DataTable dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; 

Forse il tuo codice manca questa riga dall’esempio Microsoft:

 MyDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure 

Eccoci qui,

 DataSet ds = new DataSet(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; //database connection cmd.CommandText = "WRITE_STORED_PROC_NAME"; // Stored procedure name cmd.CommandType = CommandType.StoredProcedure; // set it to stored proc //add parameter if necessary cmd.Parameters.Add("@userId", SqlDbType.Int).Value = courseid; SqlDataAdapter adap = new SqlDataAdapter(cmd); adap.Fill(ds, "Course"); return ds; 
  public DataSet Myfunction(string Myparameter) { config.cmd.Connection = config.cnx; config.cmd.CommandText = "ProcName"; config.cmd.CommandType = CommandType.StoredProcedure; config.cmd.Parameters.Add("parameter", SqlDbType.VarChar, 10); config.cmd.Parameters["parameter"].Value = Myparameter; config.dRadio = new SqlDataAdapter(config.cmd); config.dRadio.Fill(config.ds,"Table"); return config.ds; } 
  SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = ; builder.UserID = ; //User id used to login into SQL builder.Password = ; //password used to login into SQL builder.InitialCatalog = ; //Name of Database DataTable orderTable = new DataTable(); // stored procedute name which you want to exceute using (var con = new SqlConnection(builder.ConnectionString)) using (SqlCommand cmd = new SqlCommand(, con)) using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; //Data adapter(da) fills the data retuned from stored procedure //into orderTable da.Fill(orderTable); } 
 SqlConnection con = new SqlConnection(@"Some Connection String");//connection object SqlDataAdapter da = new SqlDataAdapter("ParaEmp_Select",con);//SqlDataAdapter class object da.SelectCommand.CommandType = CommandType.StoredProcedure; //command sype da.SelectCommand.Parameters.Add("@Contactid", SqlDbType.Int).Value = 123; //pass perametter DataTable dt = new DataTable(); //dataset class object da.Fill(dt); //call the stored producer