Two Data Tables Within My Data Set That Are Loaded Onto My Form On Form_load Using Statements
Jul 27, 2009
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]...
View 1 Replies
ADVERTISEMENT
Mar 10, 2009
I am designing a form that will create a template of data that will later be loaded into another form.From a menu command "Create New Template" I will need to ask how many Fields will be needed for the new template in an input box. If the user would input say 10, then I need to generate 10 labels, 10 text boxes, & 10 combo boxes. Each group (label, Text Box & Combo Box) on its own row on the form.I also want create the data mapping for each of them at this time.Once I have achieved this then I will add a form that will lookup the template name, and row count given from the above form via the database and load the required rows of items for further data entry.
Since I will have a MAX row limit I thought about designing a form using a Table Layout panel with 25 Rows and 5 columns then doing some sort of .visible true/false for the layout panel row after the user input of row/field quantities.Another question is resizing the form around only the visible rows.
View 4 Replies
Apr 9, 2010
I have three tables in SQL server which I would like to show and access on a form. Table 1 contains account data, address, contact details etc. Table two contains data attached to a Person, tel no , Mobile no, Email etc. Table three contains details on what awards the person holds, i.e. one person can hold several awards.
Therefore I have a one many relationship between the first two tables and a one many relationship between the second two tables. This is set up in SQL
The first two tables are shown on a form, table 1 via a set of text boxes, table 2 via a datagrid control.
I would like the functionality whereby I could select a row in the datagrid showing the persons name and find the Persons_ID number then use that as a filter to a second datagrid view so that only the selected persons awards show in the datagrid.
View 2 Replies
Oct 19, 2011
I have a Microsoft Access database that has one-to-many relationships. When I created the tables for the database, I did not enter any data into any records, as that will be done by the application user. My problems is when data is entered into the parent and child tables, the parent table data is the only one that gets saved when clicking the save button on the binding navigator.If I have the parent and child tables data entered the same way a user would prior to connecting the data source and add EndEdit() to the child table BindingSource in the BindingNavigator click event, everything works exactly the way I want it to.This application is a data entry form, so it wouldn't make sense to have to have data entered in tables prior to adding the data source to my project. What is the best way to create a data entry form with one-to-many relationships? [code]
View 6 Replies
Jul 14, 2009
I am new to the forum and I was wondering if anyone would know how to display data from the tables of a MS Access database on labels on a form. The code underneath is my code for saving inputted data from textboxes.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
objDA = New OleDbDataAdapter("SELECT * FROM CDetails", "Provider=Microsoft.Jet.OLEDB.4.0;Password=;" & "User ID=Admin;Data Source =" & Application.StartupPath & "CustomerDetails.mdb")
objDS = New Data.DataSet()
objCB = New OleDbCommandBuilder(objDA)
[Code] .....
I would like to show these saved details onto another form. Is there a way to select rows and cells in the database and fetch the data in them to display them onto labels?
View 3 Replies
Sep 28, 2009
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?
View 1 Replies
Sep 28, 2009
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
View 5 Replies
Dec 5, 2011
i am trying to join 2 tables together and display them in a list view. i have this code so far
[Code]....
View 1 Replies
Jan 25, 2011
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 Replies
May 25, 2012
I 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 Replies
Jul 25, 2012
I 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:.....................
View 4 Replies
Dec 1, 2010
I 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.
View 4 Replies
Dec 28, 2010
I have used a data repeater and linked it with the data source. The program lists all the names of clients from the database with an ID number and also a URL.My first question is how can i make the url that is displayed as a link label, link to the default browser when clicked. I normally use the Shell("c:/program files/internet explorer/iexplore.exe "URL HERE") command but i'm not sure how to make this work with the data repeater?
My second question is to do with starting services, i need to take the ID number from the current data repeater record and then place it within a service name, for example if the service was callled Client_** the two ** represent the client ID. This then needs to start the service when button is clicked on the current record on the data repeater.
My third and final question is how to query a field in a current record of a data repeater, for example if i wanted to query a field called ID for that current record shown, is there a function i need to use to call the information?
View 1 Replies
Jul 11, 2011
I have a List Table (lstTable) that is on the same form that I am trying to fill in with information from a public structure (ELEM_DATA). I understand nested with statements will work if it is within the same scope but how can I do this with example 2 below:
Example 1:
With me.lstTable.Items(RECORD)
.SubItems(1).text = ELEM_DATA(RECORD).name
.SubItems(2).text = ELEM_DATA(RECORD).number
end with
[code]....
I didnt know if it is possible or if it would be as simple as changing (.name) to something else.
View 1 Replies
Oct 22, 2010
I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
View 1 Replies
Aug 8, 2011
I created a VS2010 application that stores data in xml files with a custom extension (e.g. ".ABC") I would like to be able to open an .ABC file and have the application launch with the specific file's data loaded. This is analogous to opening a Word doc and having Word open with the doc loaded. I have searched for a while but can't even think of a phrase that explains this process. Nothing seems to match "You know . . . that thing that happens when you double click on a data file".
View 2 Replies
Mar 19, 2009
i have a textbox that i want to format the value and i placed it in the Validated event.. it works ok when a user enters a value but when data is being loaded from database, it doesn't format.
View 12 Replies
Apr 4, 2011
I've a xml file to load into the datatable, but no data is loaded, also without any error. the output is 0.[code]
View 2 Replies
Nov 4, 2011
I have a gridview in windows form. When lots of data are loaded from the database to the gridview, my application hang until all the data are loaded to the gridview. Is there any way to solve this problem? I also want to display a gif image [loading.gif] or progressbar when data is being loading to the gridview to show the user that data is being loading to the gridview. But the image and progressbar also hang.
I have also one ToolTip, I want to display that tooltip in the center of the screen. My code is as follow but it is not positioning that tooltip in the center.
Dim x As Integer = TryCastInteger(Screen.PrimaryScreen.WorkingArea.Width / 2)
Dim y As Integer = TryCastInteger(Screen.PrimaryScreen.WorkingArea.Height /2)
ToolTip1.Show("It will take few seconds to display the data.", KryptonPanel1, x, y)
View 2 Replies
Mar 3, 2012
I've a SQL DataSource and a Datagrid in a Web Page. The data grid gets binded automatically when the page is loaded. How do I delay that until click event of a Button.
View 1 Replies
Mar 23, 2009
created a control inheriting a textbox. it is used to format a datetime data. i created a custom property DateTimeFormatMask which is "MM/dd/yyyy" by default. problem i'm having is that when datatable is filled by adapter and the textbox is populated with the data, it is not formatted..i placed the codes that formats the data in the Validating Event which doesn't seem to be triggered at this point.below is my code on my
View 4 Replies
Mar 31, 2010
I'm working on a VB.Net windows application.In the top half of the form application, I have a vendor number with a "GO" button and in the bottom half I have a list of tab pages. We have built the application to only go to the database and display data when the tab page is selected by the user. If I'm in one of the tab pages, and I change the vendor number and click the GO button, the data on the current tab page goes blank (it does not refresh). I have been told that I have to find a way of programmatically clicking on the tab page's tab a second time. How do I do that? I've tried using _Selected event, _Selecting event, _Click event. I've even tried to do a .Focus() on the tab page itself. Nothing seems to work to reload the new data without clicking off of the tab and back onto it manually.
View 4 Replies
Jan 11, 2012
I'm trying to setup some way to reload values once the uniqueID is selected from a combobox. once the this is selected, it has to loadup the values of the other comboboxs with the saved Choose. I've got the the point of the values are Inserted into the database and save the inital chooses.
But now i got to the point to re load the information from that ID i not sure how to go about it, I tryed using Databindings It loaded the data under a query to filter the Data to the correct Values but it ovisuly removed the Pre determinded values that are set in the combobox.
[Code]...
View 9 Replies
Apr 24, 2012
I'm implementing an application using vb.net 2005 with oracle 10g and I came across a functionality that should Select/Insert/Update/Delete data from three different tables in oracle.So I`m wondering if there is a way to prepare all the 3 commands (SQL Statements) separately and then execute them in one shot to the oracle, so in this way I can guarantee that all of them are successfully executed or all are failed to execute, and also I could gain more performance which is critical in my case.Thus I`m looking for a syntax in vb.net that helps me execute more than one OracleCommand in one shot to the oracle.
View 1 Replies
Jan 26, 2012
I have 2 tables in MySQL database. These table were joined through a query and handled by a dataset. Im displaying these data through setting the dataset as the datasource of my datagridview. But when it comes to Update, Insert and Delete statements, I got an error because the sqlcommandbuilder does not generate statements in multiple tables.I want is, when I press the update button..all the changes made in the datagridview will be updated in the database. Can i make it without creating a datasource in design mode or through smart tag? If I have to manually create an UpdateCommand for adapters..Can I have a code snippet for that?
View 1 Replies
Dec 9, 2009
Let's say I have an edit view that is strongly-typed to a table called "MyData". The view has multiple tabs, each with several different fields from the table. For performance, the data is only loaded when the tab is viewed, so if you only edit a field on tab 1 and submit the form, the data for tab 2 will not be loaded.
The problem I'm running into is on the submit. I'm doing the typical routine of finding the existing record in the database and updating the passed values:
<AcceptVerbs(HttpVerbs.Post)> _
Function Edit(ByVal data As MyData) As ActionResult
Using dc = New MyDataContext
[Code].....
However, this method doesn't know which tabs were loaded, so if the tab with "desc" on it is not loaded, this method thinks the user blanked out the "desc" field, and sends NULL to the database.
How can I construct this so that only loaded fields are sent to the database, and unloaded fields are ignored?
View 3 Replies
Feb 2, 2010
I have a database that dynamically loads from Access into a datagridview. I have to enter data manually into one column in this datagridview. I need to be able to perform calculations to this data, for example I need to sum the data in this column, sqaure it and substract it from individual sqaures of the data in the cells. I should be able to sum it sum(22,33,44,53,67,23)^2-sum(22^2,33^2,...23^2). The number of columns keep changing depending on the database I choose to load, so I need to code this dynamically too. I am not really a VB person. I did the same in excel using Visual Basic and I am trying to do it in this Visual Basic environment.I built a tool in excel(VBA) that do some statistical calculations and data analysis and I am trying to build the same in Visual Basic.
View 10 Replies
Jun 8, 2010
I have loaded the rows data of a datagridview into a datatable object but I am not aware how to show them in crystal report.
View 3 Replies
Oct 29, 2009
I was under the impression that there was not much difference between Sub New() and Form_Load. However, I found one weird bug...Add a combobox and a label to a form, and the following code:
Public Class Form1
Private mstrOutput As String = ""[code].....
The label text shows that the value of ComboBox1.Text changes between Sub New() and Form_Load.Is this meant to happen?
View 5 Replies
Oct 16, 2011
I have 2 tables. I'm getting info from table1 which is loaded in an rtb.
vb.net
]Dim cmd_info As New MySqlCommand("SELECT kan_info FROM kan_info WHERE kan_id= '" & kt_id & "'", conn)
reader = cmd_info.ExecuteReader
While reader.Read
beslag_kanton_info.Text = _
"RB_REF: " & vbNewLine & _
"KT_REF: " & vbNewLine & vbNewLine & _
reader.Item("kan_info").ToString
End While
This works great, but I need to add extra info after "RB_REF:" and "KT_REF:" (e.g: RB_REF: 12345 / KT_REF:6789) Those values are located in another table. How do I change the code/query so it also get the necessarily records from that table? Obviously there is a column "kan_id" with same values. I can't merge the tables btw.
View 9 Replies
