this.m_Dailydate=this.dateTimePicker1.Value;
this.m_WorkingProcedureID=this.cmbWorkingProcedureID.SelectedValue.ToString();
if (m_myConnection==null)
{
   m_myConnection=new SqlConnection(ConnectionString);
}
m_myConnection.Open();
string strSql ="exec LI_MargeDailyQuery '"+WorkingProcedureID+"','"+m_Dailydate+"'";
SqlDataAdapter sqlAdap=new SqlDataAdapter(strSql,SqlConn); 
DataSet ds=new DataSet();
sqlAdap.Fill(ds,"table");
datagrid.DataSource =ds.Tables["table"];
datagrid.DataBind();

解决方案 »

  1.   

    this.m_Dailydate=this.dateTimePicker1.Value;
    this.m_WorkingProcedureID=this.cmbWorkingProcedureID.SelectedValue.ToString();
    if (m_myConnection==null)
    {
    m_myConnection=new SqlConnection(ConnectionString);
    }
    m_myConnection.Open();
    string strSql ="exec LI_MargeDailyQuery '"+m_WorkingProcedureID+"','"+m_Dailydate+"'";
    SqlDataAdapter sqlAdap=new SqlDataAdapter(strSql,m_myConnection); 
    DataSet ds=new DataSet();
    sqlAdap.Fill(ds,"LI_MargeDailyQuery");
    dgMargeDaily.DataSource =ds.Tables["LI_MargeDailyQuery"]; dgMargeDaily.SetDataBinding(ds,"LI_MargeDailyQuery");
    我已搞定,谢谢 pengweihua(pwh),给分。