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]

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.

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

[vijay6]

Hey jsand03z, if "Organization_I D" 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_I D" 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.