Retrieve data from sqlserver to dropdown list .

Question

I have entered data into textbox and stored in sql server in the page1. Now i want to retrieve that entered data into dropdown list and also when that category appears in dropdownlist , i have a textbox where i can select a category from dropdownlist and enter the data related to that category in page 2.. In page 3 , i want a gridview to display the contents in the dropdown list ....

please help me out. i am new into .net

Thanks and regards
Antony

Pankaj Pandey · Answer

hello On third page pic a ddl with autopostback true property. onselectedindexchanged=DropDownList1_SelectedIndexChanged> on page load... write this code.. using System.Data; using System.Data.SqlClient; if(!Page.IsPostBack) { SqlConnection conn = new SqlConnection(@server=servername;User Id=sa;Password=yourpassword;Initial Catalog=databasename); SqlCommand cmd = new SqlCommand(select yourcolumn from your table1 conn); cmd.CommandTimeout = 0; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); DropDownList1.DataSource = ds; DropDownList1.DataTextField = column name; DropDownList1.DataValueField = column name; DropDownList1.DataBind(); } on ddl selectedindexchanged event write this code protected void DropDownList1_SelectedIndexChanged(object sender EventArgs e) { SqlConnection conn = new SqlConnection(@server=servername;User Id=sa;Password=yourpassword;Initial Catalog=databasename); SqlCommand cmd = new SqlCommand(select * from your table1 where categoryname=+DropDownList1.SelectedItem.ToString()+ conn); cmd.CommandTimeout = 0; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource=ds; GridView1.DataBind(); } mark as answered if its helpful. thanks

Pankaj Pandey · Answer

hiii for page 2.. add namespace--- using System.Data; using System.Data.SqlClient; add this code to yout page_load event after put your real data(database nametablenamefieldname etc..) SqlConnection conn = new SqlConnection(@server=servername;User Id=sa;Password=yourpassword;Initial Catalog=databasename); SqlCommand cmd = new SqlCommand(select yourcolumn from your table1 conn); cmd.CommandTimeout = 0; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); DropDownList1.DataSource = ds; DropDownList1.DataTextField = column name; DropDownList1.DataValueField = column name; DropDownList1.DataBind(); after that on your button click event write this code..to save data... SqlConnection conn = new SqlConnection(@server=servername;User Id=sa;Password=yourpassword;Initial Catalog=databasename); SqlCommand cmd = new SqlCommand(insert into table2 (ddlfieldttextfield) values(+DropDownList1.SelectedItem.Text++TextBox1.Text+) conn); cmd.CommandTimeout = 0; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); if i am going in right direction then do it and then tell me..i'll give code for page 3.

antony victor · Answer

Answered. thanks to pankaj sir.

antony victor · Answer

yes pankaj sir  this code seems to be working fine and i m grateful to u.. can u help me out with the third page please...

Sunny Sharma · Answer

Hi antony Consider forming the question properly so that we better understand your requirements. Please remember that we cannot read your mind/HardDisk. Please explain a little more.