Databases
StackOverflow2013
Postsdbo
POUpdate database table based on textbox values
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUpdate database table based on textbox values
    primarykey
    data
    text
    <p>I am trying to update database table based on text-box values.But i am unable to get new modified values in database.</p> <p>Here is my code which displays information in text-boxes coming from database</p> <pre><code>protected void Info() { string sID = Request.QueryString["ID"]; string sSql = "select * from [fn_Items]('"+sID+"')"; DataTable tbl1 = new DataTable(); string sEr = myClass.FillupTable(sSql, ref tbl1); if (tbl1.Rows.Count &gt; 0) { DataRow rd = tbl1.Rows[0]; txtName.Text = rd["Name"].ToString(); txtCategory.Text = rd["Category"].ToString(); DateTime mStart; DateTime mFinish; Boolean b = false; b = DateTime.TryParse(rd["start"].ToString(), out mStart); b = DateTime.TryParse(rd["end"].ToString(), out mFinish); txtStart.Text = mStart.ToString("dd-MMM-yyyy"); txtend.Text = mFinish.ToString("dd-MMM-yyyy"); txtDescription.Text = rd["Description"].ToString(); } } </code></pre> <p>Now when the user modifies the text-box data and clicks save, the data should change in the database. Here is my click_event:</p> <pre><code>protected void btnSave_Click(object sender, EventArgs e) { using (SqlConnection sqlConn = new SqlConnection("Data Source=MSSQLSERVER2008;Initial Catalog=Items_2;Persist Security Info=True;User ID=sa;Password=password")) { string query = "UPDATE tbl_Items SET Name = @Name,Category=@Category,start = @start, end = @End,Description = @Description where ID = @ID "; SqlCommand cmd = new SqlCommand(query, sqlConn); cmd.Parameters.AddWithValue("@ID",txtID.Text); cmd.Parameters.AddWithValue("@Name", txtName.Text); cmd.Parameters.AddWithValue("@Category", Category.Text); cmd.Parameters.AddWithValue("@start", txtStart.Text); cmd.Parameters.AddWithValue("@end",txtend.Text); cmd.Parameters.AddWithValue("@Description", txtDescription.Text); cmd.Connection.Open(); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception("Error " + ex.Message); } } </code></pre> <p>Here while updating, in text-boxes I am getting the values present in the database where I need to get the modified values. How do I get the modified values instead?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJerry Coffin
    1. USChow.Net
    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. POUpdate database table based on textbox values
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COWhen debugging, do you see the values in the click event? Are you sure they are labeled correctly?
      singulars
      1. POUpdate database table based on textbox values
      1. USdavids
    2. COWhen Iam debugging I am getting the previous values which are from Info() . I am not getting the values that are changed.
      singulars
      1. POUpdate database table based on textbox values
      1. USChow.Net
    3. COOn a side note, you should validate your text inputs. Your current code is vulnerable to SQL injections. For example, let's say that in txtID.Text, I input the value `12345' drop table tbl_items `, I would be able to drop your table.
      singulars
      1. POUpdate database table based on textbox values
      1. USLunyx
 

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