How to read value from database and write into text file

Question

hi i need to read the value from database and write into a text file how to do it if anyone explain me can u please tell me to do it

Mageshwaran R · Answer

Hi, Please refer the below link, it might helps you https://stackoverflow.com/questions/1361302/how-to-read-from-database-and-write-into-text-file-with-c

Sapna Girish · Answer

try this simply solution https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html private void button1_Click(object sender, EventArgs e) { //connect database OleDbConnection connection = new OleDbConnection(); connection.ConnectionString @ "Provider=" "Microsoft.Jet.OLEDB.4.0" ";Data Source=" "demo.mdb" ";User Id=;Password=" OleDbCommand command = new OleDbCommand(); command.CommandText = "select * from parts" ; DataSet dataSet = new System.Data.DataSet(); OleDbDataAdapter dataAdapter = new OleDbDataAdapter(command.CommandText,connection); dataAdapter.Fill(dataSet); DataTable t = dataSet.Tables[0]; //export datatable to excel Workbook book = new Workbook(); Worksheet sheet = book.Worksheets[0]; sheet.InsertDataTable(t, true , 1, 1); book.SaveToFile( "insertTableToExcel.xls" ,ExcelVersion.Version97to2003); }

Bhuban Magar · Answer

Hello, You can read or retrieve data from database without using Stored Procedure. // Using Dapper private string ReadData() { try { using (IDbConnection connection = DbConnection.DbConnect()) { string result= connection.Query string >( "Select Name from Student" ).FirstOrDefault(); return result; } } catch (Exception ex) { throw ; } } //Using ADO.NET private void ReadData( string connectionString) { try { string queryString = "SELECT Name FROM dbo.Student;" ; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { string result= ( string ) reader[ "Name" ]; } reader.Close(); } } catch (Exception ex) { throw ; } }

shreyas adikumar · Answer

HI Bhuban Magar thanks for the reply i need to do without the stored procedure in asp.net is it possible do please tell me how to do it

Salman Beg · Answer

Hi. First read data from database using ado.net and then follow below link to write into text file, https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/file-system/how-to-write-to-a-text-file

Bhuban Magar · Answer

using System; using Dapper; using System.Data; // ConnectionString for Database public static class DbConnection { public static string connectionString = "Data Source =ABC-PC\MSSQL2016; Initial Catalog = ABCDatabase; User ID = sa; Password=sa@123"; public static IDbConnection DbConnect() { IDbConnection connection = new SqlConnection(connectionString); return connection; } } // Read Data from Database public string GetClassByID(int classID) { try { using (IDbConnection connection = DbConnection.DbConnect()) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@ClassID", classID); string result= SqlMapper.Query (connection, "[dbo].[usp_GetClassByID]", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault(); return result; } } catch (Exception ex) { throw; } } //Write Data in TextFile Public void SaveFile(string result) { string appFullPath = Application.StartupPath; string fileName = appFullPath + @"\ConnectionString.txt"; if (!File.Exists(fileName)) { FileStream fs = new FileStream(fileName, FileMode.Create, FileAccess.Write, FileShare.None); fs.Close(); } File.WriteAllText(fileName, result); }