How 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?
I 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 RepliesI have a listbox that contains 10 records as the follow:
1 + 1 = 2
1 - 1 = 0
2 / 1 = 1
[code].....
i remember that in Qbasic i could assign values to variables from a text file. (not in the code inside.). How to make the same in VB.NET?
View 5 RepliesI have a class file, myClass.vb. Here is an example of the file:
Private _active As Integer
Private _categoryID As Integer
Property active() As Integer
[code]....
when I want to assign a value to the variables in the class file, should I assign them like what I have in line 24, and 25 or line 28 amd 29? how I assign the variables in terms of performance?
I need to assign variables dynamically in a loop. In php you would use curly brackets but this doesn't work in vb.
Dim i As Integer
For i = 1 To 12
lblMonth{i}.text = 'whatever
Next
Anyone know how I can escape the the i variable so it becomes part of the string that precededs it?
What is the cleanest way to assign a value to multiple variables? For example, how can I assign FALSE to each of Label1.Visible, Label2.Visible, Label3.Visible, Label4.Visible, and Label5.Visible.Is there anything like
code
Label1, Label2, _
Label3, Label4, _
[code]....
I have a datagrid with customer data such as ID, name, email, phone etc.When I select a row (with a button or selectionchanged) I want to store that row's columns in variables like
dim email as string
dim name as string
email = dgCustomers.theselectedrow.theselectedcell
[code].....
This is my first attempt at writing a program that accesses a database from scratch, rather than simply modifying my company's existing programs. It's also my first time using VB.Net 2010, as our other programs are written in VB6 and VB.NET 2003. We're using SQL Server 2000 but should be upgrading to 2008 soon, if that's relevant.I can successfully connect to the database and pull data via query and assign, for instance, the results to a combobox, such as here:
[Code]...
How do I execute a query so as to assign each field of the returned row to individual variables?
Ive looked it up, nothing really worked on 2008, I have a string that always the same length, and want to split it up into variables. The string looks like:
0-555-555
I have 3 designated variables for each number and I don't want to put them into an array.
What I'm trying to do here is Capture 2 Variables from a Textbox
Here is an example of whats going to be in here.
User:Pass
I want to declare everything before the : as user and everything after the : as pass.
I've Googled, and found a few things, but I couldn't seem to get it working fully.
I hjave the following text read from a txt file but would like to assingn each of the three numbers to induvidual variables how can i achive this?
(234.134, 105.087, 0.000000)EDDIT:
[Code]...
only now the product of XVAL and ZVAL is displayed as 0.123 8.910 and not 0.123 + 8.910 = 9.033 the 9.033 which is what im after
I have used ColumnHeaderSelect instead row header select... how to assign database row values to ColumnHeaderSelect.
View 1 RepliesI need to have a property that is a nullable date as the datestamp is used for when a process is completed. If there is no date this is a way to determine if the process has occurred. I have created a Nuallable DateTime property (DateTime?) However when I try to assign a value from my database entity (when debugged has a date value) I am not thrown an exception however my property still reads a null value after assignment. How can I get a DateTime? type to accept a DateTime value?
I thought this would do the trick
_object.DateStamp (type = DateTime?) =
_entity.DateStamp (Type = DateTime?, Value = DateTime) o
Or for more understandable syntax
Ctype(object.DateStamp, DateTime?) = Ctype(entity.DateStamp, DateTime?)
Strange thing is I can assign the properties value like this.
Ctype(object.DateStamp, DateTime?) = Now
I am using LinQ Entities.
I have a little problem regarding the use of DBNull, NULL etc. in VB.net in combination with SQL Server 2k.
More specifically, I want to do something along the lines of this:If x = 0 Then
x = DBNull.Value where x is declared by Dim x as Object. I would rather use Double, but I can't assign DBNull.Value to this, and using Object works quite well, too. But every time I hit this condition, I get an exception: A first chance exception of type 'System.InvalidCastException' occurred in Microsoft.VisualBasic.dll This is not a major show-stopper, since the database value I write x to in the next step, is NULL by default - most of the time! So I need the ability to write NULL to it. If that was not the case, I would have been able to work around this by catching exceptions, I think - but sadly, this isn't really of use then.
Using VB.NET2003,ASP.NET1.1,SQLServer 2005 Express. how to use a Repeater Control to get a split string from database, and also want to add buttonsto use where each piece of the string is, not to edit thepiece of string, but like a agknowledgement button(I'll have to deal with that part later)
[Code]....
I am a school student and having a project on importing text to access database. The problem seems easy but the issue is the text file i am trying to import has no delimiter. .
firstnamelastnamesexage
jhonlittlem15
Now how can I split the text and import it to an access database.
I am trying to split a long string based on an array of words. For Example:Words: trying, long, array Sentence: "I am trying to split a long string based on an array of words."Resulting string array:Multiple instances of the same word is likely, so having two instances of trying cause a split, or of array, will probably happen.
View 5 RepliesI am doing a project on Sending/ Recieving SMS through VB.Net 2008. I am getting the following string while recieving a message from the modem
+CMGR: "READ READ", "+919223336661",,"08/10/10,12:45:00+22"THIS IS A TEST MESSAGE
Now I want to break it and store in database as
Sender= +91223336661
Date Time= 08/10/10,12:45:00+22
Message=THIS IS A TEST MESSAGE
Where Sender, Date Time and Message are the column name of the database. The maximum length of the Message is 160 characters.
I am doing a project on Sending/ Recieving SMS through VB.Net 2008..I am getting the following string while recieving a message from the modem +CMGR: "READ READ","+91922333666 1",,"08/10/10,12:45:00+22"THIS IS A TEST MESSAGE..Now I want to break it and store in database as [code]where Sender, Date Time and Message are the column name of the database. The Maximum length of the message is 160 characters.
View 2 RepliesAdmin assigns the authority and get a new form to the new assign in with vb.net & access. I am not sure about this,I need a way to do the new form assigned? How?Actually, this project is the admin will assign the authority to a manager, and the manager will get the password to log in. Then, the manager once log in and will get a form to set the rooms who is going to use and date, etc, this is multi-manager to handle the room setting jobs.But, I think, I got stuck, I am not sure how to do the new form, HOW DO YOU ASSIGN THIS NEW FORM FOR EACH NEW MANAGER?????? THIS IS VB.NET WITH ACCESS.
View 3 RepliesI am writing some code and want to check if certain things are in my database. Is there a better way than just creating a new string, performing the select and storing it in the string? I have to do this a few times for several items in my DB columns, but is there a way I should be doing this that would not require me to make a new string, and a new select for several items, well a better way? The items in my db aren't all strings and the data types vary.
View 2 RepliesI'm trying to put together a quick program for our database, I haven't touched VB since vb6, and we have 2008 .NET now. my question.
Ideally I'd like to make an array which can hold multiple values...such as
Job[job#].joblocation
Job[job#].jobsupervisor
So there would be a Job array, and then different values contained within that. I can't seem to make an object or whatever which allows me to hold different variables inside it.
Im currently writing a sort of Tamagotchi game or "virtual pet". It's really basic, it runs on timers and has a health meter, hygiene, happiness etc. The problem I have is when the program is closed it obviously resets the properties back to the origional settings. Is there a way I can save the state of the program so when the user opens it back up it is as the same as of the point when it was closed?[Just had an idea, would I set a timer to periodically save the value of the variables to a database and then have them load the next time the user opens the program, for example if the health was 50% on closing or at intervals it would save the health into a column in a db table then when the user re opens the program call that db?]
View 5 RepliesI am developing an application where I need to make use of multiple values during the run time. These values are configuration setting of the application as specified by user and are stored in a database (more than 50 in number containing strings/boolean and numeric). I have defined a structure to contain all the variables that will store this information. At start of app, I retrieve all values from database and fill the structure which i can use when required. I am wondering if it is a good idea to declare too much of variables and keep them alive during the run-time as compared to retrieving the values from database every time it is required?
View 4 RepliesI have this
[Code]....
I want to check if the variables sUsername and sPassword are in the database, now the SQL syntax looks fine to me, but I am wondering how do I execute the command (I thought it might be scCommand.ExecuteNonScalar), and I'm also wondering how do I check if it returned any results? The other question was, this can connect to my website's MySQL database right?
I would like to create a split container with a three way split. The first split is a vertical split. The second is creating a horizontal split within panel2 of the first split container. panel1 will hold a treeview control the other two panels will hold listview controls
I think this question has been asked already in a couple different ways and I've reviewed those posts and I've tried to do what was suggested but it doesn't seem to work for me. I've tried to place a second split container inside panel2 of the first split containter. This gave me what appeared to be a three way vertical split.
I have written a web page which connects to a database and then display 3 values from a management reporting system using the database.
I am accessing a database using the following code:
<asp:SqlDataSource ID="SqlToVersion" runat="server"
ConnectionString="<%$ ConnectionStrings:WebImportOnServer %>"
SelectCommand="SELECT [VerNo], [PeriodName], [PeriodNo] FROM [atblVersion]"
[Code].....
but it is how to replace the question marks with valid code that takes the values from the bound fields that I am stuck with.
Last year (2010) I came across a FANTASTIC command that allowed me to take a string of variables with a common delimiter and break it all back out into separate variables (possibly an array) with one statement.
[Code]...
As long as the delimiter was a unique specifiable character, this one-statement command could break it out into elements. my memory and point me in the right direction.
I have code, shown below, that works all except for 1 thing: The variables being passed byRef get passed, but once modified in the else section of the "if me.invokerequired" code of RecordData, the variables are never updated in the calling function. To reiterate, the calling function does not receive the updated data that is in the variables custid and amt.When debugging, I see the data change in the else section of "if me.invokerequired", but once it returns from the callback the data is missing.[code]
View 15 Replies