vs05 C#连接 SQL05 语句

webconfig:

<appSettings>
<add key="ConnectionString" value="server=.;database=shujuku;uid=sa;pwd=123" />
</appSettings>

1.gridview:

SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from 表", conn);
DataSet ds = new DataSet();
try
{
da.Fill(ds, "testTable");
this.GridView1.DataSource = ds.Tables["testTable"];
this.GridView1.DataBind();
}
catch (Exception error)
{
Response.Write(error.ToString());
}
finally
{
conn.Close();
}

2.DataList:

SqlConnection conn = new SqlCo