大虾来帮我看看这段代码有什么问题!!
public SqlConnection objConn;
public SqlDataAdapter objDa;
public DataSet objDs;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack)
{
Class.sharewareDb classDb = new shareware.Class.sharewareDb(ConfigurationSettings.AppSettings["strConn"].ToString());
string sql1 = "select top 10 softID,SoftName,SoftVer from SoftDown_SoftInfo order by SoftTime desc";
string sql2 = "select top 15 softID,softName,CatalogName from softDown_softInfo order by softTime desc";
DataSet objds;
objds = classDb.databind(sql1);
DataGrid1.DataSource = objds.Tables[0].DefaultView;
objds1 = classDb.databind(sql2);
DataGrid2.DataSource = objds.Tables[0].DefaultView;
objds2 = getDataSetBy(10,2,"xtgj");
DataGrid9.DataSource = objds2.Tables["xtgj"].DefaultView;
Page.DataBind();
}
}
public DataSet getDataSetBy(int topNum,int rootID,string tableName)
{
string sql5 = "select top "+topNum+" softid,softname from softdown_softinfo where rootid="+rootID;
objConn= new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
objDa = new SqlDataAdapter(sql5,objConn);
objDa.Fill(objDs,"'"+tableName.ToString()+"'");
return objDs;
}
值不能为空。参数名: dataSet
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.ArgumentNullException: 值不能为空。参数名: dataSet
源错误:
行 80: objConn= new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
行 81: objDa = new SqlDataAdapter(sql5,objConn);
行 82: objDa.Fill(objDs,"'"+tableName+"'");//提示这行出错!!
行 83:
行 84: return objDs;
源文件: c:\inetpub\wwwroot\shareware\default.aspx.cs 行: 82
堆栈跟踪:
[ArgumentNullException: 值不能为空。
参数名: dataSet]
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
shareware._Default.getDataSetBy(Int32 topNum, Int32 rootID, String tableName) in c:\inetpub\wwwroot\shareware\default.aspx.cs:82
shareware._Default.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\shareware\default.aspx.cs:70
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()