What should I do if the ID field number is automatically +1 when adding a new record?

cosila

There is an ID field in the database, INT. Now every time a new record is added, the ID is automatically +1 from the segment. How to implement it? Here is my code:
 Public Overrides Sub SaveForAdd2 ()

        Dim drData As DataRow = DataSet11.Tables ("Application Form"). NewRow ()
        Try
            drData ("id") = TextBox36.Text
            drData ("Application Workshop") = TextBox30.Text ()
            drData ("Application Team") = TextBox31.Text ()
            drData ("Applicant") = TextBox33.Text ()
            drData ("Subject Leader") = TextBox34.Text ()
            drData ("Application Date") = DateTimePicker1.Value.ToString ("yyyy-MM-dd")
            drData ("name") = TextBox35.Text ()
            drData ("Unit Price") = TextBox36.Text ()
            drData ("Quantity") = TextBox37.Text ()
            drData ("Total") = TextBox38.Text ()
            drData ("Remarks") = TextBox39.Text ()
            drData ("Use") = TextBox40.Text ()

        Catch ex As Exception
            MessageBox.Show ("The data format is incorrect!")
            Exit Sub
        End Try

        Try
            DataSet11.Tables ("Application Form"). Rows.Add (drData)
            If Me.DataSet11.HasChanges = True Then
                SqlDataAdapter1.Update (DataSet11)
            End If
        Catch ex As Exception
            MessageBox.Show ("Data addition failed!")
        End Try
    End Sub

nkawei

Two options:
1. Check the maximum ID in the database first, and then add 1 to it.
Second, set the ID field to automatically increase in the database.

cosila

I want the code, thanks

iamstef

Define the IDENTITY column in the database

cosila

Brother, how do you define the IDENTITY column in the database?

devilz

Define the database: ID automatically grows:
such as:
create table #temp
(
id int identity (1,1),
value varchar (10)
)

cosila

I want the program to find the maximum ID in the DataGrid, and then +1, I do n’t know how to write the statement in the DataGrid to find the largest ID record

tsh6969

select max(id) from table

tsh6969

DataSet11.Tables("Application Form").Compute("max(ID)","")Retrieve the maximum ID of the current data source

nijiaoshaa

You can change the ID field type to automatic growth in the database. You click on the data type of the ID field, and a drop-down box will appear.