Guest User

Untitled

a guest
Dec 11th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1.  
  2. string ClientconnString = @"Data Source=D:\DB\App.sdf;Encrypt Database=True;Password=@APpsn_985@;Persist Security Info=False;Max Database Size = 4091";
  3. SqlCeConnection conn = new SqlCeConnection(ClientconnString);
  4. conn.Open();
  5.  
  6. SqlCeCommand CeCmd = conn.CreateCommand();
  7. CeCmd.CommandText = @"UPDATE F_finger SET updatedt=@updatedt WHERE p_empno='AK6277'";
  8. CeCmd.Parameters.Add("@updatedt", SqlDbType.DateTime, 30);
  9. CeCmd.Parameters["@updatedt"].Value = DateTime.Now;
  10. int rows = CeCmd.ExecuteNonQuery();
  11. conn.Close();
Add Comment
Please, Sign In to add comment