C#的SQL数据库高手请解答
电脑王杨扬 2002-12-15 12:34:54 private void frmMain_Load(object sender, System.EventArgs e)
{
string source="Initial Catalog=YY图书馆;Data Source=localhost;Integrated Security=SSPI;";
string select="SELECT * FROM 图书信息库";
SqlConnection myConn=new SqlConnection(source);
SqlDataAdapter myDataAdapter=new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand(select,myConn);
SqlCommandBuilder myCB=new SqlCommandBuilder(myDataAdapter);
myConn.Open();
DataSet myDataSet=new DataSet();
try
{
myDataAdapter.Fill(myDataSet,"图书信息库"); //到这句总说系统错误!!!
dtgList.DataSource = myDataSet;
}
finally
{
myConn.Close();
}
}
系统对应的一个SQL数据库:YY图书馆,其中一个表“图书信息表”
请指点!急等!