inserting values

Hi,

You have to write 10 different Insert statements if you have explicit values.

Thanks -- Vj

http://dotnetvj.blogspot.com

yes

  first write xml for your grid rows

      ex:   valuevalue

valuevalue

valuevalue

Now in sql server we have a procedure that converts xml to a table

XMLPreParedocument @XMLString,@Doc

 OPENXML()

   you can see this in sqlserver functions

yes,

and can we write with one single query?

Try this:

INSERT INTO thetable (field1, field2)
SELECT value1, value2
UNION ALL
SELECT value3, value4
UNION ALL
.
.
.
SELECT value5, value6;