How to Display data as per the DropdownList selection

Bineesh Viswanath

13y1.6k.NET

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhay Shanker13y ago
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;
}
0
Tirthak Shah13y ago

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(cmd,conn);
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());
0