Database Reference
In-Depth Information
values('” + name + “',” + Cname +
“,'” + Dept + “',” + CDept + “,”
+ Salary + “,” + CSalary + “,” +
TC.ToString() + “)”;
Glo balClasses.DBOperations.
SetData(DStr);
}
else if (richTextBox1.Text.
ToUpper().Contains(“VERIFY”))
{
string Query = richTextBox1.Text.
Replace(“\n”, “ “);
string SelectSTR = “select * from BC”
+ MLSDB.DMLSTR(richTextBox1.Text).
Trim().ToUpper() + “ where “ +
MLSDB.PredicateSTR(richTextBox1.
Text);
DataRow DR = GlobalClasses.
DBOperations.GetData(SelectSTR).
Tables 0].Rows[0];
string xkey = DR.ItemArray[0].
ToString();
int xlbOl = Convert.ToInt32(DR.
ItemArray[1].ToString());
int xtc = Convert.ToInt32(DR.
ItemArray[6].ToString());
int newLabel = MLSDB.
VerifyBCUserbelief(xtc, Convert.
ToBoolean(MLSDB.
AttributeSTR(richTextBox1.Text)));
string UpdateSTR = “Update BC” +
MLSDB.DMLSTR(richTextBox1.Text).
Trim() + “ set CName = “ +
newLabel.ToString() + “, CDept =
“ + newLabel.ToString() + “,
CSalary = “ + newLabel.ToString()
+ “, TC = “ + newLabel.ToString()
+ “, flag = “ + newLabel.
ToString() + “ where “ + MLSDB.
PredicateSTR(richTextBox1.Text) +
“ and TC = “ + xtc.ToString();
Glo balClasses.DBOperations.
SetData(UpdateSTR);
}
Search WWH ::




Custom Search