Click here to Skip to main content
15,894,017 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Multiple forms of same look. Pin
Luc Pattyn26-Mar-10 17:38
sitebuilderLuc Pattyn26-Mar-10 17:38 
AnswerRe: Multiple forms of same look. Pin
Johan Hakkesteegt27-Mar-10 23:05
Johan Hakkesteegt27-Mar-10 23:05 
AnswerRe: Multiple forms of same look. Pin
Deep Unknown29-Mar-10 9:40
Deep Unknown29-Mar-10 9:40 
QuestionNavigating a web site using VB.net code. Pin
Daniel Riek26-Mar-10 5:23
Daniel Riek26-Mar-10 5:23 
AnswerRe: Navigating a web site using VB.net code. Pin
David Mujica26-Mar-10 6:09
David Mujica26-Mar-10 6:09 
QuestionAltering dll reference from in exe in VB.Net Deployment Pin
JayKhatri26-Mar-10 4:32
JayKhatri26-Mar-10 4:32 
AnswerRe: Altering dll reference from in exe in VB.Net Deployment Pin
Dave Kreskowiak26-Mar-10 13:59
mveDave Kreskowiak26-Mar-10 13:59 
QuestionDiscrepency in List tables subroutine Pin
Quecumber25626-Mar-10 4:17
Quecumber25626-Mar-10 4:17 
I have the following subroutine to list the tables from a selected SQL Server database. In this case AdventureWorks.

Private Sub DisplayDatabaseTbls(ByVal tblTables As DataTable)
lstTbls.DataSource = Nothing
lstTbls.Items.Clear()
For Each row As DataRow In tblTables.Rows
lstTbls.Sorted = True
lstTbls.DataSource = tblTables
lstTbls.ValueMember = "Table_Name"
lstTbls.DisplayMember = "Table_Name"
Next
End Sub

It retrieves the database tables just fine, but when I open up the same database in Microsoft SQL Server Management Studio Express I noticed that the tables where listed differently.

Example:

My Subroutine list the tables like this:
AWBuildVersion
Department
Employee

While SQl Server Management Studio list them like this:
dbo.AWBuildVersion
HumanResources.Department
HumanResources.Employee

Can someone tell me how I can make my subroutine match the SQL Server Management Studio?

Thanks in advance,
Quecumber256
QuestionUnits of measure for comparisons Pin
Marcus J. Smith26-Mar-10 2:14
professionalMarcus J. Smith26-Mar-10 2:14 
AnswerRe: Units of measure for comparisons Pin
Dalek Dave26-Mar-10 2:25
professionalDalek Dave26-Mar-10 2:25 
GeneralRe: Units of measure for comparisons Pin
Marcus J. Smith26-Mar-10 3:12
professionalMarcus J. Smith26-Mar-10 3:12 
QuestionMessage Removed Pin
25-Mar-10 23:45
kpuneeth725-Mar-10 23:45 
AnswerRe: convert vb code to php - Crosspost Pin
Smithers-Jones26-Mar-10 2:45
Smithers-Jones26-Mar-10 2:45 
QuestionTelnet Client session Pin
Sunil G25-Mar-10 20:51
Sunil G25-Mar-10 20:51 
QuestionHelp converting C# snippet toVB Pin
programmervb.netc++25-Mar-10 19:22
programmervb.netc++25-Mar-10 19:22 
AnswerRe: Help converting C# snippet toVB Pin
Dave Doknjas26-Mar-10 10:52
Dave Doknjas26-Mar-10 10:52 
GeneralRe: Help converting C# snippet toVB Pin
programmervb.netc++26-Mar-10 16:25
programmervb.netc++26-Mar-10 16:25 
GeneralRe: Help converting C# snippet toVB Pin
Dave Doknjas26-Mar-10 16:33
Dave Doknjas26-Mar-10 16:33 
GeneralRe: Help converting C# snippet toVB Pin
programmervb.netc++26-Mar-10 16:37
programmervb.netc++26-Mar-10 16:37 
GeneralRe: Help converting C# snippet toVB Pin
Dave Kreskowiak27-Mar-10 2:47
mveDave Kreskowiak27-Mar-10 2:47 
GeneralRe: Help converting C# snippet toVB Pin
programmervb.netc++26-Mar-10 16:36
programmervb.netc++26-Mar-10 16:36 
GeneralRe: Help converting C# snippet toVB Pin
programmervb.netc++26-Mar-10 16:42
programmervb.netc++26-Mar-10 16:42 
Questionusing list collection and structures (but i need to find a particular "entry" in the list on a search criteria Pin
Simon_Whale25-Mar-10 6:39
Simon_Whale25-Mar-10 6:39 
AnswerRe: using list collection and structures (but i need to find a particular "entry" in the list on a search criteria [modified] Pin
Wayne Gaylard25-Mar-10 14:49
professionalWayne Gaylard25-Mar-10 14:49 
GeneralRe: using list collection and structures (but i need to find a particular "entry" in the list on a search criteria Pin
Dave Kreskowiak26-Mar-10 2:05
mveDave Kreskowiak26-Mar-10 2:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.