I'm new here, I have a problem with my query in my POS program.For a product I need to read the price of it, I made a connection with my database, it's succesful I've already tested it. When I click to a button then will a msgbox appear with the price of that product.
POS
Private Sub btnGroot_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGroot.Click
[code].....
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
i should say hi experts :D . Help me with this pretty code :)
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
I'm checking if the application needs to update before the user starts the software. But, they have to enter a few items of data and then press enter. When they do, if an update is available, the application closes, my update app runs and then the new version is opened. I want to just update when the application is loading, so they don't have to waste time entering data if the application is just going to close anyway. But when I run the block of code to check for updates, I get an SqlException.
[Code]...
I have a database application connected to a sql express datafile, i am using a datagridview and have clicked on the arrow and added a query. the query is simply sort / ascending on my date field which is a text field with auto generated when the field is focused so i know the dates are entered correctly but when i use the query they are not in their correct order. [Code]
View 10 RepliesI've been trying to figure out how to use the CONTAINS clause for the last couple of days, on and off. The appropriate datatable is configured for full-text search, but whenever I run the program and come to the point where this query is run, I get this error "Syntax error: Missing operand after 'CONTAINS' operator.". Here is the code:[code]....
I've tried replacing the "*" with parenthesis, percentages, and deleting them, but it always gets the same result. What is the correct syntax to use the CONTAINS clause within the .filter query or is there some work around or something that I am missing?
I'm trying to set the tab order on my form and no matter what I do, it doesn't relearn the new tab position after I change the index. It almost seems like the form is locked.
View 1 RepliesI've created a log in system using a database and query builder to return the correct values, however, once the users signed in I need to bring up the rest of their data from the same table in the database. How'd be the best way of going about this? I'm not sure whether the log in should be changed to use the primary key as well.
View 2 RepliesI have read through soem other threads on this site and it has gotten me this far, but I can't seem to get over the hump.I am trying to create a table to reports back the proper data from a sql database based on what a user types in a textbox. I have pulled a dataset that i have already setup onto the tabl.
Public Class robsearch
Dim sstring As String = "1234"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code]......
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]...
I got this code in order to build an url for the link using a querystring from the current page. The problem is.... It doens't work.
[Code]....
I am trying to read data from remote SQL base. I have written the function that works great if you need to get 1 Value , but when I want to read 2 or more value at from one query it doesn't work [Code]
View 4 RepliesWhen I'm trying to run this program Sql QUERY doesn't work properly , but the month and day are okay but it comes to year it doesn't work...
Dim strSql As String = "SELECT * FROM tblAudit WHERE Date_Time BETWEEN '" & Format(dtpFROM_F.Value, "MM/dd/yyyy") & "' AND '" & Format(dtpTO_F.Value, "MM/dd/yyyy") & "'"
classLibrary = New ConLib
classLibrary.openConnection(strConnection)
lblconstat.Text = DatabaseStatus
If Not classLibrary.isconnectionopen() Then
Exit Sub
End If
classLibrary.initializeCommand(strSql)
Basically i have a query string that when i hardcode in the catalogue value its fine. when I try adding it via a variable it just doesn't pick it up.This works:
Dim WaspConnection As New SqlConnection("Data Source=JURA;Initial Catalog=WaspTrackAsset_NROI;User id=" & ConfigurationManager.AppSettings("WASPDBUserName") & ";Password='" & ConfigurationManager.AppSettings("WASPDBPassword").ToString & "';")
This doesn't:
Public Sub GetWASPAcr()
connection.Open()
Dim dt As New DataTable()
Dim username As String = HttpContext.Current.User.Identity.Name
[code]....
When I debug the catalog is empty in the query string but the WASP variable holds the value "WaspTrackAsset_NROI"
[code]Myself and a coworker have stared at this quite a lot and we can't figure out why it's not working. The problem is in the value for @ID (since it still works when I leave the other one parameterized). The funny thing is, Just a few lines of code above it I have a different query that sets a parameterized value for the same ID, using the the same choices list that the For Each loop is getting the match variable from.Choices is a list of longs, and when I use choices(0) to parameterize ID in a query, it works. But now down here in this loop I have the new match long, and it doesn't want to make it work for me.
View 1 RepliesI have two tables say "Table1" and "Table2". I made a UNION query and saved it as "AllTimesFailure". It is worth mentioning, I am using Access DB. When I am trying to fetch the records from AllTimesFailure through oledbDataReader, it says "The Microsoft Jet database engine cannot find the input table or query 'AllTimesFailure'. Make sure it exists and that its name is spelled correctly.". I double checked query name and found correct but the problem still exists. when I run the same query as I pass through my command object, it works fine in Access query analyzer and fetches records normally.
[Code]...
I'm trying to write a Vistual Studio 2008 macro to run a stored TFS query and display the results.Previously I've created a query and named it 'Assigned to Me' to display all the work items currently assigned to me.Instead of View->Team Explorer, click, click down the tree to My Queries then double click 'Assigned to me' I want to write a macro to automate these steps.
Sub TemporaryMacro()
DTE.Windows.Item("{131369F2-062D-44A2-8671-91FF31EFB4F4}").Activate() 'Team Explorer
DTE.ActiveWindow.Object.GetItem("tfsserverMyProjectWork ItemsMy QueriesAssigned to Me").Select(vsUISelectionType.vsUISelectionTypeSelect)
[code]....
have a query in SQL, returns the results I expect, however when I copied this query to a bindingsource.filter call,I get "Missing Operand" errors
Me.ItemsBindingSource.Filter = String.Format("SELECT * FROM items WHERE (GETDATE()) BETWEEN (items.ItemStartDate) AND DATEADD([month], items.ItemOccurances, items.ItemStartDate)")
I've spent a whole day on this already without figuring it out. I'm hoping somebody can help me translate the following MySQL query to work for SQL Server 2005:
SELECT MAX ( messages.date ) AS maxdate,
topics.id AS topicid, topics.*, users.*
FROM messages, topics, users WHERE messages.topic_id
= topics.id AND topics.user_id = users.id AND
topics.forum_id = " . $forumid . " GROUP BY
messages.topic_id ORDER BY maxdate DESC
$forumid is a QueryString value defined in the following VB.NET code-behind code:
forumName.Text = "<a href='ViewForum.aspx?forumid=" & row.id & "'>" & row.name & "</a>"
Banging my head against a wall here. I have a query that looks like this.
SELECT FirstName, LastName, Address
FROM Members
WHERE FirstName LIKE 'JOE%'
That works absolutely fine in query wizard and the DataTablePreview data window. However, when I do this.
SELECT FirstName, LastName, Address
FROM Members
WHERE FirstName LIKE ?
I get nothing when I run the fillby method. If I change the LIKE to =.
SELECT FirstName, LastName, Address
FROM Members
WHERE FirstName = ?
Everything works great. I need to get LIKE working though so I can wildcard search.
I'm using the SQL server OLE db connections if that means anything.
UPDATE
Using the LIKE operator doesn't work at all. When I just swap out = for LIKE. Nothing is returned.
What is the correct format of using keypress in VB 2010. I have tried the following code to use ESC as shortcut to closing the form but its not working: [Code]
View 4 Repliesis it possible to get the correct time online? Because we are currently making a system that requires date and time. We are preventing a common error where the system time is outdated so we are going for online time and checking it in out system.
View 2 RepliesThis seems really dumb but I go to this site - [URL] and click on the link for Visual Basic 2010 Express, select English as the language and I get the file vb_web.exe. The file installs Microsoft Visual Web Developer 2010 Express. All of the tools in it seem to be for web development only.Where is vb express 2010 download for creating Windows forms, console apps etc.? (or am I missing something "basic" -- sorry about that -- regarding how the 2010 version works?
View 7 RepliesI'm trying to read data from a text file into an array and then loop through all the lines and display it into the textbox, only problem is i want each line on a new line so this is what i have:
[code]...
But that adds a newline to that last line causing a out of bounds error.How do i make it add a newline for each LINE except the last one?
Lately I have been making a program (I guess you could call it a trainer), which would read the process memory to get the character's coordinates in a game. It later makes a simple map and show it in a separate windows. I built this program in VB.net, and it works surprisingly well. The only problem is the fact that the memory address where the coordinates are stored, changes every time I restart the game. Could someone please help me find a way, for the program to find the correct address by itself? If it helps, the game I am referring to is Minecraft.
View 2 RepliesWhat is the correct method of setting the printer pagesize?The more I google it the more confusedI become as every example seems to be different.
View 1 Repliesvb.net
Public Sub PopulateClient()
Dim clientadapter As New MySqlDataAdapter("SELECT clientid, Client_Name FROM client", strConn)
Error I keep getting is "Input string was not in a correct format." It is getting this error because of this:
vb.net
clientID = Int32.Parse(cboClient.ValueMember)
If I don't use that for the PopulateDept() then I get this error "Error1Option Strict On disallows implicit conversions from 'String' to 'Integer'.TaxCert.vb19033TaxCertForm"
I want to test whether the connection string is valid or not?What should I do ?
View 18 RepliesI have an SQL Database which has some end dates. I have used this little statement to make sure that the dates come out of the database in the right format
Execute("Set dateformat dmy")
And I use the below statement to enter the data in to a datatable and, with the above command, when I go to look at the data in datatable visualiser the dates seem to be in the correct dd/MM/yyyy format
"SELECT CID, expdate FROM Traineecerts WHERE iscurrent = 1"
Now when i try d1 = row("expdate") the format changes to the american MM/dd/yyyy format
Please note d1 refers to a variable with the type of date. Even if I format the dates after using d1 = format(row("expdate"),"dd/MM/yyyy") they don't change unless I make d1 a string. Is this normal?
I am trying to test is the innertext of a <td> tag corresponds with an <input> tag before clicking it. To be more clear I have a list of the MAC Addresses in my program and I want to delete a selected MAC Address from the website that matches the selected one.
I tried this
WebBrowser1. _
Document. _
GetElementsByTagName("table").Item("listTab").GetElementsByTagName("input").Item(selected item index).InvokeMember("click")
But not knowing the right index of the MAC Address that matches it just deletes the wrong MAC Address.
