Hello -

I am trying to display the results of a parameterized stored stored procedure in a form. The datasource is supposed to be the dataset, correct? What is the datamember supposed to represent?

Any help will be greatly appreciated

Hi,

The procedure is the same as executing the command text in a manner.

The following is an example calling the Procedure:

conn = new SqlConnection(ConnectionString);

SqlCommand comm = new SqlCommand();

comm.Connection = conn;

comm.CommandType = CommandType.StoredProcedure;

comm.CommandText = "proaa"; // the name of procedure in the SQL Server

SqlParameter[] par = new SqlParameter[1];

par[0] = new SqlParameter("@ID",SqlDbType.Int);

par[0].Direction = ParameterDirection.Input;

par[0].Value = 1;

comm.Parameters.AddRange(par);

adapter = new SqlDataAdapter(comm);

dataset = new DataSet();

adapter.Fill(dataset,"dt01");

dataGridView1.DataSource = dataset;

dataGridView1.DataMember = "dt01";

The following link is for your reference:

HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET

If I misunderstood you, or you have other questions, please feel free to tell me.

Best regards,

Ling Wang

---

Please remember to click “Mark as Answer�on the post that helps you, and to click “Unmark as Answer�if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi,

The procedure is the same as executing the command text in a manner.

The following is an example calling the Procedure:

conn = new SqlConnection(ConnectionString);

SqlCommand comm = new SqlCommand();

comm.Connection = conn;

comm.CommandType = CommandType.StoredProcedure;

comm.CommandText = "proaa"; // the name of procedure in the SQL Server

SqlParameter[] par = new SqlParameter[1];

par[0] = new SqlParameter("@ID",SqlDbType.Int);

par[0].Direction = ParameterDirection.Input;

par[0].Value = 1;

comm.Parameters.AddRange(par);

adapter = new SqlDataAdapter(comm);

dataset = new DataSet();

adapter.Fill(dataset,"dt01");

dataGridView1.DataSource = dataset;

dataGridView1.DataMember = "dt01";

The following link is for your reference:

HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET

If I misunderstood you, or you have other questions, please feel free to tell me.

Best regards,

Ling Wang

---

Please remember to click “Mark as Answer�on the post that helps you, and to click “Unmark as Answer�if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi Shannon,

Ling has given an excellent example of how to assign the DataSource. Simply said, we cannot directly assign DataSet as DataSource. Instead we could assign the DataTable which resides inside the DataSet. If we want to set the DisplayMember and ValueMember, we could get the Column Names from that DataTable inside the DataSet. This is the common architecture regardless of any kind of data access in DotNet.


-- Chandramohan.P