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
difference between SAP R/2 and R/3
How does VaryByCustom work?
What do I have to do to make my code work with the security system?
Can any body send me Some Interview Questions of ASP.Net 2.0 or Later to my mail id that is gauravscott@gmail.com
Define common language specification (cls)?
Explain the difference between a namespace and an assembly name?
Define a variable in asp?
which is the bet long term & basic to advanced available course for asp.net in hydrabad plz reply me t my email address also thanking you sm.chishty@gmail.com
Define querystring collection in asp?
What is asp used for?
what is execute dataset for sp
Name the browsers that can access asp pages?