|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Schema RowSetsThe topic below includes some sample code.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbconnectionclassgetoledbschematabletopic.asp -- Show quoteHope this helps. Dan Guzman SQL Server MVP "BI-Solutions" <BI-Soluti***@gmail.com> wrote in message news:%23aOjDQv1FHA.2964@TK2MSFTNGP09.phx.gbl... > Hi, > > Sample Application of Schema RowSets. > > Regards, > Stephen > Dear ,
This link is not available, Plz suggest me other. Regards, Stephen Show quote "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message news:e1EeBWx1FHA.1108@TK2MSFTNGP14.phx.gbl... > The topic below includes some sample code. > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbconnectionclassgetoledbschematabletopic.asp > > -- > Hope this helps. > > Dan Guzman > SQL Server MVP > > "BI-Solutions" <BI-Soluti***@gmail.com> wrote in message > news:%23aOjDQv1FHA.2964@TK2MSFTNGP09.phx.gbl... >> Hi, >> >> Sample Application of Schema RowSets. >> >> Regards, >> Stephen >> > > The link is to the Visual Studio reference documentation on
GetOleDbSchemaTable. Below is the sample from the code from that topic. This returns a DataTable containing the list of database tables. public DataTable GetTables(OleDbConnection conn) { conn.Open(); DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null, null, null, "TABLE"}); conn.Close(); return schemaTable; ) -- Show quoteHope this helps. Dan Guzman SQL Server MVP "BI-Solutions" <BI-Soluti***@gmail.com> wrote in message news:eWQo%23734FHA.636@TK2MSFTNGP10.phx.gbl... > Dear , > > This link is not available, Plz suggest me other. > > Regards, > Stephen > > "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message > news:e1EeBWx1FHA.1108@TK2MSFTNGP14.phx.gbl... >> The topic below includes some sample code. >> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbconnectionclassgetoledbschematabletopic.asp >> >> -- >> Hope this helps. >> >> Dan Guzman >> SQL Server MVP >> >> "BI-Solutions" <BI-Soluti***@gmail.com> wrote in message >> news:%23aOjDQv1FHA.2964@TK2MSFTNGP09.phx.gbl... >>> Hi, >>> >>> Sample Application of Schema RowSets. >>> >>> Regards, >>> Stephen >>> >> >> > >  |
|||||||||||||||||||||||
Other interesting topics