Although the sqldbhelper. CS class has not been rewritten, it is hard to come up with a souvenir ~~~~~
/**/ /// <Summary>
/// Execute the SQL statement and return the first row and the first column (SEA)
/// </Summary>
/// <Param name = "sqlstring"> SQL statement </Param>
/// <Param name = "paiparms"> Parameter Array </Param>
/// <Returns> Int </Returns>
Public Int Executesql4value ( String Sqlstring, Params Sqlparameter [] parameter parms)
{
Using (Sqlconnection connection = New Sqlconnection (strconn ))
{
Using (Sqlcommand cmd = New Sqlcommand ())
{
Try
{
Preparecommand (CMD, connection, Null , Sqlstring, callback parms );
Object R = Cmd. executescalar ();
If (Object. Equals (r, Null ))
{
Throw NewException ("Value unavailable!");
}
Else
{
Try {IntA=(Int) R ;}
Catch {Return 0;}
Return ( Int ) R;
}
}
Catch (System. Data. sqlclient. sqlexception E)
{
Throw NewException (E. Message );
}
Finally
{
Cmd. Parameters. Clear ();
}
}
}
}