I have a program which I am converting from VB6 to VB2010 this is also my first venture into sql. I have read many of the examples to try to get to grips with deleting records including those in this forum by imcilhinney
My problem is that I want to delete all but one of the records when the user presses a button, everything goes well until the 'ExecuteNonQuery' is reached.
[Code]...
I have been trying to install VB2010 Express, which directs me to uninstall VS2010 Beta. I have been primarily successful in this, but I keep getting error 1402, as follows:Form "Microsoft Visual Studio 2010 Professional Beta 2 Setup - Update Page":
Uninstalling Components:
[completed - check] Microsoft Office Development Tools for Visual Studio 2010 (x64)
[completed - check] Microsoft Visual Studio 2010 Professional Beta 2
[pending - double bar] Microsoft Visual Studio Macro Tools
[code]....
When I modify and delete data in a DataGridView, I get the error:
The record cannot be deleted or changed because table 'Table Name' includes related records.
but I can add new data, only cannot modify and delete data.
In my application, I open a "Customer Details" form and on confirming I have to delete all records from other 2 tables (Order & OrderDetails) of the database. I am not able to delete records. It somehow stops by on - ordDetAdap.Update(ordDetDs) . The code is as follows :
[Code]...
There may be N number of Orders and each order may have N number of OrderRedetails. There are rows and also shows proper data in MsgBox, also row.Delete works fine, BUT why does it stop at Update(OrdDetDs) I can't make out. Any idea where am I going wrong.
Also Is their any easy way out to delete all records using just a single statement providing OrderId from OrderDetails table ? As of there are 10 rows of a single order, then For loop will iterate 10 times and delete 10 rows, instead if I can delete all 10 rows at once would be beneficial.
Is there any advantage to using the VB2010 express version versus the VB2008 express version? Can they be installed side by side or will VB2010 express replace VB2008? I have no issues with the 2008 version, so I don't know if installing the 2010 version would be of any advantage.
View 9 Replieshow to get records into oracle database delete from db & update the records i have successfully connected my vb 2008 win form with oracle 10g.
View 1 RepliesI'm trying to delete a number of records in a table from the last and forward. My idea is to use sql like this: delete top " & variable & " * from table where ID = something It gives me a general sytax error. Is it at all possible? Fuga. Edit: I also have the order by statement there. I just forgot to put it in the question.
View 5 RepliesI'm just using the default SQL Server Express in my vb 2008 express edition as my database server for my database operation. When I tried to update the records on my table I got a runtime error which indicates the error on this line 'myCommand.ExecuteNonQuery()'and it highlights a yellow background on it. The runtime error says "SqlException was unhandled: An expression of non-boolean type specified in a context where a condition is expected, near 'Number'. ".
Imports System.Data.SqlClient
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim myConnection As New SqlConnection
Dim myCommand As New SqlCommand
[code]....
I am trying to show the date that stored in sql2008 in vb2010 by using datetimepicker.
Here is my code:
Private Sub Load_Project(ByVal cJobNo As String, ByVal nFlag As Integer)
Dim lnComboboxIndex As Integer
Dim lcSQL As String
'nFlag => 0-Edit 1-Copy Record
[Code] .....
give me the source code to add database connectivity in VB2010 express through ADO.Net. Including all the commands to add, update, delete, retrieve and modify the database fields. It would be really helpful if anyone can provide me with a small prototype working model with the source code.
View 1 RepliesI am starting programming entity framework by julie lerman. all her examples are in c#, which i do not use. when i right click on the edmx model in solution explorer (vb2010 express), i do not get an 'open with' option, only 'open' which italready is, in design mode.
View 2 RepliesI create a project.However, after I close VB2010 express and then open again I can not find or open my project.Futhermore, I need to zip a project and send it.I am doing something wrong in process of saving. I do not know what?
View 2 Replieswrote a program which works perfectly fine on the Win7 64 bit machine I wrote it on. Tried to run it over server and previous versions of windows (all 32 bit) and got an error (see screenshot attached) In some googling looked like there was an export function I missed so I've done: -Tools -> Options -> Projects and Solutions -> Check "Show Advanced Build Configurations" box -Project -> project properties -> Compile -> Advanced Compile -> and I've read there is something that should be changed here (the target framework?)
[Code]...
I created a windows form in VB 2010 and I am trying to view it in 2008, but I get the error message "The selected file is a solution file, but was created by a newer version of this application and cannot be opened".
Is there anyway I can re-save the 2010 project(similar to Microsoft word) in order to be able to open in older version?
How to convert VB2010 Express proj to VB2008
View 6 Replies(pardon me for re-using someone else's wording - but it seems this question comes up in each NEW version of the IDE) Does anyone know how to disable VB autosave? I like to open a working solution/project, mess around with it, and if I cant get it working, I like to exit without saving so that the original working version is left.
But silly VB 2010 autosaves changes, therefore stuffing up, a once working solution/project. I can understand autosaving whilst working though a large solution, but I prefer to click save once I have accomplished a routine, in the solution/project.
Is there a command or couple of code lines that will pause the running program for one or two seconds?
I have a program that checks the system time every 250milliseconds and I need to skip checking it three times the first time it comes back with ":00" seconds from the system clock.
Or another option would be to reset the timer to 1000 and then back to 250...
I use windows Vista.I had been working intensly on a new program all day today and pretty much all day yesterday. I was almost finished.Then my computer crashed. I rebooted.When I came back into Visual Basic 2010 express, I expected that somewhere I would see my files. Besides... I HAD BEEN SAVING THE FILES ALL DAY LONG USING CONTROL+S on my keyboard. The little * symbol at the top of each file would go away. I assumed that meant it was actually saving my work as I went along. I did not, however, actually go to file->SAVE at any point along the way.
After coming back into VB2010 express, no autorecover dialog appeared. I looked for my project in the list, and it wasn't there. I looked at "recent files" and "recent projects" and found nothing. Finally I searched my whole hard drive for my project, and found only one EMPTY directory located at:
C:UsersDellLaptopDocumentsVisual Studio 2010Backup Files, which matched the name of my project I had spent the last two days working on.
I need to write, read and delete data from a MSAccess database file (.accdb)
Is there a SIMPLE sample to get me started?
I have written lots of code with the ADO Library in VB Excel and previous versions of Visual Basic. With the dissappearance of the recordset object, how do we perform data manipulation with an attached Access Database? It seems things could be a lot easier, and less complicated by now, however, the best methods appe
View 5 Replieshow would I copy files into a jar, as well as delete folders from that jar. Would I have to decompile it then recompile it? Would sharpziplib do the trick?
View 1 RepliesI have a TCPListener demo setup and working. The demo program has been supplied by Bill Chung, here:[URL]..the Listener uses a DataGrid to output whatever data is received but currently it doesnt store it.
Ive created a simple database and linked it to my project. what i need help with is getting the data that is currently outputted in the DataGrid to be stored into my DB table.
[Code]...
I want to know how to Update / delete the table records in ASPNETDB.MDF in single update / delete query ?
View 1 RepliesI am using wmplib and i like to know a duration time of a lot of files onto a same folder (software for audiobook for low vision persons)
View 2 Repliesadding and updating records from VB to MS Access.
code is as follow:
Private
Sub btnNSubmit_Click(ByVal
sender As System.Object,
ByVal e
[code]....
The following code deletes the records from the table on run time but not actually from the MS Access database. I have deleted all the records and when I restart the application, all records are exist.
How to solve the problem?
[Code]...
I have a blank form, and I've added a really simple Access database with two tables with two columns each. If I click and drag the name of one of the columns, and drop it on the form, I get a label and a textbox.
I was assuming that since the load procedure already had Me.WhateverTableAdapter.Fill in there, that when I pressed the green arrow to run the program, I'd be able to flip through the records in the column.
When I click "preview data", I do see the data is there, but when I run the program, it says 0 records and none load. Is there something else I have to do to be able to flip through the records in that one text box?
imports System.Data.SqlClient
Public Class Form3 Inherits System.Windows.Forms.Form
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim ra as Integer
[Code] .....
Attached File(s)
deleting.txt (793bytes)
Number of downloads: 9
Is it possible to delete all records from a bindingsource without using a loop? My binding source is a dataset table
View 3 RepliesI use this code to get row id from dgv to delete that row after that
Me.
TextBox1.Text = DataGridView1.Rows(e.RowIndex).Cells("id").Value
Now how can I amend this code to use it to get sevral rows ids in case that I want to delete more than one row ?