protected void ddlcity_SelectedIndexChanged(object sender, EventArgs e)

One Listbox showing all cities. If you select one city in
list box the information related to that particular city
should be displayed in Datagrid . How do you do that?

Question Posted / sathish

3 Answers
10088 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / sathish

protected void ddlcity_SelectedIndexChanged(object sender,
EventArgs e)
{
sqlConnection con= new sqlConnection(" ");
string str="select * from table where city ='" +
ddlcity.SelectItem.Text ="'";
sqlDataAdapter da= new slqDataAdapter(str,con)
dataset ds = new dataset;
da.fill(ds,"City");
dgview.datasource=ds.tables["City"];
dgview.dataBind();
}

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the two Layouts supported by a Web form in ASP.NET?

1071

List down the sequence of methods called during the page load.

919

Define common type system?

988

How to store checkbox value in database in asp.net mvc? : Asp.Net MVC

980

What is the difference between custom web user control and a custom web server control?

966

How to find last error which occurred in Asp.net ?

1273

When we use cookie less session? Explain its working?

1027

Is asp.net and .net same?

973

Explain how does asp page work?

1017

What is the difference between stored procedure vs function?

1049

Define the term Scavenging in Caching?

1040

What are the file extensions for razor views?

1148

What is inproc and outproc?

993

Is session server side or client side?

958

What is preprocessor in .net?

979