ill get the obviuose out of the way. I have XP Pro, VB2010, query(read only) to an ODBC db, displaying several results in a text box. How can I make the data display w/o the the numbers displaing decimal places. These are quantities that are to be displayed not pricing, ie. the result would say 7.0000 qty on hand, and it should say 7 on hand. The code is below,
[Code]...
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]...
1. How to produce querry results within the application by user input. ( I want to acheive a similar function to querry in MS Access.
2. How to produce results in a form application from a preassigned querry triggered by a button click event.
I have the following code:
Dim db As New linqclassesDataContext
Dim categories = (From c In db.faq_cats)
NewFaqDropDownCategory.DataSource = categories
[code]....
In an application for a Storage company, I have a form with 107 buttons in five Group Boxes. Each Group Box represents a Building and each Button represents a Storage Unit. They are layered in Table Layout Panels, bottom TLP has 5 columns, one for each Group Box, each Group Box has a TLP with 2 columns and 10 rows, where each button is located. What I would like to do is change the color of any button based on the results of a query.
Buttons are called btn1, btn2, btn3..... Text on the buttons is 1, 2, 3, 4,.... I have a table for the buildings and one of the properties is "Available" set as an intger and is either 0(No) or 1(Yes). I have a query that I run on form load that returns the correct results, to test I put a DGV on a form and set the DataSource to the DataSet returned. Returned is the "Available" Buldings Number(1-107)[code]...
I have a project in Visual Studio 2008 and there is a working data connection to a MySQL database. In other words, I can query the db directly from Visual Studio and it will display the results.
I've tried a couple of approaches that I found online for writing a connection string and accessing the db, but no luck yet.
All I'm trying to do is code a button to query the db and then reset the text property of a label/textbox to display the results based upon another label/textbox value.
The pseudo-code I am imagining is something like this:
Private Sub query_submit_button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles query_submit_button.Click
result_textbox.Text = SELECT field FROM table WHERE otherfield = key_textbox.Text
End Sub
I didn't see any related questions posted on SO - forgive me if I missed one that already exists and this is a dupe.
What is the correct way to accomplish this?
EDIT
Using MySQL 5.1
How do you carry out a query from a criteria e.g name entered by the user from a textbox. and then display the query results in a list box..
View 2 RepliesAt present i have an interface which displays a string of sql code in a rich text box.
I also have my microsoft access database connected to the form.
How would i go about getting the sql code in the rich text box to produce the results for the query??
How can I display only the most current results from a text file? I have a button the user can click that needs to display only the most current results from the text file.
View 9 RepliesSimply put, I have a text file full of reg values. I want to search the text file for X number of reg values. I want to then, have those values and their dword values (whole line + next 3 to 4 lines in the file) listed in either another text file or an Excel spreadsheet. Regardless of the format, I would like to have the values sectioned off for each of the values searched (probably tables of some sort).[code]...
View 1 RepliesI am writing my own script for a simple calculator that determines if a number is prime, and its prime factors.[code]The loopcount = compare - 2 means I want the loop to be 2 less than the square root of the answer so that when do a descending calculation (loopcount = loopcount - 1) it doesn't see if 1 or 0 is a factor of the answer. for the calculations after that, I want, every time n1 = n2 (a whole number factor of the answer), I want to report those results to a text file (n2 and n3) in this format "(n2, n3)" then go to the next line. and continue to execute the loop until the loopcount is zero. Currently, when I run the code, the application closes when I click the prime button (button that runs this code) and I don't know why. This is my first semester in school, and have never coded before, so I am a definite laymen with code, but I really really want to learn it (hence why for fun im just creating algorithms for different things).
View 2 RepliesI started with not knowing anything and I have built 2 programs over the last month and a half and have learned valuable information from the help of this board. I have 1 last hurdle before I am done and I am hoping to get another tip for this. First of all let me start by explaining what I have done.
[Code]...
Catch block in text.vb and display the results in default.aspx
View 5 Replieshow 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 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 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 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 Replies
