Columns

To retrieve details about all of the columns in the database, retrieve the "Columns" schema collection by invoking the GetSchema method in the NetSuiteConnection class. This collection contains information such as the column name, column size, and data type, which can be obtained with the code below. To retrieve column metadata, instantiate a new NetSuiteConnection and open the connection:

C#

string connectionString = "Account Id=XABC123456;Password=password;User=user;Role Id=3;Version=2013_1;Location=C:\\myfolder\\;Offline=false;";
using (NetSuiteConnection connection = new NetSuiteConnection(connectionString)) {
  connection.Open();
  DataTable databaseColumnsSchema = connection.GetSchema("Columns", new string[] {""Account"});
  foreach (DataRow column in databaseColumnsSchema.Rows) {
    Console.WriteLine(column["ColumnName"].ToString());
    Console.WriteLine(column["ColumnSize"].ToString());
    Console.WriteLine(column["DataType"].ToString());
  }
}

VB.NET

Dim connectionString As String = "Account Id=XABC123456;Password=password;User=user;Role Id=3;Version=2013_1;Location=C:\\myfolder\\;Offline=false;"
Dim tableName As String() = {"Account"}
Using connection As New NetSuiteConnection(connectionString)
	connection.Open()
	Dim databaseColumnsSchema As DataTable = connection.GetSchema("Columns", tableName)
	For Each column As DataRow In databaseColumnsSchema.Rows
		Console.WriteLine(column("ColumnName").ToString())
		Console.WriteLine(column("ColumnSize").ToString())
		Console.WriteLine(column("DataType").ToString())
	Next
End Using