loading csv file to SQL Server

loading csv file to SQL Server

CREATE TABLE CSVTest
(FirstName VARCHAR(40),
No1 INT,No2 INT,No3 INT,No4 INT)
GO

select * from CSVTest


BULK
INSERT CSVTest
FROM 'd:\Tesing.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO


select * from CSVTest

If there is a error in a particular row that row will not be added.
rest of the rows will be loaded into sql server.

.csv file
vijay,20,19999,90000,8
Jagadeesh,9,111,60000,9

Using JavaScript to Display messages in ASP.NET pages

<script language="javascript" src="script/ReasonForVisit.js">

or in aspx page

function setmessage()
{
if(language=='english'){
document.getElementById('header1').innerHTML="No Records found.";
document.getElementById('span1').innerHTML="We are unable to find
your records.";

}
else{
document.getElementById('header1').innerHTML="No Records found.";
document.getElementById('span1').innerHTML="We are unable to find
your records.";
}

}

.aspx pages

<table style="width: 100%;" border="0" cellpadding="0" cellspacing="0" id="Table1">
<tr align="center">
<td id="header1">

</td>
</tr>
<tr align="center">
<td id="span1">

</td>
</tr>
</table>