Get data from Access instead of Notepad (URGENT)
 

Hi

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
{
enable();
/** [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
else
{
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!

Re: Get data from Access instead of Notepad (URGENT)
 

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



            adapter.Fill(table);







            // 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"]);



                Console.WriteLine(s);



            }







            // wait



            Console.ReadLine();



        }



    }



}

good luck

Re: Get data from Access instead of Notepad (URGENT)
 

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