SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand1.CommandText,sqlConnection1.ConnectionString);
应该是
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand1.CommandText,sqlConnection1);
吧!
最好是SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(CommandText,sqlConnection1);
CommandText是string型的,值为sql语句
你用SqlDataAdapter了,再用sqlCommand没必要了
应该是
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand1.CommandText,sqlConnection1);
吧!
最好是SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(CommandText,sqlConnection1);
CommandText是string型的,值为sql语句
你用SqlDataAdapter了,再用sqlCommand没必要了
这句,第二个参数应该是一个连接,而不是连接字符串,改成
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand1.CommandText,sqlConnection1);
sqlDataAdapter.Fill(DBSet);
这个可能错了,应该是:
SqlConnection conn = new SqlConnection(ConnectionString)
conn.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(SqlString,conn)