Check if Valid WaterSIM_DB datatable

Namespace: WaterSimDCDC
Assembly: 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 false

Remarks

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();

See Also