I set 'NONE' for the authenticate mode in my web config file of my ASP.NET application. For the SQL Server, i put NT AUTHORITY/Authenticated Users for the user for database that use by the application as well as dbo. So, are you sure that not problem i using directory browser in my application? Thank for advice.

This was thrown together, but should work if you replace the tablenames, columnnames and filenames with values that apply to your application BULK INSERT DBName.dbo.StagingTable -- StagingTable can be a copy of your destination table From 'C:\YourFile.txt' -- actual path to your file With ( FieldTerminator = ',', RowTerminator = '\n' -- for new line ) Alter Table StagingTable ADD SafeToTransfer BIT NOT NULL Default(1) -- Run some integrity checks prior to attempting to tranfer if ( select Count(*) From DBName.dbo.StagingTable Where IsNumeric( ColumnA )=0 ) >0 BEGIN Update DBName.dbo.StagingTable Set SafeToTransfer = 0 Where IsNumeric( ColumnA )=0 END if (select Count(*) From DBName.dbo.StagingTable Where isDate( ColumnB )=0 ) >0 BEGIN Update DBName.dbo.StagingTable Set SafeToTransfer = 0 Where isDate( ColumnB )=0 END if ( select Count(*) From DBName.dbo.StagingTable Where isNumeric( ColumnD )=0 ) >0 BEGIN Update DBName.dbo.StagingTable Set SafeToTransfer = 0 Where isNumeric( ColumnD )=0 END Insert Into DBName.dbo.DestinationTable ( ColumnA, -- an INT Column ColumnB, -- a datetime column ColumnC, -- a varchar(100) column ColumnD, -- a numeric(9,5) column ColumnE -- another varchar(100) column ) SELECT CAST( ColumnA as int), -- an INT Column CAST( ColumnB as datetime), -- a datetime column LEFT( ColumnC, 100), -- a varchar(100) column CONVERT( numeric(9,5), ColumnD), -- a numeric(9,5) column LEFT( ColumnE, 100) -- another varchar(100) column From DBName.dbo.StagingTable Where SafeToTransfer = 1 Alter Table StagingTable DROP COLUMN SafeToTransfer

Well, your problem here is that your import data is ambiguous. You don't know whether a comma represents a field separator or a digit grouping symbol. The best thing to do is to change the import data format, for example to put quotes around numeric fields that can have a digit grouping symbol in them, or indeed to put quote marks around all fields. It's then traditional to double quote marks that actually appear within a field. Bulk insert is typically easiest to handle with fixed field widths rather than the use of separators. There's what looks to be a good CSV file reader class at http://www.codeproject.com/cs/database/CsvReader.asp[^] (disclaimer: I haven't used it). You could use this to write a convertor to tab-separated format once you've sorted out the ambiguity, if you can't get the source data generated in a usable format. Stability. What an interesting concept. -- Chris Maunder

You can use OnItemDataBound event to do the functionality as that event executes for each row of the datagrid. Best Regards, Apurva Kaushal

you can read the CSV file and then can store it in some array and then you can filter it and finally store it in the database. In which step is the problem. :) Best Regards, Apurva Kaushal