VS 2008 Assigning SQL SELECT Query To Array?
Jul 10, 2009
Scenario: Writing a scanning program, thing is I can't have duplicate file names(which I generate). The img file paths r saved in a database.I'm trying to write a function that will return all the records I need using a SQL SELECT. To make this work I need to put all the retrieved records(just the one field from the database) into an array.My Problem: I have no idea how to put the retrieved SQL query into an array and then return it.
Private Function fileNameAcquisition(ByVal path As String, ByVal id As Integer) As String
Dim conn As New SqlConnection
Dim dr As SqlDataReader
[code].....
View 3 Replies
ADVERTISEMENT
Jan 19, 2009
I'm tying myself in knots with AND OR NOT qualifyers to return all rows having two different items. From a column headed 'Instrument' I want to retun 'CELLO' and 'VIOLIN' Where am I going wrong with the following?
View 8 Replies
Mar 19, 2012
I have 10 checkboxes on my screen. I have a variable setup called "case" as a string. I want to know how I can say:
If checkbox1 is checked then case would be equal to "this".
If checkbox2 is checked then case would = "that"
Example of something I tried to cook up but didn't work because it tells me that I can't only use this in a "select case".
Dim Case as string
If checkbox1.checked = true
case = test1
end if
If checkbox2.checked = true
[Code] ......
View 5 Replies
Dec 21, 2009
I am trying to retrieve a password from an SQLite database. The id of the row the password is in is 1. I want to assignt his password to a variable called actualpass.[code]
View 1 Replies
Jan 7, 2012
My DATE field always display with time in vb.net is there a select query to format it into yyyy-MM-dd?
View 3 Replies
Jan 9, 2010
I don't know if I worded this properly, but I have a mdb query that I display in a Datagrid on my form. The first column is TransactionNumber, which is the primary key and a running total (ex. RackingTransactionKey=RackingTransactionKey + 1). What I need to do is when the form is opened, find the highest (last) TransactionNumber from the query or Datagrid and assign it to a variable (RackingTransactionKey), so I can can update it (+1), therefore generating a unique number so I can add data to the query.
[Code]...
View 13 Replies
Dec 9, 2011
I'm having trouble assigning values to an array and am getting the error, "Value of type MemberFocal.Member cannot be converted to System.Array" - MemberFocal.Member is part of a custom class and I am attempting to create an array of these objects. Here is the code:
[Code]....
View 1 Replies
Feb 3, 2010
I decided to learn Visual basic because I want to see actual results and I don't see any in C++
when I was following it I get "Declaration expected" I'm going to assume that there is something wrong with the way that I'm assigning the array it's values but I don't know what to do.
Public Class Form1
Dim player(2) As String
player(0) = "Bob"
[code].....
View 2 Replies
May 6, 2009
[code] i feel that it is a waste of code and should be shrunk down into some sort of loop. [code] i know i could easily leave it the way i originally had it, but i hate having wasted code!!
View 8 Replies
Oct 24, 2009
I still cant work this out!!his is what i started off with:
CurrentButtons(1) = Button1
CurrentButtons(2) = Button2
CurrentButtons(3) = Button3
[code].....
View 1 Replies
Mar 2, 2009
I have a text file which I open and then read in 1 line at a time and split up. I then takes each component part from the split string and assign it into a variable as I go.
I then want to specific varaibles and put them into an array and build the array.
Can I read in each element and assign it directly into an array or is this was best.
also
I seem to be getting an error when I try and directly add items into an array
' myCarrier(98).EZY_Both = myCarrier(98).EZY_Both + 1 '
Structure Carriers
Public BA As Long
Public BA_Lev3 As Long
[Code]....
View 4 Replies
Dec 26, 2009
I am having a problem with objects and arrays of objects. Basically obj_stored holds how many objects I have stored in my text file, in this case t shirts. line(y) is an array that holds each line that has been read from the text file. I then use this to assign values to my array objects properties. For example I know the first line is the color of the first t shirt, second size, third price etc. Then I know the next line will be the color of a new t shirt. There are 6 t shirts in the file.
Dim t_shirt(5) As Clothing.t_shirt
Dim t_shirt_purchased As New Clothing.t_shirt
For x = 0 To obj_stored
t_shirt(x) = Clothing
t_shirt(x).color = line(y)
y = y + 1
t_shirt(x).size = line(y)
y = y + 1
t_shirt(x).price = line(y)
y = y + 1
Next
MsgBox (t_shirt(4).size)
My problem is it seems to be resetting these values after it has finished. Im creating the object each time and assigning values to it's properties but when it's finished it all resets and says 'Object reference not set to an instance of an object'. I'm new to OOP and was wondering what sort of approach i would take to doing this, if the one i am taking is wrong.
So I am aiming to:
Read everything in from the text file.
Create new instances of the objects depending on how many t shirts are stored, (5 t shirts = 5 objects)
Assign the values to my objects properties.
View 2 Replies
May 2, 2009
1. i am trying to assign button1....button81 a position in currentbuttons(81) and i currently have it at
currentbutton(1) = button1
curentbutton(2) = button2
and so forth to 81. how can i get around it into a small loop so i loose alot of the redundant code?
2. i am also having difficulty with being able to change properties of buttons in regards with..for the butons like...button1, button3, button5, button6 etc...to all be changed to a different colour.i currently have something along the lines of
button1 = system.colour,
button2 = system.colour.
View 10 Replies
Feb 21, 2012
I have Date and Time available in xaxis() array format. I would like to assign this to x axis of the MS Chart. My all other data is in datatable format and already have assigned series to this values.Chart1.Series(0).Points.DataBindXY(xaxis, yaxis).. but it gives me error as i do not have valid values for y axis.
View 2 Replies
Aug 19, 2010
I am new to Vb I am trying to assign to each one of the objects in an array a set of properties and I get "Object reference not set to an instance of an object."
Public Class Form1
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim pointer As Integer = 0
depart(pointer).id = "text"
depart(pointer).name = "text" 'here I get the error
[Code] .....
View 5 Replies
May 1, 2012
Am getting error in development code "Reference to a non-shared member requires an object reference." when assigning value to string array where Array is defined in a class.
Here's some sample code to illustrate problem.
Module FieldNames
'Budget Departments
Public Class GLD
[Code]....
View 4 Replies
May 20, 2009
Is there an easy one line way to select all items in an array and clear them? I've tried:
Array(-1) = Nothing
but it doesn't work. I've tried the Array.Clear but the array length can be as big as it wants. Besides the For loop is there another way to select all of the items and set them to the same value?
View 4 Replies
Feb 21, 2012
I have a form that asks for a name, and a phone number, it has 3 buttons, a add customer button, show list button and an exit button. When the add customer button is clicked, it increments intCustomer variable, formats the phone number, makes sure only the first letters of the name are capitalized and creates an ID that is the first 4 letters of the name plus the customer number, the show list button takes ALL customers added to the array and displays them into a multi-line text box, like so:
ID Num Customer Name Phone Number
JOHN-1 John Harry Peters (111) 111-1111
Paul-2 Paul J Rodgers (111) 111-1111
Etc...
The area where I am completely lost in, is how to add the consecutive customers to the array, in the correct way. here is my code in its entirety
Public Class frmCustomerName
Dim intCustomer As Integer = 1
Dim names(9, 2) As String
[code]....
View 1 Replies
Jun 30, 2010
how to assign a 1-dimensional array value I get from a function directly into an element in a 2-dimensional array. An example would be
Dim Results(7)() as DoubleResults(0) = myFunction() ' returns an array with 5 doubles What is the correct syntax for this, if any? I'm still having a bit of difficulty switching over from Python arrays, which work a lot better, it seems.
View 5 Replies
Mar 21, 2011
I am getting an error when helping someone with their code. They are trying to create an array of Items, but gets an error at ItemStruc(counter).ItemName = Contents(0)
I am not sure why. >_>
Structure is as follows:
public structure Item
dim itemName as String
[Code].....
View 2 Replies
Jul 23, 2011
I want to select to multiple sql tables using select query in vb.net..I have 2columns in sql table..I have tried this query.. But i'm getting error.
TextBox11.Text = Val(27)
cmd = New SqlCommand("SELECT outside,power FROM vijay21 INNER JOIN vijay22 ON vijay21.outside=vijay22.outside WHERE outside BETWEEN " & Val(TextBox11.Text) & " AND " &
[code].....
View 4 Replies
Aug 20, 2011
I'm in the middle of making a battleship game, and I'm trying to get picture boxes .visible=True based on the coordinates (that have already been given a nice Try/Catch/Finally error handeling block) of the ships. Example: I have picture boxes in a grid formation that are all red, and my naming convention for them is picR00 for the coordinates (0,0), picR01 for the coordinates (0,1)... et al. Because I'm using a(10,10) for my boolean array, I want the stuff thats false (not marked), those coordinates' red picture box to become visible, and the true have the green ones become visible. Here is what i have so far:
Dim a(10, 10) As Boolean, b(10, 10) As Boolean, c As Integer, x As Integer, y As Integer, ox As Integer, oy As Integer
For c = 1 To 3
[Code].....
View 12 Replies
Jul 12, 2010
I seem to be having a heck of a time trying to figure out how to add the results from a mySQL query to an array in vb.net. Right now, I only understand that you have to define the dimension of the array, however this is shy of impossible since the dimension of the array will change due to different results from the query. What is the proper way to take my results and put them in an array?
View 12 Replies
Apr 20, 2011
I'm creating a simple programming assignment in Visual Basic 2010.(Don't know if it matters, but I'm working in MS Visual Studio.The program consists of two windows forms and a module.Everything works fine except for this one loop I'm trying to use to display whether the answers were "correct" or "incorrect".[code]
View 8 Replies
Jun 14, 2011
I didn't think it fair to post a comment on Fredrik Mörk's answer in this 2 year old post, so I thought I'd just ask it as a new question instead..NB: This is not a critiscm of the answer in any way, I'm simply trying to understand this all before delving into memory management / the marshal class.
In that answer, the function GetByteArray allocates memory to each object within the given array, within a loop.Would the GetByteArray function on the aforementioned post have benefited at all from allocating memory for the total size of the provided array:
Dim arrayBufferPtr = Marshal.AllocHGlobal(Marshal.SizeOf(<arrayElement>) * <array>.Count)
I just wonder if allocating the memory, as shown in the answer, causes any kind of fragmentation? Assuming there may be fragmentation, would there be much of an impact to be concerned with? Would allocating the memory in the way I've shown force you to call IntPtr.ToInt## to obtain pointer offsets from the overall allocation pointer, and therefore force you to check the underlying architecture to ensure the correct method is used*1 or is there a better way? (ToInt32/ToInt64 depending on x86/64?)
*1 I read elsewhere that calling the wrong IntPtr.ToInt## will cause overflow exceptions. What I mean by that statement is would I use:
Dim anOffsetPtr As New IntPtr(arrayBufferPtr.ToInt## + (loopIndex * <arrayElementSize>))
I've read through a few articles on the VB.Net Marshal class and memory allocation; listed below, but if you know fo any other good articles I'm all ears![URL]..
View 1 Replies
Jul 16, 2010
I'm trying to get a simple count of rows meeting some criteria. The value returned does not coincide with the correct number of rows when running the same query in Management Studio (SQL 2005)
vb.net
Public Function RowsAffectedCount() As Integer
Dim result As Integer = 0
[code]....
'result' always returns 1, but I have 3 records meeting that criteria in the database. Been staring at the code for a couple hours now and can't figure it out... I just need to know if the Count of rows returned from a SELECT statement is greater than 1 (at least two records).
View 9 Replies
Mar 16, 2009
I have an ado.net statement I want to convert to use NHibernate:
Dim sql As New StringBuilder()
sql.AppendLine("SELECT r.RoleId, r.RoleName ")
sql.AppendLine("FROM dbo.aspnet_Roles r ")
[code]...
View 1 Replies
Nov 20, 2011
I have pulled information from a database into a datatable (dtCustomerInfo) then I expanded on the columns by processing the data and I can display this in a datagridview without any problem. However, the data is in detail and I want to ultimately summarize by customer name.The code below has a commented sql statement that is the statement I ultimately want but it is not working. However, the idea is that I want to Select from one datatable into another but run aggregate sum on several columns so that I will get one record per customer showing totals for each column.So I broke it down to just pull all data possible into the second table.[code]I do know the grouping in the current select * statement does nothing but my issue is more that the columns do not show up.
View 3 Replies
Feb 21, 2011
On an SQL query I have. I have the select query working fine but according to the result I need to set the column of a table to 0. I have the following Select query:
CODE:
So where the CommissionCalculator SetUp > 0 I want it to Update the CommissionStructure SetUp column to 0. I was thinking I might need an IF statement but I dont know how to work with them in SQL.
View 7 Replies
Sep 18, 2009
class:
Public Sub insetTotalPaidAmt(ByVal dtSDate As Date)
Dim comm As OleDbCommand
Try
strQry = "INSERT INTO rpt_Paid_Amt(ST_ID,ST_PAY_AMT,ST_DIS_AMT) " & _
"SELECT S.ST_ID,SUM(P.PAY_AMOUNT),SUM(P.PAY_DIS) " & _
[Code]...
View 1 Replies
