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

Posted by Fugio under C# on 7/21/2013 | Points: 10 | Views : 1718 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi there !
how to select row from datagridview when column have cells is empty
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();
}

}

}

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Nadeemshaik on: 7/22/2013 [Member] Starter | Points: 25

0	write like this private void selectrow() { int i; for( i=0 ;i<dataGridView1 .Rows .Count -1;i++) { if (string.isNullorEmpty(dataGridView1.Rows.Cells["Name"].Value.ToString())) { sqlconn.Open(); string sqlquery = "select * from tbl... where id='" + dataGridView1.Rows.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(); } } } Fugio, if this helps please login to Mark As Answer. \| Alert Moderator

write like this

private void selectrow() 

{ 

int i; 

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

{ 

if (string.isNullorEmpty(dataGridView1.Rows.Cells["Name"].Value.ToString())) 

{ 

sqlconn.Open(); 

string sqlquery = "select * from tbl... where id='" + dataGridView1.Rows.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(); 

} 





} 



}

Fugio, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts