when i try to insert data from database into dataset using data adapter, it takes long time, i want to use hourglass but i'm confused how or when i type the code so user will know that application still work.
View 1 RepliesHow do you restore a dataset to the previous state before updating the database with a data adapter? I have a concurrency update problem that I believe to be caused by this. The update fails during the update and a rollback command is issued using a SQLTransaction object. However, now the rowstates of the rows that did not have errors have been changed to unchanged. So this record is no longer availible to be inserted into the database. When I updated the value that could not be null and then test the second update which runs just as the first does then I get a concurrency error. The update code is below:
[Code]...
Only my local dataset updates when adding, deleting or editing records.The Source Database is supposed to update on issuing DataAdapter. Update(dataset )However, when I check my source database after running the operations it remains the same as the original.
View 6 RepliesI want to track changes in an application. So I've made a copy of the main table in that application, and am accessing both tables in the application using two separate datasets.
My plan was to use the HasChanges method of the main DataSet to get changed rows and then insert those into the copy table. When I run the code I get an error:
A first chance exception of type 'System.InvalidCastException' occurred in MyApp.exe
Unable to cast object of type 'MainDataTable' to type 'MainAuditDataTable'.
Here's the code:
If Me.DataSet3.HasChanges Then
' 'look for each row that has changes, not new rows
' 'insert that row into the auditing table
[Code].....
[code]when I run my program and press this button Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles exceptionsButton.Click..I have my date range within a time that I know that my dataset should produce a result, but when I put a line break in my code here: adapter.Fill(ds)and look at it in debug, I show a table value of 0. If I run the same query that I have to produce these results in sql analyser, I see 1 result. Can someone see why my query on my form produces a different result than the sql analyser does? [code]I can also verify that the variables are passing the correct values. Can anyone please assist as to why this isnt working?
View 1 RepliesI have the following
Imports System.Data.SqlClient
Public Class Main
Protected WithEvents DataGridView1 As DataGridView
[Code]......
I have the following code:
Code:
Imports System.Data.SqlClient
Public Class Main[code]....
and when I run my program, I have my date range within a time that I know that my dataset should produce a result, but when I put a line break in my code here:
Code:
adapter.Fill(ds)
and look at it in debug, I show a table value of 0. If I run the same query that I have to produce these results in sql analyser, I see 1 result. Can someone see why my query on my form produces a different result than the sql analyser does? Also here is my schema for my two tables:
Exceptions
employeenumbervarcharno 50 yesnonoSQL_Latin1_General_CP1_CI_AS
exceptiondatedatetime no8 yes(n/a)(n/a)NULL[code]......
i'm using vb 2008 and local database sql server compact 3.5 to build a application.the problem is that i can't insert a new data to the database from the app. i'm wrote the query right at dataset and using table adapter. but when i call the query, it succeed but the data don't exist at database.why when i add data, it's not working. actually when i run it, it says that adding process is success, no error, and it shows at the datagrid. but when i look at database. the data that i add is not there.and in tableadapter, i also make sortData, seachData query, i can use both of them perfectly when i run the app.so, i really confuse why is the insert query didn't work.
View 2 Repliesbelow is my code:
myCommand = New SqlCommand("SELECT VisitorID, VisitorName, Skill FROM tblVisitor LEFT JOIN tblSkill ON tblVisitor.SkillID = tblSkill.SkillID", myConnection)
myAdapter = New SqlDataAdapter(myCommand)[code]....
then it catch an error as Incorrect Syntax near". which it points to myAdapter.Fill(myDataSet, "tblVisitor") not the Select command.
I've made a dataset using the dataset designer, and I'm trying to add a column to reflect changes made to the database (added a column, nothing fancy). Is there a way to 'refresh' the dataset schema from the datasource without deleting my adapter (and all the methods and queries I've created)?
View 2 RepliesI got a system which i want to insert, delete, update the data into my database and the data from database will be display using datagrid. The below is the coding for one of my button, delete.
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Try
btnSearchEmpNo.Enabled = False[code].....
Now I wanna set when user click on this button to delete a employee (for example) then the datagrid that i have in my application will not show the data of the deleted employee but in the background, the employee haven't been deleted from database.The employee only will be deleted from database when the user click on SAVE button.I know this application have to use RowState but how?
What I want to happen is that the button from my system will remove the previous data from database and then insert new data to database from text file. Im done with inserting new data. The thing is that I dont how to control or where to put the Delete Command from my code.
[Code]...
i want to populate a listbox from a sql database and foll is the code i encountered error with:
Dim con As SqlConnection
Dim cmd As SqlCommand
Dim lrd As SqlDataReader
[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 RepliesI am writing a program with VB.NET, there I have to select data from one table. Then I have to update about 4 tables and insert to 2 Tables. Which approach will be ok for me? I'm thinking to use DataSet.
View 3 RepliesI have a form that fills a table adapter with this:
Me.Scratchpad3TableAdapter.Fill(Me.MDRDataSet.scra tchpad3
and what I'd like to do is when users edit something on this form that they post the changes to a table called exceptionsedit which is not part of that dataset. What I don't know how to do is to how to insert those edits to the exceptionsedit table.
i am trying to join 2 tables together and display them in a list view. i have this code so far
[Code]....
I have a windows form program that pulls data from a sql server. That same data is being read from a ASP.NET website that sets properties for the site. The SQL server has 3 tables: tblWebPage, tblObjects, tblProperties. and 6 views for the 6 web page: vWebPage01, vWebPage02, vWebPage03..ect. When the program loads you see buttons for each web page on the site. When the user clicks on the Home Page it loads this data: [code]Now, the problem lies in updating vWebPage02, vWebPage03, ect.. I assume with the same data I can copy my form with the code and change the form name and the data set to build and update. So that's just what I did changed the form name where needed and changed "vWebPage01" to "vWebPage02".When I tested the program My "vWebPage01" form it built and updated no problem. when I went to test "vWebPage02" it built the dataset and table adapter fine but it did not update at all.
View 1 Repliesim in the middle of doing sql queries i can search my data base usingGetDateFrom (Select, from, where) Me.nameTableAdapter.FillBy(namenDataSet.descip, Me.box1TextBox.Text,Me.box1TextBox.Text, Me.box2TextBox.Text, Me.box2TextBox.Text)i have this working fine im struggling with inderting data to my databse i have made the query ..
INSERT INTO `details` (`Forename`, `Surname`, `Username`, `Password`)
VALUES (''& ForenameTextBox.Text &'', ''& SunameTextBox.Text &'', ''& UsernameTextBox &'', ''& PasswordTextBox &'')
[code]....
I've just finished my first vb.net application and have a question about setting up data sets and data adapters.It seems like I do a lot of repetition in coding and I'm wondering if there's a better way to set them up.Below is the coding I use to set up a data adapter (daAddSpeaker) and a data set (dsAddSpeaker).The purpose of this coding is for the user to add a speaker name to an Access table thru a windows form.The coding works as intended but I'm wondering why I have to repeat "SELECT * FROM tlkpSpeaker" and refer to "tlkpSpeaker" so often.[code]
View 3 RepliesI am trying to write data back to my database in my project, but it keeps disappering when I make any changes to code. I can build the project, add data, close the project and build it again and the data is still there. But as soon as I make any changes to anything, on the next build, all of the data is gone.
The table will not be bound to any controls in the final project, but for testing purposes I have a datagrid control that it is bound to. My code started as follows:
[Code]...
how can i insert a data into the database sql when i choose one radio button and one chekbox i have 4 radio button and chekbox?
View 9 Replieshow to insert data in a database?i have every thing set up ..i only need to code to when you click it inserts in the databse..
buy the way i have an obdc set up.is there a way to make it update ?
so if i insert data in the application it updates the mysql databse to?
I'm using visual studio 2005 to develop a mobile application. The database i'm using is sql compact edition. I know in normal sql like mysql, ms sql i can do a multiple insert of data but in sql ce it don't work!
I know of a long way that is to just create a createVendor1, createVendor2 as many time as i need to insert the data..but i don't think this is the right way to do it. this is what i have currently, if i remove the 2nd insert , it works. NOTE: There is a semi colon at the end of the insert but that is not the problem as removing it also doesn't work.
Private Sub FormOrder_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim createVendor As SqlCeCommand = connection.CreateCommand()
[Code]......
I have this code:
Dim myConn As SqlConnection
Dim cmd As SqlCommand
Dim sqlstring, DNAME, DEXP, DCREATION, DLASTUPDATE, DCOMMENTS As String
[code]....
When I execute, it gives me this error:Cannot open database "DOMAIN_NAME" requested by the login. The login failed.Login failed for user 'comm-pc10pcuser10.comm'.and it highlights myConn.Open() I have SQLServer 2008 and a user name and pass for my database.
I created a database (.mdf) file. I added data to it after running the program in debug mode. When I closed it and opened it up again, the data I got was stored and loaded again.I closed my whole Visual Basic Express program. When I opened it up again, all the data had disappeared.
Can you tell me what I am doing wrong with the program? I can't get queries to work either. It worked when I used the NOrthwind dataset this past weekend but it is not working when I use my own or empty dataset.
When I put information into my database form, the data is not permanently saved to my database?
View 1 RepliesI able to insert new row into my datagridview. but dont know how to inserts all the row into my database
this is my code to insert new row into my datagridview[code]...
I have used Access databases before so thought I'd try something different. My problem is that when I try to add a new record to one of the tables in the databasethe code runs through fine, but the data is not added into the table :S have probably missed something simple, but it's been a while since I did any projects using a database.Here's my code:
Imports System.Data.SqlServerCe
Public Class Form1
Dim con As SqlCeConnection = New SqlCeConnection("Data Source=C:UsersMattDocumentsVisual
[code].....
I verified data types that are being inserted to insure that this is my problem. I dont see any exception errors.Am i missing a veriable or something that is related to my connection.
Imports System.Reflection
Imports System.Data.SqlClient
Imports PSXSTL.Data.DataAccess
[code].....