string strConn = "Data Source=localhost;database=pubs;user id=sa;password=tiger;timeout=60";
SqlConnection ThisConn = new SqlConnection(strConn);
ThisConn.Open();
SqlCommand ThisCmd = new SqlCommand();
ThisCmd.CommandText = "Select * from authors";
ThisCmd.Connection = ThisConn;
SqlDataAdapter ThisDpr = new SqlDataAdapter();
DataSet ThisDst = new DataSet();
ThisDpr.SelectCommand = ThisCmd;
ThisDpr.Fill(ThisDst);
grdShow.DataSource = ThisDst;
grdShow.DataBind();