how to select row from datagridview when column have cells is empty

John fugio 2447 21 Jul 2013

Hi there !

I tried this but nothing worked

Please help on this

private void selectrow()

{

int i;

for( i=0 ;i<dataGridView1 .Rows .Count -1;i++)

{

string row = dataGridView1.Rows[i].Cells["Name"].Value.ToString();

if (row =="")

{

sqlconn.Open();

string sqlquery = "select * from tbl... where id='" + dataGridView1.Rows[i].Cells

["id"].Value.ToString() + "'";

SqlCommand sqlcmd = new SqlCommand(sqlquery, sqlconn);

SqlDataAdapter sqlda = new SqlDataAdapter(sqlcmd);

DataTable dt = new DataTable();

sqlda.Fill(dt);

dataGridView1.DataSource = dt;

sqlconn.Close();

}

Ask by John fugio

Updated 24 Jul 2013

1 Answers

Manmohan Jha 24 Jul 2013

private void selectrow()
        {
            int i;
            for( i=0 ;i<dataGridView1 .Rows .Count -1;i++)
            {
                string row = dataGridView1.Rows[i].Cells["Name"].Value.ToString();
                if (row =="")
                {
                    sqlconn.Open();
                    string sqlquery = "select NameE from tbl... where id='" + dataGridView1.Rows[i].Cells
["id"].Value.ToString() + "'";
                    SqlCommand sqlcmd = new SqlCommand(sqlquery, sqlconn);
                    SqlDataReader dr=cmd.ExecuteReader();
                    while(dr.Read())
                    {
                    dataGridView1.Rows[i].Cells["Name"].Value=dr["Name"].ToString();
                    }
                    sqlconn.Close();
                }
            }           
        }

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

how to select row from datagridview when column have cells is empty

Can you answer this question?

1 Answers