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
What are the methods in Session Object?
What is full form of aspx?
What is asp software?
I am not doing well in my oracle class and desparetly need some help. My main problem is the join chapter. I am very frustrated right now because I got my first zero in my in school lastweek. I excell in every other subject except oracle. I really would like to learn the program, but it looks dim for me right now and it is too late to drop the class without getting 'F'. Can someone pleae help me. with this one because I only have a few days before my assignment is due. If you leave your email I will get intouch with you immediately. Thanks
when u r designing where how do u design other than drag and drop method in the project of asp.net
What is msmq? What is n-tier system?
what is execute dataset for sp
what is the full form MSWC?
What type of code is found in a code-behind class?
In how many ways you can track the Session?
In how many ways you can connect to the Database?
how we can establish the connectivity between front end and backend?(asp as front end and c# as back end)