SQL Query String Not Working
Sep 14, 2011I 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 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 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?
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 RepliesPrivate 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'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'm currently making an app that needs to run a query between two dates. this app will run automatically, so i need to put the dates as today and yesterday, essentially.
[Code]...
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]....
Private Sub txtname_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtname.TextChanged
myConnection.Open()
[CODE]...
I want to four digit code like Abneesh than first query finding max of A and second string take string A than code generate like A001----------A999
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 using the following lines and am not able to concatenate the needed values, why it is not working.
Dim rxBuffer As String = " "
Dim rxData As String = " "
Dim rxDataStringBuilder As New StringBuilder[code].....
I make a query in coding. But I got conversion error.My query is below
Dim strSelect As String = ""
strSelect = "SELECT " & _
"Description As [Desc], " & _
[code].....
Exception error is like
Conversion from string "iif(CurCons = 0, " to type 'Double' is not valid
Actually, in my report, i wanna show if it's zero then '-'. If i set it in this string.I got another error like below The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value.
From da.Fill
Dim cmd As New OleDbCommand(strDynamic, m_DBConn)
Dim da As New OleDbDataAdapter(cmd)
da.Fill(ds, "tblCur")
On my project, If I do String.Contains, Even if its positively true (Made a MsgBox Popup) It returns false! My Code:
Dim bad As Boolean = False
For Each item As String In adlist
If e.Url.Contains(item) Then
[code].....
I 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 Replies