How to Display data as per the DropdownList selection

Question

Sir I need your help to display data as per the dropDownList Selection. Please look at the following ScreeShot:- My intention is  when I select a name from Customer Name dropDownList I need to display the concerned room type roomPrice and paymentType in the following dropDownList. The SQL StoredProcedure I wrote for this function is:- Give me the C# code to implement this query.

Abhay Shanker · Answer

try as below public static DataSet Osvezi(string naziv_tablice) { try { using (SqlConnection konekcija = new SqlConnection(ConfigurationManager.AppSettings[skripta])) { konekcija.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = konekcija; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = Osvezi; cmd.Parameters.AddWithValue(@tablica naziv_tablice??DBNull.Value); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { // Fill the DataSet using default values for DataTable names etc DataSet dataset = new DataSet(); da.Fill(dataset); return dataset; } } } } catch (Exception ee) { //Obravnava napak } return null; }

Tirthak Shah · Answer

SqlConnection conn=new SqlConnection(Your Connection String); SqlCommand cmd=new SqlCommand(); Dataset dt=new Dataset(); public Dataset Filldropdown(adminmanager obj) { conn.open() cmd.CommandText=ShowbookingPeerCustomer cmd.commandtype=commandtype.storedprocerdure; SqlDataAdapter adpt=new SqlDataAdapter(cmdconn); adpt.filldata(dt); return dt; } Then In the dataset there are columns and you just give this column value to the dropdownlist. Ex:: drppaymenttype.selectedvaue=convert.toint32(dt.rows[0][payment Type].tostring());