DB/Reporting :: Writing A Program And Loading Info Into A SQL Database
Feb 17, 2009
I'm writing a program in VB.Net and loading the info into a SQL database. Debugging it works fine on my machine that I am programming it on, it connects to the database and runs through all the info perfectly. However trying to get it to run on another machine it will not connect to the database. I realize the reason for this is the connection string, it's looking specifically at the file directory for the database. How do I change this so that it will function on any machine. The program is only intended to run on one machine at a time and not over the internet.
View 2 Replies
ADVERTISEMENT
Nov 17, 2009
What I am trying to do is get specific info from a database and what I am getting is the first entry.
I have made a database connection, made the top bar not visible and I have inserted a text box and multiple labels. My MDB database has 3 columns (street, city, postcode) and multiple rows.
What I want is when a user enters a postcode in the text field the other labels get the info related to it. I.E. when a user enters "FY1 3DL" the labels update to "King street" and "Blackpool". With the code below I get the first row from the database.
Code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.StreetsTableAdapter.Fill(Me.WcipcodeDataSet.Streets)
End Sub
View 1 Replies
Jul 31, 2010
I am working on a media player, and I would like to setup a local playlist feature. I am using a single ListBox and its "Display-" and "Value-Member" properties. The display is the song's Artist and Name, and the value is the song's file path (i.e 'C:UsersUSERMusicetc.').To write the file path to the .txt file, I believe I can use the following code:[code]
View 18 Replies
Sep 25, 2009
writing user info such as user, computer name, date, and time to an acces database using a button click event. Then use a query to check if the user has accepted the aggreement. If the user has accepted the aggreement then call a vb.exe that display the aggrement. I have a login script that runs the vb.exe and uses a button click that records the user info to a csv file, but if the user has already agreed to the policies I do not want it run again.
View 4 Replies
Sep 20, 2010
I have a program where a lot of the required information for it is stored in text files. I simply read this information into large arrays. However, I don't think it's necessary to load all the information each time. Rather, it would be more efficient if I could simply search through a list of items to find the one I need and then use the data from it, or to find a similar name and use it elsewhere.
Would I be right in using a database? And is database programming done in SQL? I have a book on it telling me to use the SQL Server (IIRC), so I shouldn't be doing it in the VB.NET Express GUI?
Here's an example of what I would do:
Hex = 03 00 => dex number 003
Search in file Pokemon Dex Numbers
003 returns Bulbasaur
Check Bulbasaur base stats in the base stats file
etc
So basically I'm reusing a lot of information. I think a database would be best and it would all be internal right? I'm getting complaints about access denied to a text file (since it's stored in the program directory in the program files).
So to cap up the few questions I have:
-Databases are done in SQL and not inside the GUI?
-Databases would load internally?
-I could search a database without having to load it into like an array or something?
View 2 Replies
Jul 20, 2008
how would I go about making the user access different local SQL databases. As in they use a GUI program to access / read / write data in a database but can also use that same GUI program to do the same to multiple database files.Is that sort of setup easy to integrate into a VB program? or does a VB program by nature only try to access one database? To integrate the open and close dialogs into a VB GUI in terms of different database files, is there much involved?
View 10 Replies
Jan 7, 2010
I'm making a database app. I've finish the search, add new, and add function. What I'm trying to do is to expand the functionality of the add new item function.
View 2 Replies
Dec 27, 2009
I have setup a file that is comma delimited:
{object name,text,object name,text...}
I have loaded the file, split the delimited text into to separate arrays. One array is for the' object name', the other for its corresponding text.The text is no issue. My issue is that the 'object name' would look something like "form1.label1, form1.label2..." This loads fine, but I can not figure out how to get the 'object name' to be used as an object.I dimensioned the array for 'object name' as an object, but this won't work:
objectname(i).text = "..."
Looking at the values of the 'object name' array, after each listing it says {string}I need this to work this way because the file is loaded with the idea that it could be in any order, longer or shorter then another, etcetera.
View 2 Replies
Jan 19, 2009
I'm making a kind of rpg game which has variables that i need to save. I saved them like this..
[Code]...
View 5 Replies
Apr 16, 2009
I want to create a form that, when starting, will display in a ListBox the content of a txt file. I know the file is read because I can display the content in a MsgBox. Here's a snippet of what I tried so far:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim filein As String = "MyProjects.txt"
Dim objReader As New System.IO.StreamReader(filein)
ListBox1.Text = objReader.ReadToEnd
objReader.Close()
End Sub
When I debug my app, ListBox1 is empty.
View 7 Replies
Oct 26, 2010
I have an issue with StreamWriter class. Basically, in an application running as a web service, I need to write info into a log file. When I send 2 web service calls simultaneously, the entries created in the log file are not correctly written. For example,
in call #1, ID 1 - xyz is to be written to the log file. In call #2, ID 2 - abc is to be written. When I viewed the log, it shows ID 1 - xyz & ID 1- abc. Looks like there's some memory data being shared and mixed together, even though it's totally 2 separate web service calls. From my understanding, each call (i.e. each will be process under a different application instance) should have its own set of memory allocation for data processing... If I am to make this application as a Console Application, it looks like everything is processed correctly.
View 3 Replies
Apr 27, 2010
It has the ability to recursively grab all .wmv and .mp3 files in any chosen folder, and add them to a playlist.When opening the playlist, my program adds all the songs to an array, then starts adding the songs to a listview, categorizing them by song, artist, album, and genre, using a dll to access the ID3v1 tags on the .mp3 file.It can successfully create playlists of thousands of songs at a somewhat okay speed, the problem is loading that into the categorized listview.It used around 75% of my friend's CPU while loading his 5k+ song playlist into the listview, and it never finished after loading it in for a couple minutes (it auto updates as it loads, because it is done in a new thread.) It never finished because his OS has a bug where, if the CPU usage is over 100% for more then a few mins, it BSOD's, but that's beside the point.
His CPU, by the way, is a quad core 2.33 GHZ processor.The listview loads thousands of songs by using a lot of CPU [low amount of RAM, less then 40MB 99% of the time], and it does it slowly. [code]I've already redone the sub once or twice to speed it up, and at the moment it's 2-3.,
View 1 Replies
Jul 27, 2009
I have connected my database to visual basic.I have a form1 which allows me to scroll through all the data in my database (i.e. the name, account no, address etc)My form2 contains a calculation involving payments which involve the previous account.My form3 needs to contain this calculation PLUS the database information in a RichTextBox. My question is how do I include my DB info in a RichTextBox? (i.e how do I pass the information from form1 onto form3)
View 4 Replies
May 17, 2008
I am currently making an old school adventure game for a college project, it uses an Access database (dbGameStats) which has the primary key (gameStatsId) which is an auto number. The main form of the game holds the data bindings, dragged into text boxes, and the various screens of the game are shown over the top of the main form. So on the main form I have highscore and player name text boxes, bound to the corresponding database fields, when running the program, the user enters a name, the highscore field is altered as the game progresses and when the user exist the database is updated using this:
[Code]...
View 2 Replies
Nov 30, 2009
I'm working on a simple "sports management" game just to test out whether I could make an actual one some time in the future, but for the life of me I haven't been able to figure out how to save the contents of the datagridview. I want it to be saved in a format that doesn't require the user to have Access or any other program, so that the only thing users need are the .exe and the database file. Another question about the datagridview: How do I access the content on specific rows and columns of the datagridview? If I want TextBox1.Text to be whatever is written on Row 4, Column 2, how do I access that information?
View 1 Replies
Aug 26, 2009
I am doing invoicing using VS2008 VB. I use Crystal Reports to produce the invoice. I create an in memory dataset to pass to Crystal Reports. What I would like to do is save the dataset I sent to Crystal Reports as an audit trail of the exact invoice. It would only be retrieved in the event of a dispute concerning the original invoice. I thought of using the WriteXML, ReadXML. But that would overwrite the existing XML. Does anyone have a better way of saving the XML for future retrieval?
View 7 Replies
May 27, 2010
I have a vb.net program using the MS SQL 2005 Database.I use the SqlClient.SQLdataAdaptor to insert the records in DB.Whenever i load the program and then use the SqlClient.SQLdataAdaptor to insert record into DB for the 1st time, it will take longer time to load. But if I use the same SqlClient. SQLdataAdaptor to insert record into DB again immidately, it will take shorter time to load. However, if I wait for 5-10mins, then use the same SqlClient.SQLdataAdaptor to insert record into DB again, it will take longer time to load again.Can anyone tell me this loading is due to the SQL Server itself / the VB.net?Can anyone suggest me a way to check the reason of this loading? [code]
View 1 Replies
Jun 4, 2008
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 Replies
Feb 2, 2011
I need to write some code to tell the user when daylight savings starts and ends in another timezone, this is what I came up with but it keeps selecting the last Else line. The other lines are working fine, the problem is only with the lines, daylight savings today and not tomorrow. There is probably a much neater way of doing this but I thought this would work.
Private Sub Auto_Time_Change()
Dim sydneyTime As TimeZoneInfo = (TimeZoneInfo.FindSystemTimeZoneById("AUS Eastern Standard Time"))
If TSSlblTimeZone.Text = "Normal Time" Then
If CurDate.AddDays(1).Day = "1" Then
[Code] .....
View 4 Replies
Oct 12, 2008
Here is a code to insert data to DBaccess from textbox. When I write a colon(') in the textbox to add to DB it caused error and show me this Message "Syntax error in string in query expression '''')'
Code:
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source =" & Application.StartupPath & "Store.mdb ")
Dim cmd As New OleDbCommand
cmd.Connection = conn
'Add text to DB
[Code] .....
View 8 Replies
Apr 21, 2008
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 Replies
Mar 30, 2008
I am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 Replies
Sep 20, 2011
Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 Replies
Oct 9, 2009
I was wondering, i have smtp mail adress and password (for gmail*) and it is probably very easy to read it when opened with hex editor or decompiled so i want to encode/crypt that info in my program to make it almost (i know it isnt possible to make it fully unreadable) unreadable and/or make my program undecompilable
View 8 Replies
Aug 21, 2009
How could I make a program that goes soemthing like this
1. I open program
2. I log in with my user and pass (User doesnt have to be case sensative)
3. A form shows up where I can store Usernames to differnt things
4. It gets saved into the form
View 12 Replies
Jun 7, 2012
i am trying to make a login screen that is connect to a database(NOT MS ACCESS).i keep geting an error when i try geting it to conect to the database
"Value of type MySqlData.mySqlClient.MySqlDataReader cannot be converted to System.data.OleDb.OleDbDataReader
At rdr = MyCommand.ExecuteReader()
dose anyone know whats going on
[Code]...
View 2 Replies
Apr 11, 2010
I created a database in access 2007, linked it to my project in visual studio 2008 (vb). When I enter some data using the UI, it does not save it in the database, and it's gone as soon as I run the program again. I dragged the textboxes from the datasource panel, onto the UI..
this is the code that was automatically generated by vs for the save button:
[code]Private Sub StaffBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StaffBindingNavigatorSaveItem.Click
[Code].....
View 2 Replies
Feb 15, 2010
I have 3 labels I want to populate with info from my database. I have a SELECT statement that works for only one piece of info but I need it to include the other 2 as well.
I have 3 labels: Current, YTD, and MTD My select statement is working for YTD but I don't know how to write the SELECT statement to include the others.
[Code]...
View 6 Replies
Sep 14, 2011
I need to display info about each of the 50 states when selected in my program. I have one combobox with all the states as items inside, one button that you click to get the info and one listview for displaying the info. Here is my code so far:
Imports System.Text.RegularExpressions
Public Class Form1
Private Function getinfo(ByVal state As String)
[Code]....
View 2 Replies
Feb 12, 2011
Is there any way to make a program that gets data from the input site (like the javascript: Time left:, and the bidding page)
my goal is to make a program that will bid your maximum input using your credentials at the last minute... i hate loosing bids...
is this even possible with vb express 2010?
View 1 Replies
