System.Data.SqlClient.SqlConnection cnn = new System.Data.SqlClient.SqlConnection("server=.;database=northwind;trusted_connection=SSPI");
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("insert into orders(orderdate) values (@mydateparam)", cnn);
System.Data.SqlClient.SqlParameter param = cmd.Parameters.Add("@mydateparam", System.Data.SqlDbType.DateTime);
param.Value = System.DateTime.Now;
try
{
 cnn.Open();
 cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex)
{
 System.Windows.Forms.MessageBox.Show(ex.Message);
}
finally 
{
 cnn.Close();
}

 uid  =  S a