Functions to handle generic low level database operations using the SQL SELECT Language
Namespace: Wiker.WIDatabaseAssembly:
Syntax
Visual Basic |
---|
Public Class WIDBUtil |
Visual C++ |
---|
public ref class WIDBUtil |
Examples
CopyC#
WIDBUtil dbUtil;
CDatabaseInfo DBInfo;
StringBuilder StrB;
int CompanyID;
string CompanyName;
DBInfo = new CDatabaseInfo();
DBInfo.DatabaseType = eDatabaseType.SQL;
DBInfo.Location = "SqlServer";
DBInfo.DBName = "TestDatabase";
DBInfo.Username = "LoginName";
DBInfo.Password = "LoginPassword";
dbUtil = new WIDBUtil(DBInfo);
if (dbUtil.LastError != eDBErrorCodes.None)
{
MessageBox.Show(string.Format("Failed To allocate dbUtil\n{0} - {1}",
dbUtil.LastError.ToString(), dbUtil.LastErrorMessage));
return(false);
}
StrB = new StringBuilder();
StrB.Append("SELECT CompanyID, Name ");
StrB.Append("FROM tblCompany ");
StrB.Append("ORDER BY Name ASC");
if (!dbUtil.Open())
{
MessageBox.Show(string.Format("Failed To open database\n{0} - {1}",
dbUtil.LastError.ToString(), dbUtil.LastErrorMessage));
return(false);
}
dbUtil.CommandText = StrB.ToString();
while (dbUtil.ReadRow())
{
CompanyID = dbUtil.ReadInt(0);
CompanyName = dbUtil.ReadString(1);
}
dbUtil.Close();
Inheritance Hierarchy
See Also