Questions tagged [getschematable]

The SqlDataReader.GetSchemaTable method returns a DataTable that describes the column metadata of the SqlDataReader.

The SqlDataReader.GetSchemaTable method returns a DataTable that describes the column metadata of the SqlDataReader.

Column schema information includes the following information about the column:

  • Name;
  • Data type;
  • Size;
  • Whether the column is a primary key field;
  • Whether the column is an autonumber (AutoIncrement) field.

Namespace: System.Data.SqlClient

Assembly: System.Data (in System.Data.dll)

Source:http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable.aspx

18 questions
0
votes
1 answer

IBM.Data.DB2.Core DataReader.GetSchemaTable() method throws NotSupportedException C# .NET standard

Code is in C# .NET standard var connectionString = $""; var connection = new DB2Connection(connectionString); connection.Open(); IDbCommand command = connection.CreateCommand(); string sqlStatement = "
Kaman Poole
  • 87
  • 1
  • 10
0
votes
1 answer

conn.GetSchema("Tables") on Excel file does not return worksheets

I am changing my application from Windows Forms to a Windows Service. conn.GetSchema("Tables") is working differently in the two code bases. In the new code base, I cannot get the Excel worksheets returned. conn.GetSchema("Tables").Rows.Count is 0.…
Brad Mathews
  • 1,567
  • 2
  • 23
  • 45
0
votes
0 answers

How to Handle Access Percentage Fields?

MS Access has a "Format" setting for each field. For a numeric field, one of the options is "Percentage". When percentage is selected, the behaviour of the number of decimals changes. For example, with 0 decimals specified, the field will…
ic3b3rg
  • 14,629
  • 4
  • 30
  • 53
1
2