C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Text;
using System.Windows.Forms;

namespace PSTMGR
{
    public partial class AdminControl : UserControl
    {
        IniReader INI;
        //DataTable dispTable;
        DataTable dataTable;
        DataView dataView;
        DataRow dataRow;
        UserObj currentUser;

        public AdminControl()
        {
            InitializeComponent();
            INI = new IniReader(Application.StartupPath + "\\PSTMGR.INI");
            this.DBPath.Text = INI.ReadString("DBInfo","DBPath", "");
        }

        private void changeDBPath_Click(object sender, EventArgs e)
        {
            OFD = InitOFD(null);
            DialogResult dr = OFD.ShowDialog(this);
            if (dr != DialogResult.OK)
                return;

            string fn = OFD.FileName;
            this.DBPath.Text = fn;
            INI.Write("DBInfo", "DBPath", fn);
        }

        private OpenFileDialog InitOFD(OpenFileDialog o)
        {
            if (o != null)
                return o;

            o = new OpenFileDialog();
            o.InitialDirectory = "C:\\";
            o.Title = "Load Image File";
            o.CheckPathExists = true;
            o.CheckFileExists = true;

            //	create filter
            o.Filter = "Access DB(*.MDB)"
                + "|*.MDB";

            return o;
        }

        private void searchUsers_Click(object sender, EventArgs e)
        {
            bool first = true;

            String dataQuery = "SELECT * FROM USERS";
            //String dispQuery = "SELECT FIRST_NAME AS [First Name], " +
            //                   "LAST_NAME AS [Last Name], USER_NAME AS [Username], " +
            //                  "PASSWORD AS [Password] FROM USERS";
            if (searchUserName.Text.Length != 0)
            {
                first = false;
                dataQuery += " WHERE USER_NAME = '" + searchUserName.Text + "'";
            //    dispQuery += " WHERE USER_NAME = '" + searchUserName.Text + "'";
            }
            if (searchFirstName.Text.Length != 0)
            {
                if (first)
                {
                    first = false;
                    dataQuery += " WHERE";
              //      dispQuery += " WHERE";
                }
                else
                {
                    dataQuery += " AND";
                //    dispQuery += " AND";
                }

                dataQuery += " FIRST_NAME = '" + searchFirstName.Text + "'";
                //dispQuery += " FIRST_NAME = '" + searchFirstName.Text + "'";
            }
            if (searchLastName.Text.Length != 0)
            {
                if (first)
                {
                    first = false;
                    dataQuery += " WHERE";
                  //  dispQuery += " WHERE";
                }
                else
                {
                    dataQuery += " AND";
                    //dispQuery += " AND";
                }

                dataQuery += " LAST_NAME = '" + searchLastName.Text + "'";
                //dispQuery += " LAST_NAME = '" + searchLastName.Text + "'";
            }

            dataTable = PSTMGRApp.Connection.Query(dataQuery);
            //dispTable = PSTMGRApp.Connection.Query(dispQuery);
            dataView = new DataView(dataTable);
            this.adminResults.DataSource = dataView;
            fillDataFields();
        }

        private void adminResults_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            fillDataFields();
        }

        private void fillDataFields()
        {
            if (dataTable.Rows.Count != 0)
            {
                //dataRow = dataTable.DefaultView.
                dataRow = dataTable.Rows[adminResults.CurrentRow.Index];

                currentUser = new UserObj(Convert.ToInt32(dataRow["USER_ID"].ToString()),
                                          dataRow["USER_NAME"].ToString(),
                                          dataRow["PASSWORD"].ToString(),
                                          dataRow["FIRST_NAME"].ToString(),
                                          dataRow["LAST_NAME"].ToString(),
                                          Convert.ToBoolean(dataRow["ADMIN_PRIV"]),
                                          Convert.ToBoolean(dataRow["ADD_PRIV"]),
                                          Convert.ToBoolean(dataRow["EDIT_PRIV"]),
                                          Convert.ToBoolean(dataRow["DELETE_PRIV"]));

                userName.Text = currentUser.UserName;
                passWord.Text = currentUser.Password;
                firstName.Text = currentUser.FirstName;
                lastName.Text = currentUser.LastName;
                adminCheck.Checked = currentUser.Admin;
                addCheck.Checked = currentUser.Add;
                editCheck.Checked = currentUser.Edit;
                deleteCheck.Checked = currentUser.Delete;
            }
            else
            {
                currentUser = new UserObj();

                userName.Text = null;
                passWord.Text = null;
                firstName.Text = null;
                lastName.Text = null;

                adminCheck.Checked = false;
                addCheck.Checked = false;
                editCheck.Checked = false;
                deleteCheck.Checked = false;
            }
        }

        private void clearUsers_Click(object sender, EventArgs e)
        {
            searchUserName.Text = null;
            searchFirstName.Text = null;
            searchLastName.Text = null;
        }

        private void adminResults_Sorted(object sender, EventArgs e)
        {
            String column = adminResults.SortedColumn.Name.ToString().Trim();
            String order = adminResults.SortOrder.ToString().Trim();

            MessageBox.Show(column);
            MessageBox.Show(order);

            /*switch (column)
            {
                case "First Name":
                    if (order.Equals("Ascending"))
                        dataTable.Select(null, "FIRST_NAME ASC");
                    //dataTable.DefaultView.Sort = "FIRST_NAME ASC";
                    else if (order.Equals("Descending"))
                        dataTable.Select(null, "FIRST_NAME DESC");
                    
                        //dataTable.DefaultView.Sort = "FIRST_NAME DESC";
                    break;
                case "Last Name":
                    dataTable.DefaultView.Sort = "[LAST_NAME]";
                    break;
                case "Username":
                    dataTable.DefaultView.Sort = "[USER_NAME]";
                    break;
                case "Password":
                    dataTable.DefaultView.Sort = "[PASSWORD]";
                    break;
            }*/

            switch (column)
            {
                case "First Name" :
                    if (order.Equals("Ascending"))
                        dataView.Sort = "FIRST_NAME ASC";
                    else if (order.Equals("Descending"))
                        dataView.Sort = "FIRST_NAME DESC";
                    break;
                case "Last Name" :
                    if (order.Equals("Ascending"))
                        dataView.Sort = "LAST_NAME ASC";
                    else if (order.Equals("Descending"))
                        dataView.Sort = "LAST_NAME DESC";
                    break;
                case "Username" :
                    if (order.Equals("Ascending"))
                        dataView.Sort = "USER_NAME ASC";
                    else if (order.Equals("Descending"))
                        dataView.Sort = "USER_NAME DESC";
                    break;
                case "Password" :
                    if (order.Equals("Ascending"))
                        dataView.Sort = "PASSWORD ASC";
                    else if (order.Equals("Descending"))
                        dataView.Sort = "PASSWORD DESC";
                    dataTable.DefaultView.Sort = "[PASSWORD]";
                    break;
            }
        }
    }
}