i am creating a pda application using vb.net and sqlce and i can't seem to get parameterised query (or atleast i think mine is one) working.i dont know what i am missing because on the code below, i still get a END OF STATEMENT EXPECTED.[code]
View 2 Replies
I am trying to query WMI to get the current IP address of the computer.I have the following code, which queries the MAC address, and this works fine.But if I change the query to "ipaddress" (a valid property), I get a run-time error, something about a type mismatch [code]
View 4 Repliesuser.fld_usr_name is a string with the value random name user is an object that is given as a parameter
ByVal user As GUser
this is the linq query that doesn't work
Dim result = (From usr In users Where usr.Name.Contains(user.fld_usr_name) Select usr).ToList()
this is the one that works
Dim result = (From usr In users Where usr.Name.Contains("random name") Select usr).ToList()
this is the error
Object reference not set to an instance of an object.
I am using this in Linq to Active Directory library which probably means it's linq to entities I've tried everything?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If Master.Text = "8888" Then
[Code]...
i dont know whats rong in this , it says syntax error at * if i delete star then query runs but database still contains the row. FYI its code for desktop application using vs2008
statement = "SELECT OrderID, (SELECT VendName FROM Vendors WHERE Vendors.VendorID = Orders.VendorID) " &
",OrderDt, RcvdDt, OrderTotal " &
"FROM Orders " &
"WHERE VendName=? " &
"ORDER BY OrderDt DESC"
Dim cmd As New OleDbCommand(statement, connection)
cmd.Parameters.AddWithValue("VendName", txtVendorFilter.Text)
Dim reader As OleDbDataReader = cmd.ExecuteReader(CommandBehavior.Default)
I was trying to do this before by simply concatenating the textbox value right into the SQL and I was getting a "No values given for required parameters", and read that that I should use parameterized queries instead. So I tried this and it doesn't give me any errors, but the reader never has anything in it. I've never used parameterized queries before, so I'm a bit lost as to why this isn't working. I've changed the above code to account for OLEDB from what I briefly read on how it should work, and it's giving me the "no values given for required parameters" again.
I have a SQL query string that gets the top 5 records from a database however 3 variables are passed with the sql query that gets specific data.[code]
View 5 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 Replies[code]its show me that it have written the command but when i stop the program and see my db its is not there. i've searched the net and alot of books but i cant seem to make it work.
View 1 RepliesI am trying to run what I thought was a rather simple parameterized insert query, but am running into all sorts of problems. SQL EXPRESS 08R2, VB.net
Here is the VB code that builds the parameters...
UPDATED Variable names:
itemDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings("MyConnectionString").ToString()
itemDataSource1.InsertCommandType = SqlDataSourceCommandType.StoredProcedure
itemDataSource1.InsertParameters.Add("@short_Text", short_Text)
[Code]....
With DataAdapter i passed a query and this is working....
Dim strSQL1 As String = "SELECT tbl_Items.GroupName, tbl_Items.ItemName, tbl_quantity.Quantity, tbl_quantity.QtyDate FROM (tbl_Items INNER JOIN tbl_quantity ON tbl_Items.ItemID = tbl_quantity.ItemID)WHERE(tbl_quantity.QtyDate = #12/29/2009#)"
Dim da1 As New OleDbDataAdapter(strSQL1, DataConn)
Dim dt1 As New DataTable
da1.Fill(dt1)
But when i give the date as this, not working...
Dim tmpDate As DateTime
tmpDate = System.DateTime.Now.Date
Dim strSQL1 As String = "SELECT tbl_Items.GroupName, tbl_Items.ItemName, tbl_quantity.Quantity, tbl_quantity.QtyDate FROM (tbl_Items INNER JOIN tbl_quantity ON tbl_Items.ItemID = tbl_quantity.ItemID)WHERE(tbl_quantity.QtyDate = " & tmpDate & " )"
I have the following code which will only return one column of 41.
vb.net
Using Command As New OleDb.OleDbCommand("SELECT * FROM Products_TAU WHERE ItemID= @ItemID", Connection)
Command.Parameters.AddWithValue("@ItemID", ItemID)
[Code]....
That table alone is filled with 76 records and has 41 columns of data to pull.. this is only returning the first column of the row indicated by the where clause.
Before I had the where clause call it by lineID which there is 4 records of that... and it was able to pull 4 columns from it...
The below query fails with Null Reference Exception when there are elements in BOMIDs where MatID property is nothing.I thought the 'x.MatID isnot Nothing AndAlso' would prevent the x.MatID.Process part of the where from being executed. There are a couple elements in the BOMIDs collection that where MatID is nothing.
From x In BOMIDs _
Group Join y As PurchasedProcess In SpecialProcesses _
On x.MatID.PurchasedProcess Equals y.Name _
Into G = Group _
[code]....
I am trying to prevent from having to escape apostrophes in my string variables by using a parameterized query with a OleDbConnection, but it is not working. I am trying to insert into an Access db and I keep getting those pesky html codes.
Dim pConn As New OleDb.OleDbConnection
pConn = New OleDbConnection(cb.ConnectionString)
Dim SqlString As String = "INSERT INTO Strings (Mlt_String_ID, Lng_ID, Strg_Name, Sht_Text, Lng_Text, Alt_Text) Values (@Mlt_String_ID,@Lng_ID,@Strg_Name,@Sht_Text,@Lng_Text,@Alt_Text)"
[code]....
I have a SQL 2005 table called Customers and i would like to query the table for exact match and partial match. The exact match query is working OK but when i use the partial match, it doesnt return any result. Strange thing is, it works inside the query designer, it returns rows. On the dataset, if i right click and say 'Preview Data' and supply the search criteria, it doesnt bring in any rows. Same happens in the vb.net form also. Instead of partial string, if i supply the full customerid, it returns a row.Whereas I can return rows on another table, Suppliers. I dont know where the problem lies. Here is the sql:[code]In fact, I am trying to use the wizard generated code and details on the form. No changes done to the code or form.The customer id is nchar(10) column and is the primary key also. I ran the same steps on the Northwind database too, and the same problem exists.
View 4 RepliesI am trying to make a project for point of sale and i am having issues with updating inventory table. once cashier make sale items quantity should get subtracted from inventory table. i tried bellow code but it is not updating table, however in message box it does give me new quantity for that item.
[Code]...
[Code]...
MsgBox(cmd) End If End While '***** END ***** reader.Close() con.Close() MsgBox("The Connection to the Database is now Closed") End Sub End Class
I not able to update query in MSAccess having 3 images. Also, its not showing any error.
Awaiting ur reply.
[Code]...
I am trying to prevent from having to escape apostrophes in my string variables by using a parameterized query with a SqlConnection, but it is not workinUPDATED: this is current code...
'Populate Connection Object
Dim oCnn As New SqlConnection(strConnection)
'Define our sql query
[code].....
this is the code
Dim con As New OleDb.OleDbConnection
Dim com2 As New OleDbCommand
Dim constring As String = ConfigurationManager.ConnectionStrings("esourcecon").ConnectionString
con = New OleDbConnection(constring)
com2 = New OleDbCommand("UPDATE Customer SET CName = @CName, CAdd= @CAdd, CTel= @CTel, Cmob= @CMob WHERE CName='" & C1.Text & "' ", con)
[Code]...
id is an autonumber field and if i change the where string to another column then also i dont get any error and the values are still not entered
I am new bie in Scripting world.I wrote a script in vb 2008 to query active directory information.Even though the script task executes successfully when i tried toretrieve records from the object variable using for loop container in ssis it gives an error the object variable doesnt have valid data n it.i suspect that i am facing errors in assigning the result set to the package variable declared as object.Please could someonehelp by having a look whether the data will be assigned correctly according to my script.i am trrying to pass the information queried from ad to package variable gvresults described as object.
[Code]...
I have the following in VB:
Dim sources = From source In importSources Select New With _
{.Type = source.Key, .Source = source.Value.Name}
dgridSourceFiles.DataSource = sources
[code]....
I want the Indexing server Query to Search any type of document by document name.Let assume i have ..
test.ppt
test.pdf
test.doc and so on.
If I enter the test name in my search text box the , I want the search result with these file. I am using the vb.net with the help of MicroSoft Indexing Serice. I need the query of MicroSoft Indexing Serice for search any type of document by document name or title.
Public Function GetSearchResultFromIndexServer(ByVal strSearchString As String, ByVal sPath As String, ByVal sLookIn As String, ByVal sSortBy As String, _
[code]....
I want the Indexing server Query to Search any type of document by document name.
Let assume i have ..
test.ppt
test.pdf
test.doc and so on.
If I enter the test name in my search text box the , I want the search result with these file. I am using the vb.net with the help of MicroSoft Indexing Serice. I need the query of MicroSoft Indexing Serice for search any type of document by document name or title.
[Code]...
I'm looking for a control that allows images to be placed onto it and moved about. Moreover, I need to draw lines between the images. It will sort of be like the query designer in SQL Man Studio. It will be used as a virtual desktop where a variety of objects (and their icon representations) can be freely placed and moved. I'm having a blank and cant remember where I saw this before.
View 2 RepliesI am trying to find customers name that starts with "S" in my access database. If i run the following query in access its working fine. Select Lastname from employees where Firstname Like '*S*';. it displays two records which is right. if I use it in access it..its not working. Any idea why? All other queries are working in VB. like if I use Firstname equals "Sam" but it doesn't work when I use Firstname Like '*S*'
View 3 RepliesHere is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
When Creating a query using the sear Criteria Builder . I keep getting the error : "The schema returned by the new query differs from the base query" what does that mean and how do i avoid this problem in future
View 2 RepliesI found on msdn samples and modified (add Thread.GetDomaind.UnhandledException)
<SecurityPermission(SecurityAction.Demand, Flags:=SecurityPermissionFlag.ControlAppDomain)> _
Public Sub Main()
' Add the event handler for handling UI thread exceptions to the event.[code].....
I am connecting to an Access database and using a parameter query with the LIKE operator to return all rows that match query. The string to search for is taken from a Textbox
sql =
"Select * FROM Allview WHERE Info Like" &
"*" &
CStr(TextBox1.Text) &
"*"
The query does not return any data in vb, but when run from access with same string, there is data returned.The connection to the database is done correctly, as I am able to return data with various other queries.
Partial code :
Dim
con As
New OleDb.OleDbConnection[code]....
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
