Add combobox to dataGridView

Dealy

Hello,

I load data from a database into a dataGridView. How can I set one of the columns to combobox that loads data from a stored procedure?

Here's my code for loading data:

using (conn = new SqlConnection(connectionString))

{

SqlCommand cmd = new SqlCommand("SELECT_TASKS", conn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add(new SqlParameter("@UserID", System.Environment.UserName));

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

da.Fill(dt);

tasksGridView.DataSource = dt;

}

conn.Close();

Thank you in advance.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dealy12y ago
Thank you for the link, but this article is about inserting data from a Combo box, with specific data, to a database. What I am looking for is data to be loaded from database on a Combo box.
0
Munesh Sharma12y ago
go to this link
http://www.mindstick.com/Articles/6ad5e5a1-7802-403c-a85f-99296208b9ac/?ComboBox%20in%20DataGridView%20in%20C
0
Dealy12y ago
Yes.
0
Anurag Sarkar12y ago
Do you want data to be loaded on Combo box?
0