adding csv file to database

Hai man...

I have successfully added the dump file into my database....wat i did was

first i opened the dump file using Wireshark tool then i stored it as .csv file..hope this not a prob for u...

Then in c# i used the following code...

SqlCommand command = new SqlCommand();
    command.Connection = con;
    command.CommandText = "BULK INSERT snort.dbo.[IncomingDataset]" + @" FROM 'c:\wednesday'" + "WITH" + "(" + "FIELDTERMINATOR = ','," + "ROWTERMINATOR='\n'" + ")";
    command.CommandTimeout = 300;
    command.ExecuteNonQuery();
    Console.WriteLine("--------Dataset loaded sucessfully-------\n\n"); 

stored in sql server 2005
Here snort.dbo is the database name
Incomingdataset is the table name

c:/wednesday is the csv file.....


Hope i made myself clear..any doubt lemme know...

Have you stored the tcpdump into a database??

If yes, Please explain how?

How do you convert tcpdump to csv data?

Thanks.

Hai man.............

Thanks for the reply......anyway how can i post a file in this forum to show the csv file which i am working in.......

Thanks...

Ok, then could you please give me the exact form of your CSV file, you can present it with false data, I want just to see it so that I can give you the right code
About stocking/retrieving a Blob file to/from a data base I suggest this Amr's article

Thanks for the reply man....

I dont know much about blob data type....and which one is easier n preferable to do....anyway i go for the last...adding the stock to each individual data column.....

Ok, I have a question do you want to stock it as a binary file as a blob file or you want that each column of the given file is stored in  a given data base column?