How to use a DataAdapter with stored procedure and parameter

Question

How to use a DataAdapter with stored procedure and parameter

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?

34

c# stored-procedures dataadapter

задан Tony Hinkle 10 June 2016 в 14:56

2 ответа

Возможно, в вашем коде отсутствует эта строка из примера Microsoft:

MyDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure

3

ответ дан 27 November 2019 в 16:08

Другие вопросы по тегам:

c# stored-procedures dataadapter

Похожие вопросы:

score 69 · Accepted Answer

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;
        }