Calcuate In A SQL Query With Feild Values From A Different Row?
Aug 10, 2011
If I have a query dataset in MS Access (or SQL query) that results in a table with column A as such:
A
500
400
300
How can I hav Column B show growth rates such as B2 = (A2/A1) where A2 = 500, A3 = 400, and A4 = 300, and so on successively (like one can perform on an excel sheet) as such:
B
1
.8
.75
(Columns shown adjectly below for clarity)
A B
500 1
400 .8
300 .75
View 3 Replies
ADVERTISEMENT
Apr 14, 2010
url...How do I reference a query in a DataTableAdapter so that I can put the values gathered into a Textbox? I'd like them to all go on their own line in an order like so: LastName, FirstName, GradYr: MP1_Pts: MP1_Comments; MP2_Pts: MP2_Comments.Can someone guide me in the right direction here? This is the final step I need to take in creating my program.
View 12 Replies
Apr 24, 2012
Right now I have an array that is unparsed. One of its elements goes something like this:
"Blah, 555-5555"
So it's a name and a telephone number separated by a comma. The instructions I have tell me to use a query to put the information in the array into a data grid view in two columns, one for the name and one for the telephone number. I don't know how to isolate each inside a query.
View 6 Replies
Dec 26, 2011
suppose we have three tables in the Database:
[Code]....
View 1 Replies
Oct 25, 2011
I am trying to use Linq to Xml to query attribute values that will be used to populate a combo box. My xml looks like this:
<Records>
<Record id="1">
<LogoPositioning>
<Brand id="26">
<Xpos>100</Xpos>
<Ypos>200</Ypos>
[Code] .....
My issue is with getting the attribute values. I tried this:
For
Each xattr
As
XAttribute
In
attr
cboBrandChoice.Items.Add(test.Value)
Next
However, I keep getting the following error:
{"Unable to cast object of type '<GetAttributes>d__8' to type 'System.Xml.Linq.XAttribute'."}
I'm new to using Linq so this error isn't making a whole lot of sense to me.
View 2 Replies
Oct 26, 2009
I want to check some values in a sql db without populating controls. I can select the row i want, but for some reason my mind then hits a blank, maybe its because its monday.I want to check a few bit fields in the row and if 1 - do something, if 0 do something else. In this case depending on which bit fields are set to what, id like to enable/disable various controls on my form.
Heres the code i got so far, but as i said then i drew a blank, and i may be going about this completely wrong:Dim SQLcon As New SqlConnection("server=DEVSERVERDEVSQL;" & _
"integrated security=sspi;database=WDA_SQL")
Dim SQLqry As New SqlCommand("SELECT * FROM Users WHERE (Username = @Username) AND (Password = @Password)", SQLcon)
SQLqry.Parameters.AddWithValue("@Username", UsernameTSlbl.Text)
[Code]...
View 15 Replies
Apr 10, 2012
how to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code
Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
txtCurrentUser.Text = Login.txtUser.Text
Dim strsql As String
[code]....
View 3 Replies
Jun 1, 2010
I have a table which fields are Date, No, Turnover, TotalWin, Opencredit, Handpay, Billin, gamesplayed and I am trying to write sql in vb.net that will show me previous day value but I cant. Here is what I am trying to do.
[code]...
Ok Thomas I am not able to give correct answer to your question because first time in my Life I am trying to write sql. I was doing this with MSAccess and it was easy. Now I am getting pretty simple error I think with this code but I can't find solution again. What is wrong.
View 2 Replies
Nov 15, 2011
I have a sql query with that adds numerical values from different table to find total for a shipment. When I execute this query, it works fine for the first record but rest of the records show null value when I know there are records present. SQL pros take a look if there is a problem with my syntax.
CODE:
View 8 Replies
Aug 18, 2011
Im having an issue with a certain query,Dim nwLat As Double Dim Ssql As String
nwLat = nwLatHidden.Value
Ssql = " select * from customer where latitude < " & nwLat
TFRcount.SelectCommand = Ssql
TFRcount.SelectParameters.Clear()
TFRcount.DataBind()
All it does is refresh the page and does nothing; it should populate a chart. However when I replace nwLat with a value (eg where latitude = 56) it works perfectly and populates the chart. Any ideas what's wrong with nwLat?
EDIT: I switched nwLat to long and it works; however it only takes the number up to the decimal and ignores the rest. Any way to fix? (eg as double 56.764746 and long 56)
View 2 Replies
Jun 3, 2010
This is the current code. Rather than put in this 100 times for each number, What would be a better way? Have had a go myself but can't get it to work.
[Code]...
View 6 Replies
Apr 26, 2010
I have 2 tables Table1 with columns [BId,Name,Amount] Table2 with columns [CId,BId, ExpenseType,Expense]. BId Is the foreign key in Table2. The Amount field in Table1 is always higher than Expense in Table2. I need to update the values of Amount (increase or decrease) based on value of Expense and I want to do it in single query in LINQ. Eg If the Expense has to be updated with 200, I would decrease(negate) Amount value with 200. If Expense is reduce to 100 then the Amount is increased by a value of 100.
View 1 Replies
Oct 24, 2011
I am using a where comparer in the below snippet from my function.. I need to order or sort the returned items by one of the columns... I tried using .OrderBy(function(f) f.regDate) but that dont work at all... The part of the function in question looks like this:
[Code]...
View 1 Replies
Aug 5, 2009
I'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.
View 1 Replies
Nov 12, 2011
From r In ReceiptLines
Where
r.RECEIPT.RECEIPTDATE >= _reportStartDate
And r.RECEIPT.RECEIPTDATE <= _reportEndDate
[Code].....
I am fetching all departments and their sales, average, count from the ReceiptLine, Receipt, ReceiptDiscount tables. The problem i am facing is, if i remove where discount > 0, I am getting null exception. But if I include that, then I only get sales that has discount. How would I write query that bring all sales less discount (if it has one).
View 2 Replies
Nov 8, 2010
Trying to do a mysql parametrized query and i'm having a little issue.
cmd = conn.CreateCommand
cmd.CommandText = "insert into `rootforest` (rootforestname, BusinessName) VALUES (?rfname, ?bname)"
[Code]....
It errors on the executenonquery. Says the column rootforestname can not be null. i don't under stand why it does not fill in the value in the command text.
View 3 Replies
Jul 28, 2011
Private Sub ButtonSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonSave.Click
[Code]...
View 3 Replies
May 9, 2011
I am getting the above error in my code. I've searched the net (on this site and others) for a solution to this problem and it seems that its either something to do with a field name being a reserved name ie. Date, Time etc.... or its missing (') or (") in the SQL command. ive tried both these solutions to no avail.
Dim objDataAdapter As New OleDbDataAdapter
Dim objDataSet As New DataSet
Dim objDataReader As OleDbDataReader
Dim i As Integer
Dim SQLstr As String
[Code] .....
View 2 Replies
May 24, 2011
I am trying to Query a table with data from another table and return a filtered result
Dim i As Integer = 0
For Each lrow In dtlist.Rows()
Dim lat As Double = dtlist.Rows(i)("Latitude") 'CDbl(Me.SubjLat_txt.Text)
Dim lon As Double = dtlist.Rows(i)("Longitude") 'CDbl(Me.SubjLon_txt.Text)
[code]....
Obviously doesnt work but the idea is thats the Value i need to put in the Value Column of dtlist In short the project, loops through one table(dtlist) of address's and gets the distances of it from the address's in the second table(dtsold) then gets the higest value from dtsold within a certain distance?
View 2 Replies
Aug 23, 2011
Hpw can I pass multiple values from same column in a query? I am using vb.net and sql server database.
With my query an exception is generated saying that @booking_date has already been declared try a different variable....
My query is:
Dim da As New SqlDataAdapter("select * from Bookings where booking_date Between (@booking_date AND @booking_date) AND booking_time Between (@booking_time AND @bookinbg_time) AND game = " & x, con)
View 1 Replies
Apr 2, 2012
I am having trouble using the values that were selected from the dropdown list. How would you reccommend passing the selected values from the view?Ideally, we want to use the selected dropdown values to determine a query.
View 1 Replies
Feb 6, 2011
here is my code. dont seem to know whats the problem. i have 12 data fields in access excluding the ID field.
Dim strCon As String = "Provider=Microsoft.jet.oledb.4.0;data source=C:UsersdexterDocumentsdesktopcsci14databaseMuseum-final.mdb"
Dim dSet As New DataSet
[Code].....
View 3 Replies
Dec 22, 2011
I have Customers table in a database. I'd like to create List of CustomerNames using entity framework 4.1. How can I do that in Visual Basic?
Dim customerNames = (From c In _context.Customers
Select New With {c.CustomerName}).ToList()
brings a list of anonymous objects.
View 1 Replies
Sep 25, 2009
I use LINQ but I am not an expert.. still learning as well on vb.net and sql
I have tables Orders and Numbers
Orders Table:
Order_ID -primary key
Date_Ordered
[Code].....
View 1 Replies
Dec 12, 2011
i am making a simple testing application within visual studio 2010, thought im gonna be direct. in ms.acces i made a database with a few tables, this one is about the table : leden. the error indicates that i simply do not have enough values to insert into the table and i think it has to do with the ID(autincrement in acces)
[Code]...
View 7 Replies
Jul 29, 2011
Private Sub ButtonSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonSave.Click
If frUpdate = False Then
[code].....
View 5 Replies
May 7, 2010
How can I query a DataTable to find all of the unique values in a column? SQL has the 'unique' or 'distinct' keywords, but I dont know how to do this against a DataTable.
View 6 Replies
Mar 2, 2011
I have several labels that bind to my query adapter and I need to update (not TO the database but FROM the database) as data changes on database by another application.I only need to either check data on my database that changed or reload the data.I'm using data set, table adapters and tableadapter.queryadapter to query data (tantalization) from my database.all I want is to refresh/ update this values on my controls in my windows form I'm using VB.NET on VS2010.
View 12 Replies
Jun 29, 2010
In my code I enter a string in a text box and have the query check the server for the entry. If it exists it returns the string and the date into two separate variables. The database only has TrackingNumber and Date. Below is the code. As of right now i get "Invalid attempt to read when no data is present." at the "If (sdr("TrackingNumber") IsNot Nothing) Then" line.
Public Function CreateSqlParameter(ByVal name As String, ByVal dbType As DbType, ByVal direction As ParameterDirection, ByVal value As Object) As SqlParameter
Dim parameter As SqlParameter = New SqlParameter()
[Code]....
View 3 Replies
Aug 3, 2011
I've got the hang of using dates now, but I haven't learned how to test multiple results of a query. I can return a value from a query, but I'm unsure how to return many without putting them into a data grid view or an object on the form. (In Visual Basic)I have to check when a particular investment needs to be bought or sold, there will be more than one in almost every case. I've got the function to find out the interval between the months, checking if the asset is bought or sold in month x, but I'm unsure how to test it against multiple assets at once - nor do I know the best way to do so.
View 12 Replies