How to Check Table Cell Value

What is this Rajkiran.. I gone into depression after shoing your codes.

Bro i was asked a very easy question and found the ans on a blog. I uses sql query SELECT with a WHERE clause and got the result and the Codes is very easy and Simple.

the idea i got from http://www.informit.com/articles/article.aspx?p=167930

con.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from Stock where qty <= 5 ", con);
DataTable dt = new DataTable();
sda.Fill(dt);
Low_stock_grid.Rows.Clear();
foreach (DataRow dr in dt.Rows)
{
int n = Low_stock_grid.Rows.Add();
Low_stock_grid.Rows[n].Cells[0].Value = dr[0].ToString();
Low_stock_grid.Rows[n].Cells[1].Value = dr[1].ToString();
}
con.Close();

1 Reply

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

Praveen Maurya8y ago
What is this Rajkiran.. I gone into depression after shoing your codes.

Bro i was asked a very easy question and found the ans on a blog. I uses sql query SELECT with a WHERE clause and got the result and the Codes is very easy and Simple.

the idea i got from http://www.informit.com/articles/article.aspx?p=167930
con.Open();

            SqlDataAdapter sda = new SqlDataAdapter("select * from Stock where qty <= 5  ", con);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            Low_stock_grid.Rows.Clear();
            foreach (DataRow dr in dt.Rows)
            {
                int n = Low_stock_grid.Rows.Add();
                Low_stock_grid.Rows[n].Cells[0].Value = dr[0].ToString();
                Low_stock_grid.Rows[n].Cells[1].Value = dr[1].ToString();

            }
            con.Close();