hi,

i have problem with inserting multiple row record in sql server. i have a form where there is more than 1 checkbox, when the end user check on checkbox, i want insert this value to sql server. can anyone tell me how it work? thanks.

Do you mean you are trying to gather the value of a checkbox and insert it into a database?

--Stole this from a moderator

I will only tell you how to do it, not do it for you.

Unless, of course, you want to hire me to do work for you.

dparson,
yup, tat's what i want. i want to gather all the information tat checked then insert it into database, it will be a multiple record.

Transact SQL Cursors

http://msdn2.microsoft.com/en-us/library/ms190028.aspx

I try to steer clear of cursors whenever possible as they seriously degrade your preformance. In so far as 'Multiple Record' I assume you mean you are inserting 2 rows of data.

In .NET you can use a text command or a paramertized query to do this, and then call it as many times as needed; if i was doing this inside of sql (depending on the situation) i would do something like

INSERT INTO [table]([value1], [value2])
    SELECT [value1], [value2] From [AnotherTable] Where [value3] = [something]

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.