2008-07-01

How to Add datas to data grid

con = new SqlConnection("server=DAMITH\\SQL2005;database=Test;user=sa;password=123;");
con.Open();
SqlDataAdapter thisadapter = new SqlDataAdapter("SELECT * FROM LoginTable ", con);
DataSet thisdataset=new DataSet();

thisadapter.Fill(thisdataset);
DataGrid1.DataSource =thisdataset ;
DataGrid1.DataBind();


con.Close();

No comments:

SQL Query Stuff

1 . By using this query can search any string contain within stored procedure, function or view SELECT object_name(id) FROM sys.sysc...