[How Do I:] Pass Information From One Page to Another Using a Query Stringhttp://asp.netTue, 10 Mar 2009 07:35:05 GMTumbracoComments for [How Do I:] Pass Information From One Page to Another Using a Query StringenComment Posted by abelanethttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringThu, 26 Jun 2008 19:30:23 GMT00000000-0000-0000-000000005861Very good video - explained in a very understandable way. Thanks

]]>Comment Posted by j.shafeehttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringFri, 27 Jun 2008 05:16:10 GMT00000000-0000-0000-000000005862This is too cool!Thanks Chris Pels!

]]>Comment Posted by uwspstarhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringFri, 27 Jun 2008 09:40:03 GMT00000000-0000-0000-000000005863very nice video

]]>Comment Posted by zmb94http://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringFri, 27 Jun 2008 14:43:52 GMT00000000-0000-0000-000000005864The C# vesion isn't available.

]]>Comment Posted by kemaleminhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringSun, 29 Jun 2008 01:44:59 GMT00000000-0000-0000-000000005865Very basic and irrelevant video! at least it is not something that requires first page publishing on ASP.NET website. Building querystrings is something that every single person who is involved in web programming learns the very first thing.

The video should instead concantrate  

1) Security and Validation of querystrings

2) The limits and limitations of querystrings.

3) When and when not to use querystrings

4) comparison between page.transfer, previouspage. and other methods of retrieving form information and transferring to other target pages.

]]>Comment Posted by Nezdethttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringTue, 01 Jul 2008 12:56:40 GMT00000000-0000-0000-000000005866Nice video Chris!

Iam about to create a serachpage for my project. And Iam about to use querystring to send over searchinformation to the samepage (By samepage I mean, the results will be shown in the searchpage)

Do you recomend us to use the alternative that you showed on the vide

OR

Should we change the Form-tags Method="get"

Which one should you prefer, and why?

(My querystring picks upp all the unnecessary strings if i put the <form method=get>, it get's a bit dirty-querystring)

Hope you can answer this!!

THANKS

]]>Comment Posted by rhianahttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringTue, 01 Jul 2008 23:08:17 GMT00000000-0000-0000-000000005867@kemalemin: Please don't front urself

These are tutorials, it's suppose to be basic...

Nice Video Chris Pels, I've learned a lot from u

]]>Comment Posted by DMAsuncionhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringWed, 02 Jul 2008 02:45:06 GMT00000000-0000-0000-000000005868Thanks a lot, God Bless..

]]>Comment Posted by shailatlashttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringThu, 03 Jul 2008 03:31:41 GMT00000000-0000-0000-000000005869Hello Chris,

Can you please tell me what is the software you use to record the session ?

Thanks

]]>Comment Posted by sfrandyshttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringThu, 03 Jul 2008 14:55:25 GMT00000000-0000-0000-000000005870The link that is to be the C# version contains the VB version.  Could this please be changed?  Thanks

]]>Comment Posted by chaoslegion05http://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringThu, 10 Jul 2008 10:04:13 GMT00000000-0000-0000-000000005871The C# link contains the VB code!

]]>Comment Posted by tclonyemhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringThu, 10 Jul 2008 11:36:58 GMT00000000-0000-0000-000000005879Below, I've written the C# code for both code files:

1) Default.aspx.cs

namespace ASPQueryString

{

   public partial class _Default : System.Web.UI.Page

   {

       protected void Page_Load(object sender, EventArgs e)

       {

       }

       protected void btnSubmit_Click(object sender, EventArgs e)

       {

          string targetURL;

          targetURL = "Target1.aspx?";

          targetURL += "CustID=" + Server.UrlEncode(txtCustomerId.Text.Trim());

           targetURL += "&CustName=" + Server.UrlEncode(txtCustomerName.Text.Trim());

           targetURL += "&ProdID=" + Server.UrlEncode(txtProductID.Text.Trim());

           targetURL += "&ProdDesc=" + Server.UrlEncode(txtProductDescription.Text.Trim());

         Response.Redirect(targetURL);

       }

   }

}  

2) Target1.aspx.cs

namespace ASPQueryString

{

   public partial class Target1 : System.Web.UI.Page

   {

     protected void Page_Load(object sender, EventArgs e)

       {

        if ((Request.QueryString["CustID"] != null))

           {

               labCustID.Text = Request.QueryString["CustID"].ToString();

           }

        if ((Request.QueryString["CustName"] != null))

           {

              labCustName.Text = Request.QueryString[1].ToString();

           }

           if ((Request.QueryString["ProdID"] != null))

           {

               labProdID.Text = Request.QueryString["ProdID"].ToString();

           }

           if ((Request.QueryString["ProdDesc"] != null))

           {

               labProdDesc.Text = Request.QueryString[3].ToString();

           }

       }

   }

}  

]]>Comment Posted by ngonka2003http://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringTue, 15 Jul 2008 05:13:33 GMT00000000-0000-0000-000000005880Merci pour cette demonstration tres bien presentée.

]]>Comment Posted by asaterhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringFri, 22 Aug 2008 06:40:58 GMT00000000-0000-0000-000000005881Very nice video

Thank you

keep it coming

]]>Comment Posted by bsvnhllhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringThu, 28 Aug 2008 06:06:24 GMT00000000-0000-0000-000000005882this could have been more usefull

]]>Comment Posted by cyrussullivanhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringSat, 13 Sep 2008 15:38:48 GMT00000000-0000-0000-000000005883I am trying to figure out how to bind a query string to a form view item inserted event so that when i hit the insert button i will be taken to a page displaying the inserted data. So far I cant find a tutorial that says how to do that.

]]>Comment Posted by anisurrahmanhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringTue, 14 Oct 2008 16:56:33 GMT00000000-0000-0000-000000005884Thank you very much...

]]>Comment Posted by agoyalhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringWed, 15 Oct 2008 04:25:04 GMT00000000-0000-0000-000000005872This is a very helpful video tutorial.

]]>Comment Posted by ccgilsonhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringFri, 07 Nov 2008 08:13:11 GMT00000000-0000-0000-000000005874Very clear and helpful, but for me the video wastes too much time with setting up. The tutorial's title is: 'How Do I: Pass Information From One Page to Another Using a Query String' and not 'How Do I: Place basic controls into an HTML page, name them, position them and then pass Information From One Page to Another Using a Query String'

]]>Comment Posted by djaferhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringWed, 12 Nov 2008 08:14:10 GMT00000000-0000-0000-000000005875thanx

]]>Comment Posted by djibril_chimere_DIAWhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringSun, 30 Nov 2008 12:13:58 GMT00000000-0000-0000-000000005876Thanks! Jërëjëf !

]]>Comment Posted by Hamza_zararhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringMon, 01 Dec 2008 04:24:59 GMT00000000-0000-0000-000000005877very nice video :)

]]>Comment Posted by mdmkhttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringThu, 22 Jan 2009 07:44:20 GMT00000000-0000-0000-000000005878Its Really wonderfull!!

]]>Comment Posted by bohunthttp://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringFri, 13 Feb 2009 17:36:21 GMT00000000-0000-0000-000000005885Nice video.

]]>Comment Posted by Nilesh810http://asp.net/web-forms/videos/how-do-i/how-do-i-pass-information-from-one-page-to-another-using-a-query-stringTue, 10 Mar 2009 07:35:05 GMT00000000-0000-0000-000000005886I have two tables pre_enquiry & enquiry ,enquiryno is primary key of pre_enquiry table,username is also stored in it.In enquiry webform if i enter username then related enquiryno. should be autofilled in textbox ,& delete the record from pre_enquiry table

I have done following

public partial class EnquiryForm : System.Web.UI.Page

{

SqlConnection cn,cn1;

SqlCommand cmd;

//DataTable dt;

protected void Page_Load(object sender, EventArgs e)

{

// if (!IsPostBack)

//{

// cn = new SqlConnection(ConfigurationManager.ConnectionStrings["BruserConnectionString2"].ConnectionString);

// cmd = new SqlCommand("select EnquiryNo from Pre_Enquiry where(Uname=" + TextBox1.Text + ")");

// cn.Open();

// tr=cmd.ExecuteReader();

// while (tr.Read)

// {

// int i = tr["EnquiryNo"];

//}

// tr.Close();

//cn.Close();

//}

}

protected void Button2_Click(object sender, EventArgs e)

{

// cn = new SqlConnection(ConfigurationManager.ConnectionStrings["BruserConnectionString2"].ConnectionString);

// TxtEnqNo.Text = Convert.ToString(cmd = new SqlCommand("select EnquiryNo from Pre_Enquiry Where(Uname=" + TextBox1.Text + ");", cn));

// //TxtEnqNo.Text = Convert.ToString("EnquiryNo");

// cn.Open();

// cmd.ExecuteNonQuery();

// cn.Close();

}

protected void Button1_Click(object sender, EventArgs e)

{

cn = new SqlConnection(ConfigurationManager.ConnectionStrings["BruserConnectionString2"].ConnectionString);

//cmd = new SqlCommand("select EnquiryNo.,enqDate,Uname,BranhName,TelNo from Pre_Enquiry");

//cmd = new SqlCommand("Insert into enquiry values('" + DropDownList1.SelectedItem.Text + "','" + DropDownList2.SelectedItem.Text + "','" + TxtEnqNo.Text="select EnquiryNo from Pre_Enquiry where (Uname="+TextBox1.Text+")" + "','" + DropDownList3.SelectedItem.Text + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + Convert.ToInt32(TextBox3.Text) + "','" + Convert.ToInt32(TextBox4.Text) + "','" + Convert.ToInt32(TextBox5.Text) + "','" + DropDownList4.SelectedItem.Text + "/" + DropDownList6.SelectedItem.Text + "/" + DropDownList7.SelectedItem.Text + "','" + DropDownList5.SelectedItem.Text + "','" + TextBox6.Text + "','" + TextBox8.Text + "','" + RadioButtonList2.SelectedItem.Text + "','" + TextBox9.Text + "','" + RadioButtonList3.SelectedItem.Text + "','" + RadioButtonList4.SelectedItem.Text + "','" + RadioButtonList5.SelectedItem.Text + "','" + TextBox7.Text + "');", cn);

cmd = new SqlCommand("Insert into enquiry values('" + DropDownList1.SelectedItem.Text + "','" + DropDownList2.SelectedItem.Text + "','" + TxtEnqNo.Text + "','" + DropDownList3.SelectedItem.Text + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + Convert.ToInt32(TextBox3.Text) + "','" + Convert.ToInt32(TextBox4.Text) + "','" + Convert.ToInt32(TextBox5.Text) + "','" + DropDownList4.SelectedItem.Text + "/" + DropDownList6.SelectedItem.Text + "/" + DropDownList7.SelectedItem.Text + "','" + DropDownList5.SelectedItem.Text + "','" + TextBox6.Text + "','" + TextBox8.Text + "','" + RadioButtonList2.SelectedItem.Text + "','" + TextBox9.Text + "','" + RadioButtonList3.SelectedItem.Text + "','" + RadioButtonList4.SelectedItem.Text + "','" + RadioButtonList5.SelectedItem.Text + "','" + TextBox7.Text + "');", cn);

cn.Open();

cmd.ExecuteNonQuery();

cn.Close();

}

protected void TextBox1_TextChanged(object sender, EventArgs e)

{

//dt=new DataTable("Pre_Enquiry");

//tr = new DataTableReader(dt);

// cmd=new SqlCommand("select EnquiryNo from Pre_Enquiry where(Uname="+TextBox1.Text+")");

int i;

cn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["BruserConnectionString2"].ConnectionString);

cmd = new SqlCommand("select EnquiryNo from Pre_Enquiry where(Uname=@uname);", cn1);

cn1.Open();

SqlDataReader tr;

tr=cmd.ExecuteReader();

while (tr.Read())

{

i = Convert.ToInt32(tr["EnquiryNo"]);

TxtEnqNo.Text = Convert.ToString(i);

//TxtEnqNo.Text=cmd.Parameters.Add("@EnquiryNo").Value;

}

tr.Close();

cn1.Close();

}

}

]]>