hi the connection string will change to the last user why?because you put it in static variable it's means that this variable is shared for all users of application .so when any user assign it,it has only the last value. for example if we have static variable called x.the first user assign it by 5 .the second user assign it by 10. it becomes 10 not 5 . don't use static variable in this case. Essam

hi you can use this simple code String conString="data source=localhost\SQLEXPRESS;initial catalog=New;integrated security=true"; SqlConnection cn = new SqlConnection(conString); SqlCommand cmdFillGrid = new SqlCommand("select * from myTable", cn); SqlDataAdapter adapter = new SqlDataAdapter(cmdFillGrid); DataSet ds = new DataSet(); adapter.Fill(ds, "myTable"); GridView1.DataSource = ds.Tables["myTable"]; GridView1.DataBind(); Essam Moustafa

hi my brother the code that i wrote is in c# you can convert it in vb.net easily. you don't need that the detailsview is postback or not because the code that i wrote can be implemented in ListBox Or DropDownList_SelectedIndexChanged Event if you try my code your problem will be solved. Essam Moustfa

hi after you fill your control as(listbox) you put this code in ListBox1_SelectedIndexChanged sqlconnection cn=new sqlconnection(); cn.ConnectionString = conString; SqlCommand cmd1 = new SqlCommand("select * from myTable where ID="+ListBox1.SelectedValue.ToString(), cn); SqlDataAdapter ad = new SqlDataAdapter(cmd1); dataset ds=new dataset(); ad.Fill(ds, "v"); DetailsView1.DataSource = ds.Tables["v"]; DetailsView1.DataBind(); TextBox1.Text = DetailsView2.Rows[1].Cells[1].Text; you can replace listbox with dropdownlist your brother Essam Moustafa

hi i want help you but your question is not clear plz write again your question clearly. Essam Moustafa

hi your code is correct and i tried it under a button,the page runs without errors. tell me where you put your code? if you put it in load event,take care because you will have an error if the detailsview isn't filled in load event. try your code in button click event. thanks Essam Moustafa