DropDownList with TextBox

Question

Hello sir I am working in asp.net and use dropdownlist with textbox. I want to insert textbox value in dropdownlist with database also . please define a some code for this problem.

waris khan · Answer

This is not working please give me any other solution.

Satyapriya Nayak · Answer

Hi Davin Untitled Page Text=Insert /> 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_with_TextBox { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; string str; void showdrop() { SqlConnection con = new SqlConnection(connStr); if (!IsPostBack) { DropDownList1.Items.Add(Choose Name); con.Open(); str = select * from employee; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader[ename].ToString()); } reader.Close(); con.Close(); } } protected void btn_insert_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(connStr); con.Open(); com = new SqlCommand(insert into employee values(@ename) con); com.Parameters.AddWithValue(@ename TextBox1.Text); com.ExecuteNonQuery(); con.Close(); } protected void Page_Load(object sender EventArgs e) { showdrop(); } } } Thanks