Sql insert statement, how to generate a primary key?

[jsand03z]

Okay lets say I want to generate a primary key for organization_ID instead of manually entering it in a textbox I created.
When this program runs the user is not suppose to see the primary key when submitting this information. Basically what I want is a random unique idenfier generated.

My idea was to use some kind of count function?

 Public Shared Function Insert_Organization() As DataSet
 
        Dim _DBConnector As New DBConnector()
        Dim ds As New DataSet
        Dim query As String
        Try
            query = "INSERT INTO Organization (Organization_Name, Organization_Info, Organization_Statistics, Organization_Total_Donated, Organization_ID) VALUES ('" & DataBaseProject_Hunger.AddOrganization.OrgNameTextBox.Text & "', '" & DataBaseProject_Hunger.AddOrganization.TextBox1.Text & "','" & DataBaseProject_Hunger.AddOrganization.TextBox2.Text & "','" & DataBaseProject_Hunger.AddOrganization.TextBox3.Text & "','" & DataBaseProject_Hunger.AddOrganization.TextBox4.Text & "' )"
            ds = _DBConnector.GetDataSet(query)
        Catch err As Exception
            MessageBox.Show(err.Message)
        Finally
            MsgBox("Added New Organization sucessfully.", MsgBoxStyle.Information, "")
        End Try
        Return ds

[r035198x]

Don't do it with your code. Let the database do it for you. How to make your database do it for you depends on which database you are using.

[jsand03z]

@r035198x
I'm using sql server 2012. I tried it that way once and the program broke.

[vijay6]

Hey jsand03z, if "Organization_ID" is an integer type then the simple way is set "Is Identity" to 'Yes' in your SQL Server 2012 database. Then don't insert value for "Organization_ID" column whenever you're inserting a new row in your table (The database will do it for you automatically).

[jsand03z]

Thank you, it seems to work fine now.