c# datagrid

Hi,

I am a newbie started learning c# coding recently, I have a datagrid connected with sql build to check some service status.

I have binded three different table to it, now i want to loop only through the flaged row (ie. if flag=1, it has to check status else it should not check them).

I have planned to do this by adding one text field and a button field on my asp page, when I set flag my page to "0" it should omit that row and loop through rest of the table.

using (SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString2"].ToString()))

{

DataTable dtJob = new DataTable();

da =

new SqlDataAdapter("SELECT originating_server, name, enabled, description, notify_email_operator, date_created, date_modified, last_run_date, last_run_time, owner FROM ServiceStatus", myConnection);

da.Fill(dtJob);

DataTable dtService = new DataTable();

da =

new SqlDataAdapter("SELECT* FROM WinServ ", myConnection);

da.Fill(dtService);

dtJob.Merge(dtService);

DataTable dtwebserv = new DataTable();

da =

new SqlDataAdapter("SELECT * FROM webserv ", myConnection);

da.Fill(dtwebserv);

dtJob.Merge(dtwebserv);

gvDetails.DataSource = dtJob;

gvDetails.DataBind();

gvDetails.DataSource = dtJob;

gvDetails.DataBind();

myConnection.Close();

pls help me !!!

Thanks and regards,

3 Replies

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

Bhushan Bhasme11y ago
HI bharatwaj vanamamalaihere You need to loop the whole grid view....and check out the flag ==1 else you need to mainten separate column whose visibility=false and you need to bind the flag column to it and by loping on it you need to chekc the flag status==1
bharatwaj vanamamalai11y ago
Hi,

thanks for replying, could you please elaborate??
Sreekanth Reddy11y ago
Perform it in CellFormating event of datagridview: private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { }