protected void BindPn(string CodHk) { string LtxtSql = string.Format("EXEC SP_PANTALLA_ADVICE 16,'','HIR','{0}','PN',0,0,0,{1},'01-1-2009','01-01-1900','01-01-1900'", CodHk.Trim(), Session["!dC!@"]); DdlPN.DataSource = Cnx.DSET(LtxtSql); DdlPN.DataTextField = "PN"; DdlPN.DataValueField = "Codigo"; DdlPN.DataBind(); }
protected void BindPn() { string LtxtSql = string.Format("EXEC SP_PANTALLA_ADVICE 16,'','','','PN',0,0,0,{0},'01-1-2009','01-01-1900','01-01-1900'", Session["!dC!@"]); DdlPN.DataSource = Cnx.DSET(LtxtSql); DdlPN.DataMember = "Datos"; DdlPN.DataTextField = "PN"; DdlPN.DataValueField = "Codigo"; DdlPN.DataBind(); }
protected void BindBDdlPN(string Pn) { DSTPSL = (DataSet)ViewState["DSTPSL"]; if (DSTPSL.Tables["PN"].Rows.Count > 0) { DdlPN.DataSource = DSTPSL.Tables[0]; DdlPN.DataTextField = "PN"; DdlPN.DataValueField = "Codigo"; DdlPN.DataBind(); } }
protected void BindDataDdl(string Accion) { DST = (DataSet)ViewState["DST"]; string VbPrmtr = ""; if (!Accion.Equals("")) { VbPrmtr = TxtRef.Text; } DdlPN.DataSource = DST.Tables[3]; DdlPN.DataTextField = "PN"; DdlPN.DataValueField = "Codigo"; DdlPN.DataBind(); DdlPN.Text = ViewState["PN"].ToString().Trim(); }
protected void BindPn(string Tipo) { Cnx.SelecBD(); using (SqlConnection sqlCon = new SqlConnection(Cnx.GetConex())) { string LtxtSql = "EXEC SP_PANTALLA_ADVICE 16,'','HIRSC',@Tp,'PN',0,0,0,@ICC,'01-1-2009','01-01-1900','01-01-1900'"; sqlCon.Open(); using (SqlCommand SC = new SqlCommand(LtxtSql, sqlCon)) { SC.Parameters.AddWithValue("@Tp", Tipo.Trim()); SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]); SqlDataAdapter SDA = new SqlDataAdapter(); SDA.SelectCommand = SC; SDA.Fill(DTPN); ViewState["DTPN"] = DTPN; DdlPN.DataSource = DTPN; DdlPN.DataTextField = "PN"; DdlPN.DataValueField = "Codigo"; DdlPN.DataBind(); } } }