What is a variable in asp?
No Answer is Posted For this Question
Be the First to Post Answer
Explain how do you initiate a string without escaping each backslash?
Define collection?
What is the difference between 1.1 and 2.0 .Net framework?
IN THREE TIER AMONG THREE LAYERS WHICH ONE IS INDEPENDENT LAYER AND HOW?
What do the abbreviations asp and jsp stand for?
How do I save an aspx file?
What are asp controls?
which sdlc model was used for whatsapp?
SAP Design Studio Reporting Tool for beginners
using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class Default2 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { SqlConnection cn = new SqlConnection("Data Source =Prg1; Initial Catalog= DBTEST; Integrated Security = True"); cn.Open(); DataSet ds= new DataSet (); string str = "DB_test"; SqlDataAdapter da = new SqlDataAdapter(str, cn); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.CommandText = str; da.Fill(ds); Session["test"] = ds; } protected void btnSubmit_Click(object sender, EventArgs e) { DataSet ds1 = new DataSet(); ds1= (DataSet ) Session ["test"]; DataTable dt = ds1.Tables[0].Clone(); DataRow[] dr; string[] sqlInput = txtNo.Text.Split("-".ToCharArray ()); if (txtNo.Text != "" && txtWeight.Text != "") { if (sqlInput.Length > 1) { string query = ("t1 <=" + sqlInput[0] + " and " + "t2 >=" + sqlInput[1]); dr = ds1.Tables[0].Select(query); } else { string query = ("t1 <=" + txtNo.Text + "and " + "t2 >=" + txtNo.Text); dr = ds1.Tables[0].Select(query); } foreach (DataRow dr1 in dr) { dt.Rows.Add(dr1.ItemArray); } int i = Convert.ToInt32(dt.Rows[0] ["zone"].ToString()); DataTable dt1 = new DataTable(); DataRow[] dr2; dt1 = ds1.Tables[1].Clone(); dr2 = ds1.Tables[1].Select("weight=\'" + txtWeight.Text + "\'"); foreach (DataRow dr3 in dr2) { dt1.Rows.Add(dr3.ItemArray); } DataRow[] dr4; DataTable dt2 = ds1.Tables[2].Clone(); dr4 = ds1.Tables[2].Select(("weight=\'" + txtWeight.Text + "\'")); foreach (DataRow dr5 in dr4) { dt2.Rows.Add(dr5.ItemArray); } int j = Convert.ToInt32(dt.Rows[0] ["days"].ToString()); lbl.Text = dt1.Rows[0][i].ToString(); lbldays.Text = dt2.Rows[0][j].ToString(); } else { } } } ============================================================ ================ CREATE PROCEDURE DB_test AS BEGIN DECLARE @tb1 table ( t1 bigint, t2 bigint, zone bigint, days bigint ) insert into @tb1(t1,t2,zone,days) select (case when(charindex("-",No)-1>0) then convert (bigint,substring(No,1,charindex("-",No)-1)) else No end) as t1, (case when(charindex("-",No)-1>0) then convert(bigint,substring(No,charindex("-",No) +1,len(No))) else No end) as t2, Zone as zone, Days as days from [926] select * from @tb1 select * from zone select * from days end GO
Should user input data validation occur server-side or client-side?
What is the difference between asp and html? Or why asp is better than html?