Databases
StackOverflow2013
Postsdbo
POhow to update a record from the values taken from the text box fields
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhow to update a record from the values taken from the text box fields
    primarykey
    data
    text
    <p>I am making a list of records in a web form with edit and delete options. I have retrieved the values in the text box fields for update. Now, when the user clicks the update button, the record is updated.</p> <p>How can I do it remaining on the same page or redirected to another page? </p> <p>This is my code:</p> <pre><code>public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { binddata(); } } SqlConnection con; SqlDataAdapter da; DataSet ds; void binddata() { string pid = Request.QueryString["Prod_Id"]; con = new SqlConnection("Data Source=.\\sqlexpress; initial catalog=PracticeDb; user id=sa; pwd=manager;"); con.Open(); da = new SqlDataAdapter("Select * from Products where Prod_Id='" + pid + "'", con); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); string P_Name = ds.Tables[0].Rows[0]["Prod_Name"].ToString(); string U_Prce = ds.Tables[0].Rows[0]["Unit_Price"].ToString(); string I_Hnd = ds.Tables[0].Rows[0]["In_Hand"].ToString(); string Fxd = ds.Tables[0].Rows[0]["Fixed"].ToString(); string Stus = ds.Tables[0].Rows[0]["Status"].ToString(); TextBox1.Text = P_Name; TextBox2.Text = U_Prce; TextBox3.Text = I_Hnd; TextBox4.Text = Fxd; TextBox5.Text = Stus; } protected void Unnamed1_Click(object sender, EventArgs e) { string pid = Request.QueryString["Prod_Id"]; var Pd_nme = TextBox1.Text; decimal Uni_prce = decimal.Parse(TextBox2.Text); int In_hnd = int.Parse(TextBox3.Text); string Fxd = TextBox4.Text; string Stus = TextBox5.Text; SqlConnection con = new SqlConnection(); con.ConnectionString = ("Data Source=.\\sqlexpress; initial catalog=PracticeDb; user id=sa; pwd=manager;"); con.Open(); string qry = "UPDATE PRODUCTS SET Prod_Name='" + Pd_nme + "',Unit_Price='" + Uni_prce + "',In_Hand='" + In_hnd + "',Fixed='" + Fxd + "',Status='" + Stus + "' where Prod_Id='" + pid + "'"; SqlCommand cmd = new SqlCommand(qry, con); cmd.ExecuteNonQuery(); con.Close(); } } } </code></pre> <p>Thanks.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USchuff
    1. USuser2431114
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POhow to update a record from the values taken from the text box fields
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POhow to update a record from the values taken from the text box fields
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COThanks for the edit .any solutions ?
      singulars
      1. POhow to update a record from the values taken from the text box fields
      1. USuser2431114
    2. COthere are multiple solutions for doing such a thing... 1. For staying on the same page, you can use javascript+ajax to post the updated values. 2. For redirection you can create a query string and add parameters to it and update it on other page...
      singulars
      1. POhow to update a record from the values taken from the text box fields
      1. USHmxa Mughal
    3. COI don't understand the problem. Your code for updating the database looks okay from here. Do you get any errors?
      singulars
      1. POhow to update a record from the values taken from the text box fields
      1. USAlexander
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload