I my opinion i think i should use datasets fully when performing select, insert, update and delete operations to DB. Foloowing this concept, The applications control flow should be:
[Code]...
What is the best way for me to have several datasets ?i've thought about creating a routine for creating datasets with a number in their names, each one with the desired data, but that's not very intelligent (although might work)i'd like to create what would be like an "ARRAY OF DATASETS"
[Code]...
(obs, i've done the same code loading one XML to one dataset and it works perfectly, i've gone back and forth more than one time to assure that it isn't just a logical mistake, it's syntax and lack of programming knowlegde.
I created the dataset and connection to my SQL database at design time to make it easy to drag and drop bound controls and stuff to my form. My problem is this, when I did this it creates the connection string in design time also, but the connection varies depending on where the software is installed after the development.My question, is there anyway to set up the bound controls on my forms and everything with the typed dataset created in design time on the connection created in design time... then when the application is run, can it change the connection string at run time to get it connecting to and creating the dataset from the the correct sql database?
View 1 RepliesI want to create a lookup program for library books using VB6 or VB.net.
I have created a Form1.VB with two listboxes :- Listbox1 Listbox2.
Im using an Access Database with a Library Category Table
Field1: Category
Library Title Table
Field1: Category
Field2: Title
Field3: Author
Field4: Publisher
Using the Data Adapter ConfigurationWizard Ive created
OleDBDataAdapter1
OleDBConnection1
And from the Library Category table Ive created Dataset1 attached to Listbox1
OleDBDataAdapter2
And from the Library Title table Ive created Dataset2 attached to Listbox2.
Both Datasets fill using the Preview Data function. I then load Variable CategoryString with Listbox1.text,
and I would like to know how to search Dataset2 and retrieve all titles linked to that category and display Title, Author, Publisher in listbox2.
Im needing to create a 2 applications that can talk to each other. One wil run on a server as the server application and others will run on workstations as clients. I want them to connect to the server app much like a chat program would work. I want to be able to send commands from the server to the workstations such as reboot, open this file, things like that. I also would like to be able to send the commands backwards to the server if needed as well. i think a chat program could be modified to do this by "watching" the message and if the word "reboot" comes through then the server/workstation would convert that to a command.
View 9 Repliesi wanna know whether we can create mobile applications for nokia (N series) and install them in the phone using vb.net..i have gone through the smart Device option available in .net and it seems to be valid only for pocket PC's.
View 1 RepliesI am working in Windows applications. I want to create a Chart for showing results as user friendly. How to create chart in VB.NET or C#.NET for Windows Applications.
View 3 RepliesI have some experience creating programs that use tcp to transport information from a server computer to a client computer and vise versa. However, I am unable to create udp server/client programs with visual basic.net . My goal is to be able to set up a connection with several computers that can communicate with eachother.Kevin Schaefer "The world is round and the place which may seem like the end may also be the beginning"
View 1 Replieswhich method is more efficient to use: DataAdapter and DataSet Or DataReader when importing data from a certain database table???
View 6 RepliesI am very familiar with VBA and have been using access and excel to create applications that connect using ADO and/or linked tables.I'm looking to start developing simple Windows applications for my company using Visual Basic, that will connect to Oracle and SQL Server Databases using ADO. What do I need to accomplish this? If I purchase Visual Studio 2008 Pro, will it come with VB? And do I need anything in addition to this in order to connect to SQL or Oracle databases using ADO method?
View 7 RepliesI am using VB 2008 Express Edition and I need to create applications using the Smart Device template and the ASP.NET Web Site template.
View 1 RepliesUsing: Visual Studio 2005.We are developing three different applications. We currently have 4 different modules that we all share among our applications. When a change is made to one of the modules, we must make changes to the other two modules.If it is possible, how do you (where do you) create a single location for one file to be shared among three different applications? Hopefully this will avoid the unnecessay task of changing a file three times.
View 3 RepliesIm trying create a small payroll system using VB.Net windows form applications. The problem im currently facing is when im updating the datagridview. But my update doesnt work. IM using dataset and databinding source. I want to udpate the datagrid view and automatically update the database. [code]
View 1 RepliesI am working on a project that is used for key broadcasting. Don't worry nothing illegal, I'm making a multibox application for world of warcraft. However I am having trouble when it comes to launching and manipulating other applications from another.
[Code]...
how to connect different vb applications to a database server.like accessing data from one database by different applications...
View 4 RepliesIs there a way to, when a parent application is opened up, that at the click of a button, or anything of designated event, that this parent application can open a secondary one?
View 11 RepliesI'm trying to work with an ODBC driver for Interbase in VS2008 (vb). I succesfully inserted the data tables I want to use in the project datasource. Then I want to add some rows in one of the tables of the datasource. I used myDataSet.addTABLENAMErow(field1, field2, ...).The compiler gives me no error, but when I open the database with InterbaseConsole, the line I've add is not there. Do I do something wrong? Must I open/save the database (how do I do so). I've tried meDataSet.AcceptChanges whitout result.I'm not used to work with Datasets and tables...
View 1 RepliesAnyway to view the content of a dataset or datatable in debug? I don't mean looking up a specific element of the dataset but to view the hole thing.
View 4 Repliesdifference between the two statements given below
1. Dim ds as new DataSet
2.Dim ds as DataSet = New DataSet
I'm trying to combine two datasets, each with 1 datatable and each having the same schemas. Datatable 1 would have a list of records. Datatable two may, or may no, have some or all of the records from table 1 plus more records. I would like to remove all the records from table 2 that are present in table 1.
This is what I got so far:
For Each table1 As DataTable In ds.Tables
For Each row1 As DataRow In ds.Tables(0).Rows
ds.Tables(0).PrimaryKey = New DataColumn() {ds.Tables(0).Columns(0)} 'Where 0 is the index of the column that's your key
row2 = ds2.Tables(0).Rows.Find(row1("ID"))
'if its found, delete it
Next
Next
how to join two datasets together.
First Dataset
Dim sql As String
sql = "SELECT payment.Debtor, SUM(Value_invoice) AS before_this_month,debtor.nama FROM Payment INNER JOIN dbo.debtor ON Payment.Debtor = debtor.debtor" & _
[code]....
Now i just want to either inner join or left join PaymentBeforeThisMonth and PaymentThisMonth into another dataset?
I have a dataset that contains only employee ID's. I need to loop through that dataset and for each employee ID I need to loop through several other datasets and pull data. I need help with this looping syntax. Here is a sample of some code that I am receiving an error with:
Dim EMPID as Integer
Dim CommandEmpid As New OleDb.OleDbCommand
Dim EmpidDS As New DataSet
[code]....
I have a form that needs to load data for 20 different combo boxes - the data is always the same. To get the combo boxes to function properly i need to create a separate dataset for each combo box. Doing this when the form loads takes it about 7 seconds each time a search result is double clicked and the form pops up displaying the correct data. The form is bound to the main table. Is there a way to store these data sets in memory somewhere so the user can close the form but still have them loaded? I can put this code behind the login form and it works until the form is closed, then the combo's no longer load.[code]
View 8 Repliesi want to check if datasets have changes and after that use msgbox (vbYesNoCancel) when program closes ,when i wrote this code it had error "Operator 'Or' is not defined for types 'System.Data.dataset' and Boolean"..[code]
View 2 RepliesI want to use my main dataset (dbds) on a second form. It's simple, on my main form, the user clicks a button, opens a new form, they enter an item number and I want to find that row, and change a value in another column of that same row, and have that be in effect onthe main dataset to send back to the database.[code]...
View 1 RepliesI have declared a dataset (let's call it 'Fred') as public in a VARs module. In the main form in a sub routine called at the start of the project I connect to an Excel spreadsheet and read it into the 'Fred' dataset into one table (called 'Table') I then bind the dataset table to a datagridview and I can see the spreadsheet. Which is very nice :-)
Having loaded the dataset I want to be able to get some values so I created a button and used the following
msg = Fred.Tables("Table").Rows(0).Item("Name")
I think this should get the value in the first row and in the column called 'Name' in the table called 'Table'
But I get an error when I click the button 'Object reference not set to an instance of an object' which I think means I need to use the 'New' keyword...
So I added to the button
Dim Fred = New DataSet
But I get the same error.
Now I have to admit that I've never really got my head around how to use the 'New' keyword and would have hoped to be able to get data from a dataset through my entire project - especially as I've declared it as 'Public'. Surely if I use 'New' all over the place then I create new datasets
I need to very quickly write an exe system on a laptop where when the laptops are connected to the network they read a database table and store the data locally, so staff can use the laptop while they roam.The laptops have quite small capacity and the company would prefer not to use SQL Express or Access.
My question is, can the data initially be downloaded into the exe application via a dataadapter and dataset, and will that dataset the retain the downloaded data, or will I need to ensure the dataset is written to an XML file and then loaded/unloaded each time the laptop application is started while the staff are travelling ?
What I'm looking for are videos in vb.net for console application that will show me how to use DataSets and TableAdapters step by step. Please provide links
View 4 RepliesI'm using the MYSQL .NET connector with an adapter to fill a dataset from a SELECT statement. Between different SELECT statements I use the DataSet.Clear() function. The Getxml shows me that the dataset is empty, however when cycling through the Table's columns, I have all the columns from all the tables used in prior SELECT statements.
How do I go about that without Dimming new Datasets for each table?
I'm not sure, if this is possible, but what I would like to do is fill a DataTable with results from "SELECT TABLE_NAME FROM myDB.INFORMATION_SCHEMA.TABLES" and then fill individual data sets in a For Each loop. I'm able to fill a data table with the table names I want to populate, and I can update my SQL Command of the SqlDataAdapter, but when I try to fill the data set by using the results from the row, I run into an error that I can not convert a string to a DataTable or DataSet. Each DataSet is named just like the table name. The code is at home, so I can't paste all of it here, but hopefully, you understand, what I mean. A small amount of the code that I remember is below, and this is inside a Using block connecting to a SQL Server.For Each row as DataRow in dt.rows
tsql = new SqlCommand("SELECT * FROM myDB.." + row("TABLE_NAME"), mycon)
oleda.SelectCommand = tsql
oleda.Fill(row("TABLE_NAME"))