This is a migrated thread and some comments may be shown as answers.

Help with simple radgrid insert, update, delete

2 Answers 147 Views

Grid

This is a migrated thread and some comments may be shown as answers.

SIT asked on 17 Mar 2009, 05:12 AM

I must be missing something really basic. I have created a table in sql server 2008 called mytest with two fields (mytest_id int identity, mytest_name nvarchar max). I am trying to use radgrid to be able to insert, update, and delete. I am using Visual Studio 2008 to create a web application project. I have added the radscriptmanager, radgrid, and radajaxpanel. I created the datasource to the mytest table on sql server and added the select, insert, update, and delete sql statements:

Select: SELECT mytest_id, mytest_name FROM mytest
Update: UPDATE mytest SET mytest_name = @mytest_name WHERE (mytest_id = @mytest_id)
Insert: INSERT INTO mytest(mytest_name) VALUES (@mytest_name)
Delete: DELETE FROM mytest WHERE (mytest_id = @mytest_id)

I have added the Select, Edit Update Cancel, and Delete columns.
I have set AllowAutomaticDeletes, AllowAutomaticInserts, AllowAutomaticUpdates all to true.

I think the commands are failing because there is no values for the @variables
If I change the delete command to: DELETE FROM mytest WHERE (mytest_id = 1)
the record is successfully deleted.

Any help is appreciated,
Dave

Help with simple radgrid insert, update, delete

2 Answers, 1 is accepted