SqlDataAdapter要与SqlCommand联系起来,然后通过sqlDataAdapter fill DataSet
代码如下(用于水晶报表):
DataSet1 myDs=new DataSet1();
SqlConnection myConnection=new SqlConnection(connectionString);
SqlCommand myCommand=new SqlCommand("GetInfoTotal",myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@deptname", SqlDbType.VarChar,50);
myCommand.Parameters["@deptname"].Value =drpdept.SelectedItem.Text;
myCommand.Parameters.Add("@date1", SqlDbType.VarChar,20);
myCommand.Parameters["@date1"].Value =InpCStart.Text;
myCommand.Parameters.Add("@date2", SqlDbType.VarChar,20);
myCommand.Parameters["@date2"].Value =InpCEnd.Text;
SqlDataAdapter MyAdapter=new SqlDataAdapter(myCommand);
MyAdapter.Fill(myDs,"TotalInfo");
myrpt.SetDataSource(myDs);
InfoRpt.ReportSource=myrpt;