Check if Valid WaterSIM_DB datatable
Namespace: WaterSimDCDCAssembly: WaterSimDCDC_API (in WaterSimDCDC_API.dll) Version: 5.0.0.10 (5.0.0.10)
Syntax
C# |
---|
public bool Valid_DataTable( DataTable Target ) |
Visual Basic |
---|
Public Function Valid_DataTable ( _ Target As DataTable _ ) As Boolean |
Parameters
- Target
- Type: System.Data..::..DataTable
a DataTable to check
Return Value
true if valid otherwise falseRemarks
Checks if the DataTable has the required fields to be a valid WaterSim data table. Five fields are required and constants are provided for these five fields,
rdbfID, rdbfScenarioName, rdbfSimYear , rdbfProviderLabel, and rdbfProviderCode. Below is SQL command syntax for creating such a table.
CopyC#
OleDbConnection dbConnect = new OleDbConnection(MyConnectionstring); OleDbCommand cmd = dbConnect.CreateCommand(); cmd.CommandText = "CREATE TABLE [MYTABLENAME] ("+ rdbfID + "COUNTER PRIMARY KEY, "+ rdbfScenarioName + " CHAR(50), "+ rdbfSimYear + " INT, "+ rdbfProviderLabel + " CHAR(25), "+ rdbfProviderCode + " CHAR(5) )" cmd.ExecuteNonQuery();