如何在加载事件后面的代码中调用两个存储过程....... [英] how can you call two stored procedure inside code behind load event.......

问题描述

你可以在代码隐藏文件里面调用两个存储过程（page_load事件）。



网格视图和datalist有两个控件使用,,,,你怎么能调用两个程序???

  protected   void  Page_Load（ object  sender，EventArgs e）
 {
  if  （Page.IsPostBack ==  false ）
 {
 SqlConnection objConn =  new  SqlConnection （ConfigurationManager.ConnectionStrings [  BuildMyPCConnectionString]。ToString（））; 
 objConn.Open（）; 
 
 SqlCommand objCmd = objConn.CreateCommand（）; 
 objCmd.CommandType = CommandType.StoredProcedure; 
 objCmd.CommandText =   PR_ProductDetail_SelectByPK; 
 objCmd.Parameters.AddWithValue（  @ ProductID，Convert.ToInt32（Request.QueryString） [  ProductID]））; 
 
 SqlDataReader objSdr = objCmd.ExecuteReader（）; 
 
 dlProductDetail.DataSource = objSdr; 
 dlProductDetail.DataBind（）; 
} 
 
} 
 

这是针对datalist的......你怎么能为gridview调用存储过程....

解决方案

  protected   void  Page_Load （ object  sender，EventArgs e）
 {
  if （Page.IsPostBack = =  false ）
 {
 SqlConnection objConn =  new  SqlConnection（ConfigurationManager.ConnectionStrings [   BuildMyPCConnectionString]。ToString（））; 
 objConn.Open（）; 
 
 SqlCommand objCmd = objConn.CreateCommand（）; 
 objCmd.CommandType = CommandType.StoredProcedure; 
 objCmd.CommandText =   PR_ProductDetail_SelectByPK; 
 objCmd.Parameters.AddWithValue（  @ ProductID，Convert.ToInt32（Request.QueryString） [  ProductID]））; 
 
 SqlDataReader objSdr = objCmd.ExecuteReader（）; 
 
 dlProductDetail.DataSource = objSdr; 
 dlProductDetail.DataBind（）; 
  //   gridview代码开始 
 
 objCmd = objConn.CreateCommand （）; 
 objCmd.CommandType = CommandType.StoredProcedure; 
 objCmd.CommandText =   PR_ProductDetail_SelectByPK_two; 
 objCmd.Parameters.AddWithValue（  @ ProductID，Convert.ToInt32（Request.QueryString） [  ProductID]））; 
 
 SqlDataReader objSdr2 = objCmd.ExecuteReader（）; 
 
 grdProductDetail.DataSource = objSdr2; 
 grdProductDetail.DataBind（）; 
 
 objSdr.Close（）; 
 objSdr2.Close（）
 
 
} 
 
} 

< pre lang =vb> hi

如果您的绑定相同的数据 然后绑定阅读器对象 gridview 。 else create new command 和 datareader object 和绑定它。创建不同的sqlcommand object

请尝试以下..

  protected   void  Page_Load（ object  sender，EventArgs e）
 {
  if （Page.IsPostBack ==  false ）
 {
  //   for datalist  
 SqlConnection objConn =  new  SqlConnection（ConfigurationManager.ConnectionStrings [  BuildMyPCConnectionString ]的ToString（））; 
 objConn.Open（）; 
 
 SqlCommand objCmd = objConn.CreateCommand（）; 
 objCmd.CommandType = CommandType.StoredProcedure; 
 objCmd.CommandText =   PR_ProductDetail_SelectByPK; 
 objCmd.Parameters.AddWithValue（  @ ProductID，Convert.ToInt32（Request.QueryString） [  ProductID]））; 
 
 SqlDataReader objSdr = objCmd.ExecuteReader（）; 
 dlProductDetail.DataSource = objSdr; 
 dlProductDetail.DataBind（）; 
 
  //   for gridview  
 SqlCommand objCmd1 = objConn.CreateCommand （）; 
 objCmd1.CommandType = CommandType.StoredProcedure; 
 objCmd1.CommandText =   PR_ProductDetail_SelectByPK_Gridview; 
 objCmd1.Parameters.AddWithValue（  @ ProductID，Convert.ToInt32（Request.QueryString） [  ProductID]））; 
 
 SqlDataReader objSdr1 = objCmd1.ExecuteReader（）; 
 Gridview1.DataSource = objSdr1; 
 Gridview1.DataBind（）; 
 
 con.Close（）; 
 
} 
} 

Can u call the two store procedure inside the code behind file in(page_load event).

grid view and datalist there are two control used,,,,how can you call two procedure for that???

protected void Page_Load(object sender, EventArgs e)
   {
       if (Page.IsPostBack == false)
       {
           SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["BuildMyPCConnectionString"].ToString());
           objConn.Open();

           SqlCommand objCmd = objConn.CreateCommand();
           objCmd.CommandType = CommandType.StoredProcedure;
           objCmd.CommandText = "PR_ProductDetail_SelectByPK";
           objCmd.Parameters.AddWithValue("@ProductID", Convert.ToInt32(Request.QueryString["ProductID"]));

           SqlDataReader objSdr = objCmd.ExecuteReader();

           dlProductDetail.DataSource = objSdr;
           dlProductDetail.DataBind();
       }

   }

this is for datalist ...how can u call store procedure for gridview....

解决方案

protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack == false)
        {
            SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["BuildMyPCConnectionString"].ToString());
            objConn.Open();
 
            SqlCommand objCmd = objConn.CreateCommand();
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.CommandText = "PR_ProductDetail_SelectByPK";
            objCmd.Parameters.AddWithValue("@ProductID", Convert.ToInt32(Request.QueryString["ProductID"]));
 
            SqlDataReader objSdr = objCmd.ExecuteReader();
 
            dlProductDetail.DataSource = objSdr;
            dlProductDetail.DataBind();
//gridview code begins

 objCmd = objConn.CreateCommand();
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.CommandText = "PR_ProductDetail_SelectByPK_two";
            objCmd.Parameters.AddWithValue("@ProductID", Convert.ToInt32(Request.QueryString["ProductID"]));
 
           SqlDataReader  objSdr2 = objCmd.ExecuteReader();
 
            grdProductDetail.DataSource = objSdr2;
            grdProductDetail.DataBind();

objSdr.Close();
objSdr2.Close()


        }
 
    }

hi

if your binding same data to both then bind reader object to gridview also. else create new command and datareader object and bind it. create different sqlcommand object

Try below..

protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack == false)
        {
             //for datalist
            SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["BuildMyPCConnectionString"].ToString());
            objConn.Open();
 
            SqlCommand objCmd = objConn.CreateCommand();
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.CommandText = "PR_ProductDetail_SelectByPK";
            objCmd.Parameters.AddWithValue("@ProductID", Convert.ToInt32(Request.QueryString["ProductID"]));
 
            SqlDataReader objSdr = objCmd.ExecuteReader();
            dlProductDetail.DataSource = objSdr;
            dlProductDetail.DataBind();
            
            //for gridview
            SqlCommand objCmd1 = objConn.CreateCommand();
            objCmd1.CommandType = CommandType.StoredProcedure;
            objCmd1.CommandText = "PR_ProductDetail_SelectByPK_Gridview";
            objCmd1.Parameters.AddWithValue("@ProductID", Convert.ToInt32(Request.QueryString["ProductID"]));
 
            SqlDataReader objSdr1 = objCmd1.ExecuteReader();
            Gridview1.DataSource = objSdr1;
            Gridview1.DataBind();
            
            con.Close();

        }
    }

这篇关于如何在加载事件后面的代码中调用两个存储过程.......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！