string strConn="server=;Trusted_Cnnection=yes; database=northwind;";
SqlConnection ConnSql=new SqlConnection (strConn);
string strSQL="SELECT * FROM customers ";
SqlDataAdapter da=new SqlDataAdapter(new SqlCommand(strSql));
DataSet ds=new DataSet();//
da.Fill(ds,"customers");//使用DataAdapter的Fill方法(填充),调用SELECT命令
目的是将表customers数据从数据库中加到dataset中,但是这段代码没有达到目的,应该修改那一句?如何修改?
SqlConnection ConnSql=new SqlConnection (strConn);
string strSQL="SELECT * FROM customers ";
SqlDataAdapter da=new SqlDataAdapter(new SqlCommand(strSql));
DataSet ds=new DataSet();//
da.Fill(ds,"customers");//使用DataAdapter的Fill方法(填充),调用SELECT命令
目的是将表customers数据从数据库中加到dataset中,但是这段代码没有达到目的,应该修改那一句?如何修改?
sqlconnetion conn=new sqlconnetion("server=.;database=db;uid=sa;pwd=123");
sqldataadapter sda=new sqldataadapter("select * from customers" ,conn);
dataset ds=new dataset();
sda.fill(ds);
SqlDataAdapter da=new SqlDataAdapter(strSql,ConnSql); 还有你这连接字符串是不是写错了server=.
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Customers;", ConnSql);
DataSet ds = new DataSet();
da.Fill(ds, "Customers");
string strConn = @"server=(local); integrated security = true; database = northwind";
SqlConnection ConnSql=new SqlConnection (strConn);
string strSQL="SELECT * FROM customers ";
SqlDataAdapter da=new SqlDataAdapter(new SqlCommand(strSql));
SqlDataAdapter da = new SqlDataAdapter(strSQL, ConnSql);
DataSet ds=new DataSet();
da.Fill(ds,"customers");