关于SqlDataAdapter的简单问题求助,头都搞大了
public byte[] GetData(string rwbh)
{
SqlConnection sqlConn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
DataSet ds=new DataSet();
SqlDataAdapter sqlAdp=new SqlDataAdapter();
sqlAdp.SelectCommand.Connection=sqlConn;
sqlAdp.SelectCommand.CommandText="select * from 表1 where 字段1>'" + rwbh + "'";
sqlConn.Open();
sqlAdp.SelectCommand.ExecuteNonQuery();
sqlConn.Close();
sqlAdp.Fill(ds,"表1");
return dsCompress.CompressDS(ds);
}
上面的执行时会出错,但将:
SqlDataAdapter sqlAdp=new SqlDataAdapter();
sqlAdp.SelectCommand.Connection=sqlConn;
sqlAdp.SelectCommand.CommandText="select * from 表1 where 字段1>'" + rwbh + "'";
改成:
SqlDataAdapter sqlAdp=new SqlDataAdapter("select * from 表1 where 字段1>'" + rwbh + "'",sqlConn);
后却正常。不知什么这两句有什么区别?因为这个sqlAdp要重复用到,所以不便写成第二种样式。
???