How to use a DataAdapter with stored procedure and parameter

Question

I want to fill a DataGridView control using DataAdapter. But I don't know how to do it since I'm using a stored procedure with parameter. Can someone cite an example please?

Answer 1

I got it!...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;         } 

Answer 2

 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;