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
Is asp better than php?
What is the difference between asp and saas?
If I want to build a shared assembly, does that require the overhead of signing and managing key pairs?
how can i show the data of sql table in different dropdown list?
What is pdf aspx?
6) Events in page life cycle?
What is Server-Side includes?
what are ASP Objects?
What are the methods in applet ? When is init(), start() called ?
Define managed code?
Explain the order of precedence for logical operators.
What is application object in asp?