populating data to dropdown list and text field from sql table

Question

Hi Can you help me for populating data to dropdown list from sql server db table and when selecting the dropdown list the text box field must be loaded accordingly? example: If I select employee id (E0000001.....) in ddl the other textbox fields have to be loaded(namedepartmentdesignation...)

Naresh Avari · Answer

Sorry Karthika You have to set AutoPostBack property to true for the ddlEmp. onselectedindexchanged=ddlEmp_SelectedIndexChanged AutoPostBack=True> Then it will work. Plz make sure to like my answer if your problem solved....

Naresh Avari · Answer

Hi Let me give a sample: Dropdownlist with OnSelectedIndexChanged event and a TextBox: onselectedindexchanged=ddlEmp_SelectedIndexChanged> Bind ddlEmp in Page_Load like this: protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { string connStr = Declare Your connection string here using (SqlConnection con = new SqlConnection(connStr)) { con.Open(); using (SqlCommand cmd = new SqlCommand(SELECT EmployeeId FROM Employees con)) { using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { ListItem li = new ListItem(); li.Value = dr[EmployeeId].ToString(); li.Text = dr[ EmployeeId ].ToString(); ddlEmp.Items.Add(li); } } } } } } and in ddlEmp_selectedindexchanged: protected void ddlEmp_SelectedIndexChanged(object sender EventArgs e) { using (SqlConnection con = new SqlConnection(connStr)) { con.Open(); using (SqlCommand cmd = new SqlCommand(SELECT * FROM Employees WHERE employeeid=' + ddlEmp.SelectedValue + ' con)) { using (SqlDataReader dr = cmd.ExecuteReader()) { dr.Read(); if(dr.HasRows) { txt1.Text = dr[EmployeeName].ToString(); } } } } }

Aman Jen · Answer

Hi  I have modified the code as below...but now it is saying : There is no row at position 0. Dim sqlcmd As String = (select * From DP_Table Where P_id = ' & DropDownList1.SelectedItem.Value & ') Dim ad As New SqlDataAdapter(sqlcmd cn) Dim ds As New DataSet ad.Fill(ds DP_Table) TB1.Text = ds.Tables(DP_Table).Rows(0)(P_id).ToString TB2.Text = ds.Tables(DP_Table).Rows(0)(P_Name).ToString

Satyapriya Nayak · Answer

Hi Karthika Untitled Page onselectedindexchanged=DropDownList1_SelectedIndexChanged> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Dropdownlist_click_data_in_textbox { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; SqlCommand com; protected void Page_Load(object sender EventArgs e) { DropDownList1.AutoPostBack = true; SqlConnection con = new SqlConnection(strConnString); if (!IsPostBack) { DropDownList1.Items.Add(Choose id); con.Open(); str = select * from test; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader[id].ToString()); } reader.Close(); con.Close(); } } protected void DropDownList1_SelectedIndexChanged(object sender EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = select * from test where id=' + DropDownList1.SelectedItem.Text + '; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { TextBox1.Text = reader[name].ToString(); } reader.Close(); con.Close(); } } } Thanks

karthika neelamegam · Answer

Hi I can only see the data populated to dropdown list and the textbox is not getting loaded when I clicked the dropdown.please reply me ASAP

Santhosh Kumar Jayaraman · Answer

Load the combobox from sql server on pageload like this private void Form1_Load(object sender EventArgs e) { SqlDataAdapter ad = new SqlDataAdapter(select *from Regcon); DataSet ds = new DataSet(); ad.Fill(ds Reg); comboBox1.DataSource = ds.Tables[Reg].DefaultView; comboBox1.DisplayMember = name; comboBox1.ValueMember = name; } Then in the combobox SelectedIndexChanged event private void comboBox1_SelectedIndexChanged(object sender EventArgs e) { SqlDataAdapter ad = new SqlDataAdapter(select *from Reg where name=' + comboBox1.SelectedItem.ToString()+ ' con); DataSet ds = new DataSet(); ad.Fill(ds Reg); textBox1.Text = ds.Tables[Reg].Rows[0][Name].ToString(); textBox2.Text = ds.Tables[Reg].Rows[0][Department].ToString(); textBox3.Text = ds.Tables[Reg].Rows[0][Designation].ToString(); }