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