Problem while fetching records from sql server database

Ankit Kumar

10y829.NET

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

4 Replies

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

Ankit Kumar10y ago
hi Raj,
i had made a configuration related mistake and i have resolved it myself
Gokulraj Sankar10y ago
hi
Please share your error screen shot.
Ankit Kumar10y ago
Hi Raj,
It's not working.........
Gokulraj Sankar10y ago
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();
}