c# textfile store in sqlserver

Question

Hi,
I want a coding of text file is stored in database..

Sandeep Pant · Answer

SQL CODE
CREATE DATABASE TextStorageDatabase USE TextStorageDatabase
CREATE TABLE Table1( Content varchar(400), FileName char(50))
SELECT * FROM Table1
C SHARP CONSOLE CODE
using System; using System.Collections.Generic; using System.Linq; using System.Text;
using System.IO; using System.Data.SqlClient;
namespace UploadTextFileContentAndName {     class Program     {         static void Main(string[] args)         {
Console.WriteLine("ENTER THE FULL PATH OF File TO BE UPLOADED");             string fullPathToFile = Console.ReadLine();
Console.WriteLine("You entered the path as {0}",fullPathToFile);             SqlConnection con;
try             {                 con = new SqlConnection(@"Integrated Security=True;Initial Catalog=TextStorageDatabase;Data Source=YOUR SERVER NAME");
con.Open();
string content = File.ReadAllText(fullPathToFile);
Console.WriteLine("Content of all is {0}",content);
string fileName = Path.GetFileNameWithoutExtension(fullPathToFile);                                   Console.WriteLine("Your file name is {0}",fileName);
SqlCommand cmd = new SqlCommand("INSERT INTO Table1 VALUES (@content, @fileName)",con);                 cmd.Parameters.AddWithValue("@content", content);                 cmd.Parameters.AddWithValue("@fileName", fileName);
int result=cmd.ExecuteNonQuery();                 if (result>0)                 {                     Console.WriteLine("data entered to the table");                  }                 else                 {                     Console.WriteLine("No data entered");                 }
con.Close();                 Console.WriteLine("Connection close");
}             catch (Exception ex)             {                 Console.WriteLine(ex.Message);             }
Console.ReadLine();
}     } }

Vithal Wadje · Answer

you can refer my article here
http://www.c-sharpcorner.com/UploadFile/0c1bb2/uploading-and-downloading-excel-files-from-database-using-as/

Krishna Garad · Answer

Take a look here