How to read value from database and write into text file

shreyas adikumar

7y2.1k.NET

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Accepted 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
0
Sapna Girish7y ago
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);
}
0
Bhuban Magar7y ago
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;
}
}
0
shreyas adikumar7y ago
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
0
Salman Beg7y ago
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
0
Bhuban Magar7y ago
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);
}
0