What is the easiest method of storing data and retrieving it using VB? FYI, I have not used Access before. It will be a movie database that stores title genre, etc. I thought about using a text file but i think thats crude and ran across this site:
View 1 RepliesWhat SQL Server data type should be used to store RichTextBox text? The reason I ask is because the BOL indicates not to use text or ntext anymore because these data types will be excluded from future versions of SQL Server.
View 4 RepliesI have 10 IP address I need saved so that when the programed is closed the user doesn't have to re type them all back in. To get around this I created a database that would store the values. My table contains one Field "host" and then has all 10 IP addresses listed below that.I'm trying to figure out how to make a text box on my form look at a certain row in a SQLServer 2005 table.
For example:
txtIP1.text = Row 1 of SQL table
txtIP2.text = Row 2 of SQL table
Here is what I have in my Form load Event. This works, but again I need the second rows value to show in the second txtbox.
[Code]...
I have a combobox where the user can type the sql server name. Then a connect button that, when the user click, I want it to populate another combobox with all the databases from the server in the previous combobox. Unfortunately, I am getting the error object reference is not set....!
Here is where I am getting the error:
For Each objDB As Database In Me.SMOServer.Databases
I am new to VB ...I'm using vb2008 connecting to sql server 2005.
Here is my complete code:
Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common
Public Class Form1
'Public Class frmSQLConnection
Private m_objServer As Server
[Code] .....
I am using the following Select Statement to retrive data from my .csv file database:
Code:
Dim comm As New OleDb.OleDbCommand("Select *, Left([Street Full Address], IIF(InStr(12,[Street Full Address],'-')>0, InStr([Street Full Address],'-')-1, Len([Street Full Address]))) as StreetFullAddress From " &
[Code].....
There are "text" files, there are databases, I used to use a record (now called a structure) in a ".dat" file, but I'm having trouble finding documentation support in vs2010. So I'm thinking maybe it's time to move up to ... ? databases? ".txt"s? The current app I'm trying to write will only have a couple of hundred "records" at the very most; Old vb6 command like LenB which would return the size of a file in bytes is no longer, and I can't find how len( .."as byte" of file) would actually be implemented. len( <filename>, as byte) isn't the correct syntax - what is?
Is there some thing less dramatic than a full blown database? Or getting used to how a database uses SQL and all that goes along with that shoud be something to get handy with?
I am trying to store 8 separate pieces of information in a text file (like a database) [but not a SQL database], consisting of integers and strings. How would I use an array to do this? Will an array collect data from text boxes (I also want to display the 8 pieces of information in separate boxes). also how would I save the text file so I can open it again or open a different text file (database?), from within the program?
EDIT: I see I need to use readline and writeline to read/write from a text file but how would I find specific data to show in my boxes?
I have data that I want to store in some type of variable where I can easily access when needed. For example I have:
google.com -> This is a cool website.
yahoo.com -> News website
gmail.com -> Mail website
I want to be able to store those in some type of group so if I go like:
get data of google.com without going through a loop.
In the program I'm working on, there is a 'sign-in' form that pops up for the user to enter first name, last name, and DOB. What I want to do is STORE that information in a text file for FUTURE use by the program (i.e. displaying a list of all previous users of the program).I already know how to use streamwriter to write text to a file, but I would like for the text file to be stored within the program files and also for a new user's data to be appended to that file every time.
Do I simply add the text file to the project files? When I do that, its path is 'My Documents'. How will that affect the program when I publish it? I guess I just don't yet understand what happens when the program is finished and published. The code for the 'Submit' button on the sign-in form is pasted below. At the bottom, I've put a comment to indicate where I want to store the data to a file.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim TxtBox() As String = {TextBox1.Text, TextBox2.Text, TextBox3.Text}
For i As Integer = 0 To 2
If TxtBox(i) = Nothing Then
[code]....
What I'm trying to accomplish is first of all, adding items in a list box, but while doing so, store data into that item so when the user clicks on it, the data will be brought up into the correct text boxes.
My idea on how this will all work out has to do with array lists. I'm thinking each time an item is added to the list box, an array list is generated containing all the data from the text boxes. The array list would be named as the text of the list box item.
So then when the user clicks on one of the items, it can find that array list easily because of the selected index, and then update the text boxes with the data.
Is the way I'm thinking of possible? If not, or if there is an easier what, what would that be?
Here is what I would like to do:
- Store string data from a 'sign in' form into a text file. This text file must be one that is saved even after the user exits the program. The text file must also be one that will stay with the program even after it is published (executable).
- Be able to write to/read from the file for purposes of displaying some or all of that data on a form.
I use an Application Setting to do this - of type 'Specialized String Collection'. I tried this, but for some reason I could not get it to work. It was a good idea, but I need to be able to SEE the data that has been saved, and with a setting it seems like that is not easily done. I've decided that I either need to use a simple text file or a 1-table database for this. I would prefer just a text file, but in either case, it needs to be part of the .exe when published.
I have added a text file to my project, but I am not sure if it will be "included" in the project when I publish it. The path of the file I've added is in 'My Documents', but in my code, I will have to specify the path in order to use Streamwriter. How will this affect the program when I publish it? I felt the need to make a new thread because on my last one we had been mainly talking about settings, and I've decided that isn't the best option for me.
I have a small market place in my website so I want to development a small app for retrieve and check data for example find a transaction or the email of a client and to show this data in a datagridview, this the the html code of a transaction :
[Code]...
Subj.There is no knowledge that is not power.
View 3 RepliesHow do you store data in the access database and also to retrieve it? and also a search engine for the database?
View 1 RepliesHere's the situation: I need to navigate to a list of sites and retrieve data from them; I know how to retrieve the data, but I'm unsure of the best way to navigate to each of these sites.
[Code]...
I was wondering if it's possible to store application data within an application without storing the data in an external file. For example, in my application, the user can choose where he/she would like to store the files that the application creates. I need to make the application remember the location that the user specified. I've tried using My.Settings to save this information, but since my application is standalone, if the location of the application changes, the My.Settings information changes as well (unless I coded it incorrectly before). I would prefer not to store this data in a .txt file or something similar.
View 10 RepliesI am not new to vb but still an amateur, however, I am still learning linking vb apps to mysql, here is where my troubles begin. I am stuck and been trying for hours on end to get past this problem. It's starting to hurt my head! I am sure others have similar problems.I posted my imports and the module I put my public sub in. The sub is called as a form loads.The Error is:
An unhandled exception of type 'MySql.Data.Types.MySqlConversionException' occurred in MySql.Data.dll
Additional information: Unable to convert MySQL date/time value to System.DateTime
[code].....
Is it possible to have a quick and easy way of retrieving the last 10 records from a table?
Currently what I have been doing is retrieving all the records then one-by-one cylcing through each record until I have the last 10. To me this seems to have a lot of over-head reading each record. I just wondered if there was a quicker way of doing it.
I need to convert a large VB6 app to vb.net which does a lot of database work and produces a Crystal Report. The initial form is simple a login form which validates the user. I am trying to use a datareader to retrieve the user's login info but it won't compile on the statement where I'm trying to get the Connection String from the app.config file. It complains that the ConfigurationManager is not declared on the dim statement. Where and how do I declare the ConfigurationManager? I thought it was just pointing to the app.config file but apparently that is not correct. [Code]
View 3 Replieshow do i retrieve password in database using secret answer and email address and put the answer on label1.text? this is my code Private Sub btnRet_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRet.Click
Dim con As New OleDb.OleDbConnection
Dim dbprovider As String
Dim dbsource As String
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String
[Code]...
I am reading data from a socket (as bytes) and storing this data in a string. Then later i need to access specific bytes within the string and do some math with them. However the bytes that I read back from the string are not what I am expecting.
[Code]...
I need to store data in a grid like this:
{0,1,2,3}
{4,5,6,7}
{8,9,10,11}
{12,13,14,15}
I know I can use multi dimensional arrays, but Is there any easier way to do it? Also I need to get values from it like myData.Item(0,1) would return 1.
I've linked the two using the standard data sourcing method and I now need to use the data that is read in to it on another form. The idea of this is that I'm creating a wage calculator and the employees are stored in a database and can be viewed on a vb form, however, I now need to use the data of their pay/hr to be used on another form to calculate the wage.I have tried to declare a public variable across the two separate forms, and on the button that takes you to the other to set this variable as the contents of the text box which is displaying the pay/hr using the following
Public Class ManageUsers
Public HrlyRate As Decimal 'Declaring global variable to use between forms
'Some other code in between relating to rest of the stuff on the form
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
RatePerHourTextBox.Text = HrlyRate 'Saving private variable to global variable
Calculation.Show()
End Sub
End Class
Then on the other form I have used this code to do the calculation:
Public Class Calculation
Private Sub calculation_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
[code]....
I'm having trouble trying to put together some code for an array. What I'm trying to do is get data entered from a text box and store it in an array.What I then need to do is take the entered data and make it appear in reverse order to what it's been entered and show this.
View 6 Repliesstoring data into an array. I understand how to place information in one record eg in index 0, but how do i place data into several records(indexes).
View 4 RepliesI have propetie get set classes, and a constructor to quickly set them all.The only concern I have is that the byval in the constructor class and the byval in the set() properties, might be inefficient because the parameter is copied twice? Should I use ByRef? Or is that too dangerous?
'Config data for an Environment.
Public Class Environment
Private msEnvName As String
[code].....
I'm trying to learn visual basic and i've made my application all work and now I just need to make the listview save data.As far as I know, I can create a database with all the relavent tables in it for each column in the listview. For example in a database, I will have a table that will have four columns because I have a four column listview. Each row must be tied together though.
The other option is to create a text file and use some xml or seperate them with commas. which one should I go with? I'd rather do the database one, but I really have no idea how to go about it.
How can i store data accquired from an Ip address within the LAN into my database?
View 3 RepliesI have a question. I have a asp site that keeps track of inventory. I currently have it as to where any updates to the inventory, an email is sent with the new changes. How can I get it to send the old changes and the new changes. I know I will need to somehow temp store the old values to use them in the email, but I can't figure out how to do it. I don't want to store them in an actual database table.
View 1 Repliesis there any way to keep data stored in an application retrieved from web references like we get data [items] invoked in a listbox from web references and then after publishing it when once exe. is run the data is invoked or retrieved from web references. so that when next time once again exe. is run the retrieved data will be there instead of waiting services to get data.
View 13 Replies