SQL GUID USE AT GRID PANEL

[sadeque]

hi,

one of my table has primary key column as guid. so how can i use insert guid value through grid panel. i use the following code but its not working.

        InsertCommand="INSERT INTO DesignationInfo 
                           (vDesignationName,
                            vDesignationInBengali,
                            vDesignationShortName, 
                            bDefault, 
                            bInUseForm, 
                            bInUseReport) 
                        VALUES 
                            (@vDesignationName,
                             @vDesignationInBengali,
                             @vDesignationShortName,
                             @bDefault,
                             @bInUseForm,
                             @bInUseReport);                         
                        SELECT @newId = NEWID();"

[sadeque]

Got the solution.

        InsertCommand="INSERT INTO DesignationInfo 
                           (vDesignationID,
                            vDesignationName,
                            vDesignationInBengali,
                            vDesignationShortName, 
                            bDefault, 
                            bInUseForm, 
                            bInUseReport) 
                        VALUES 
                            (NEWID(),
                             @vDesignationName,
                             @vDesignationInBengali,
                             @vDesignationShortName,
                             @bDefault,
                             @bInUseForm,
                             @bInUseReport);"