Multiple recodrs are not saving from data grid view

STEP 1:
StringBuilder strSample = new StringBuilder();
DataTable dt = new Datatable();

STEP 2:
Add your datagridview value in to above declared datatable;

STEP 3:
strSample.Append("<Root>");
if (dt.Rows.Count > 0)
{
foreach (DataRow dtDetailsRow in dt.Rows)
{
strSample.Append(" <TESTDETAILS TEST_ID1 = '" + 1 + "'");
strSample.Append(" TEST_VALUE1 = '" + "SAMPLE TEST" + "'/>");
}
}
strSample.Append("</Root>");

Step 4:
send this "strSample" stringbuilder to SQL Server Stored Procedure Like below

Step 5:
CREATE PROCEDURE [dbo].[SP_Sample_Test]
(
@strSample NText
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @OC INT
--TEMP TABLE DECLARATION
DECLARE @TBLSAMPLEDTLS TABLE
(
TEST_ID1 INT,
TEST_VALUE1 VARCHAR(25)
)
SET @ERRORCODE=0

--Temp table Insert
Exec SP_XML_PrepareDocument @OC Output, @strSample
INSERT INTO @TBLSAMPLEDTLS
(
TEST_ID1,TEST_VALUE1
)
SELECT TEST_ID1,TEST_VALUE1
FROM OPENXML(@OC,'Root/TESTDETAILS',1)
WITH (TEST_ID1 INT,TEST_VALUE1 VARCHAR(25))

--Main table Insert
INSERT INTO Sample_Test
(
TEST_ID1,TEST_VALUE1
)
SELECT TEST_ID1,TEST_VALUE1 FROM @TBLSAMPLEDTLS

SET @ERRORCODE=0


END


Finally at one shot your data's get uploaded.

pls give datagridview in loop condition
for(i=0;i<datagridview1;i++)>
{
insert into table name value();
}