I am trying to query a SQL db and send the results to a notepad or wordpad doc. I have the VB code wrapping the statement and it works fine but I have to put the results to a doc so the user can preview and/or print.
View 3 RepliesI'm using vb.net express with access 2010.Everything is working fine except for a simple query:SQL: SELECT * FROM Customers WHERE Name Like 'Ale*'Which returns all the names starting with Ale. Now in my .NET code I wrote this:cmd = New OleDbCommand("SELECT * FROM Customers WHERE Name Like " & Chr(39) & Name.Text & Chr(39), connection)Now when I start the app and in my textbox "name" I write Ale* I have the following expression:SQL: SELECT * FROM Customers WHERE Name Like 'Ale*'But when it executes from .NET (dr = cmd.ExecuteReader) it doesn't find ANYTHING.
View 11 RepliesI've tried different approaches to query a simple xml and compare one of it's values but none of them worked well.
Consider the following XML structure:
<?xml version="1.0" encoding="iso-8859-1" ?>
- <Shops>
- <Shop>
<text>Northampton</text>
<value>NN</value>
<currentdate>050809</currentdate>
<labelcounter>1</labelcounter>
[Code] .....
I have the shop name in a drop down list which is ShopsDDL and it's set to autopostback. What I want to achieve is:
On postback, check for a xml node where node's text = shopDDL shopname
And retrieve also this node's currentdate and label counter.
Rhen, if the node currentday = today then increment labelcounter by 1
Else set labelcounter = 1 and currentday= today
My problem is the XML query, I can do all the logic as soon as I manage to retrieve data from the XML.
The example of source code to make a simple notepad?
View 2 Replieshow do I use notepad as a database inside a vb.net program.I am making an athletics database/profile program which will include all school records for each and every student.So what I want to know is, how do I use a notepad file, filled with data, to perform search functions on records (like finding the fastest times in a particular event) and sort functions (assending order of times etc.) and view them on a form.
View 1 RepliesI am trying to follow an example. I'm getting the following errors:
1. PartNum is not a member of 'Vantage2.OMSDataContext.
2. Name 'Where' is not declared.
3. Method arguments must be enclosed in parenthesis.
4. Name 'p' is not declared.
5. Comma, ')', or a valid expression continuation expected.
For reference, the link is here: [URL]
I have followed with my code as follows...
Class Window1
Private db As New OMSDataContext
Private View As BindingListCollectionView
Private Sub Window1_Loaded(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs) Handles Me.Loaded
[Code] .....
I know this sounds simple to the majority of the database gurus out there but I am finding it difficult to find anything related.I am using Visual Studio 2008 VB.net winforms application.I have a form which contains a datagridview. what I want to do by push of a button is set the field "OnHand" either to default or 0. The 'either or' is really for you guys. Which ever one works the best in terms of reducing code or functionality is obviouls prefered.Once the 'OnHand' Fields in every record has changed then I would like to save all the data back to the database'This is more than likely very simple I just cannot find anything that discusses this kind of thing.
View 1 RepliesWith a 1-many relation. Ok, I have constructed the schema, and now I want to make the appropriate forms in which a user would scroll for a customer and then by pressing a button, a new form would appear showing all the orders that he has made.
I am interested in the way of building two forms that would have a one to many relation. That is basically what I would like to know. Also, Do you have any good book to suggest in order to create a real world app, in VB2008, Emphasizing in data-binding and connecting controls with underlying DB, one to many forms, searching etc.
I have loaded my database with one table under "Data Connections" in the "Server Explorer" pane.What is the standard / best-practices way to handle a simple query in a VB ASPX page?
My left <div> would be a set of form elements to filter rows, and when the button is clicked, the main <div> would show the columns I want for the rows returned.
Note: Answers in C# are okay too, I'll just translate.
I am trying to get a query to work with Visual Basic 2010 Express addition I have pasted the code below but it just errors out with to many arguments I have taken this sample from a reference book but cannot get the darn thing to work. I have looked all over the net and Microsoft for a solution but still no go if any one can help it would really be great. BEP
Private Sub FillBypeeps1ToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FillBypeeps1ToolStripButton.Click
[Code]...
This one is my simple XML
Dim Xml = <BODY ID="1">
<HEAD1>
<Eyes type="S" l="1" f="1"></Eyes>
[code].....
I am just starting to dive into the ADO.Net routines in VB.Net, have used ADO in VB6 forever just would like to make sure I am getting started on the right foot here.
'As I test I had hard coded the connection string here which I have removed from the post, I will switch it to a var that is read from a config file later.
CN.Open()
Dim Cmd As SqlCommand = CN.CreateCommand
Cmd.CommandText = "Select * from tblusers where userid=@UserID"
[code]....
btw I realize that I have not yet added a message for when the Userid is not found. I am more concerned with the method I am using to query the db and read the results as well as closing the objects afterwards.
I am trying to create a tool which I would input a word in a text box and it would search the path i give it to look for a word in a notepad file and copy the whole line to a new notepad and paste it.
i did this for now, i am able but i am able to copy all the text from the note pad and put it in a textbox for now..
Dim FILE_NAME As String = "P: est est.txt"
Dim objReader As New System.IO.StreamReader(FILE_NAME)
Dim TextLine As String
[Code].....
I am having trouble to get the command to ask them to go read the text file and copy only the line for the word I put in the input box and to put it in a new notepad.
I have a form that when you click a button it begins a query. I want the user to know that they already started a query and they basically need to wait and not hit the button again. To do this I have a list box that has an lbResults.item.add() to it
Code:
Private Sub btnControlKSMS1117Query_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnControlKSMS1117Query.Click
[code]....
i'm trying to populate a simple combobox with a query to a MySql database. I Just want the combobox to show the results of the query:
SELET DISTINCT models from Cars
I am using VB 2008 with Datasets, how can I achieve this?
I'm retrieving data from an Excel sheet, using a simple SQL query using a textbox as input to my variable. It works great when I enter an integer to search for (such as 213 for example) but when I put in a mixture of numbers and letters (48A for example) I get the following error: Syntax error (missing operator) in query expression '[P&L]=48A'.
Private Sub MPLS3()
Dim BrNr As String
BrNr = TextBox1.Text
Dim stSQL As String = "SELECT [MPLS Date] FROM [Master Data$] WHERE [P&L]=" & BrNr & ";"
[code]....
The code below works fine on my development PC, but when I deployed the app, it crashes.
Here is the lines of code that are relvant
Private TdsTypesList As List(Of TDS_Type)
...
TdsTypesList = (From tt In db.TDS_Types Select tt).ToList
[Code].....
I have many queries that are using linq, and none of them throw any errors. The set of data is not very large either, less that 100 rows. I dont know if I have any other queries that do not have where statements in them that work.
Running .net 3.5 without sp1 on the client machine, although I am running sp1 on my development PC. looking for a solution that doesn't require sp1 to be installed.
Edit Code breaks on the second line when remote debugging.
I looked over [URL] and tried the following, with the same error.
TdsTypesList = tl.OfType(Of TDS_Type)().ToList
I finally found a dirty workaround. Instead of pulling all of columns from that table, I was able to re-write the query to omit 1 column. This returns an object of anonymous type, and I can use that object. I still would like to know what causes this though.
how to draw a simple line chart representing sql query data results?
View 8 RepliesI 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
anyone knows how to fetch the query of a view (Sql server) in vb.net?
View 3 RepliesI'm fairly new to visual basic and have a problem that is probably quite easy to solve yet I have been unable to do it so far and am about at wits end.I have an access database with a table that contains a list of cities and states. what i would like to do is to populate a combo box on a vb form with a list of the states in the states column. the query that i have is as follows:
SELECT DISTINCT State from Cities I have previewed the data in the dataset designer and it works, i just can't figure out how to make it fill the combo box. i initially created a table with just all of the states and then used a binding source and table adapter to bind it to the combo box, but if I'm able to figure this out this would help with my application going forward
I have a string qText with the text of a query in it, say qText = "select * from Data". how can I execute it to fill a TableAdapter I have in my form with the resulting data?
View 2 RepliesI am writing a little program that does the following:Allows the user to enter a id number.Then when the find button is clicked, we connect to the database and run a select statement for the id.I am trying to figure out how to get the first name, last name and birthdate into textboxes on my form.
I would like to have a way to display a messagebox if the resultset = 0 so as to tell the user no records found.Then if the information is correct I am going to have a button to update the information which is going to call a stored procedure I have in place to update the record.how to make the connection which I think I have working and then loading the individual fields into the appropriate textboxes.
I want to ask how to i , passed the value i get from my previous form using this"Login.user.Text" to a Query Builder to filter the result based on the value of Login.user.Text" .
SELECT LecturerID, Lecturer_P
FROM Lecturer
WHERE (LecturerID = ??? )
[code].....
i'm trying to make a query to a sql database, so when the user enters the id, the columns related to that id will be displayed. but, im getting an error: "Object reference not set to an instance of an object"
the code:
Code:
Try
TextBox1.Text = InputBox("Enter the Id.", "fsdf.")
query = "select * from Students where Id = '" & TextBox1.Text & "'"
[Code]......
So I'm working with a mysql database, and I already have some queries down. I have to make a windows application form in vb.net that can display the results of these queries in a dataGridView.Lets say I'm working with frm1, and i have datagrid1 which will be filled using the query "select * from xyz" when btn1 is clicked.Can someone please take me through the right steps to do that? References needed, connections to be made, etc. I did look through online materials, but they are mostly way too long and not dataGridView specific
View 2 RepliesI have a simple "two-tables" database (SQL EXpress) and a very simple application (VB 2008 Express). The two tables are customer and order and their structures are:
customer(IDcustomer, LastName, FirstName) IDcustomer=primary key orders(IDord, Number, Description, IDcust)
IDord=primary key the tables are related (IDcustomer-->ID cust)
In VB2008 environment I create a dataset, by means of Data Source Configuration Wizard, which encompass both customer and order tables (xsd file). By opening xsd file I set the relationship in the following manner:
"Both relation and foreign key constraint"
Update Rule = Cascade
Delete Rule = Cascade
In my form I show customer table in detail-mode and orders table in datagridview-mode. Two Fill method are created in the Load event and they work correctly.In "CustomerTableAdapter" I create, with QueryBuilder, a search query (say LastName query) and I write the following code:
Private Sub frmSearch_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.CustomerTableAdapter.FillByLastName(Me.CustomerOrdersDataSet.custom er, "D") 'All Lastnames with first letter = D
[Code]...
I'm trying to run a query and display the result in a listbox. I can do it for a datagridview but not for a listbox .
Code:
Private Sub frmNieuweActie_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
strSql = "SELECT Acties.Actieid, Acties.Actie " & _
"FROM(Acties) " & _
[code]....
I get the correct amount of items in my listbox but it displays "System.Data.DataRowView" as item .
I have the following query that works fine if I cut/pase into an SQL query in access, but when executed in VB the loop is skipped - ie, no data is returned.
[Code]...
it seems that this query doesnt read the begindate and only displays record with enddate.
Code:
str = ""
str = str & "Select sum(quantity) as totalpurchase from purchaseorder where itemcode='" & itmcode & "' and"
str = str & " category='Consumables' and company='" & company & "' and (datereceive >= '" & datebegin & "' and datereceive <= '" & dateend & "')"
str = str & " and (postatus='received' or postatus='oh-hand')"
i am using vb2010 and mysql community server.