Split A Listbox And Assign To A Variable In Order To Save To MS Access?
Mar 15, 2012I have a listbox that contains 10 records as the follow:
1 + 1 = 2
1 - 1 = 0
2 / 1 = 1
[code].....
I have a listbox that contains 10 records as the follow:
1 + 1 = 2
1 - 1 = 0
2 / 1 = 1
[code].....
I currently have a listbox that is filled with input from a user and is currently saved to a textfile. What I need to do is, when the listbox (holds 10 records) displays the records which are shown [code]And so on. I need to save to a table in MS Acess that have the following fields:[code]
View 2 RepliesThese is the content of my txt file which is saved in D drive in my pc abc,1,2,3..I tried the flowing but it didn't work:[code]I am getting error on this line.. data = line.Split(","c)...it says this line isn't in use anymore or something and that I rather use LineInput but thats asks for filenumber and i don't know what that is. I am sorry but I am a complete beginner. what else can I try? [code]ok that error is gone now but now if I want to add these values to a list box..how can i do that?
View 1 RepliesI have this string, it's "x/y". How can I use the split function to rid the / and assign the x to myVariable and assign the y to myVariable2
View 1 RepliesHow do I read a line in a database and split and assign them into variables?As of now, i can only load the entire database into a variable
sql = "Select * from MenuDatabase" How do i read the database line by line and spit the lines according to column?
so i have a quite huge program. but lets say i have one label. and i want to save that. i have the code and everything for saving the text of the label. now i want to assign ctrl+s to automatically save the labels text once pressed instead of going through a menu to choose save.this is like a regular texteditor where u press ctrl+s and it saves.
ive used this
If (e.KeyCode = e.Control & Keys.S) Then
MessageBox.Show("Ctrl+S pressed")
End If
and
[code]....
but it doesn't do anything once pressed.im also using the keydown declaration for the form.
This might not be so 'VB' as it is 'SQL using VB' I have an application with a built in MS Access DB. I have a table that has a column full of integers, I shoot the DB a SQL "order by 'column name' " string and it returns the table ordered by my column of integers.BUT it returns them like this, and I want them like this
0 6
1 5
2 4
[code]....
How do I get the OrderBY to do a descending list starting with the highest number?
I am writing a program that involves the split Function. The user will enter A, B, C. I wrote a splic fuction code (below). I am not quite sure if it is right, I would also like to know how to write the code for that split function when the user preses the save button after entering there input.
Dim strInput As String 'input string
Dim strOutput() As Sting 'output string array
strInput = "A, B, C," 'user input
strOutput = Split(strInput, ",") 'splits the input string
I have a file txt file that holds 3 values each seperated by a space how can i assign each value to its own variable and use that for other things?
View 4 RepliesOk, so I`ve been studying a bit of VB lately.. bought a few books and read lot`s of articles and seen hours of instructional videos, and I slightly start to get the hang of a few things.. :) I`ve recently started a fun little project, but I seem to lack a bit of knowledge to reach my goal. I`ll first try to describe my project:
[Cde]...
I've been making this BlackJack program for a school project
I have 52 image files, labelled from '_1' to '_52' in my resources folder, each number corresponds to a card.
My question is, how do I get a picture box to assign the correct resource according to a variable
So, say I have
"pictDealerCard1" -> picture box which displays the first of the dealers card
DealerCard1 = 37 -> random number generated through INT(RND() * 52)
and resource '_37'
[Code].....
I need to assign a varible in a while clause. I.e., i would do it in php like this: while (!is_bool($char=$this->getChar()) in every loop, the function would assign $char a value, the is_bool function would test it, and the code INSIDE the while clause would have access to that $char.
View 4 Repliesi would like to assign the value of a combobox to a variable and use this variable as a parameter on the insert statement.see code below,code 1 works ok,but code 2 brings an error relating to wrong datatype,i cant seem to find where the problem because i think i am doing everything right.
[Code]......
i would like code 2 to work so that i can assign the variables different values at different scenarios. column serialno is a foreign key from table Stock.
I want to assign a string value to a variable in the DataGridView LostFocus event. I found that I can't just do variable = "string value, it will give me the "Unable to cast object of type 'system.eventargs' to type 'system.windows.forms.datagridviewcelleventargs'" error.
The function created by double-clicking on the datagridview is:
Private Sub DataGridViewInvoice_LostFocus(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridViewInvoice.LostFocus
I'm trying to retrieve data from an access database, but I'm trying to do it all in VB. Basically I need to query the database, and I think I've done that correctly. But then I need to assign the value in a certain field, to a variable. So for example,
Dim email = orders.CustomerEmail.
How to assign a value to a variable.
Below is my current code:
Dim acc
As
New AccessDataSource()
accDS.SelectCommand = "SELECT TOP 1 orders.OrderDate, orders.OrderNumber, orders.OrderProduct, orders.OrderTotal, orders.CustomerName, orders.CustomerPostCode, orders.CustomerEmail"
accDS.DataFile = "~/App_Data/Database.mdb"
I get nothing but headaches when I try to update settings in the My.Settings class, or when I try to assign a newly assigned setting to a variable. Sometimes the settings update OK at run time; other times times they update only after the application closes; and other times still they appear to update at run-time, then when I close the program and reopen- they go back to the previous settings.This is how I assign a value to a my settings and how I assign a setting value to a variable.[code]
View 6 RepliesI'm new with vb.net my problem is how to assign field value from database to a variable here is my code
Call connectdatabase()
dim uname as string
dim pass as string
Try
sql = "SELECT * FROM user;"
command.Connection = conn
[Code] .....
i like to assign html codes to String variable
Dim code As String
code= " <meta http-equiv="Content-Type" content="text/html; charset=windows-1254"> "
i think i am getting this error because of double Quotation marks "character constant must contain exactly one character."how can i assign it to a string?
I would like to assign cboBegCust.SelectedValue to c and cboEndCust.SelectedValue to d
Dim c, d As String
cboBegCust.SelectedValue = "customer"
cboEndCust.SelectedValue = "customer"
[Code]....
I want to Assign the Value to Multiple Variable of same type in .net and that to in one line of Code.
View 6 RepliesI think I remember reading somewhere that it was possible to assign items to a variable if the item inherited from a base class, but I can't remember how.
I want to have a class that gets properties set and one of the properties is an error code property. I want to assign any exceptions that occur to the property, but it could be any type of exception. I remember that all exceptions inherit from the Exception class.
How can I assign an exception to a property based on the class it inherits from?
I have the following
Public Structure Foo
dim i as integer
End Structure
[code].....
is there any possibility to assign a value to a variable inside an IF condition in VB.NET?
Something like that:
Dim customer As Customer = Nothing
If IsNothing(customer = GetCustomer(id)) Then
Return False
End If
Any way to attempt to assign a variable within a data class or structure when I have the variable name as a string. Where would this be useful? Let's say I have a data class that exactly mirrors the columns of a table in a SQL database. This lets programmers easily interact with table row data as it gets passed around as an actual, specific object since Intellisense can enumerate the variables for them, etc.
However, populating such an object is tedious and repetitive--the programmer who creates the new object has to one by one match up all the members when reading from the SQL data adapter. It would be nice if they could somehow enumerate all the variables in that class and attempt to auto-assign the values from the database instead of having to build a custom population method for each new data class. A person could create a hash table or tree or something that pairs member names with actual objects.
I want to declare a variable to hold the query result from LINQ to SQL like to the following:
Dim query As IQueryable(Of Student)
If isNoUserName Then
query = From st In db.Students _
Order By st.AssignedId Ascending _
[code]....
Return query
Error : conversions from 'System.Linq.IQueryable(Of )' to 'System.Linq.IQueryable(Of Student)'.
How do I declare variable "query" to hold both data from "Student" and "User" tables?
I've just read [url]...
I'm wondering if it is a typo. Do they actually really wanted to say: the implementation of the JVM is free to instead of the compiler is free to.
and my second question is that do we have this issue with C#/VB as well? (in which the ""compiler"" is free to assign a value to a variable even before the variable is fully initiated/even before the constructor function of the class of the variable is fully ran.
Is it possible to declare a variable and to choose it's appropriate type during runtime?
it should be something like this (of course, the last line does not work):
'Determine what type of variable is needed later
Dim myVariableType As System.Type = System.Type.GetType("System.String", True, True)
'Create variable with needed type
Dim myVariable As myVariableType ' Should be a string variable in this case
How do I assign the query result to a variable.I am using SQLlite. Below is the code for retrieving password from the User Table. I need to compare the given password and the given password.
Dim i As String
Dim p As String
i = txtUserID.Text
[code].....
So I have a class called Transactions and I put all my functions there. The problem is, when I try to call that specific function and assign it to a variable, there is a "ByRef Argument Type mismatch" error that keeps on bugging me.
Public Function GetUserID(name As String) As Integer
Dim gotID As Integer
Dim rec As Recordset
Call connectDB
sSQL = "select ID from User where Name ='" & name & "'"
Set rec = CurrentDb.OpenRecordset(sSQL)
[Code] ......
Dim n As System.Windows.Forms.TreeNode
For x = 1 To TreeView1.GetNodeCount(True)
n = TreeView1.Nodes.Item(x)
[code]....