Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- string ClientconnString = @"Data Source=D:\DB\App.sdf;Encrypt Database=True;Password=@APpsn_985@;Persist Security Info=False;Max Database Size = 4091";
- SqlCeConnection conn = new SqlCeConnection(ClientconnString);
- conn.Open();
- SqlCeCommand CeCmd = conn.CreateCommand();
- CeCmd.CommandText = @"UPDATE F_finger SET updatedt=@updatedt WHERE p_empno='AK6277'";
- CeCmd.Parameters.Add("@updatedt", SqlDbType.DateTime, 30);
- CeCmd.Parameters["@updatedt"].Value = DateTime.Now;
- int rows = CeCmd.ExecuteNonQuery();
- conn.Close();
Add Comment
Please, Sign In to add comment