protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //string txtSession = " "; if (Session["IDNumber"] == null) { } else { string Id = Session["IDNumber"].ToString(); bll = new BusinessLogicLayer(); try { doc = new Docket(); } catch (Exception) { } } } protected void grdInvolvedDockets_SelectedIndexChanged(object sender, EventArgs e) { doc = new Docket(); bll = new BusinessLogicLayer(); Session["DocketName"] = grdInvolvedDockets.SelectedRow.Cells[1].Text; doc.DocketName = Session["DocketName"].ToString(); bind(doc); } public void bind(Docket doc) { doc = new Docket(); using (SqlConnection con = new SqlConnection("Data Source=KEVIN-PC;Integrated Security=true;Initial Catalog=E-Docket1")) { con.Open(); SqlCommand cmd = new SqlCommand("spLoadDevelopment", con); string result = Session["DocketName"].ToString(); doc.DocketName = result; SqlParameter param = new SqlParameter("@DocketName", doc.DocketName); cmd.Parameters.AddWithValue("@DocketName", doc.DocketName.ToString()); string new1; new1 = cmd.ExecuteScalar().ToString(); //lblDetails.Text = result; } }
ALTER PROCEDURE [dbo].[spLoadDevelopment] -- Add the parameters for the stored procedure here @DocketName varchar(50) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT [Development] FROM DOCKET WHERE DocketName = @DocketName END
new1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)