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 Replies
I 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 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 Repliesmodify code to insert the data to MS SQL and save changes when click save button for the second time?
View 14 RepliesI have a database created using sql server express 2008. There I have two tables called tbl1 and tbl2, which are related as tbl1.CityNumber=tbl2.CityNumber.
I have created the programme using VB 2010; there, a form has three textboxes.
Tables: tbl1,tbl2 ; (related as tbl1.CityNumber=tbl2.CityNumber)
Columns to be updated:tbl1.CityName , tbl1.CityNumber, tbl2.StreetName
TextBoxes on the VB form: txtCityName , txtCityNumber, txtStreetName
[Code]....
But, now the problem is, the two tables have not get updated,after going to the database in MS.SQL Server Management Studio. I think I'm very closer to have my required result. I have tried my best to track place,where I've gone wrong.I have been trying to find a method for last five days.
I have never worked with datagridview before. I need to know how to use it so i can use it in my (calculator) program. I would like to know how to make columns, rows, linking the cells in the table/grid to textboxes so values entered into the textboxes (on the calculator) after pressing save goes straight to the table.
View 1 RepliesI have three tables under one database. I'm using the built-in Navigator control for now until I get this figured out, but I'm using a button command instead of the built in navigator button. I need the "Save" button to save the data in the text fill boxes to save to the corisponding table. I used the drag and drop option to drop rows from each table to the form. See code:
Private
Sub Button1_Click(ByVal
sender As System.Object,
ByVal e
[Code]....
In my datagridview I was fill in using join tables (table1 = pr_employees, table2 = pr_employee_deduction). My problem now is during save button I want to update records from table2 only.[code]
View 3 RepliesI 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 RepliesI am really stuck in FarPoint Spread. I have a FarPoint Spread in my WinForms. In the run time I am putting the values in the Spread to do some calculation. But I want to know how I can export / save the data that I have enter into the cells during the runtime. I mean I want something like export to excel or Save as filename.xls / .xlsx.
View 1 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:.....................
I haven't done any VB coding since school (15 years ago) but currently have a need to run what "sounds" a fairly simple app at work. I'm hoping some of you might be able to give me some pointers as to whether or not my idea is possible, and if it is, how best to approach it.
I work for a company where we send a number of standard emails to potential clients asking them to contribute to our magazine . if no response we then send a number of follow up emails. each and every time I send a new email to a new prospect I'm editing one of our template emails, putting their name and email address into outlook and manually sending emails. Then for every reminder I'm going back into outlook, clicking reply all and then c&p'ing our second or third reminder emails in each and every time. needless to say at least 2-3 hours of my day are spent editing and resending the same emails on outlook.
[Code]....
Possible to create new tables in my database at runtime. What components will I have to use?
View 2 Repliesi 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?
Is 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 am doing my school on project on rs 232. it involoves VB. I have found out how to save text in .txt file in the code. But i have no idea when i save this particular text for instance with time and date oso..
For example my i can do this.I want to save " Hi i am VIJAY "
when i open the text file i can see " Hi i am VIJAY"
But what i want is When i open the text file i want to see " Hi i am VIJAY 10:35 24/01/2010 "
is there any help i can find ?
I am pulling three coloums of data from a SQL view into my data drid Day,TimeIn,TimeoutI want to colour my datagrid rows red if timeout is null and green if both the timein, timeout have data in them.[code]
View 2 RepliesI have a select query like this. But from the below codes, I cannot update t2.unit_price in the same SqlDataAdapter
My Codes :
Dim MyQuery1 as String="Select t1.item_id,t1,group_id,t2.unit_price from Table1 t1 left outer join Table2 t2 on T1.Item_ID=T2.Item_ID"
Dim DAp1 as SqlDataAdapter,Ds1 as New DataSet
Con.Open()
DataAdapter1=New SqlDataAdapter(MyQuery1,Con)
DataAdapter1.Fill(Ds1)
[Code] .....
From the above codes
Dim Sav1 As String = "insert into table1 .........."
I don't know how to mention table2 also there ?
In my Project I have a Dialog Box (MonkeyList), a Database(MonkeyList.sdf), and DataGridView1. DataGridView1 is on the MonkeyList DialogBox. I want to save changes to the table when OK_Button is clicked.
View 11 RepliesI want to create a sub that gets changes from my typed dataset and datatable. But it says mydatatable is not a public member of dataset. Passing in as objects.
Public Sub GetRateChanges(ByVal myDataSet, ByVal myDataTable)
If myDataSet.HasChanges(DataRowState.Modified Or DataRowState.Added) Then
' Create DataSet variable.
Dim xDataSet As DataSet
[CODE]...
Another question. . I pull this infor from a view via tableadapter and it comes from several different tables.. How could I save my changes and insert the new records to the appropriate tables>?
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it?
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.
Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
I have two questions:
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it
I have two data tables within my data set that are loaded onto my form on form_load using statements written in code (not the designer. When I change a value for the first table via a text box the change is made to the data set. But when I try the same for the second table, the change doesn't remain in the data set when I switch to a different company and come back. I query the second table using the primary key of the first table but no code is needed when I change the values for the first table so I don't understand why the same doesn't work for the second when I change a value via a data-bound text box....
Here is my code that initially binds the data:
'This is used to read our data from the data base
Public Sub Read_Data_SQL()
Call Clear_Bindings()
[CODE]...
Here is the code I call when the selected index of my company combo box changes to have the second table reflect that of the first:
'This sub populates any information contained in the Contact2 table
Private Sub Update_Contact_2()
Dim Company As String = cmbCompany.Text.Replace("'", "''")
[CODE]...
I can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 Repliesi am trying to join 2 tables together and display them in a list view. i have this code so far
[Code]....
if it affects the run time of a program if I were to have multiple data tables as opposed to one data table with all my data in it? I am trying to minimize datagrids and just use code to access table data, in hopes that it will speed up my program. But I am ignorant if multiple tables vs 1 main table will make a difference because there will still be the same amount of overall data present in my program one way or the other....?
View 3 RepliesI am about to commence a little project whereby using a forms based application to visualise temperature in a building over a day. I am using data loggers placed strategically around the building (these record temperature and time of the read). I am planning to use a picturebox with the buildings floor plan within it and on using a scrollbar (using time as the metric) scroll through the day with temperature being represented by the size of the graphics on top of the floorplan (these represent the location i placed the data loggers around the building).
I have already built a tool to digitise the location of the loggers on the floor plan (saves the data loggers id ref and x y coordinates in the picturebox back to an access datatable).I am planning to use loops on scoll to draw and resize the graphics in another picturebox. The data loggers could be many (up to 30 or more) hence i am concerned this might grind to a halt or become so staggered that it will cease to be useful.The question i would like to ask is is this the most efficient way of doing this or am i going down a dead end.
how to code for the save button in vb.net datagrid view by using insert into sql and update sql statements (it should be able to insert & update the data grid and save the changes) when the save button is clicked .
View 2 RepliesHow to save all the data displayed in DataGridview( 2 column, no primary key) and have a button and
View 7 Replies
