using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;namespace DataAdapterDemo
{
public class SQLAccess
{
private static SqlConnection conn = new SqlConnection(@"server=.\SQLExpress;database=AdapterDemo;Trusted_Connection=SSPI");
private SqlDataAdapter sda = new SqlDataAdapter();
private DataSet ds = null; public DataSet getDataSet()
{
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("select * from Demo", conn);
sda.SelectCommand = selectCommand;
sda.Fill(ds);
return ds;
}
catch
{
return null;
}
finally
{
conn.Close();
conn.Dispose();
sda.Dispose();
}
}
}
}
代码如上 但是报错 "值不能为空。\r\n参数名: dataSet"请问如何解决……
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;namespace DataAdapterDemo
{
public class SQLAccess
{
private static SqlConnection conn = new SqlConnection(@"server=.\SQLExpress;database=AdapterDemo;Trusted_Connection=SSPI");
private SqlDataAdapter sda = new SqlDataAdapter();
private DataSet ds = null; public DataSet getDataSet()
{
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("select * from Demo", conn);
sda.SelectCommand = selectCommand;
sda.Fill(ds);
return ds;
}
catch
{
return null;
}
finally
{
conn.Close();
conn.Dispose();
sda.Dispose();
}
}
}
}
代码如上 但是报错 "值不能为空。\r\n参数名: dataSet"请问如何解决……
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货