populating a Listbox control with the results of a T-SQL query in VB.NET? Here is some code to start with:
Dim myconnection As SqlConnection
Dim myda As SqlDataAdapter
Dim ds As DataSet
[Code]....
how to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesI am getting stuck on this problem. It seems simple but for some reason im having trouble.
Here is what I have of the following:
Try
cn = New OleDbConnection("Provider=microsoft.Jet.OLEDB.4.0;Data Source=G:SeanBMSBonder3_0.mdb;")
[Code]....
This works to get only one of the values. Actually the last. how can i get all of them?
I come from Access and I am developing now my first windows form app in visual basic 2010 based on a Access database *.mdb. The thing is i have an access db with 5 tables. I have created the forms, connected to the database, all is working great. Parent- child relations are working, datagrids and comboboxes populate the right way, buttons are working.
But now I want to populate listbox, and combox from tables with queries. Like in access I would like, for example to populate two different listboxes bound to the same table with different queries, so that the listboxes give different results, based on different variables or textboxes.
But I don't know how to attack the problem: the query works against the tableadapter, so the info it gives back is always the same. I have tried to duplicate the tableadapter of the table i want to query, writing different sql queries in both, but it does not seem to work. I don't know in what direction I should ivestigate: LINQ, sql queriess, coded queries, filtering the listbox...
Im using a combobox that bound to a DataSet. The Dataset retreives it's values from SQL.
I can retreive the values fine. However only displaying (1) Column. Which is fine.
Here's where it gets complicated for me. The dataset has 2 other columns that get filled. I need the resulting columns to be sent to text boxes when I select a value from the combobox.
How could I add array values and populate the results in a specified text box?Then repeat for each line after. Then get a final total.
For example:
1 2 3 4 5 (15)-text box
1 2 3 4 5 (15)-text box
2 4 4 3 5 (18)-text box
-----------------------
(48)-text box
I'm trying to populate it with the results from a table in a dataset, something like Dim MyStringArray() as string = {Me.MyDataset.MyUsers.Rows.Tostring}. So I would end up with, StringArray() = {"Bob", "Jane", "Sally"}. I know I'm missing something very simple but I'm just not getting it.
View 5 Replieswhy I cannot populate the data grid with the results of my loop>
Public Class FormInput
'The disabled close button declarations;written by Achmad Zeanuri
Private Const MF_BYPOSITION = &H400
[Code].....
I'm having a devel of a time getting what I figure is something simple to work.
I need to set up a Combobox where the list of items is created by accessing a stored procedure.
The SQL code is simply (I left off the code to create the sp);
SELECT ItemCode
FROM vw_CodeList
GROUP BY ItemCode
ORDER BY ItemCode
I do however have a slight background with VBA particularly with MS Access, so I am not completely lost.I am recreating my Access database application in VB.net.I created a new project and added an Access database through the wizard, which automatically created a dataset for the database. On one of my forms I have, esentially, a search form. What I want to happen is have a text box, and as I start typing display a search result from my customers table in the list box under it. So for example, I type "A" and all customer names that start with "A" are displayed in the list box.I continue typing with a "p" (full string is now "Ap"), then all customer names that start with "Ap" are displayed and so on...
I did search on my own first before posting this and found a few tips but cant really get it to work the way I want. This is what I have... I know I would put this code in the keypress event of my test box, but just until I get it working I attached it to a button to search. (I basically got this online and not even sure its the correct usage.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'Create a dataview[code].....
The item in red is where i get an error. it sucessfully builds and i open the find form enter a last name that I know is in the customers table, but I get the error "Cannot find Column ["whatever name i typed inthe text box"].So first of all is this the correct way of going about what I want to achieve?If so how can I get it to work?BTW the next step for the user would be to double click the customer in the list box they are searching for to open the customer Details form for that customer, so I would need an ID or Index attached to that item to be able to open that record in another form.
I've populated my DataTable will all the results from a SQL search. Upon a button click I want to populate a combobox with all the results where a condition is met. My DataTable as a column called UserID and I want to add all results where the UserID is equal to a set value (for example 12). I can do this to add all results and I guess I could add a if statement inside this to be If Entry.Tag = 12 Then but is there a better way?
[Code]...
I have a listbox and i populate it with data in my code like this on the page load....
[code]...
So say one item in the list is displayed Ted Jones (123) and its valuefield should be 123. Im just not understanding what i am doing wrong here.
for now, i am using this code but it doesnt give me what i want.. for example i want to list all the items with the string "1"
Dim x, count As Integer
x = ListBox1.Items.Count
count = 0
[Code]....
I have setup an OleDbConnection and my query works just fine but the problem I am facing is that I want the entire query not just a certain row or column. I also would like to place this entire query into a blank excel spread sheet.[code]
View 1 RepliesIf this is in the wrong section, I have a program that queries a database and puts the info in a specific format in a txt file. Now my problem comes w/ how to format the date.
Should I format the date in the SQL query OR is there a way to take the result from the query and format sometime before it is writen to the txt file? I'm not exactly sure how to do either. Would I need a subquery to get the desired date format?
[Code]...
I am using an access DB and wanted to create a query that returns user's in the db. First I need to check the db to see if it is empty. Then I need to check to see it my query returned any values. How do I go about doing this?
View 6 RepliesI'm a bit confused on how to grab query results. With VBA i would open a record set and have the results of the query written to that recordset. IN VB.net how can I grab the query result and throw each column into specfic arrays?[code]Now how would I force it to query my DB? I have a connection established already.After the query how can i play with the columnes and place them into arrays?
View 2 RepliesI have used linq quite abit but was just wondering how to append the results of two IEnumerable(of X) together into one IEnumerable(of X)
View 4 RepliesI had this query sp_msforeachdb 'select "?" AS db, * from [?].sys.tables' when I execute it in sql server, it return multiple results. How I can read all the results in my vb?
View 2 RepliesI have the following code in my program: Dim empenrollments = From enroll In db.EnrollmentSummary(eid)
Select New With {.Name = ename, enroll} Dim elist = empenrollments.ToList returns this error
In the following lines, I have to get each row in the returned results and add it to a DataTable, but it never gets there.
[Code]...
I am familiar with the VB6 ADO way of dealing with SQL queries and looping through the record set results.
However, what is the correct way to query a server, cycle through the results, and dispose of my query in VB.Net? All the ways I have been using seem to be unstable and crash randomly.
I have been using the following code:
Public Function GetSQLTable(ByVal strSQL As String) As DataTable
Dim table As New DataTable
Dim adapt As SqlDataAdapter
[Code].....
I am learning VB.NET and wanted to try and connect to a Oracle.DataAccess with this simple SQL Query but am stuck how to get my results.
Imports Oracle.DataAccess.Client
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click[code].....
I'm trying to get the results of a WMI to display in a datagrid however the code executes without error yet the datagrid doesnt show any output
Try
Dim scope As New ManagementScope("\" & servername & "
ootMicrosoftDFS")
[code].....
I'm trying to execute a SQL query and pull the results into a text file. However, I'm getting an error in the bolded part. I think probably the biggest help would be an explaination of what the code in bold is actually doing. I pulled this from a book but don't think I completely understand. To me it seems like its saying that for each row in table 'extract'. Extract it, and write it?? But it doesn't seem to work that way. When it gets to that part, the error I get says that the row doesn't exist in the table
Private Sub btnExecute_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExecute.Click
Cursor.Current = Cursors.WaitCursor 'hourglass cursor
Dim connection As New SqlConnection
[code]....
I have a query using LINQ-to-SQL. It queries an underlying database table Rooms. It uses Where conditions to narrow down the results, namely:
Gender.Current Occupancy < Max Occupancy Available Flag is Checked I know this should return results but it keeps returning an empty set.Code is below
[code]...
UPDATE: I've verified that the issue is with the statement where sh.is_available = 1, which doesn't make sense since this is a bit field.
Why would a VB/ASPX page not return results for a query which runs fine with other Oracle clients? (Same username) The following code should first output the query and then execute it outputting a single exclamation point per record. However, it outputs the query (as it should), but does not return any rows (nor error). If I copy the query to SQL Plus (or other editor) as the same user, the query returns results.
Why might my code not output any results?
Dim MyQuery As String = "...some query..."
Dim Factory As DbProviderFactory = DbProviderFactories.GetFactory("System.Data.OracleClient")
Dim myConn As DbConnection = Factory.CreateConnection
Dim myCommand As DbCommand = Factory.CreateCommand
Dim MyReader As DbDataReader
[Code]...
I have a basic question about using a database with Visual Basic.I'm using a OleDb connection. I have dragged and dropped editboxes from the DataDource view. This automatically places the table navigation- bar on the form. When I run it this works fine.However I want to be able to search within the table, with an SQL statement.How can I connect the results from the SQL query to the navigation bar,such that the editboxes automatically take the values of the record without having to assign every textbox manually?
View 1 RepliesDatagrid with results form sql query
View 10 RepliesI need a clarification about using datagridview and query statement. i created a sql express database. In the project has been created a dataset with inside a table. In my form i used a datagridview and in automatic have been created BindingSource, TableAdapter, TableAdapterManager and BindingNavigator.
Till here everything is ok because i can add, delete and save members of the table.
Now i wanted to use another datagridview for a research but i don't understand what to use for do that.
procedure to search in a table using a new query?
I know that have been already done this kind of questions but i don't understant if using bindingsource, sqltableadapter, tableadapter ecc..
I am trying to display query results from SQL server in VB. I wrote following code, but not getting how to "Just display the results";
[Code]...