Database

Frank Kerrigan wrote:

SELECT Column1 + " " + Column2
FROM MyTable

If you want to be "Really Fancy"

SELECT Column1 + ' ' + Column2
FROM MyTable

select (id + rate) as IDRATE from test

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;
}