how to insert txt file into database sever

Question

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

Srikanth Reddy · Answer

To know the point of line completion while streamreader is going on : using (var sr = new StreamReader(fileName)) { for (int i = 1; i sr.ReadLine(); return sr.ReadLine(); } Please do accept my answer if it's correct. Thank you.

Srikanth Reddy · Answer

sorry I'm not clear with your response. line by line means ?

Abhishek Singh · Answer

hello srikanththanku 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

Srikanth Reddy · Answer

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 ;