Gridview - Edit LinkButton - Edit Data in another page

Question

Hi I have doctors Registration page.I have another page which shows the availble doctors in GridView.In GridView I add EditDelete LinkButtons.Delete LinkButton works properly.But Edit LinkButton Can't work properly.Actually I've no idea about how to do this?Doctor's data are entered in Registration.aspx.Available Doctors name listed in view.aspx.When I perform Edit in view.aspxit will redirect to registration.aspx.Then i've to update Doctors details.(In gridview Doctor's data are showed from different tables)Can anyone give me the idea to solve this issue?

Hardik Patel · Answer

protected void Page_Load(object sender EventArgs e) { if (!Page.IsPostBack) { if (Request.QueryString.Count > 0) { 1. gridview - editcolumn - yourpage.aspx?ed={0} yourpage.aspx 2 . if (Request.QueryString[ed] != null) // on yourpage.aspx { string str; str = select * from adver where srno =  + Request.QueryString[ed] +  ; DataTable dt = new DataTable(); dt = objConn.GetDataTable(str); if (dt.Rows.Count > 0) { txtno.Text = dt.Rows[0][1].ToString(); txttitle.Text = dt.Rows[0][2].ToString(); txttitle1.Text = dt.Rows[0][3].ToString(); FCKeditor1.Value = dt.Rows[0][4].ToString(); Button1.Text = Update; } } } } } protected void Button1_Click(object sender EventArgs e) { string str; if (Request.QueryString.Count > 0 && Request.QueryString[ed] != null) { str = Update adver set adname = ' + txtno.Text + ' adtitle=' + txttitle.Text + ' title=' + txttitle1.Text + 'discription=' + FCKeditor1.Value + ' where srno =  + Request.QueryString[ed] +  ; } else { str = insert into adver values (' + txtno.Text + '' + txttitle.Text + '' + txttitle1.Text + '' + FCKeditor1.Value + '); } Int64 i; i = objConn.ExecuteNonQuery(str); if (i > 0) { Response.Redirect(adlist.aspx?msg=save); } } i hope this will help you

Sanjeeb Lenka · Answer

which format you are getting date of birth from database and which format you want to show.

Kavi suja · Answer

Hi SanjeebThank you It's working.The details are bring to registration page sucessfully.But when i read Date of Birth It can't bring correctly. string sdt = Convert.ToString(dr[4]); string[] words = sdt.Split('/'); ddlMonth.SelectedValue = words[0].ToString(); txtdateofbirth.Text = words[1].ToString(); txtbdayyear.Text = words[2].ToString();

Sanjeeb Lenka · Answer

hi kavi you did a typo mistake here. if (Request.QueryString[id] != null) { string id = Request.QueryString [id]; editdocdetails(id); } change it to: if (Request.QueryString[id] != null) { string id = Request.QueryString[ Did ]; editdocdetails(id); } your query string you are passing doctor id as Did if any problem reply

Kavi suja · Answer

Hi I can't get Doctor id here if (Request.QueryString[id] != null) { string id = Request.QueryString[id]; editdocdetails(id); }

Sanjeeb Lenka · Answer

it looks correct so what the problem you are getting.

Kavi suja · Answer

Hi In view.aspx.cs I add the following: if (e.CommandName == EditDoctor) { string id=Convert.ToString(e.CommandArgument); Response.Redirect(Doctorregistration.aspx?Did= + id); } In registeration.aspx.cs if (Request.QueryString[id] != null) { string id = Request.QueryString[id]; editdocdetails(id); } protected void editdocdetails(string id) { try { conn.Open(); string select = select d.SalutationList_pkeyd.firstnamed.middleinitiald.lastnamedate_format(d.dateofbirth '%m/%d/%Y')d.Educationd.Speciality c.value as MobileNo from contactinfo c commonpersoninfo d where d.pkey=' + id + '; MySqlCommand cmd = new MySqlCommand(select conn); cmd.CommandType = CommandType.Text; MySqlDataReader dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows) rbnsalut.Text = dr[0].ToString(); txtpfirstname.Text = dr[1].ToString(); txtpmiddlename.Text = dr[2].ToString(); txtplastname.Text = dr[3].ToString(); Is this the correct method?

Sanjeeb Lenka · Answer

can you provide your code. Are you able to get the Doctor id in Registration page.

Kavi suja · Answer

Hi Sanjeeb Thanks for your reply.I'll try using doctor's ID as query string.

Sanjeeb Lenka · Answer

hi kavi On clicking of Edit button you a have to pass the Doctor id as query string in registration form. from that id you have to get the data from database and bind it to corresponding field for edit. --Link Edit you have to go for Gridview rowcommand event to pass the doctor id value with response.redirect to registration page. if you want more help reply