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
Do you know ASP? Are u willing to work in it?
What app opens aspx files?
Define file system object object?
Define session object?
Explain the different types of session state management options available with asp.net?
I have all files relating one project in ASP.... I want to make a Localhost for running like website........
What is wsdl file? (explain in detail)
What is an err object?
What is asp used for?
What is the use of global.asax?
Explain the difference between client-side script and server-side script?
What's the purpose of using BUFFER property?