One Listbox showing all cities. If you select one city in list box the informat

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 / swapna

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

Answers were Sorted based on User's Feedback

One Listbox showing all cities. If you select one city in list box the information related to that ..

Answer / 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

One Listbox showing all cities. If you select one city in list box the information related to that ..

Answer / sathish

On select change event of the list box use the following code.

Dim con as new sqlconn("connectionstring")
con.open()
dim da as sqlda("select * from table where cityname=" &
listbox1.selecteditem)
dim ds as new dataset
da.fill(ds)

Is This Answer Correct ?

5 Yes

1 No

One Listbox showing all cities. If you select one city in list box the information related to that ..

Answer / yogaraj i

protected void ddlcity_SelectedIndexChanged(object sender,
EventArgs e)
{
if (ddlcity.SelectedValue == "Any of the city name")
{
DataSet ds = GetUserInfo();
GridviewCitycity.DataSource = ds;
GridviewCity.DataBind();
}
}

Is This Answer Correct ?

2 Yes

4 No

Post New Answer

More ASP.NET Interview Questions

What is meant by web application?

0 Answers

on modify statement, executeNonQuery returns zero rows affected even though there has been modification carried out sucessfully in the table.. can anyone tell me is this possible??? if yes, how..???

1 Answers ADITI,

Explain Apache web servers ? How can you get ASP.NET running in Apache web servers - why should you do this?

0 Answers Siebel,

Which authentication uses a combination of windows and iis authentication?

0 Answers

What is caching? What are different ways of caching in asp.net?

0 Answers

what is use to destroy an object? illustrate.

2 Answers Patni,

What is Web Gardening? How would using it affect a design ?

1 Answers Infogain,

Webconfig file is cofiguration of server or browser?