hello dear I am in problem to load data in dropdown list by coding. ItemCode if any body help me best regurds.

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) { SqlConnection con = new SqlConnection(strConnString); if (!IsPostBack) { DropDownList1.Items.Add("Choose ItemCode"); con.Open(); str = "select * from employee"; com = new SqlCommand(str, con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader["ItemCode"].ToString()); } reader.Close(); con.Close(); } }

Answer

how to load data in dropdownlist in asp.net?

Rowshan Ali

12y

1.7k

hello dear
I am in problem to load data in dropdown list by coding.

ItemCode

Answers (1)

Next Recommended Forum

Editing records

Combining 2 gridviews

Forum Statistics

Please welcome our newest member Pavan A.
3,083,254 users have contributed to 147,418 threads and 483,473
In the past 24 hours, we have 14 new threads, 28 new posts, and 58 new users.
In last week, the most popular thread is 'System.Data.SqlClient'.

Upcoming Events

View all

Excel Automation with Power Automate : Automate Your Business Processes - Ep.3
Global Azure Bootcamp - Rasipuram
Software Architecture Conference - 2025