i have two tables.. mainTable and tempTable..
in click event i save records to this table.. this table are identical in its structure. on my code i used 2 insert statement to store records to the two tables..
is there an other approach and a more easy way to do this? i mean without using two insert statement?
I have a 5 tables in my database and i want to access all my tables togather at a time.e.g.I have a code for one table i.e. rs.Open "select * from Group_info", con, adOpenDynamic, adLockBatchOptimistic. instead of Group_info table i want to access 5 tables also as Login_table,User_info table,group_name table etc. How i do that
View 11 RepliesHow can I save data in the textbox to two different tables? I have it bound to tableA to display data and I want to save that data to tableB and tableC when I click save.
View 2 RepliesI fill DataSet from Access Database then create Datagridview to display data. My problem is how to Save Data back to a different table in Database then the one used to create the DataSet? I'm using Visual Studio 2008 and Visual Basic 2008.Original Table used to fill DataSet is called RecordList the new Table will be RecordListReport.
View 8 RepliesI want to save new data from access tables to sql tables without overwriting old data in sql. Data table format for access and sql is same. (using Visual Basic).
View 1 RepliesI am having a problem saving related tables and querying them. I have both data binding sources on the form and I have both being added, end edit, and both being saved. When I "view all" and click on the related table "crimes" they're not showing with the Inmate that committed them. I have gotten it to do this with a code similar to that below and I am wondering what I'm doing wrong so that the datagridview for crimes will display the correct crimes for the correct inmate. The primary key for inmates is DOC# and the Primary Key for Crimes is "Entry ID"
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Me.Validate()
[Code].....
I am developing a program that will contain a TabControl on a form. The TabControl will have multiple TabPages that will represent forms used in the mental health field by clinicians. What I have done so far is created a SQL Express 2005 database that contains a table for each TabPage. To start off, I am working with only 2 tables to see if I can make this work. The tables are called EvalPage1 and EvalPage2. Each table includes a field called ClientID which I have named Key Indexes. I am also using these fields to create a relationship: EvalPage1.ClientID (Parent) and EvalPage2.ClientID (Child)
The problem That I am encountering is when I use the BindingNavigator to enter and save a record, it only works for EvalPage1 and not for EvalPage 2. Here is the code that I am using:
Public Class MainForm
Private Sub EvalPage1BindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles EvalPage1BindingNavigatorSaveItem.Click
[Code]....
I have 3 tables. customer,item, pricing, each with keys customerid,itemid,priceid. pricing is related to customer and item tables by a 1 to many.pricing (priceid,customerid,itemid,price)
[Code]...
Possible to create new tables in my database at runtime. What components will I have to use?
View 2 RepliesI have two tables < student > and <class> . In vb2008 i make the connection to the database, display the data in both tables, edit existing data. The problem is that when i try to insert new rows to both tables there is a problem when i try to save both tables at the same time. The save button is in the studentBindingNavigator. I connect to the db through the Add New Data Source. The message i get is Can not insert or change a record beause it requires a relevant record in table student. Does anyone know anything about it?The two tables are related to each other.
View 1 RepliesIs it possible to navigate multiple tables at a time.... The two tables are joined with primary and foreign key relationship...
some site to which i can refer or some sample code for all first,next,previous,last
I can do it when its single table....
Private Sub btnFirst_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFirst.Click
' con.Open()
[Code]......
I'm currently trying to create a program that includes a text box (to input a number into), a button and a list box that will display the times tables for the number that is entered into the text box.
The idea of the program is so that a user can enter a number into the text box, for example, the number 5 and all the times tables (up to 12) will be displayed[code]...
I dragged 2 tables onto a form, the nav bar at the top showed up, but it only saves data for one table for some reason - how can I make it save data to both tables at the same time? I looked up the properties, but I can only select one dataadapter
View 4 RepliesI'm developing a web application that provide a service of online reservation, and I need to save the data (for example in a specific day and access to them).How can I do that.Is it possible using : System.Web.UI.WebControls.Calendar?
View 1 RepliesWhen ever I add a new entry into the database, it will do it. When I click save, it will save it. When I go back to edit the entry after it was saved the first time, and I hit save again, I get a concurrency violation? It only does it when I add an entry. If I close the program out and restart it again I can save all day long as long as I don't add a new entry. First of all, dunno where the violation is coming from, but I only have a message box on my catch statement on the save button.
I have added it to the database using the following code 100 times and it has always worked:
Me.shuttlerunsbindingsource.addnew()
My save code is:
Try Me.Validate()
Me.ShuttleRunsBindingSource.EndEdit()
Me.ShuttleRunsTableAdapter.Update(Me.ShuttleRunsDataSet.ShuttleRuns)
[Code] .....
Why after a million times of using this exact same code is it not working? It will save all day long no problem as long as I don't add a new entry. Here is my add
Try ShuttleRunsBindingSource.AddNew()
EmployeeInitialsTextBox.Text = lblUser.Text
Catch ex As Exception
MessageBox.Show("UNABLE TO ADD! " & ex.Message) End Try
The message box for the add code never shows so I can't see that is causing any trouble. I am using VS2010 and a local database, not SQL. I just tried doing it again, I added an entry, I saved it, I got a successful message. I then tried to change something and I got a concurrency violation when I clicked save again. I then tried to delete an entry and it successfully deleted it, but when I went to edit another entry and save I got the violation.
I'm trying to save my application settings at run time, but im not noticing any change in the application settings window. Basically, whenever a change is made to the price of a room, i want to save it to the settings so it can recalled later on in run time and when the program is started up again at a later day. Heres the code im using;
[Code]...
I am trying to save forms containing PDF and Pictures on DVD at run time then be able to load them back trough the DVD
View 6 RepliesIn an VB2008 application an email can be saved in a SQL 2005 database. The date, time and subject are saved in SQL. Let's say the receiving time of an email is 12:56:55. After saving the values in SQL a SELECT of the SQL table gives me a time of 13:56:55. From this result I conclude SQL is saving a time value differently. - Is this difference come from the time zone? - Is this difference come from the daylight saving? - Is this difference come from both? How can I easily compare these two values?
View 3 RepliesI am trying to have a textbox to enter a run time in. i.e. 10:32 (ten minutes and 32 seconds). I will then need to have an if..then statement like this:
txtRun.text = Run
If Run <= 9:12 then
RunScore = 60
[code]....
I have the following Public Class Payroll Private Sub DateTimePicker1_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DateTimePicker1.ValueChanged
[Code]...
and I'm trying to save the datetimepicker value as a variable to pass to a sql database. I'm just not sure what the datetimepicker value is, is it Me.DateTimePicker1.Value or is it dt?
I am coding ib Visual Basic. I need to store the current system time in MS Access timestamp field. How do I go about it.
Dim row As DataRow = ds.Tables("StudentTable").NewRow
row("SSMA_TimeStamp") = System.DateTime.Now.ToString()
I have been making a control and have added a property for a list(of CustomClass). The custom class contains a string, an image and a list of another custom class which contains a string and an image. I have added this property to the designer by adding the browsable attributes and all appears to work correctly with this.
My problem comes when running the program. I can set all of the values within the property and I can go back to them and they are saved, however, as soon as I run the program, the values are wiped out as the property is set to Nothing.In order to allow my property to be edited and saved, I realize that I must initialize the list and have done so in the accessor method of the property (if the property's value is nothing).
I have modified the values in the designer and placed a breakpoint on all of the items which use the property and it's underlying field, as well as on the property's methods itself. The first breakpoint hit is of it being accessed and the value is always nothing.
I'm not sure where the values are supposed to be stored as I have checked the designer code where it would normally store types such as strings and I have checked the resources to see if they have been saved there (like an image would be). After running the code, the values in the designer are wiped out also.
[Code]...
I'm saving my settings like this...
[Code]....
Right now the existing VB code I have uses GUID to generate "random" filenames on save.
For instance:
ff8514d389a041649fd8b925a32f2b51.jpg
e1c938560fc1464ab2138065fc4661d3.jpg
Instead I want a date stamp, Time Stamp, and numbered filename:
For instance:
20091015_131644_001.jpg <--(Date_Time_NumberIncrement)
20091015_131551_002.jpg
Or something along those lines. The current code (which saves a jpeg to a random GUID filename) is below:
Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports System.IO
[Code] .....
Right now the existing VB code I have uses GUID to generate "random" filenames on save.
[code]...
Instead I want a date stamp and numbered filename:
[code]...
I want to work on a project I have in mind and this envolves saving data which would need to be updated every time the user exits the program. I suppose I need to know how to save a file to a blank text document, and how to get the application to read the information when it is called for. I believe I need to set delimiters or such, the helpfile is useful, but limited and some information is not listed at all.
View 7 Repliesi want the user to login, and the first thing is, having the text document for that(if theres a safer way to do it, let me know) then it goes to the weekly sales page, but theres also the goals for the sales, which rarely change, but if they do i would like them to be able to change them, then next page is the list of the workers, and if they need to i would like them to be able to add workers. so my question is: is there anyway that maybe i could save both the goals, and the workers in the text document, and when they need to change it/add workers it will save it in the text document and the next time they sign in the changes will be permanent? also is there a way to delete the user once they have been created, other than going into the txt document and deleting it.
View 2 RepliesI have noticed in a windows-based VB application I am working on when the "Automatically adjust clock for daylight saving changes" is de-selected, the time in the application is off by one hour. Is there anyway to make the application not sensitive to that and just display the date value that is retrieved from the database?
View 12 RepliesI have been trying to find and/or think up a way for data to automatically update a data table.I have a log that shows all the customers that came in today with various information. There could be twenty or thirty employees adding to this log or updating or doing things with that customer. This information is in a Data Table on a ASPX page in Visual Studio 2010 that the code is binded in the aspx.vb page that is calling a page in my APP_CODE database file that calls a query in my Database to get the information.My question is could someones actions on a different computer make my computer refresh or to re-bind that data.I have thought of some kind of timer/counter maybe that looks to see if the count of the log is different.
View 2 RepliesI am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................