IDE :: ODBC To SQL Server Shows List Of Procedures But Not List Of Tables Or Views?
Oct 27, 2009
In VS 2008, VB.Net, I am successful connecting to a local SQL Server and seeing all tables/views/procedures.I created an ODBC data source to a remote SQL server with a database of the same structure as the local one.The connection tests out ok. In the VS 2008 Server Explorer I add this source. When I click on the plus-signs to expand items, neither the tables nor the views show anything, whereas the full list of procedures appears.How can I see the lists of tables and views in Server Explorer for an ODBC source?
View 1 Replies
ADVERTISEMENT
Oct 27, 2009
In VS 2008, VB.Net, I am successful connecting to a local SQL Server (version 8) and seeing all tables/views/procedures in Server Explorer. The local OS is Win XP Pro SP3. I created an ODBC data source to a remote SQL server (also version 8) with a database of the same structure as the local one. The connection tests out ok. The remote computer runs Windows Server 2000 SP4. In the VS 2008 Server Explorer I add this ODBC source. When I click on the plus-signs to expand items, neither the tables nor the views show anything, whereas the full list of procedures appears. Is it the old SQL Server version? Is it the old Server OS version? Something else alltogether?
View 2 Replies
Dec 30, 2010
This is what I'm sure will be the first of many noob-ish questions from yours truly... I'm studying as a mature student for a Computing Degree (encompassing web design, hardware, programming and systems analysis). The programming seems to be my weak spot this year. I enjoyed C++ last year, doing basic console applications, but progamming visually with VB in Visual Studio 2008 I'm struggling!
[Code].....
View 12 Replies
Oct 20, 2009
I have just started to learn how to use SMO in some cases. Below is some code I found from a site to list the servers and databases for each. What I would like to do is go a step further and list all of the databases and stored procedures in their own listboxes when I select a database. I would like to not include the system ones or at least have a checkbox to decide to include them or not. I searched and could not find how to do this.
Here is the code I have so far:
Imports Microsoft.SqlServer
Imports Microsoft.SqlServer.Server
Imports Microsoft.SqlServer.Management
[Code]....
View 2 Replies
Nov 5, 2011
I wish to make a project where a teacher views a list box with a list of students of a class. When he selects a name from the first list box the second listbox would change its data to show the grades for that one student.
View 10 Replies
Aug 5, 2010
I have one application create tables in database dynamically during run. Another application need to find all these tables' name in the database. how should in do in vb.net
View 7 Replies
Mar 12, 2009
I have used list views for a project. I have used sum items on the items. The sub items are prices of products. I will need to use these sub items to come up with a total.Also, i have used to listviews, for a smoother look and feel. You click the product which then is removed from the list view and added to the second one. Would this also "move" the sub item across to the other list view?
View 1 Replies
Mar 10, 2009
I am trying to learn how to work with the different controls in Visual Studio for VB.Net in particular the List View and Tree Views. I don't have any code to show as I am not working on anything in particular just messing around with it to learn what the different controls do that weren't covered in my Intro to VB.Net class last semester.I would like a clearer explanation on how to actually use code for these controls. In particular adding and removing items from the List and Tree Views using code.
View 1 Replies
Aug 4, 2009
I am using VB 2008 and wonder if there is a way to draw lines between the data elements in two listviews to bind the elements together?
View 1 Replies
Jan 27, 2011
I have a small problem i'm trying to fetch list of directoies from 1 special ftp server wich does not support LIST command i was try this code and it works for all ftp server i have try exept this special one :
'' Get the object used to communicate with the server.
'Dim request As FtpWebRequest = DirectCast(WebRequest.Create("ftp://" & txtFTPhost.Text), FtpWebRequest)
[code]...
I'm getting error 502 which means command is not supported and app crashed. I would just simple said leave it but i have try normal ftp clients like FlashFXp and it works just fine (i can see error in the log but it just pass it and show direcoties)
View 4 Replies
Jun 23, 2011
Is there a way to get a list of ODBC drivers that are installed on a Windows XP machine from .NET?
I basically would like to see (in .NET) what is in:
Control Panel->Administrative
Tools->Data Sources (ODBC)->"Drivers"
Tab.
View 1 Replies
Jun 8, 2011
Is there any way to pass multiple values (a list of values) to a query via ODBC Parameters in VB.Net?
For instance, is there a way to create a query along the lines of:
-- vb.net has something like Dim itemNumbers As New List(Of Integer)(SomeCount)
SELECT Cost, Description
FROM MyItemList
WHERE ItemNum IN (<my list of item numbers>)
View 1 Replies
Jan 21, 2009
Option Explicit
Private Declare Function SQLAllocEnv Lib "odbc32.dll" (phenv As Long) As Integer
Private Declare Function SQLFreeEnv Lib "odbc32.dll" (ByVal hEnv As Long) As Integer
Private Declare Function SQLDataSources Lib "odbc32.dll" _
(ByVal hEnv As Long, ByVal fDirection As Integer, ByVal szDSN As String, _
[code].....
View 1 Replies
May 24, 2011
Can anyone tell me how to list ODBC and OLEDB drivers that are installed in the windows system?
I want to display them in a DGV and create a connection string from the users choice.
XP,Vista and Widows 7
View 4 Replies
Dec 15, 2011
Ive got 2 List boxes 1 Shows Processes other one is for Storage. Anyway that's not important. Im trying to Kill all the Processes wat are stored in Listbox 2. I had to add .exe at List for Listbox 2 But still not working ? The problem is its not removing the File names that are stored
ProgressBar1.Increment(1)
Process.EnterDebugMode()
If ProgressBar1.Value = ProgressBar1.Maximum Then
[CODE]...
View 19 Replies
Nov 27, 2010
Im trying to add a variable that shows amount of tax deducted in a list box among other output variables. If anyone can help I would like to know how to code the lstResults.Items.Add("-$ " & Tax & " Tax") bracket to display the amount of tax deducted from the total salary wages.
Public Class Form1
'Decalirs Variables
Dim Hours As Integer
Dim Overtime As Integer
[code]....
View 3 Replies
Aug 17, 2010
so im dynamically populating a checkbox list. I have confirmed that my text and values are correct for each checkbox but when I check a few and click my event button when I loop through the items they are all set to select=false...
Dim resource As ListItem
Dim SelectedHashTable As New Hashtable
For Each resource In chkResources.Items
[code].....
View 1 Replies
Oct 24, 2010
I want to make simple photo gallary . First thing I have a combo box contain several folder whene I choiec a a certain folder, it should shows all the pic name that the selected folder contain. Whene I click in certain pic in the listbox , the picture box should show the selected pic.
[Code]...
View 5 Replies
Feb 13, 2011
I need to create a program that when I click a button it shows a sentence (took it from a list) random. But after it have to delete the sentence from the list 'cause we dont want to read it again I don't know so much about VB so I'd like some help!
View 25 Replies
Aug 12, 2010
I am trying to achieve this.
Public Enum Tables
customers
[code].....
View 1 Replies
Mar 19, 2011
I am absolate new to vb.net .can some one help me to write a query that will display list of tables in combobox.using the code bellow i can create table but i want to be able to add all the avilable table names in combobox.Imports System.Data.OleDb Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Cmd As OleDbCommand
Dim SQL As String
Dim objCmd As New OleDbCommand
[Code]...
View 2 Replies
Aug 15, 2011
is it possible to fill a list box from two SQL tables firstname lastname.
View 7 Replies
Jul 13, 2009
I am trying to write the code needed to link two tables together. One table is a list box and the other table is a data grid view. What would the example of the code needed in order to link these tables together so that each time you click on an item in the list box, the data grid would then show the corresponding information that matches up with the selected item.
View 1 Replies
Oct 27, 2011
I am trying to create a button on a form that will open a connection to a database and list all the tables in the database inside a listbox. Everything I have read indicates I can associate a single table to a form, and have no idea how to:
a. Create code for the button to access all the tables in the database.
b. Display that list in a list box.
The text that I am using is murach's ADO.NET 3 database programming with VB2010, and I am less that thrilled with it.
View 3 Replies
Nov 23, 2011
I have the following:
a table of addresses and a bindingsource for the table
a enum list of address type: 0 = "Mailing", 1 = "Physical", 2 = "Shipping" etc...
I would like to bind the datasource of the combobox to the enum so it displays "Mailing", "Physical" etc. Then I would like to change the bindingsource position of the address table based on the user selection of the combobox.
Here is what I have so far:
cbxAddressName.DataSource = New BindingSource(ApplicationEnums.GetEnumList(GetType(ApplicationEnums.CompanyAddressType)), Nothing)
[Code].....
View 1 Replies
Jun 2, 2009
So I pulled out my SQL book and I think I am doing this right but VS don't seem to like it. Here is what I got:
[Code]...
View 5 Replies
Apr 9, 2009
I need to load a list of tables and linked tables in an MS Access Database into a combo box. I have this.
vb.net Imports System.Data.OleDb
[Code]...
1. How do I load the access tables and the link tables into my combo without the system tables showing up?
View 7 Replies
Feb 4, 2011
I'm having trouble finishing up this salary program which is designed to calculate salary based on gross sales while using arrays. Essentially, when the Calculate Salary click event is initiated after salary is entered, either $200 should show up in the list box or, if the persons sales were over $5,000, a calculation of their sales * 9% + 200 should show up in the list box. Right now, anytime I enter any number, "Double Array()" shows up in that list box. Additionally, a bar graph is supposed to supposed to be displayed in the lower list box showing how many people are in certain categories starting from "$200-$299" through "over $999". These results should be shown when the Show Totals click event is initiated.
[code]...
View 1 Replies
Nov 12, 2009
how to read all the tables returned by SQL Stored Procedure? My Stored procedure returns two tables:
ID Name
-----------
1 Jeff
2 Joe
[code]....
i want to read data from both of these tables. I tried using SQLDataReader and then populating into datatables but then i can only read the values of 1st table. I want to read both the table values. How do i do it?
View 1 Replies
Feb 5, 2012
SELECT
Login.LoginID, Student.[Student Name], Student.[Student address], Student.StudentID
FROM
Login
INNER JOIN
Student ON Login.LoginID = Student.LoginID
WHERE
(Login.username = @user) AND (Login.password = @pass)
RETURN
How do I display the Student Name, Student Address, StudentID, and LoginID into multiple textboxes?
View 2 Replies
