I 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 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'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 am looking for some guidance with the most optimal or efficient way to export a dataset to an excel file. I have searched the forums and found a number of methods to do this. However, the code I am currently using is very inefficient as it is itterating through the rows and columns to create the excel file. The app I am working on needs to be able to create 50 or so excel files each with 500+ rows and 40-50 columns. This method seems to inefficient for my use.
I have seen some code out there to use an ODBC call to excel to create the file. I am wondering if someone can verify that this is the most efficient way to meet my goal. It should also be noted that after the export I will want to do some basic formatting of the sheet. Adding bold column headers, autofilters, and autofit all columns.
I have a Page class and a PageCollection class in a 3d party ORM framework. I can fill the PageCollection based on parameters (pageid, parentid, url etc..) (SQL query). But I need the data multiple times around the ASP.NET MVC website (Sitemap, Authentication), so I chose to load all pages 1 time and reference that (global) collection.
GlobalClass.Pages //is PageCollection containing all pages
I have now created functions which return a temporary subcollection or single entity based on the parameters mentioned before (pageid, parentid, url etc..).
GlobalClass.Pages.GetByPageId(id) //returns single page entity
GlobalClass.Pages.GetByParentId(parentid) //returns subcollection
The site however got very slow.
cache the subcollections (GetByParent())? create internal hash-lookup tables for the collection? Something else...?
Namespace BLL
Public Class PageCollection
Inherits CustomCollectionBase
[Code]....
I was wondering what was the best way to search a database. Is it possible to perform bubble sort etc or any sort of binary search to the database instead of doing a linear search. If so how would I go about doing this through an Sql statement.
View 6 RepliesWhats the best way to handle the connection to a db when it's accessed often? I have an app where the user selects an item from a drop down list(call to the db) and then a picture of the item is returned along with it's relevant information(another call to the db). Small application but basically every action results in a call to the database. Should i just be filling like a global dataset and then accessing the information from there(if thats possible)? The database is stored locally(currently an Access Db but will be SQL in the future)
View 3 RepliesI 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 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 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?
does VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 RepliesOk i have an issue that i have reported before but never had a satisfactory result to so time to try again. and im just about ready to throw this whole visual studio nonsense in the trash, ive wasted god knows how many hours on this now. I have a medium sized VB.net (2008) project, which has around 50 Datatable adapters that i have setup in the dataset designer, and are all workign perfectly well.
[Code]...
I wrote small program which is able to open database using OpenFileDialog, then I added binding navigator (so I can navigate and make changes in my data set) and now I would like to SAVE data which I see in datagridview AS NEW FILE... I have a question: How to save data (and changes) from datagridview using SaveFileDialog?[code]
View 5 RepliesI have a dataset that fills a tableadapter and I'd like to be able to post changes made to the dataset to a database with a date marking the changes. I've never used the TableAdapter.Update method before and was wondering if someone has any good tutorial links for that method. Here is the
[Code]...
I have a dataset that fills a tableadapter and I'd like to be able to post changes made to the dataset to a database with a date marking the changes. I've never used the TableAdapter.Update method before and was wondering if someone has any good tutorial links for that method.
[Code]...
I had an Excel spreadsheet which I put in MS Access (database). I then took that database and used that as a source in VB to create a GUI for. In VB I have an input text box to search and pull of different fields. I created some queries for searches in from the text box. I have have a dataset view of the data which has the binding navigator (add, insert, save).
The problem I have is that when I hit the '+' for add to add information and then click the 'save' button in the binding Navigator, the information I put in does not save. I check this by exit out of the program run (debug to open the app) and then open it back up to search and/or check for the new information I put in. My overall goal is to create to publish the final code and use an a standalone program.
Also, as another option,(I would like to learn) Is there a way to map VB directly to an Excel file to have the user input information and save to the excel file.
I 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 had a dataSet which link to a database. I need to add one field inside the database, After adding the field, how can I update and link it to the dataSet?
View 4 RepliesIt seems that when using With blocks in VB.NET, the resulting MSIL larger than w/o. So this leads me to ask, are With Blocks really more efficient? MSIL is what gets JITed into native machine code, so smaller code size should imply more efficient code, right?
[Code]...
I have managed to create a connection to the database and am able to save information to it from my form, the form contains 22 textboxes, a save and another exit button. I have set the form to retrieve data in the form_load. I have used the "UPDATE" SQL command on the save button and it does save the data on all 22 textboxes (all textboxes are linked to their separate columns). But only one record will be needed that is why I did not use the "INSERT" command.
The problem arises when I click the save button, all (19) textboxes are saved but when I retrieve the text (by reloading the form), each of the 20, 21, 22 textboxes (only) the text of the 20th textbox keeps on moving tho the next textbox e.g. 20>21>22>20>21>22 is interchanged amongst themselves.
[Code]...
can u see what is the error in this code because it not saving in the data base the error is Data type mismatch in criteria expression.
[code]...
I have a datagridview that's bound to an access database, and it loads fine, and runs without errors, but it doesn't save. Here's my code:
Imports System.Data.OleDb
Public Class Form1
Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing
Dim myDA As OleDbDataAdapter
[code].....
Where to add this validation, or if there is a more efficient way of doing it and where to put it?
CODE:
How to use MVC Pattern efficient?
View 8 RepliesIs there a more efficient way of doing this code?
For Each row As DataRow In dt.Rows
Dim ts1 As String = row(0).ToString
For index As Integer = 1 To 9[code]....