I would like to retrieve the ID number for that row that was just inserted into the database. after saving it I want to get the value of its ID and pass it to another table.
View 3 Replies I would like to retrieve the ID number for that row that was just inserted into the database.
Dim Enrollment As New Enrollments
With Enrollment
.Student_ID = CInt(lvwStudents.FocusedItem.Text)
[code].....
Dim Customer As New Customers
With Customer
.Name = txtName.Text
[Code]....
After saving I want to get its ID and pass it to another table. how or what is the proper way to do this.
Does anyone know of any reason why my FilmID field (which is an autonumber) is going backwards? When I add a new record, it is going -1, -2, -3, -4, instead of carrying on from the last number. If you need the code, just ask, but I was thinking it might be something in properties or something?
View 3 RepliesI am trying to insert into a access db and the PK is an autonumber that is generated by the DB. I am getting a syntax error for the insert statement and dont know why. If possible I would like to return the autonumber value in the same statement.
[Code]...
I'm wanting to alter a column in an acces database, to a Random AutoNumber I know how to do it for incremental e.g."ALTER TABLE MyField Counter(1,1)"but how do you do it for a Random Autonumber??
View 10 RepliesI am using VS2010/VB.NET/MS Access 2007 I had added a database from ms access to the vb.net application (strongly typed)that table contains an autonumber field.I made a button to add new row and another one to save the row the problem is that I want to get the last autonumber from the database so that I can save the row.
View 1 RepliesI have a DGV that is designer generated. I can create a row perfectly fine, and I can edit rows perfectly fine. However, if I try to edit a row that I have just added and saved, i get a concurrency error. As you can see in the code below, I perform some "injection" of information into the rows before they are pushed back to the database.
System.Data.DBConcurrencyException was unhandled
Message=Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
RowCount=1
[Code].....
I am developing an application in VB.NET. in which I need to open the most recently accessed file (i.e. last accessed file in the previous session) when the application starts. One approach is to save the location of the most recently accessed file in a text file and read it when the application runs the next time.
View 2 RepliesI have a project which had a listview on it which had a property set whereby the last item added was always visible, i find now the listview does not do what i need so i have changed it for a dgv. In essence what i'm doing is a log.
View 2 RepliesWe have an application that was written in VB6 which I am trying to convert to use the latest VB (Visual Studio 2008), mostly because it's not possible to buy a licenced version of VB6 anymore (personally I'd have been happy to just keep using VB6, but without having a proper licenced version of it, we basically had to chance).The VB6 version I could simply tell it to compile the application and it produced the .exe file which I could then copy onto the server where it was running and replace the old version and then run it.
It seems like such simple things are not possible in VB 2008.I have got the application converted, and if I run it through the debugger it is working correctly, but now I need to get a compiled application to run on the server and can't seem to do it.I have tried using the publish application thing, and nothing I try succeeds in getting a working application.
I am developing an ASP.Net VB Web Application
The application contains a GridView which displays the records of a user table from my created datable. The database is an Sql server database.
The code below inserts data into one table and through the built in function @@Identity to insert the most recently added record id (tt_id) from the trainingTbl table and inserting that record id into the userAssessmentTbl. Adding the identity to the second userAssessmentTbl table works fine.
[code...]
The issue I'm having seems to be centered on how I insert a uniqueidenifier from a GridView into a userAssessmentTbl database!
And how, I guess using a loop I can insert the UserId records from that Gridview (GridView1) into the userAssessmentTbl table along with the looped id from the @@Identity.
This part of the insert parameter seems to be incorrect:
[code...]
And the error I'm met with is: 'Conversion failed when converting from a character string to uniqueidentifier.'
I've also tried it like this:
[code...]
And im met with the error: 'Operand type clash: int is incompatible with uniqueidentifier'
The qusetion has slightly changed to how do I Insert a String into SQL DB Where DataType Is Uniqueidentifier?
I am using VB.NET in VS10. After I add items to a list box I'd like it to scroll down so that the most recent items are visible. I tried this with no luck:
StatusListBox.SelectedItem = StatusListBox.Items.Count - 1
How to make the box always display the most recently added items?
Below is some code that I'm using to create objects with Visual Basic:
For indexCounter As Integer = 1 To TotalParticipants Step 1
participantClock = New Label
participantClock.Size = New Size(100, 20)
participantClock.Name = "participantClock" & indexCounter
[code]....
I'm creating a label, a button, Timer, and Stopwatch. (Though I have sinking feeling I don't need BOTH a timer and stopwatch since I'm counting time.)What I would like to do, is create the label and set that label's text to be the value from the stopwatch. The button that will be created will stop THAT stopwatch.
The problem that I'm having is that I cannot call the stopwatch by name since it wasn't created yet and VB throws a hissy fit at me for it. (After all it wasn't really declared.)So the question becomes, how do you call the most recently dynamically created control and assign events using that control. If it's not possible to do, I do not mind dumping the form and starting over creating 30 stopwatches instead (but I'd like to avoid that, if possible).
How do you clear the Recently Opened Program Lists in the start menu?
I've been making a computer cleaner, and I've Googeling and I guess binging so much to find an answer but i couldn't, does any1 know how?
The most I could find was: [URL]
BTW I know how to clear it, but I need to know with VB code.
I have one table in MS Access 2007 called "Case" and this database is link to my project in VB2010. The first field in the table is called "Auto" i made this one as autonumber. What i'm trying to do now is to create the "Case ID" with the combination between current date and current autonumber in "Auto" field. eg: 191010-12.
I am using this code to add a duplicate of a record. What I need to know is what the AutoNumber is of the new row that I just created. Is there a way to get the AutoNumber of a newly created row? I am using Access 2003 as a backend. Dim da2 As New OleDbDataAdapter("SELECT TaskNumber, JobPlanNumber, TaskDescription FROM tblTasks WHERE JobPlanNumber = ?", cn)
[Code]...
I am trying to do a user defined autonumber when I click on a button. The code worked fine when the recordset is empty, it give me a 1 on my first record, however, after I click on the button again, it give me 1 again. Here's my code.
Private Sub BtnNew_Click()
Dim rsClone As Recordset
Dim pVal As Integer[code]......
how to create an autonumber field using DAO.
[Code]...
I have a table hasn't primary key in oracle 10g and I need to add autonumber to table and use this autonumber in vb.net 2005 to control in update ,delete command in vb.net
View 4 RepliesI have a following controls in my vb.net form:
CODE:
This form will be storing a values to the SQL Database (SQL Server 2005). In the txtID textbox the auto id should be generated when ever user clicks on btnAddNew. The ID should be generated in for digit i.e. 0000, 0001,0002, .... and so on.
When the form is opened next time and when the user adds the new record, the ID should generate next value coz the ID will not be duplicated.
I have a following controls in my form:
txtID
txtName
[code].....
I need to add a record to a database and would like to get the value of the next autonumber value in the key field before the add.
View 9 RepliesI have this code that works for adding a record.
Dim da As New OleDbDataAdapter("SELECT TrainingTitle, TrainingDate, TrainingInstructor, TrainingDescription FROM tblTrainingHistory", TRAININGcn)
Dim ds As New DataSet
da.FillSchema(ds, SchemaType.Source, "tblTrainingHistory")
da.Fill(ds, "tblTrainingHistory")
[Code]...
But I wanted to show the autonumber to the user for reference. How do I know what the autonumber is?
i'm using VB 2008 and MS Access as my database for my assignment. I want to know how to get the value of the last Primary Key ID which is an Auto Number after I insert a record.
Private Sub saveBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles saveBtn.Click
Dim save As DialogResult = MessageBox.Show("Do you want to save the Anime?", "", MessageBoxButtons.YesNo)
If save = DialogResult.Yes Then Try Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App_Path() & "Anime Database.mdb;"Dim myConnection As OleDbConnection = New OleDbConnection
myConnection.ConnectionString = connString myConnection.Open()
[Code]...
How can I increment a field without using Autonumber,
like reading from its last value and then increment it?
I'm new to vb.NET and really need a detailed explanation.
s = "update Color set Color='" & ListView1.Items(y).SubItems(5).Text & "' where ID='" & CInt(ListView1.Items(y).SubItems(1).Text) & "' "
View 1 RepliesI'd like to add Auto Number per group box in crystal report. Here I use Record Number but it increases by group box.
Report View
The AutoNumber will be at the front of Barcode Column. How to set it per group box?
how i create an autonumber in visual basic statement for an oracle database??
View 1 RepliesI use the following code to insert some data into a DB:
strSQL = "INSERT INTO tblItems(itmTitle, itmCode, itmImage)"
strSQL += " VALUES('" + txtItemTitle.Value.Trim + "','" + txtItemCode.Value.Trim + "','" + c + "');"
[Code]...
With the DB table having an additional field called: itmID which is an Autonumber field so I dont need to add any data to this field.
But after the above SQL code has been executed I want to get the itmID number assigned to the new record - but I am not sure how to do this.
Im thinkin maybe using SELECT function but with WHERE filtering by the details I have just added but dont know if there is a simpler way.