i m trying to write codes for new user to fill in the form, then the new data will into my database,however, my codes doesnt work, i cant figure out what's wrong with my codes. below are my codes:
Imports System.Data.OleDb
Public Class NewUser
Inherits System.Web.UI.Page
[Code].....
there is no error encounter, however,the adding is failed and no new data can be add in.
I have a data logging application that stores data in a table in a MySQL database. Data with a TimeStamp is logged into the table anytime the data from the sensor changes. This means that there maybe 2 seconds between data points or there maybe 20 seconds between points depending on how the data is changing.
When I need the data I have 2 dates and use this command to fill a table..SELECT FROM myTable WHERE timeStamp > date1 AND timeStamp < date2 This gets all the data that has a TimeStamp between the given dates, but in most case the first date in the returned table will be after date1, so I need to get the data from one row before the date returned in the table to know what the data was at date1.How can I get the data row that immediately precedes the returned data set?
I'm using VB 2010 Express with a local Access DB. On the form I have a DataSet, a TableAdapter, a BindingSource that points to the DataSet (and the DataMember is the same table as the TableAdapter), a BindingNavigator that points to the BindingSource and finally a DataGridView that points to the BindingSource also.
I have added a Save button to the BindingNavigator. I want to enable / disable the Save button depending on whether there are changes in the data to send back to the Access DB. I think this is the code, but I am not sure if I'm really doing what I think I am (i.e. I am concerned I will assume something turns out to be wrong) or if there are better ways.
I am also uncertain what event to use to respond to. I have guessed at CellLeave, but I could be wrong and there might be much better choices. Finally I've been told that it's different if it's a DataTable, but I do not know enough to determine when something is a DataTable?
Private Sub CompClass_DataGridView_CellLeave(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles CompClass_DataGridView.CellEnter
Me.BindingNavigatorSaveItem.Enabled = Me.Component_MI_DataSet.HasChanges
End Sub
I have an application half built which accesses a Access (2003)Database File. From within the application I am able to change the data in the Access File using a Data Grid. The changes to the Data File are saved and can be recalled, changed or otherwisemanipulated however, when I add too or change any of the applicationcode the Access file reverts back to it's original state losing any data or changes that has been made.
View 3 RepliesI am designing a desktop application that will be driven by local data. I am trying to determine the best way to accomplish this. The database would contain about 10-12 tables if I use a database and I would imagine no more than 10000 records in any one table (but honestly 99% of users would not have more than 1000 records). I am thinking about using SQL Server Compact.
Is this a good solution? I can certainly include this in my installation, but I am just wondering if anyone knows of a better solution? If this is the best solution, how would you suggest that I create the tables upon deployment? Should I just run "queries" with create table statements in them from my vb application or include a database file or what?
i am just developing a library management system as one of my project. i using vb.net 2010 and the MS Access 2007 as back end. when i save some records into my database through my application it is correctly saved and i confirmed it through opening the relevant table in the database. but when i restart the application all the entered data were missing.
View 1 RepliesI am trying to create an application where it stores images as well as data.
View 3 Replieshow to find data using search command in my form application like searching a name in my database?
View 1 RepliesI have created an windows application which stores it data in a database. What I would like to know is how do I access the tables in the dataqbase and transfer the data in them into textboxes on the forms in my application. I can connect to the database and view the tables, but I have'nt got any idea how to get the data from the fields in the tables into the appropriate textboes on the application forms.
View 2 RepliesI have a checkbox in my application,when the checkbox is checked then i want to fetch the data from the database and add it to the dropdownlist of the combobox.Again when the checkbox is unchecked then i want to ramove all the data from the dropdownlist of the combobox.
I did this
Private Sub CheckBox1_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged
If CheckBox1.Checked = True Then
con = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=Etech.mdb")
[CODE]...
When the checkbox is checked then the data is added from the database to the dropdownlist of the combobox but when i uncheck it then the data is not removed from the dropdownlist of the combobox. In the above code i think i need to add an else condition to remove the data from the dropdownlist of the combobox and make it empty when the checkbox is unchecked.......but i cant give the proper else condition in the above code.
The fact is I'm making an application, which users can install by using a Setup file...once installed the data in the database can be updated by a centralized server. To do this, they can insert a DVD/CD-ROM and export the necessary data towards it. I need to do it that way, because some of the users who really need this data will be using stand alone computers.The application gets it's data from a mdb-file and the connection remains open as long a person works with the application (maybe not the best way to do, but I know :-) )...when the user uses the application, he can perform an export...this exports the .ini-file and pictures (which works fine), but he also needs to export the mdb behind the application...I already tried connection.close() before and connection.open() after the System.IO.File.Copy...but that doesn't seems to work.
View 2 RepliesI got a system which i want to insert, delete, update the data into my database and the data from database will be display using datagrid. The below is the coding for one of my button, delete.
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Try
btnSearchEmpNo.Enabled = False[code].....
Now I wanna set when user click on this button to delete a employee (for example) then the datagrid that i have in my application will not show the data of the deleted employee but in the background, the employee haven't been deleted from database.The employee only will be deleted from database when the user click on SAVE button.I know this application have to use RowState but how?
What I want to happen is that the button from my system will remove the previous data from database and then insert new data to database from text file. Im done with inserting new data. The thing is that I dont how to control or where to put the Delete Command from my code.
[Code]...
I am having two databases for the same application , one in windows and the other is web based.Since web based one have few functionalities I can't opt for a single database.At the same time I want to share Both databases to be updated with other's data so as to work error free with my module of appointment fixing.
View 2 RepliesIn vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
View 2 RepliesWhen I install my application, some forms are unable to connect to the database.
I say some because, when my login form works totally fine. Authentication happens.
But once I go into the main application, and open other windows, I start to get these error mesages:
[URL]
i need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
I have made a database application that uploads a database via FTP here is the code:
Code:
note this line:
Code:
ContactDB.mdf is the database in my application what would i have to insert for it to upload the database i have tried it as it is and its failing i could locate its full path on my machine that works but what happens when i want the application to go on someone elses pc?
I have code on log in form but it only get the latest data on username and password column on my database
Here is my code
Public Class Users
Dim MyLogIn As New myRecords
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE]...
This is my connection:
Imports MySql.Data
Imports MySql.Data.MySqlClient
Module myconnect
[CODE]...
This is my record:
Imports System
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
[CODE]...
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
When I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 Repliesi just write code for application, in which data is get by user and entered data is to print in a particular format?give me a code for vb.net button by which after click on it will print entered data?
View 1 RepliesI am sitting with a situation that I have to combined (3 years) for 26 site of 29000 database files where there is 1 table in each data base called RECDATA, I need to combined all that data Into one database file called RECDATA.
For example there is a database called DB1 with a REDATA table inside it, and then DB2 with a RECDATA table inside it, DB3 with a RECDATA table inside it est. So I need to put all the Recdata into 1 Database file, or to copy all the RECDATA from all the database files to 1 RECDATA they all have the same columns All I need is to get all that data into 1 RECDATA table.
The program where this database comes from is a voicerecording system creating a new database every day. There is 1 database just for indexing (to view the recordings) and then the daily database is where the recording lies in, that Colum is called RECFILE. I will give you a example of the 2 database.
I have a report made in Crystal Reports XI. The report is generated and exported to PDF in visual basic script using COM interface. Generally everything is running smoothly, but in one case generation breaks with error: Failed to retrieve data from the database. Details: [Database Vendor Code 9421]
Database used is MSSQL 2005 connected over ODBC to CR XI. When I am opening report with exactly the same parameters in Designer, everything works fine.It looks like it is data related, but it is hard to trace since the whole report is pretty sophisticated. Anyway I spent half a day on crawling over Dr. Google and it seems that he has no clue what might be an issue.
I have VS 2005 installed in my sytem fyi.We have two databases, say source database and destination database. The databases is in Oracle. Now we need to pull data from Source database, manipulate it and push it into the destination database on daily basis.We are planning to use VB .Net for this and would like to know if this is feasible. Using windows forms through VB .NET, is it possible to create a exe and schedule the exe on nightly basis to pull the data from source to destination.how to do this as for manipulation of data, there is no intermediate database for us?
View 1 Repliescan anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
View 5 RepliesI'm trying to connect a VB application (2010) to an MS Access DB by adding a data source from the data menu but I receive this error message "The connection you selected uses a local data file that is not in the current project.Would you like to copy the file to your project and modify the connection ?
If you copy the data file to your project, it will be copied to the project's output directory each time you run the application" and the options are (yes , No , Help)
If I choose Yes I will not be able to make the application 'device independent ' since it will not be copied under the bin , and if I choose No , changes won't be applied to the DB
I have an excel file that I would like to load into my form and display there.
View 1 RepliesI 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 using the tutorial posted here for my database testing. I have gotten it to display the data using a messagebox but it just goes through them 1 by one. I want it to display all the data from the database in a table on my form.
Using connection As New SqlClient.SqlConnection("Server=71.200.87.112MySQLExpress; Database=database_test;User ID=sa;Password=greddy6;Trusted_Connection=False;")[cod