Database

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?

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 '',