I am currently working on a program (VB.net) that use a database (SQL server 2005)that is on a server. I am using a dataset to store queries and update the database.If i was going to copy the database and move the copies location, what would i need to do to make sure that my dataset points to the copy and it's new location.
View 2 Replies
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 RepliesThis must be a common problem, so perhaps someone can point me to a Knowledgebase article. I've got a form that works fine in a completed project. It's a windows form that uses a dataset and tableadapter (which show in the tray below). Now I'm developing a different project that requires a very similar form. I want to "copy" that form into my new project, make some minor changes, and then save it under a new name.
[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 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'm happy to register in this forum , and here is my first question..I have developed an application in Visual Basic.Net 2010 and i used MS SQL Database My question is how do i move the database to another computer in order for my program to run???
View 6 RepliesI am a high school student and i am teaching myself VB, C# and C++... it is a slow process containing mainly trial and error, looking up things online, and when the time is right asking assistance from people who know more then I.
I am currently creating a VB program that creates a database of questions, and the same or separate database. using them questions it can initiate a quiz that will save results in a different database for each student. I am having difficulties getting the code right for reading the databases, and getting it to move to the next portion of the database for each question... a little more info:
Question # = Primary key (there will not be more then 1 of the same # problem)
Question Type = i am using different integers right now to specify if the question is a T/F, Multiple Choice, Open info Et Cetra.... Question Answer = Correct answer Alt answer (x3) = option to add other answers for multiple choice problems...
I don't know exactly how to get it to read a problem and when clicking a next button on a form to have it go to the next question in the database..
I have a live database and an Archive database. I want to do a selct on the live and basically create a new row in the archive database table and insert all the columns then delete the row from the live. Here is the code that creates and deletes:-
Private Sub MoveToArchive(ByRef oleDRClean As DataRow, ByRef oleDSArchiveCleans As DataSet)
Dim oleDRArchiveClean As DataRow
oleDRArchiveClean = oleDSArchiveCleans.Tables(0).NewRow
[code]....
I ran a query in access to show the same sql select and after running my routine they all say #deleted. But when I run the query again I get the rows back WHY!
I'm creating this VB 2008 application and I want to make it into a CD so it can be installed in other computers. Problem is, after I create the setup and start it even from the computer that created the application in the first place, it gives me the "unhandled exception has occurred in your application. If you click Continue, the application will wignore this error and attempt to continue. If you click Quit, the application will close immediately." and "The following file could not be found: "C:UsersMyNameAppDataLocalApps2.0Data\VHMGGXM7.8K8..." errors.
Since my first "form" is a login system, I am not sure if this problem appears because of the database search, or just the transition between forms (unlikely, I guess, since there is sort of an introductory video before the login system which uses the same logic to transition between forms)... So I tried moving the access database to a different path and I wanted to know how to tell the program (through v.b.) that the database is now in "this path" without having to re-connect and create a new DataSet, which will make me have to start the whole project again. I set up the whole project in Program Files (a place all computers must have). The video before the login system works fine, but I can't really find any other problem.
I have done a database system using microsoft access 2007 which connected to a form of vb2008.And now i want to transfer the system to another computer but as i tried it's not work.I already build the file and copy whole folder that contain the bin, obj and my project to the new computer. I tried to run it on the new computer but it show me an error that "selected collating sequence not supported by the operating system".What should i do to overcome this?
View 1 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 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 RepliesI have a form with a data connection to my access database that shows my music collection, Artist,title,year,chart position, media location & filename.It is set to show only artist & title I have a list box that i can manually load files into to create a wmp playlist i would like to be able to do one or both of the following:
1. drag and drop data from my dataset to the list box to provide a playlist
2. create a playlist from this database that will auto play
I have this:
Private m_PerformanceCounter As New _
System.Diagnostics.PerformanceCounter( _
"Processor", "% Processor Time", "_Total")
[code]......
the code is below. the system said me that the insert into sql syntax error
Dim dbProvider As String
Dim dbSource As String
Dim constr As New OleDb.OleDbConnection
[Code]....
I am using VB 2008 frountend & Access Databases for my backend.When i make changes to Database such as Change In Field Name, Change In Data Type, Change In field size Addition of new Fields, Deletion of old fields, ReOrdering fields names I use to reconfigure DataAdapter in dataset to take those changes in effect, however some changes took place where some other doesn't.get those changes in effect in right order.
View 1 RepliesIf i make changes to tables in a dataset, then want to save those changes to the actual database, how do i do this? I know that the dataset is just an "in house" virtual copy of the real database. I believe i need to use a commandbuilder but is there an easy way to do it, other then using an sql statement? If i spent the time making the changes to the dataset, why redo the work on the actual table? here's what i have, after the datasets have been changed:
[Code]...
I just want to ask. Using getChanges method in vb.net only get the changes on the dataset not on the table in database?for example I fill a dataset from a table in database.So there is a table in my dataset. There has been a changed in my table in database for example an added row.So there is no way in my dataset to determine this change because it has filled the original data.How can I determine the changes in my database table?
View 1 RepliesMy Visual Basic 2008 can insert a new row to a dataset, but the dataset does not insert new rows into the actual Access 2007 database. The database remains unchanged and there are no error messages. How can the dataset write the new row to the database? [code]
View 1 RepliesSo I'm not familiar with much vb code but I was hoping someone my spell out something pretty generic as far as updating a database. I'm pretty sure I've successfully edited rows but when i'm using my database update i get an error, probably just incorrect syntax. This is what I have so far...
[Code]...
It seems that there is no way to preserve changes to a DataSet made with the Designer when there is a change to the database. The only way to get the Designer to rescan the database to incorporate a change is to delete the DataSet and then recreate it. This of course blows away all the mods you've made in the designer. There should be a way to have the Designer rescan the database while preserve all the mods that have been made in the Designer. Otherwise the Designer is essentially useless after the initial generation of code. What am I missing?
As a workaround, I tried incorporating the changes to the database by making the same change in the Designer rather than recreating. However, clearly no one tested this is it only partially regenerates the code based on the change. Try changing a field from nulls not allowed to allowed. This works when you add data to the DataTable, but bombs as soon as you update the database, because the DataSet code does and the database code doesn't get regenerated.
I have an excel worksheet that has 20 columns of data, and thousands of rows. My goal is to take every row, and every column and insert it into a dataset.Which I have successfully done here:
'exporting the data from the excel workbook into a dataset
Public Sub Export_From_Excel()
Dim objApp As Excel.Application
[code]......
I'm using the Visual Basic Express edition 2008 and I'm not able to save the changes to the dataset as well as dataset. While the application is running. I can see the changes are made in the table but the moment I close the application and check the data in the Dataset in the right window or the data in the database in the left window, I see no changesI have also tried the Update property of Table Adapter but no use. I have done Endinit, AcceptChanges everything but moment I clode the application no changes are reflected in dataset or databse.
View 1 RepliesI use this code and update the database with changes in my DataSet but the changes are not showing up in the database.
' Update the connection object.
'------------------------------
myConnection.ConnectionString = FormMain.strDatabaseConnection
[code]....
I have an Access Database in which I am trying to add a row through a dataset. I am able to add the record to the dataset but I can't write it to the live database.
Dim connectionString As String = _
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:extraTEST.accdb;Persist Security Info=False;"
[Code].....
im using XML as my database and uses dataset to hold the xml. which one do you think is better to backup my xml?
1. write the xml to 2 location, default location and the backup location
dataset.writexml(path1)
dataset.writexml(path2)
2. write the xml to default location and copy it to the backup location
dataset.writexml(path1)
copyfile(path1,path)
if you have a better way of doing it please dont hesitate to share it..
I am in a bit of a sticky situation. I am currently writing a program where users are going to have to search for a specific skill in order for a calculation to take place.I have to hard-code around 500 skills but they also have to be able to search for the skill via a text box.I am stuck on whether or not to use an XML file to hold all this data or use a DataSet.I have no experience with either, but the XML file seems more appealing because I wouldn't then have to re-release the program for an update on skills, only the XML file would need to be replaced.
View 3 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 have a form in vb8 that is set up as follows:
I have a table in my Access database calledUsers that has a name and a password (encrypted).
Using the toolbar I created aBindingSource with a name of UsersBindingSource and a dataSource ofUsers
Using the toolbar I created aDataset called with a Name and a DatasetName called Users_Dataset
Using the toolbar I created atableAdapter called UsersTableAdapter
I added two textboxes on the form and changed theirDatabindings...Text property to the corresponding field in the Database.
How to now update the database when I click Update. What the program needs to do first is encrypt the Password before saving it. I wrote the code in the TextBox2.Lostfocus event to encrypt the data a place it back into the TestBox2 field. The only samples I find on the net refer to DataGridView controls (which work) but I don't want to use them. How can I get the database to accept these changes as well as changes to radio buttons or comboboxes?
On a form i have several text boxes binded to a bindingsource and including a datagridviewI have populated the textboxes with database fields successfully and the datagridview displays the correct information.I have the following code to save the information to the database but i cannot get it to work. [code] I have tried many code examples here in order to save the data, none of which has worked.Can anyone please help me with this?
View 1 Replies
