Q: how to add data to timestamp column in sql server through c# coding in vb 

I am creating a billing system. I attached the selling form here. I need when I click the save button, to save the data to the bill table. In the bill table data type of the Bill date is timestamp.
private void btnSave_Click(object sender, EventArgs e) {
  string query = "INSERT INTO bill(bill_no,total_amount,bill_date) VALUES('"
      + txtBillNo.Text + "', '" + txtBillTotal.Text + "','" + txtBillDate.Text + "')";

  using(con = new SqlConnection(connectionString)) {
   SqlCommand com = new SqlCommand(query, con);
   con.Open();
   com.ExecuteNonQuery();
   con.Close();

   MessageBox.Show("Record added successfully!", "Save", MessageBoxButtons.OK,
       MessageBoxIcon.Error);
  }


A: screenshot of SSMS column properties
Within the table on sql you could set the bill_date column to 


*

*Allownulls No

*DateType datetime

*Default Binding getdate()
This will automatically add the date time to the field on successful insertion into the table.
Hope this helps? 
