I am a beginner and I try this:
I try to use a stored Procedure to allow the user to input new data, after that the data will be added into a table. I dont want to allow the user to add new data directly in the table.
This is stored procedure:
Alter Procedure "SP_Test"
declare @MyTable table (Field_1 int PRIMARY KEY, Field_2 varchar(200))
select * from @MyTable
You would loop through the grid rows and call the insert SP for each row - possibly within a transaction depending on the requirement.
That's the simplest and most flexible way of doing it - you could also create a disconnected recordset - populate it then connect. Or create a text file and use bulk insert to add the recs to the table.