I want to get data from Access instead of notepad.
Here are the codes to get data from notepad by entering IC number (equivalent to ID number). The records are stored in 'Folder'.

public void btnGo_Click_1(object sender, System.EventArgs e)// -->User can select the file by entering the IC Nunber in textbox and program will check for file existence and null file
/** [Retrieve IC Number from tboxEnterICNo] **/
strFileName2 = tboxEnterICNo.Text;
path = @"Folder\"+strFileName2+".txt";
/** [Check for file existence] **/
if(File.Exists("Folder\\"+strFileName2+".txt"))// -->If file exists, open DisplayGraph form and display the graph
displaygraph.names = path;// -->copies the path to DisplayGraph form
displaygraph.ShowDialog();// -->Opens DisplayGraph form to display graph
}//End of if-condition
MessageBox.Show("File does not exist! Please create a new profile.", "Invalid File Type", MessageBoxButtons.OK, MessageBoxIcon.Error );
}// -->End of else-condition
}// -->End of btnGo_Clicks module

How should i go about to keep the records in Access and also specify retrieving of the queried data from an Access table instead?

I need some help about what to do and how the codes look like.
Thank you very much!

Recommended Answers

All 2 Replies

a little sample to help you out,
but you'd better read some ADO.Net tutorials

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;


//  namespaces needed fo data access


using System.Data;

using System.Data.OleDb;

namespace msaccess


    class Program


        static void Main(string[] args)



            //  Initialization


            string ic_number = "648937693";

            string path = Directory.GetCurrentDirectory();

            path += "\\Folder\\MyDatabase.mdb";

            // Connection object

            var cn = new OleDbConnection(

                "Provider=Microsoft.Jet.OLEDB.4.0;" +

                "Data Source=" + path);

            // sql command object, that will select your data

            var cmd = new OleDbCommand(

                "select MyField1, MyField2 from MyTable where ICNumber = @icnumber", cn);

            // this will insert "648937693" in @icnumber in SQL select statement

            cmd.Parameters.AddWithValue("@icnumber", ic_number);

            // table adapter

            // it can execute sql commands 
            // and fill table objects with data from database

            var adapter = new OleDbDataAdapter(cmd);

            var table = new DataTable();

            // here adapter opens connection

            // retrieves data with select command

            // and stores it in table object


            // iterate through rows of data

            foreach (DataRow row in table.Rows)


                // do your stuff

                string s = string.Format(
                              "MyField1: {0} MyField2: {1}", 
                              row["MyField1"], row["MyField2"]);



            // wait





good luck

oh fuck, this post is 4 years ago)))))
i'm an idiot

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.