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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ASP Interview Questions

Where will you code OPTION EXPLICIT in an ASP application? WHY?

1 Answers  


What data types does the rangevalidator control support?

0 Answers  


What is asp in web?

0 Answers  


What is the Order of precedence for LOGICAL Operators in ASP?

1 Answers  


Name the data types which does the rangevalidator control support?

0 Answers  


How do I open aspx file on mac?

0 Answers  


Name the data type should you use if you want an 8-bit value thats signed?

0 Answers  


What is asp cookies?

0 Answers  


What's the purpose of using BUFFER property?

2 Answers  


What are Constants? How will you declare a constant?

1 Answers  


What is the use of global.asax?

0 Answers  


How to use XML file as a database in the ASP

1 Answers  


Categories