title: Inserting date into database when we insert data to database every time display inserting date in asp.net
body: <p>when i inserting data into database i need to insert date also but i pass a insert query in this query i inserted data but it took date column by default SQL database date format but i want to display when the user enter data to insert data base that date i want to display my tried query is: </p>
  
  <pre><code>string s = "insert into BatchPermissons(BatchId,SubjectId,AuditoName,AudioID,CreatedBy,CreatedDate) values(" + batchno + ", " + subjectid + " , '" + AudiotoName + "', " + AudioId + ",'" + CBY + "'," + DateTime.Now.ToString() + ")";
  SqlCommand cmd = new SqlCommand(s, con);
  cmd.CommandType = CommandType.Text;
  cmd.Connection = con;
  con.Open();
  cmd.ExecuteNonQuery();
  con.Close();
  </code></pre>
  
  <p>but the above query inserting default date in database.i need to insert when i insert data that particular date will be store can any one help me out. </p>