how to insert txt file into database sever

Abhishek Singh

9y864

hi everyone ,

please help me how to insert txt file into database sever please provide me code

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreekanth Reddy9y ago
To know the point of line completion while streamreader is going on :

using (var sr = new StreamReader(fileName)) {
for (int i = 1; i < line; i++)
sr.ReadLine();
return sr.ReadLine();
}

Please do accept my answer if it's correct.
Thank you.
Sreekanth Reddy9y ago
sorry, I'm not clear with your response. line by line means ?
Abhishek Singh9y ago
hello srikanth,thanku for answer
but in program i alredy use explode function and i want insert line by line into the database
so please can you write a full program for me please .its very important
Sreekanth Reddy9y ago
Stream fs = FileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
Byte[] bytes = br.ReadBytes((Int32)fs.Length);
string strQuery = "insert into tblFiles(Name, ContentType, Data)" +
" values (@Name, @ContentType, @Data)";
SqlCommand cmd = new SqlCommand(strQuery);
cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = filename;
cmd.Parameters.Add("@ContentType", SqlDbType.VarChar).Value
= contenttype;
cmd.Parameters.Add("@Data", SqlDbType.Binary).Value = bytes;