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();
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()
}
}