How to retive the data using detail view in Dropdown List Visual Studio 2005

Question

Hi dear.. How to retive the data using detail view in Dropdown List Visual Studio 2005 using Sql Server Thanks&Regs Narasiman

Satyapriya Nayak · Answer

Hi Narasiman Try this... 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 Detailview_Dropdown { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlDataAdapter ad = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(); SqlDataAdapter sqlda; DataSet ds; string str; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { FillDropdown(); } } void FillDropdown() { SqlConnection conn = new SqlConnection(connStr); DropDownList1.Items.Add(Choose); conn.Open(); str = select * from Vendor; cmd = new SqlCommand(str conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader[VendorFName].ToString()); } reader.Close(); conn.Close(); } protected void DropDownList1_SelectedIndexChanged(object sender EventArgs e) { SqlConnection conn = new SqlConnection(connStr); conn.Open(); str = select * from Vendor where VendorFName like ' + DropDownList1.SelectedItem.Text + %'; cmd = new SqlCommand(str conn); sqlda = new SqlDataAdapter(cmd); ds = new DataSet(); sqlda.Fill(ds Vendor); conn.Close(); DetailsView1.DataSource = ds; DetailsView1.DataMember = Vendor; DetailsView1.DataBind(); } } } Thanks If this post helps you mark it as answer