我想用调用存储过程,为什么GridView1 中没有显示呢? DataSet MyDataSet = new DataSet();
SqlDataAdapter DataAdapter = new SqlDataAdapter(); if (conn.State != ConnectionState.Open)
{ conn.Open(); }
System.Data.SqlClient.SqlCommand myCommand = new System.Data.SqlClient.SqlCommand("dbo.po_PrintOrder", conn);
myCommand.CommandType = CommandType.StoredProcedure; //添加输入查询参数、赋予值
myCommand.Parameters.Add("@ord_no", "10449400");
myCommand.Parameters.Add("@TrxDB", "Data_520");
myCommand.ExecuteNonQuery();
DataAdapter.SelectCommand = myCommand;
if (MyDataSet != null)
{
DataAdapter.Fill(MyDataSet, "table"); }
GridView1.DataSource = MyDataSet;
GridView1.DataBind(); //得到存储过程输出参数
Label1.Text = myCommand.Parameters["@TrxDB"].Value.ToString();
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
SqlDataAdapter DataAdapter = new SqlDataAdapter(); if (conn.State != ConnectionState.Open)
{ conn.Open(); }
System.Data.SqlClient.SqlCommand myCommand = new System.Data.SqlClient.SqlCommand("dbo.po_PrintOrder", conn);
myCommand.CommandType = CommandType.StoredProcedure; //添加输入查询参数、赋予值
myCommand.Parameters.Add("@ord_no", "10449400");
myCommand.Parameters.Add("@TrxDB", "Data_520");
myCommand.ExecuteNonQuery();
DataAdapter.SelectCommand = myCommand;
if (MyDataSet != null)
{
DataAdapter.Fill(MyDataSet, "table"); }
GridView1.DataSource = MyDataSet;
GridView1.DataBind(); //得到存储过程输出参数
Label1.Text = myCommand.Parameters["@TrxDB"].Value.ToString();
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货