In 3-tier architecture, populate textboxes from database

Question

Hi Friends, Can anyone help me with this? How to fetch data directly from database table to textboxes when I clicked on edit button in grid view,using 3 tier architecture? I have a table in SQL server database.Upon clicking on edit in grid view, the text boxes must be filled with respective values from database table.I have used sqldatareader, but values are not binding.Any suggestions would be helpful. Thank u.

Ganesh babu · Answer

Here is the code DAL: public DataTable FetchDetails(string pid, string pname, string pcid, string sdesc, string desc, string qty, string prce, string len) { var a = new ArrayList(); SqlCommand cmd = new SqlCommand("spfetchdetail", con); con.Open(); cmd.ExecuteNonQuery(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pid", pid); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()){pid = sdr["P_id"].ToString(); pname = sdr["P_name"].ToString(); pcid = sdr["c_name"].ToString(); sdesc = sdr["P_shortdesc"].ToString(); desc = sdr["P_desc"].ToString(); qty = sdr["P_qty"].ToString(); prce = sdr["P_price"].ToString(); len = sdr["P_length"].ToString(); a.Add(pid); a.Add(pname); a.Add(pcid); a.Add(sdesc); a.Add(desc); a.Add(qty);a.Add(prce); a.Add(len); } return dt; } BAL: public object fetchdetail(string pid, string pname, string pcid, string sdesc, string desc, string qty, string prce, string len) { return dll.FetchDetails(pid, pname, pcid, sdesc, desc, qty, prce, len);}CS:protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { string pid = ""; string pname = ""; string pcid = ""; string sdesc = ""; string desc = ""; string qty = ""; string prce = ""; string len = ""; bll.fetchdetail(pid, pname, pcid, sdesc, desc, qty, prce, len); HiddenField1.Value = pid; txt_proName.Text = pname; ddl_category.SelectedValue = pcid; txt_sdesc.Text = sdesc; txt_ldesc.Text = desc; txt_qnty.Text = qty; txt_price.Text = prce; txt_len.Text = len; }

Ganesh babu · Answer

Thank u guys, I have tried all these links, but i didn't get expected result which i want

Sanwar Ranwa · Answer

Hello Please check these Links https://www.c-sharpcorner.com/UploadFile/009464/how-to-bind-gridview-in-3-tier-in-Asp-Net-using-C-Sharp/ https://meeraacademy.com/edit-update-delete-in-gridview-using-3-tier-in-asp-net-c/ https://www.c-sharpcorner.com/UploadFile/4d9083/create-and-implement-3-tier-architecture-in-Asp-Net/

Salman Beg · Answer

Hey. You can follow this link and change some of the code as per your requirement, https://www.c-sharpcorner.com/UploadFile/4d9083/create-and-implement-3-tier-architecture-in-Asp-Net/