Database Reference
In-Depth Information
ColumnSTR = ColumnSTR.
Remove(ColumnSTR.Length
- 1);
foreach (object value in
DR.ItemArray)
{
if (value is string)
{
if (!value.ToString().
Contains(“'”))
{
ColumnValuesSTR + =
“ENCRYPTBYKEY(KEY_
GUID('” + globals.
UserLabel +
“SymmetricKey'),'”
+ value.ToString()
+ “'),”;
}
else
{
ColumnValuesSTR + =
“ENCRYPTBYKEY(KEY_
GUID('” + globals.
UserLabel +
“SymmetricKey'),” +
value.ToString() +
“),”;
}
}
else
{
ColumnValuesSTR + =
value.ToString() +
“,”;
}
}
Col umnValuesSTR =
ColumnValuesSTR.Remove
(ColumnValuesSTR.Length
- 1);
string InsertSTR = “exec
dbo.usp_
EnableCellVisibility;
insert into [“ + MLSDB.
Search WWH ::




Custom Search