Cómo usar un DataAdapter con un procedimiento almacenado y un parámetro

Quiero llenar un control DataGridView usando DataAdapter. Pero no sé cómo hacerlo ya que estoy usando un procedimiento almacenado con parámetro. ¿Alguien puede citar un ejemplo, por favor?

¡Lo tengo! … jeje

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; 

Tal vez su código le falta esta línea del ejemplo de Microsoft:

 MyDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure 

Aquí vamos,

 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 
Intereting Posts