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();
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();
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),给分。