Problem while fetching records from sql server database

Question

Dear Friends........ I facing a problem while trying to fetch records from sql server database in asp .net website i am using gridview control to show the records............. my project file is attached in as a zip

Ankit Kumar · Answer

hi Raj i had made a configuration related mistake and i have resolved it myself

Gokul Raj · Answer

hi Please share your error screen shot.

Ankit Kumar · Answer

Hi Raj It's not working.........

Gokul Raj · Answer

Hi Please use the below code in getdata.aspx.cs.I hope it will work for you. SqlConnection connec = new SqlConnection(ConfigurationManager.ConnectionStrings[connect].ToString()); connec.Open(); SqlCommand cmd = new SqlCommand(select * from Product_Detail where Product_Id=@pid connec); cmd.Parameters.Add(@pid SqlDbType.NVarChar).Value = DropDownList1.SelectedItem.Value; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); }