DB/Reporting :: MDI / Shared Untyped Dataset?
Dec 30, 2008
I have an untyped DataSet: "ResultsData",which contains several tables: eg "EntryList_table".The Parent Form reads lines from a text file, parses the line, and distributes the necessary data to the corresponding data table.I then have several child forms which contain DataGridViews, each displaying the data in a unique format. All of these tables are Read only, and the DataGrid views only need to display the data attached. However, when I open the child forms, the data does not seem to update with each line read from the text file? As they are bound to the DataTables in 'ResultsData', the column headings appear correct, but will not populate the new data.I would like to have a 'Shared' DataSet that can be accessed by each child form (when activated), and will allow continuous modifications as the input lines are read.
View 6 Replies
ADVERTISEMENT
Nov 25, 2009
I want to access data using both the datasets.
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Try
[Code]....
In my code i have dataset name ds and table named Info1,when i write ds after that how tablename is coming,its not possible? How to do that ?
View 5 Replies
Sep 21, 2009
I have an untyped dataset which is programmatically bound to a form in vb.net 2008. The first record in the dataset is not necessarily the record the user selected to view. I need a way to, after the binding is done, move the dataset to that particular record. I have a currencymanger in play for use of displaying the current record of how many records. I think I need to do a search and find the row number of the select record and then use the CurrencyManager.postion to do this but have had no luck in 3 hours to locate anything I can use.
View 1 Replies
Jan 9, 2009
I want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
View 5 Replies
Sep 3, 2009
I want to create an enterprise wide dataset so that my function will call this same dataset from any of the webpage. I've created shared code in the App_Code folder. In it, there's are dataset properties. Will the pages extract info from these dataset properties each time I call the shared program or will create new property for each page.I'm trying to emulate an Enterprise Java Bean type of coding.
View 2 Replies
Oct 22, 2009
Visual Studio 2008 Express Edition.I have a have a DataSet, created from (part of a) Access database. I have tow tables in it (say A and B). When I change something in table A, I need to get data from table B to complete table A.My approach was to use the RowChanged event inside a (Partial) Class of table A. For that to work however table B needs to be shared. (I don't like to refer to an instance.) I got it to work by changing the DataSets designer code, but don't want to do it all over again when the code is regenerated for some reason. So: would there be any way to have these tables shared by default?
View 3 Replies
Aug 9, 2009
I create one typed dataset by dataset designer in VS2008. How can I change this dataset to shared typed dataset?
View 6 Replies
Feb 22, 2010
I am trying to develop a report that displays the result of a query that returns two tables. The first table is always a single row of values, the second should be a grid. I can get a report to display either independently, however it will not allow me put them both on the same report.
View 1 Replies
Jun 2, 2011
I have a dataset that I'm trying to loop through to be able to save any changes made to that dataset and update my database doing so. Is that possible? I've seen that it's possible to do it with datatables but not datasets. If so, can someone offer a starting point for me to learn with?
View 1 Replies
Nov 18, 2008
What is the best place (event/procedure) to use the newest record when navigating from record to record on a form.
For example, I want to do a calculation on 2 text boxes that are bound to a dataset. This calculation will be done each time a new record is navigated to.
View 1 Replies
May 12, 2010
Today i have been checking out the concept of datasets and i like the way they work except for a minor issue i have with it.The following code should get a databasetable and put it in a dataset and return that set to the user.[code]I submit the table name and it will select it, read it and fill the dataset with it, then return it. And it does exactly that once.If i try to re-read the same datatable it just returns the exact same dataset as the first time yet i am 100000% sure that i changed it .
View 1 Replies
May 23, 2009
i'm using vb 2008 express editor, and 3.5 compact sql, through my program, i make changes, like altering rows, deleting or adding new rows, to a dataset. i want, that when button 1 is pressed, all changes made to that dataset, are updated to my database. what is the line of code that does this? [Code]
View 1 Replies
Jun 4, 2012
I am using VS 2008, VB.NET and Windows XP r3.I am trying to use LINQ to DataSet in my app. In my test app, I can get it to work find. My test form has an OleDbDataAdapter, an OleDbConnection and a DataSet. It also has a DataGridView bound to the one table in the DataSet, a BindingSource and a Button.[code]
View 7 Replies
Mar 5, 2009
I'm having a problem with a database. I"m using these two functions to add and remove folders to the database:
Code:
Private Sub AddToFoldersTable(ByVal AddFolder As String)
If FoldersBindingSource.Find("Folderpath", AddFolder) = -1 Then
[code]......
View 1 Replies
Apr 25, 2011
Here is my code that parses an XML string to a datagridview:
Dim DS As New DataSet
DS.ReadXml(New StringReader(StringHTML))
DataGridView.DataSource = DS
[code]....
Child list for field Produits cannot be created.I'm sure it's something so simple you guys are chuckling...Can't wait to see what's the problem
View 10 Replies
Sep 21, 2008
What I mean is that when I make queries on a Parent Form. Child forms can also retrieves the datatable /datarows from its parent form.
View 3 Replies
Oct 29, 2008
We are updating our SQL SERVER 2005 database to reflect the name of our new corporate masters and we need to change the values of the fields.
Once we do so, we will hit those fields with update queries, but right now, my group just needs a listing of the affected tables There are over 250 tables to search, is there a way to iterate through the tables?
I imagine I could search the datatables once I get them, so that part isn't a problem. I just need to know how to set up some code to peek in, record what needs to be changed, close it and move on to the next table.
I've done as much for a single table, but never a load like this.
View 2 Replies
Sep 22, 2008
putting images in a dataset. I'm developing a windows application that accesses an sql server database in another server, an sql server 2000 database. A table, tblProducts, contains a field called ProdImage with type VarChar. ProdImage contains the path of the image which is stored in the server's file system.
[Code]...
View 2 Replies
Feb 18, 2008
I have a program that I designed that scans my music folder, gets the id3 information, and then in turn inserts the results into a dataset
Here is what I have:
MusicLibrary.sdf with a table called MusicLib
MusicLibraryDataSet
MusicLibBindingSource
MusicLibTableAdapter
DataGridView
So far here is where I am, if I open the database through the visual studio ide, I manually put in a few songs just for testing purposes. When I run the program the DataGridView displays the data I entered. However I can't seem to figure out how to actually programatically add songs to the database. This is what i did so far:
I execute this command for each song scanned:MusicLibraryDataSet.MusicLib.AddMusicLibRow("FileName", "Artist", "Album", "Title", "Track") Then when done execute this command:MusicLibraryDataSet.MusicLib.AcceptChanges()
After I do that how do I then insert these items into the sql database itself so that the next time I load up my program the info is there. I have plenty of sql experience, but am used to doing all this in asp.net, i've never quite gotten all the table adapters and stuff.
View 2 Replies
Mar 12, 2009
I'm writing an application to mimic a cash machine, I have a Form1 on which the user enters their PIN and chooses their card no. from a drop down box.The accountID is passed to Form2 and I know this is successfully seen by displaying it in a simple message box.A data adapter and dataset are used for this to the cards table.However, what I then require is within Form2 to retrieve the balance from that accountID in table Accounts, another data adapter and dataset have been created for this under Form2.I'm trying to get the balance into another variable, and I have written this as follows: [code]I would expect the result of this to be e.g. 100.00 but instead I am getting a response of "There is no row at position 0".
View 1 Replies
Apr 20, 2009
Firstly here's the code and i will explain my problem underneath. [code...]
Now as you can see I have a variable that holds a value member of the combo box Products which is the productID of the current product selected. Then it searchers through the products datatable and once its found the correct product or not it stores the answer in slectedproductrow. next I test to see if selected product row has found the product if it has i then see if the product has already been added to the order by seraching the the customer current order datatable if it hasn't it adds the current information to the order by using selected product row.
Now the problem i get is when i add the same product it still adds the information again as currentorderrow comes back as nothing everytime even if the product has been added before but if it was in the table which it should be it should skip that bit and just go to add the current qtys toghther.Also if i go to add a diffrent product it overwrites the the other one. So i can't store the customer order. Its like i can't store more than one row. By the way I have a datagrid and can see the product get over wrriten.
View 2 Replies
Jul 21, 2009
We have a VB.NET (aspx) website with a login first page. Once the user has logged in and is authenticated they are taken to a single page with a Menu Bar at the top and a report viewer control underneath. When the user has logged in the report viewer is initially populated by a dynamic menu (a menu of links to other reports depending on each user's permission).
Now, on some reports that the user access from the main menu, they like to export the data. The nicely formatted reports export nicely to PDF but these same reports look awful when you export to excel. Further more what is required from the excel version is no formatting and also to include extra columns of data that are available form the dataset but not from the rendered report (for use with importing these expoerts into other systems).
Is it possible to extract the data that is generated from the dataset that renders the report?What I would like to do is obtain this data and create my own excel export option (of which I will put into the page Menu bar at the top of the screen). It is important to just grab the data that is generated because different data is available depending on the parameters the user has chosen.
View 2 Replies
May 31, 2011
I have the following code:
public sub PrettyRows()
dim ds as dataset = report.dataset1
dim GroupName as string = ""
[Code]....
The Protected Overrides Sub OnInit() is comparable to the load event in VB.NET.
I am utilizing this event to call my custom sub PrettyRows. This sub will iterate the rows in my dataset and change the first column in each row so that an entry only appears once, This is being utilized to identify what group the row belongs to. The rows are sorted by group and I only wish to display the group name once and I am removing all other references to the group name.
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.
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
Aug 30, 2010
i have a situation where I need to search a table for a specific record that matches an ID number the user will specify. I know 2 methods to accomplish this. The first would involve writing some VB.net code that would call a TSQL statement and return the value through the return parameter. The second method would involve creating a dataset and populating it with a select statement.
View 2 Replies
Aug 25, 2009
K, I'm not sure which forum this question goes in, so I am putting it here.Here's my problem.I have a customer file [CSV] I am importing to SQL. I am using JET to read it into a dataset. I am using a schema.ini file to define columns, because I have one column with up to 1000 characters in it... so I have to define it as a Memo field so it won't truncate at 255 characters.
View 7 Replies
Feb 14, 2008
I am trying to read an entire database in to a dataset. I have this so far..
[Code]...
View 6 Replies
Feb 24, 2008
I am writing a school project in VB2005 and am trying to hook up a second combo box that gets its information of what to display from the first combo box. My application is where a student takes a "test" but they can choose what instructor they want in the first combo box. From there, they choose from a test of what each instructor offers in the second combo box. As of right now, my first combo box works great and my second combo box has nothing in it. Just a note, when I debug, it shows my iUserID value as 0.
[Code]...
View 1 Replies
Dec 20, 2010
I have a datagrid that I use to display data from a SQL 2000 table. I am trying to write back any changes the user makes to the datagrid data back to the original table but don't know the proper method to do this.
[Code]...
View 1 Replies
May 18, 2008
I have a storedProcedure that populates a dataset, this dataset is then used for a dataSource for a third party grid control. This all works fine, however I am having real trouble in updating the dataSet with the most recent data from my database.Below is the code that I am using to populate the dataSet:
[code]...
I am not sure how to update the dataSet with new data so that my grid control displays the most recent data. Could someone show me the code to do this?
View 3 Replies
