Click here to Skip to main content
15,886,362 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace FileManagerTool
{
    public partial class adminInterface : Form
    {
        public adminInterface(String Username)
        {
            InitializeComponent();
            passValueLbl.Text = Username; // tut55 passing the value
            load_table();
            computerTime.Start(); // For ComputerTimer
        }
    }
    DataTable dbdataset;
    void load_table()
    {
            string constring = "datasource=localhost;port=3306;username=root;password=1412";
            MySqlConnection conDatabase = new MySqlConnection(constring);
            MySqlCommand cmdDatabase =
            new MySqlCommand("Select eid as `Employee ID`," +
             "name AS `First Name`," +
             "surname AS `Last Name`," +
             "age AS `Age`," +
             "user_name AS `Username`," +
             "password AS `Password` ," +
             "gender AS `gender` " +
             "from `database`.`edata`;", conDatabase);
            // Select * from `database`.`edata`;  
            // Select eid,name,age,user_name,password from `database`.`edata`;
            try
            {
                MySqlDataAdapter sda = new MySqlDataAdapter();
                sda.SelectCommand = cmdDatabase;
                dbdataset = new DataTable();
                sda.Fill(dbdataset);
                BindingSource bSource = new BindingSource();

                bSource.DataSource = dbdataset;
                edataGridView.DataSource = bSource;
                sda.Update(dbdataset);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }
        private void searchBox_TextChanged(object sender, EventArgs e)
        {
            DataView DV = new DataView(dbdataset);
            DV.RowFilter = string.Format("name like '%{0}%'", searchBox.Text); // !!ERROR!! //
            edataGridView.DataSource = DV;
        }

What I have tried:

i have tried few syntax, which i notice when i type somethings in the textbox its show a error which could not find the column name in the database, any help would be appreciate 
i have stuck from this error for few week
Posted
Updated 18-Jan-19 20:16pm

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900