测试插入代码段

   string strConn =ConfigurationSettings.AppSettings["ConnectionString"];
   SqlConnection myConn = new SqlConnection(strConn);
   Response.Write("</br>"+myConn.State.ToString());
   SqlDataAdapter myAdapter = new SqlDataAdapter("select * from  Titles",myConn);
   Response.Write("</br>"+myConn.State.ToString());
   DataSet ds =new DataSet();
   myAdapter.Fill(ds);
   Response.Write("</br>"+myConn.State.ToString());
   DataGrid1.DataSource = ds.Tables[0].DefaultView;
   Response.Write("</br>"+myConn.State.ToString());
   DataGrid1.DataBind();
   Response.Write("</br>"+myConn.State.ToString());