how to save the database in textfile by using c# windows

Question

hi this gyana. please how to call from data base in C# by using select query and how to save this data in text file please reply me.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;

using System.Linq;

using System.Text;
using System.Windows.Forms;

using DataAccessLayer;

namespace prjtims
{
    public partial class frmtotremits : Form
    {
        public frmtotremits()
        {
            InitializeComponent();
        }

        private void btnok_Click(object sender, EventArgs e)
        {

            IDBManager dbManager = new DBManager(DataProvider.MySql);
            dbManager.ConnectionString = "Server=local instance MYSQL56;Database=microfx

Uid=root;Pwd=root";

            try
            {
                dbManager.Open();

                dbManager.ExecuteReader(CommandType.Text, "SELECT count(*),etd_ticket_type,sum(etd_child_fare),sum(etd_adult_fare),etd_service_code FROM microfx.etm_ticket_data_private_aug_2013 where ETD_LAST_UPD_DATE between '2013-07-30 18:30:00' and '2013-07-31 18:30:00' group by etd_ticket_type,etd_service_code order by etd_service_code;");

                cmb_srvc_no.Text = "";
                date_tm_pckr_frm_dte.Text = "";
                dt_tm_pkr_to_date.Text = "";

                string file_name = "E:\\oracle.txt";
                System.IO.StringReader objReader;
                objReader = new System.IO.StringReader(file_name);
                //objReader.ReadLine(file_name);
                objReader.Close();


                dbManager.Close();
           }
            catch (Exception ex)
            {
                //Usual Code
            }
            finally
            {
                dbManager.Dispose();
                MessageBox.Show("Sucessfully opened");
            }
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }


    }
}

Ring Zhong · Answer

I create a table in database (SqlServer) with name tbbook which has following columns bookid int booktit varchar(50) bookaut varchar(50) bookpub varchar(50) bookprc int bookimg varchar(50) Use script to create table tbbook in your SqlServer Database CREATE TABLE tbbook ( [bookid] [int] NULL  [booktit] [varchar] (50) Null [bookaut] [varchar] (50) Null [bookpub] [varchar] (50) Null [bookprc] [int] NULL  [bookimg] [varchar] (50) Null ) Using this code you can store data from a text file of predefined structure to your database (SqlServer). Write following code in your .aspx page Uplaod File Text=Save File Data to Database Visible=False /> Now write following code in your code (.cs ) file Use these namespaces in your code file using System.IO; using System.Data.SqlClient; //write this code below page load event protected void LinkButton1_Click(object sender EventArgs e) { //saving file uploaded file in root directory of application FileUpload1.PostedFile.SaveAs(Server.MapPath(FileUpload1.FileName)); ViewState[file] = FileUpload1.FileName; FileUpload1.Visible = false; LinkButton1.Visible = false; Button1.Visible = true; } protected void Button1_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(server=.;database=database1;uid=sa;);//modify connect string to match yours con.Open(); //reading file start StreamReader reader = new StreamReader(Server.MapPath(ViewState[file].ToString())); string line = string.Empty; string[] lines = new string[6];//array to store values read from text file while ((line = reader.ReadLine()) != null)//reading file line by line { lines = line.Split('');//spliting each line by comma sign //saving into database SqlCommand cmd = new SqlCommand(); cmd.CommandText = insert into tbbook values(@id@title@aut@pub@prc@img); cmd.Connection = con; cmd.Parameters.Add(@id SqlDbType.Int).Value = Convert.ToInt32(lines[0]); cmd.Parameters.Add(@title SqlDbType.VarChar 50).Value = lines[1]; cmd.Parameters.Add(@aut SqlDbType.VarChar 50).Value = lines[2]; cmd.Parameters.Add(@pub SqlDbType.VarChar 50).Value = lines[3]; cmd.Parameters.Add(@prc SqlDbType.Int).Value = Convert.ToInt32(lines[4]); cmd.Parameters.Add(@img SqlDbType.VarChar 50).Value = lines[5]; cmd.ExecuteNonQuery(); } Response.Write(Record Saved); //reading file end con.Close();//closing connection to database } Try it.

Muralidharan Deenathayalan · Answer

Once you got the datareader from the dbManager you need to iterate the records and write each record into the text file. while(reader.read()) { //read the fields from the current record //Using stringbuilder to keep all values + append it for each record } //Open or create the file here //write the stringbuilder contents into the file //close the file. Hope this helps you.