Database

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?

kirankanchinadam wrote:

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

Rmesh wrote:

i want to connect vb.net to sql server 2000 how to connect

Tomy1402 wrote:

`Item ID` varchar(15) collate latin1_general_ci NOT NULL default '',

Yaki_15 wrote:

MS vc7.0 ,a worning starts to arise:
CDaoDatabase is deprecated....
I don't known how to solve this.

Mike Dimmick wrote:

DAO is not being ported to 64-bit. That is, I believe the 32-bit runtime is still present for a 32-bit application, but there will be no 64-bit runtime. As such, CDaoDatabase will no longer work if you recompile your application for 64-bit.