Parsing Values In Query?

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


ADVERTISEMENT

Parsing Text Fields As Date In Update Query?

Apr 22, 2009

I've been running into some errors with converting strings to dates in the following code. I have recently added the intcall.Value = DateTime.Parse(txtIntCallDate.Text) function which had gotten rid of the error message, however the records are not being updated, any of them on the form. Prior to this the strings were being updated just fine. As long as there is a date entered on the form there is no error, if it's left blank i get the "Problem converting string to datetime"

[Code]...

View 3 Replies

Parsing And Getting Specific Values From CSV String?

May 20, 2010

I am having a string in CSV format.http:[code].....I can add new values to it by some mechanism. Everything will be same except the new values will have numeric part = 0. Take example I have this exsiting CSV string

1 , abc.txt , 2 , def.doc , 3 , flyaway.txt

Now by some mechanism i added two more files Superman.txt and Spiderman.txt to the existing string. Now it became

1 , abc.txt , 2 , def.doc , 3 , flyaway.txt, 0, Superman.txt, 0 , Spiderman.txt

What i am doing here is that this csv string is paased into SP where its splitted and inserted to db. So for inserting I have to take the files with numeric part 0 only rest will be omiited .Which will be further then converted into CSV string.Array will look like this

str[0]="1"
str[1]="abc.txt"
str[2]="2"[code].....

So at last i want to say my input will be

1 , abc.txt , 2 , def.doc , 3 , flyaway.txt, 0, Superman.txt, 0 , Spiderman.txt

Desired Output:

0, Superman.txt, 0 , Spiderman.txt

View 1 Replies

Parsing XML Attributes Into A Listbox And Filtering To Chosen Values

Jan 26, 2010

I use VB 2008, and have "moderate" programming skills.I've constructed an xml file:[code]

View 4 Replies

VS2008 Skips Code - Parsing A String Into Two Values

Sep 7, 2010

i'm parsing a string into two values then using one string named month to get the column name and one string named value to assign the value.

[Code]....

View 3 Replies

C# - .Net String Parsing Library Or Regex For Parsing .Net Code Files

Mar 5, 2009

I would like to be able to parse vb.net code files, so I can examine the collection of Subs, Functions (and their contents, including comments), private variables, etc. I can be open the actual source code files. So for example, if I have:

[Code]....

View 7 Replies

Multi-Value Query Parsing It Into "something"?

Jun 18, 2012

SELECT airplanes.ID_airplane
FROM (airplanes LEFT OUTER JOIN
airplanes_hangar ON airplanes.ID_airplane = airplanes_hangar.ID_airplane)
WHERE (airplanes_hangar.ID_airplane IS NULL)

This is the vb code.

Me.AirplanesTableAdapter.superawesome(Me.Hangar_DataSet.airplanes)

I want to pass the values returned to a combobox, or a string, doesn't matter i can take it from there.

View 1 Replies

Parsing String Each Iteration, Or Parsing Once And Storing?

Mar 16, 2011

I'm creating a vb.net winforms application that will take in user given strings, parse them, and print out labels with variable information. The given string will be used in all the labels, but the variable part of the string will change with each label.

My question is: is it better to parse the strings one time, then store those values in arrays, or to parse the string each time a label is printed? Which will perform better? Which is better practice? What is the proper way to test something like this?

View 2 Replies

Add SQL Query Values To Textbox

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

C# - Asp.net Query With Insertion Of Values In A Table

Dec 26, 2011

suppose we have three tables in the Database:

[Code]....

View 1 Replies

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

LINQ To XML To Query Attributes Values

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

Query Values In SQL Without Filling Controls?

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

Return Multiple Values From A Query .net?

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

Sql - Show Previous Day Values In Query?

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

SQL Adding Multiple Values Within Query

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

Sql Server - Sql Query And Double Var Values?

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

VS 2008 Run Same Query Several Times With Different Values?

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

.net - Update 2 Table Values In One Query In LINQ?

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

Asp.net Mvc - Sorting Or Ordering Values Returned In A EF Query MVC 3 App

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

DB/Reporting :: Simple XML Query And Comparing Values

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

Linq Query Handling Null Values?

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

Mysql Parameterized Query Not Filling In The Values

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

Number Of Query Values And Destination Field Are Not The Same?

Jul 28, 2011

Private Sub ButtonSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonSave.Click

[Code]...

View 3 Replies

Number Of Query Values And Destination Fields Are Not Same

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

Query Table Retrieve Filtered Values?

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

Sql - Pass Multiple Values From Same Column In A Query?

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

Use The Selected Dropdown Values To Determine A Query?

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

Why Are Number Of Query Values And Destination Fields Not The Same

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

.net - List Of Scalar Values From Entity Framework Query?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved