In datagridview , How to get values from sql server and display in comboxcolumn ?

Question

0.00/5 (No votes)

See more:

I have a Grid in my windows application project .. In Grid , i have DROPDOWN in one column , in that column how to display data fetched from SQLSERVER .
Please see below .. please edit below program and make me to solve problem .. THANKS IN ADVANCE..

connstring();
conn.Open();
adap = new SqlDataAdapter("gvretrieve_ip", conn);

ds = new System.Data.DataSet();
adap.Fill(ds, "dt");

foreach (DataColumn DC in ds.Tables[0].Columns)
{

}

dataGridView2.DataSource = ds.Tables[0];

int index = 5;

DataGridViewComboBoxColumn newCol = new DataGridViewComboBoxColumn();
dataGridView2.Columns.Insert(index, newCol);
dataGridView2.Columns[index].HeaderText = dataGridView2.Columns[index + 1].HeaderText;
newCol.MaxDropDownItems = 4;

dataGridView2.Columns.RemoveAt(index + 1);

Posted 7-Dec-14 20:28pm

Bns Vigneshwaran

Updated 7-Dec-14 21:32pm

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Azziet · Answer 1 · 2014-12-07T20:41:00

Try this code

string strcon = @"Data Source=kp;Initial Catalog=Name;Integrated Security=True;Pooling=False";
        SqlConnection con;
        SqlCommand cmd;
        SqlDataAdapter da;
        DataTable dt;
        DataGridViewComboBoxColumn dgvCmb;
        public Form2()
        {
            InitializeComponent();
            grdcmd();
        }
        public void grdcmd()
        {
            con = new SqlConnection(strcon);
            con.Open();
            string qry = "Select * from Dbname";
            da = new SqlDataAdapter(qry, strcon);
            dt = new DataTable();
            da.Fill(dt);
            dgvCmb = new DataGridViewComboBoxColumn();
            foreach (DataRow row in dt.Rows)
            {
                dgvCmb.Items.Add(row["Fname"].ToString());
            }
            dataGridView1.Columns.Add(dgvCmb);
        }

syed shanu · Answer 2 · 2014-12-07T20:42:00

Solution 2

Check my Article hope this will help you.
you need to create a Cobobox template column and you can set the combobox datasource as your sql query.

C#

 dgvcombo.DataSource = dtsource;
 dgvcombo.DisplayMember = DisplayMember;
dgvcombo.ValueMember = ValueMember;

DataGridView Helper Class[^]

Posted 7-Dec-14 20:42pm

syed shanu

Comments

Bns Vigneshwaran 8-Dec-14 22:41pm

Hi syed ..Hope you doing good.. I saw ur article .. But i have one doubt .. you are using window controls in your demo or telerik controls ?

syed shanu 8-Dec-14 22:52pm

Hi,
if you have read my article you wont ask this question as you can see DatagridView helper class which means this is not telerik controls this is .net winform datagridView Grid Control.

Bns Vigneshwaran 9-Dec-14 2:19am

Sorry, Am New to .net . please answer

In your article , you are just designing , you are not fetching values from sql server to combox , right ?

syed shanu 9-Dec-14 2:22am

its demo program i pass the datatable to bind the result to combo box same like that you can pass your datatable to bind to combobox.Your datatable will be as your database result.
// ComboBox Column creation
ShanuDGVHelper.Templatecolumn(shanuDGV, ShanuControlTypes.ComboBox, "DGVComboColumn", "ComboCol", "Combo Column", true, 160, DataGridViewTriState.True, DataGridViewContentAlignment.MiddleCenter, DataGridViewContentAlignment.MiddleRight, Color.Transparent, dtName, "Name", "Value", Color.Black);
here you can see dtName - is Datatable
"Name", "Value" are combobox displaymember and value member