I have a problem saving a dataset which contains rows that i have imported from another dataset. i can successfully view the imported rows in a gridview but i cannot commit the rows back to the database.
View 2 RepliesI am new to VB.NET I have inserted multiple rows into dataset (ds). Now I want to save the dataset and the new rows into the database.
View 8 RepliesI am looping through my dataset to save my database, I thought this might not be the best way. Is there a more resource efficient of doing it?
For i As Integer = 0 To CO.Tables("CO_Del").Rows.Count - 1 'CO is my DataSet
dbCommand.Parameters.Clear()
AddInParameter(dbCommand, "@IsDelete", DbType.Boolean, 0, DBNull.Value)[code].......
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]......
When I load data from xml to my dataset I want to apply this changes to database. This is my code, so far unsuccessful. [code]
View 6 RepliesMy problem is fairly simple. What my code is doing to start with is opening the form by loading a bunch of things from a database. After all the questions are done (because it is a questionnaire) it is meant to save the current score and the username that was entered before, for the sake of programming I have hard-coded a username and score however I think because I am using a different command builder it keeps giving me the same error!
(I am studying A-Level so that might explain the simplicity of the code)
Public Class AdditionTest
Dim inc As Integer = 0
Dim con As New OleDb.OleDbConnection
[Code]....
I have a dataset (WW1Dataset) with one data table(WW1).(database used in an access database) I'm trying to filter the dataset e.g a user wants to filter by a chosen surname (SurnameTextBox.text) so the datset is filtered to display only those records wherethe surname column in the dataset matches SurnameTextBox.text.
View 1 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 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 a parent/child relation I am trying to create fow 2 datasets.The parent ds consusts of a range of PO Header information
After I fill this dataset I loop through it getting the PO number. I then take that value and execute another sql statement on the DETAIL file and fill a dataset(dtlDS) for EACH row in the parent. How do I add to this dtlDS for each row? I am getting no CHILD data in the merge. Should I be filling to a datatable and do an add.row and THEN dump into the dtlDS?
I have a model that returns a dataset to a view and builds a list. The crazy thing is that I have tested this code with IE, Safari on Mac and Windows, Chrome and Opera and all return data. However, on the iPad or iPhone, zero rows are returned from the dataset object. It seems that the model is in fact passing the dataset to the view. I am using jquerymobile to render the view for the iOS devices and have taken that out of the mix to test and it still doesn't work.
[Code]...
how can I test if a dataset has rows? I'm trying to see if my sql procedure call managed to fill up my dataset.Also, is there an easy way to print the rows to a label?
View 3 RepliesI have a very simple DataSet linked to a ListBox. I need the User to be able to add Data and have used the following code (in a ToolStrip command button):
Dim newFileRow As DataRow = Database1DataSet.Tables("tbl_Files").NewRow()
newFileRow("File Name") = fleName
newFileRow("File Path") = flePath
[Code]....
This seems to work ok - the new Data immediately appears in the ListBox. However, as soon as I close the form all of the Data in the DataSet is lost.
I am currently having a few issues saving new information to a dataset. I could update the set, but on exiting and reopening the data all updates were gone. I found a few tips online but now get error messages when running the update command. This is how the code looks at present.
[Code]...
VS 2010 Saving Dataset
View 17 RepliesI have a piece of code that works for adding multiple rows to a dataset but I think that it is a lot of code and thought maybe someone may know a better way of doing it. I need to add rows to the dataset based on the selection of a combo box. ie if the user selects 15 the the program adds 15 rows to the dataset.
Case cboQty.SelectedItem = 3
Try
Dim dr As DataRow
[code].....
I have been looking for some syntax online to help me do this, but i cannot seem to find anything. I am trying to move some rows from a table in an access database to another on a click event handler.
One of the tables names is "Basket", and the other is order.So far i have this.
[Code]...
I am new to vb.net and I am trying to query a database and print out the records in the row to the console window. I got it to work, but I have a feeling that there is a more concise way to do this. One thing that I am sure is wrong is that I had to convert the dataset to a datatable to be able to retrieve the values. Is that correct? Could you take a look at the code below (especially the for loop) and let me know what I can improve upon?
[Code]...
I pass it a valid dataset that has the department name and the Department id as a number..20, 40, 30..... I want to get the department number.. I pass it HR(which is in the ds.table) but I am getting an error on the rows.find() "Input string was not in a correct format" it is a string.. what else could i be doing wrong here...
Public Function GetDeptID(ByRef ds As DataSet, ByVal strDepartment As String) As Integer
'Dim dr As DataRow
' Check to see if date is already in the table
[code].....
My Application uses For...Next loops to read a spreadsheet into a DataSet and then display information from it based on the results of search conditions (search term and a date range).I'm having a problem with the data where, if I run a search that should return the first 400 rows in the spreadsheet, I'm only getting around 200 results. I know the search should return the 400 rows because I checked it in the spreadsheet before running the search.I think my problem might be caused by my date comparisons. I think the problem might be that I'm comparing String valueHere's my code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If ListBox1.Items.Count <> 0 Then : ListBox1.Items.Clear() : End If
[code].....
I have a form with the datagridweiw object. I have connected it to the datasource and it displays the data fine. I also have set the persissions for editing. I am assuming i need a button for accepting changes to table and a button to cancel. My use for the form is to add or delete rows of data and save the changes. The database and application are both in visual basic and sql server express both 2008.
View 6 RepliesI have used VB6 for all kinds of database programming. Now I am fairly new to the vb.net. How do we read the records (rows) from a dataset and manipulate data? I want to populate a combobox or a datagrid with a recordset (in VB6 language). What is the .net equivalent of ado dataset, and how do I use it. I have tried several ways using dataadapters and dataset, etc.
View 4 RepliesI am trying to retrieve row data from a table in a dataset (dataset name is PatientsDataSet and table name is tblfacilitiesnames).
I am using VB 2008 but the code I entered is from a VB2005 sample so something must have changed in the format.
I am already connected to the database since it opens the connection when the program is run.
Here is the code:
Dim Counter As Integer
Dim Str1 As String
Dim FacRow As PatientsDataSet.tblFacilitiesNamesRow
[Code]....
I have a strongly typed dataset that has rows with duplicate [sopnumbe] I am looping through them and displaying row data I want to only display the Distinct sopnumbe rows in my initial loop1.. but the sub loop uses the data out of all rows.. So I cant filter the actual dataset.
[Code]....
I have a dataset which is bind to a datagridview. When changes are made and that dataset is modified, i want to edit the dataset and update two datarow with WHO did the change and WHEN did the change occur.
View 1 RepliesI have a question similar to this one, but reading the (accepted) answer didn't give me much insight, so I'm hoping to state it more clearly and get a clearer response back.
I'm attempting to insert a data row into a table. I'm using TableAdapter's custom "insert nonQuery" that I wrote (it works, I tested) to accept some parameters. I'm fairly new to this business of communication with a database via .NET and what I'm doing is probably wrong by design. My questions are why is it wrong and what's the right way to do it? Both are equally important, IMO.[code]...
I have a dataset with 12 columns. this dataset can be filled with > 3000 rows
This dataset is bounded in gridview (third-party).
How I can remove the duplicated rows in this dataset?
I am filling my dataset like this.
Public Function FetchData() As DataSet
Dim oConn As System.Data.OleDb.OleDbConnection
Dim oComm As System.Data.OleDb.OleDbCommand
[Code].....
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.
I have added a dataset from New Item >> DataSet and configured it. I want to add new row to it using
Dim drNewRow as datarow=DataSet1.tblTest.New
but when I press . after DataSet1, IntelliSense does not catch tblTest, rather it gives tblTestRow and tblTestDataTable
How to get DataSet1.tblTest here?