i have a form which accepts inputs from the user. I want to create a crystal report ( not from the database but from the form ) and to create a crystal report, i need to create a dataset. i dont know how to create dataset from the form's input
View 15 RepliesI created a SQL database using the migration tool.I am converting my access forms to VB.net (VS2008).I am wondering if I create a single dataset in studio to the database or do I create a dataset for each form (query)? I am trying to determine what the best solution is. Many of my forms have drop downs that are populated using queries from tables.
View 3 RepliesI have produced an application which works with datasets but I now wish to provide the user the ability to add and admend records within the database.But i wish to do this in a seperate form.My current dataset instanciates classes onLoad.Should i try passing the Dataset to the new form class? although I have the problem where by when i pass the dataset to the form class using code below i get this problem:[code]Should i just create a create a new connection to the database and produce a new dataset for this form? or is there a better way to do this?
View 2 RepliesThis is my vb6 programme for creating recordset in a module. and call it in class
and form
[Code]...
i have a few questions about seting up a form.when you creat a new for open the dataset drag and drop the tables to form it creates a top menu bar with pages plus sign and x and save.now when you run the app you need to press the plus sign to add data in the database..is there a way to make it that you dont need to press the plus sign?
View 3 Repliesdoes VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 RepliesI 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 ?
is there a suitable way to create a login form that can search database for the username and password to check if user is general or adminstrator?so basically there's like 2 levels of access.how do i make it such a way that a different form show for both after user is authenticated?i created 2 forms for that purpose. not sure what kind of code to make it work.below are some differences btw admin and generic user...
Functionalities Admin:
-Add New Chemical to List: Details, Purchase Details, Attach link to SDS.
-Search by Chemical Name, Alt Names or Location. Refine Search by Classification
-Edit existing Chemical records.
-Create/Delete Accounts.
General User:
-Search by Chemical Name, Alt Names or Location. Refine Search by Classification.
-Update purchased & consumption records for all chemicals
Alright, I've been taking this class in school for Software development, and right now I am working on a assignment my professor is having us do, and honestly, I am kind of stumped here. Basically he wants us to create a form in Visual Studio 2005. It has a group box with two Radio buttons, (One for boys, One for Girls) and a List box that lists the corresponding names of the Gender you selected with a radio button.Alternatively, you can click the Report button and get the list that way.
Heres a screenshot of how he wants it: He wants us to use parallel arrays to make the list, each name has a corresponding M or F. So far I have the objects all set up, and the I have declared the parallel array like this in the Declaration of the form:
[Code]...
i have a login form in a banking project.i set a userid and password for this login form and i did the code accordingly,it works good.In my form there are two fields namely:Userid and Password and a button named Login.
But i cant get any idea about what to do when the user wants to create their own userid and password?
I think i need to add a few more buttons to enable the user to create their own userid and password but i cant get the idea......i need some help.
Again,if i allow the user to create their own userid and password then anyone can use my project by creating a new account.........
Hence i am totally confused how to go with this.I need some urgent discussion so that i can get through this problem.
I need to pick all data in my application from my database and use it in my form
my question : how to pick all data in my application then i use it
I am currently working with VB.net 2005. I am trying to create a login form and use a text file as a database to login. The part login form is fine but i can't connected to the text file. When i use my coding with a database such as access or mysql is work fine.
[Code]...
I have loaded XML doc into a dataset (see below). That went ok. So now I can put the DS in a grid and change it.However, after changing the DS I want to export it back to a XML doc. That only succeeds partially.I am getting a XML doc, but it's not like the original (see below). And I want it to be exactly like the original.Maybe you brilliant guys can help me out The original XML code (I tried both with and without the Schema):
[Code]...
I want to check what are in the dataset, how?
?daLS.GetDataset.Tables.Item(0).Rows
16
I have the following function: Public Shared Function GetLookupTableData(ByVal TableName As String, ByVal WhereClause As String) As DataTable
[Code]...
With one xml file it loads the schema and data just fine, but with another xml file it only loads the schema and not the data. There's no error thrown - just no data loaded.
Anybody have any ideas? I've attached the .xml file for your review. I would have attached the .xsd but the system wouldn't allow it.
I've got a requirement to create report datasets by taking a list of tables, columns from those tables, filters on the tables, and relations between the tables - and build a dataset from them. All this information is contained in an xml file. So I:Read the data from the tables in the list into the dataset. Apply any filter criteria on the tables to the default views. Add any relations between the tables to the dataset relations. So far, so good, but now comes the hard part. One of the requirements is to create a default view (or table) of columns at the dataset level - with the appropriate constraints and filters applied. So there would be this default table or view that would have, for example, columns 1 & 2 from table1, columns 4 & 7 from table2, and column 5 from table3. This is where I'm stuck, because there doesn't seem to be a 'view' property or function at the dataset level.
[Code]...
I have a DataGridView on a form that is being populated from a SQL table dataset by giving criteria from a previous form. I have 6 columns in the dataset, of which the last column should be combo box column containing items "Done" and "Pending". How do I make this bound column to a combo box column and display the value as well as the alternate item too in the combo box?
View 6 RepliesI have two forms....Mainform is filled with controls that are databound to a datasource.....then I have a child form that is used to edit data from parent form.......the data that is displayed on the child form uses the Filter() method of the binding source to display data only for the customer selected......
The child form has the standard OK and CANCEL buttons set up as dialog result.......after I edit the content in child form, the changes are displayed on the child form correctly......but when closing the child form and going back to the parent form the changes dont appear there unless I restart the application.....I also tried adding the tableadapter.update/fill method in the 'OK' dialog result event handler and it still doesnt work......
How can I make the changes take effect on the parent form without restarting the application?
In VB2005, I had create a DataSet, like EmployeeDataSet.xsd, how to put it into a form?
View 1 RepliesI want to create a dataset that I can access from any form. I already created the tables and columns using the dataset designer. I read that I can declare the dataset as public in a module, but when I try to access a table I have to put the name of the module in front otherwise I get a "Reference to a non-shared member requires an object reference" error. When I declare a variable as public in a module I never have to specify the name of the module to access the variable, so why do I need to do it for a dataset? The code in my module is:
[Code]....
I have the following code which output data in an XML format and updates a row in the dataset to say its been exported.[code]...
View 5 RepliesI've been struggling with this for a while, so I finally decided to ask the question rather than try to figure it out myself.Generally, what I want is a more robust Dataset. I have to do a large quantity of hiarchical calculations, doing a wide variety of calculations.I used datasets for similar situations in the past, but there are some restrictions with datasets that I need to have, such as:Datasets are restrictive in their calculation methods, such as having no method for doing powers calculationsDatacolumns are restrictive in the types they can be, at least in the designer. I need members of this class to be of custom types.
I like the way expressions in datacolumns will calculate only when the dependent columns change. If I build a custom class that recalculates every time the value is accessed, it takes an unacceptable amount of time to recalculate all of the fields. I'd likethe class to only recalculate the value of the field when it needs to.
I am attemting to read a .txt file database into an xml file and then read the xml file into a DataSet and then bind the dataset to bindingSources and then subsequently bind comboboxes and text boxes to the binding source. I am struggling with how to create bindingsources with different filters. I am not sure if I am even going about this the right way. Perhaps there is a better way. I already have the program working using traditional OLEDB and creating different datatables but I wanted to be able to add and edit my datafile so I decided to convert it to a xml file.
HTML
If Me.OpenFileDialog2.ShowDialog() = Windows.Forms.DialogResult.OK Then
With OpenFileDialog2
folderName = .FileName.Substring(0, .FileName.LastIndexOf(""))
'fill dataset with selected xml table
[Code] .....
I am using xml reader to read an xml file into a dataset and and then create some dataviews and bindingsources for binding combo and text boxes as such:
Dim folderName As String
Dim xmlFile As XmlReader
Dim ds As New DataSet()
[code]....
I don't know how to do the same thing I am trying something like:
Me.yearavgdomtxt.Text = CStr(ds.Tables("Property").Compute("AVG(DaysOnMarket)", Nothing))
No error but no result
Export data from Dataset with multiple table to excel sheet
View 2 RepliesI'm having a little trouble figuring how to do this.I have a dataset with a single table. Each row has the following fields ProductName, Version, CompanyName
The data might look like this
Visual Studio, 2005, Microsoft
Visual Studio, 2008, Microsoft
Office, 2007, Microsoft
I have already populated the TreeView with a list of Company names from a separate table. Now, what I want to do is to loop through my dataset adding a single node for each product under the appropriate manufacturer. Then under each product adding a separate node for each version of that product.
[Code]...
i have installed visual studio 2005 in my computer i want to create a sql server 2005 file i saw a sql server 2005 option in my installed components i want to know how to create a sql server 2005 from my visual studio 2005 it is possible or not.
View 1 RepliesI create one column which is tinyint then I go to VS2008 and create typed dataset by wizard. Then I check that column's datatype it is now byte datatype. MS SQL 2005 tinyint = VS2008 byte ?
View 2 RepliesI'm a bigginer in Visual Studio. I have created the forms using Visual Studio Professional 2005 and a database using Microsoft SQL Server 2005. I have some combo boxes in the forms and want to populate them using the dataset which I have attached to the VB.net project. I used the following method.. but when I run the project, the combo box is still empty..
[Code]...
I was wondering if the following is possible. In a particular operation I want to create a dataset, bulk copy it to another SQL Server, then update a flag column in the copied rows.I'll have a system that will be regularly inserting new rows of data, then at regular intervals want to copy that data to another SQL Server. Once the rows have copied I need to change a flag column so that they won't get copied again.Whilst this is going on there is a strong possibility new rows of data will be being inserted into the source table. These new rows will be copied at another interval.
View 3 Replies