TimeStamp/Datagrid update issue

How would I get the code below to update a database and insert a  current date into the Reserve_Timestamp column?

string inv, dateT;
string key = DGrid.DataKeys[e.Item.ItemIndex].ToString();
TextBox box;
                  box = (TextBox)(e.Item.Cells[1].Controls[0]);
                  inv=box.Text;

                  // Gets the value the TextBox control in the fourth column
                  box = (TextBox)(e.Item.Cells[8].Controls[0]);
                  dateT= box.Text;

                  

                  string Sq;
                  DateTime ToDa = DateTime.Now;

                  Sq = "Update [Waveplate]" +
                        "set Inventory_Status=@Inventory_Status, Reserve_Timestamp='ToDa'"+
                        "where Part_Key =@Part_Key";

                  SqlCommand SCom = new SqlCommand(Sq, Conn);
                  //SqlParameterCollection CSql = SCom.Parameters;
                  SCom.Parameters.Add("@Part_Key",SqlDbType.Char);
                  SCom.Parameters.Add("@Inventory_Status", SqlDbType.Char);
                  SCom.Parameters.Add("@Reserve_Time", SqlDbType.DateTime);
            SCom.Parameters["@Part_Key"].Value = DGrid.DataKeys[(int)e.Item.ItemIndex];

SCom.Connection.Open();

                  try
                  {
                        SCom.ExecuteNonQuery();
                        Response.Write ("<b>Record Updated</b><br>" + Sq);
                        DGrid.EditItemIndex = -1;
                  }
                  catch (SqlException E)
                  {
                        if (E.Number == 2627)
                              Response.Write("ERROR: A record already exists with the same primary key");
                        else
                              Response.Write ("ERROR: Could not update record, please ensure the fields are correctly filled out");
                        

                  }

                  SCom.Connection.Close();

                  BindIt();
            }
devlinsAsked:
Who is Participating?
 
nhewitt21Commented:
change this:
  Sq = "Update [Waveplate]" + "set Inventory_Status=@Inventory_Status, Reserve_Timestamp='ToDa'"+ "where Part_Key =@Part_Key";

to this:
  Sq = "Update [Waveplate]" + " set Inventory_Status=@Inventory_Status, Reserve_Timestamp=" + ToDa + " where Part_Key =@Part_Key";

that should do it i think, hope this helps you out.
0
 
devlinsAuthor Commented:
what do I need to change with the connection string and parameters in order for the code to work do you see
any errors in the code besides the sql script???
0
 
nhewitt21Commented:
i see no problems with the code, although i don't see a db connections string.
0
 
EBatistaCommented:
the @Reserve_Time parameters definitions do not corresponds with the query string you've built, also you have not set the value for @Inventory_Status.
try this:

Sq = "Update [Waveplate]" +
"set Inventory_Status=@Inventory_Status, Reserve_Timestamp=@Reserve_Time where Part_Key =@Part_Key";

SCom.Parameters.Add("@Part_Key",SqlDbType.Char);
SCom.Parameters["@Part_Key"].Value=key;

SCom.Parameters.Add("@Inventory_Status", SqlDbType.Char);
SCom.Parameters["@Inventory_Status"].Value=inv;

SCom.Parameters.Add("@Reserve_Time", SqlDbType.DateTime);
SCom.Parameters["@Reserve_Time"].Value=ToDa;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.