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();
Subscribe to:
Post Comments (Atom)
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...
-
Code Output DECLARE @count INT DECLARE @ct INT DECLARE @print varchar(10) SELECT @count =10 WHILE @count > 0 BEGIN SELECT @pr...
-
****> **add name="ConToSOLDB" connectionString="Data Source=db-svr\MSSQL2008; Database=SOLV3; User Id=sa; password=...
-
In the Following code i am going to generate a Grid view with dynamic check box columns. as u can seen on the picture...
No comments:
Post a Comment