Hi there, i'm writing about how I can maintain data accuracy on a database that includes students details and want to write about what data verification is and how i can enforce in on my database storing class mates details and grades.
If you could also tell me anything about input masks and combo boxes within the same scenario mentioned above (what is it and how can it be used in this situation) that would be amazing!
Thanks, 10 points to the most helpful answer!What is data verification and how can it be carried out on students details in a database on microsoft access?
if u want to verify the data accuracy u need to first verify the data u enter to the Dataset
(in Access or SQL) by using if else or ,select case ,switch case all are known are selections
then u can update the DataSet to DataBase
by using .Update method of DataAdapter Class but in that case u need to reopen the connection by
OleDbCommandBuilder Class
the combo boxes are used to Select one of options in give selections
u can use
so important properties of ComboBox
cb.SelectItem.Text
.SelectdIndex
so u can get the Selected items name of the index number by that way the index number based on 0
the Masked TextBoxed are help to make a mask so user need to obey that pattern in order to enter the input on it
u can use Mask property for that
example
.Mask = "######-######"
Reference about more Masking
0
Digit, required. This element will accept any single digit between 0 and 9.
9
Digit or space, optional.
#
Digit or space, optional. If this position is blank in the mask, it will be rendered as a space in the Text property. Plus (+) and minus (-) signs are allowed.
L
Letter, required. Restricts input to the ASCII letters a-z and A-Z. This mask element is equivalent to [a-zA-Z] in regular expressions.
?
Letter, optional. Restricts input to the ASCII letters a-z and A-Z. This mask element is equivalent to [a-zA-Z]? in regular expressions.
%26amp;
Character, required. If the AsciiOnly property is set to true, this element behaves like the "L" element.
C
Character, optional. Any non-control character. If the AsciiOnly property is set to true, this element behaves like the "?" element.
A
Alphanumeric, required. If the AsciiOnly property is set to true, the only characters it will accept are the ASCII letters a-z and A-Z.
a
Alphanumeric, optional. If the AsciiOnly property is set to true, the only characters it will accept are the ASCII letters a-z and A-Z.
.
Decimal placeholder. The actual display character used will be the decimal symbol appropriate to the format provider, as determined by the control's FormatProvider property.
,
Thousands placeholder. The actual display character used will be the thousands placeholder appropriate to the format provider, as determined by the control's FormatProvider property.
:
Time separator. The actual display character used will be the time symbol appropriate to the format provider, as determined by the control's FormatProvider property.
/
Date separator. The actual display character used will be the date symbol appropriate to the format provider, as determined by the control's FormatProvider property.
$
Currency symbol. The actual character displayed will be the currency symbol appropriate to the format provider, as determined by the control's FormatProvider property.
%26lt;
Shift down. Converts all characters that follow to lowercase.
%26gt;
Shift up. Converts all characters that follow to uppercase.
|
Disable a previous shift up or shift down.
\
Escape. Escapes a mask character, turning it into a literal. "\\" is the escape sequence for a backslash.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment