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)
I have a basic calendar schedule i want to loop through and then do some checks. My first data reader works fine. But as soon as i put in the second data reader it does not finish.Here is my code
Dim mycommand As New MySqlCommand Dim mycommand2 As New MySqlCommand Dim myData As New DataTable[code].....
Basically the above code looks up distinct calendar entries in the database.i then loop through the entries and put the items in a list view.The code above will list about 1600 rows.in the above code if i uncomment the 2 lines the system will break It will on display one line of code. What im trying to do in the second query is to see if there are double bookings in the database.
I have a form where when the user clicks the button the values of the form are stored in SQL database. I want to write code in order to check if a specific textbox-value already exist in the database table (in the field "Name"). I 've tried writing something but it doesn't work properly.
Is there such a thing as a type similar to a point, but contains a pair of decimals, or a pair of doubles, rather than integers? I searched the forums and google with no luck. I can't believe this has never come up before, I must have been using the wrong search terms.
I am attempting to read a series of double prcision float values (x,y,z coordinates) from a binary file using the binary reader. Everything works fine except that when I read the number back it is different then the number that was written there (original file is generated by mining application).
written number : 78897.6476586 file contents hex : 40 F3 43 1A 5C CF 43 A4 this converts back to the same number as written using a IEE 754 conversion program. VB returned value : -5.45100266729248E-134 using .readDouble()
I have tried to step thru the file in one byte steps to make sure that I have the proper start position but that did not help any.
i have 3 textboxes and 3 columns in listview like names ProductCode, ProductName and Price. i save the textbox values to Listview columns.Now i want to that when i double click on any row in listview these values will be editable in the textboxes again for edit mod.
In the discussion in this thread: [URL] it was reveiled to me that vb.net, using double, could only calculate values up to 18 digits after decimal.... so I started thinking and came up with this class
Public Class LargeNumber Private pNumber As String
Public Sub New()
[CODE].............
I want to split the string into a series of doubles.... and than combine them into a large number.... The size of each double component should be 18 digits on a 32 bit computer... so that I will have room to add the last carrier...
So we've set up a sp_linkedserver on SQL Server to connect to a remote Access database.Assume the path to this database is W:/breakfast/pancakes/secretPancakes/pancakeDB.accdb
We know the username and password to the actual database Password: allY0urPancakeAreBelongToUs!
The problem is, there is also authentication to get into the "secretPancakes" directory.
This authentication is Username: SuperChef Password: ilovesf00d
[Code]...
Also, is this where I would change these credentials to the credentials used to get into that folder right?
I am using the following code to create an array consisting of double values specified by start stop and step. The problem with that is that for some weird reason there is a calculation error that seems to originate from the for statement causing the values to drift after the 11th to 12th digit after the comma which is quite irritating for the purpose i am using it.
Whenever I store values to a double-type variable, and ask to display it on the screen, there seems to always be a discrepancy, for example, I entered 7.416 to a textbox and assigned it to a double. When i ask for it to be displayed, it used to be that the 7.416 is returned to me. But just a few days ago, when I debugged my program again, it returns numbers like 7.4159987.......[code]....
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.
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.
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)
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.
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)
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
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.
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.
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.
I have a situation where I am handling both single & double mouse click events on a form. In both cases something has to be loaded, however when a double click occurs, I do not wish to execute the code attached to the single click event.Is there a way to intercept the mouse click's and check if double or single and then execute the right event appropriately?
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.
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:
