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

c# textfile store in sqlserver

Answers (3)