public static bool HasRows(string TableName)
{
CLSDataAccess dataaAccess = new CLSDataAccess();
if (dataaAccess.GetSQLDataSetByQuery("SELECT * FROM " + TableName).Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool ExistInTable(string TableName, string Criteria)
{
CLSDataAccess dataaAccess = new CLSDataAccess();
if (dataaAccess.GetSQLDataSetByQuery("SELECT * FROM " + TableName + " WHERE " + Criteria).Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool ExistInTable(string TableName, string CulumnToSearch, string SearchValue)
{
CLSDataAccess dataaAccess = new CLSDataAccess();
if (dataaAccess.GetSQLDataSetByQuery("SELECT * FROM " + TableName + " WHERE " + CulumnToSearch + " = " + SearchValue).Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public string GetAccessDBField(string TableName, string RequestedCol, string CriteriaCol, int CriteriaVal)
{
CLSDataAccess da = new CLSDataAccess();
DataTable dt = da.GetAccessDataSetByQuery("select " + RequestedCol + " from " + TableName + " where " + CriteriaCol + "=" + CriteriaVal.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
return(dt.Rows[0][0].ToString());
}
else
{
return(null);
}
}
public static bool ExistsInTable(string TableName, string ColumnName, string Value, bool ValueIsNumeric)
{
try
{
string absoluteValue = Value;
if (!ValueIsNumeric)
{
absoluteValue = "'" + Value + "'";
}
CLSDataAccess da = new CLSDataAccess();
if ((da.GetAccessDataSetByQuery("select * from " + TableName + " where " + ColumnName + " = " + absoluteValue)).Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
