Database

Colin Angus Mackay wrote:

hamada33 wrote:

select in disconnected mode for table have forign key

therasa12345vijay wrote:

how to reply to the particular message

private DataTable GetSchema()
{
	DataTable schema = null;

	using (OleDbConnection dbConn = new OleDbConnection(_connectionString))
	{
		dbConn.Open();
		schema = dbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
			new object[]{null, null, null, "TABLE"});
		dbConn.Close();
		// The table name is in the schema field "TABLE_NAME";
	}
	return schema;
	
}

private DataView GetSchema(string table)
{
	DataTable schema = null;

	using (OleDbConnection dbConn = new OleDbConnection(_connectionString))
	{
		dbConn.Open();
		schema = dbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns,
			new object[]{null, null, table});
		dbConn.Close();
	}
	return schema.DefaultView;
}

Tomy1402 wrote:

I wonder if anyone knows MySQL syntax for display All Field except certain Fields.

example :
I have a table with 100 Fields. And I want to display All Fields except Field number 25, 50, 75 and 100.

How do I do that?