I want to concatenate Emp_ID and First_Name column but it gives multistep error. my other table works fine except for the EMPLOYEE table.

try
            {
                con.Open();
                ds = new DataSet();
                dt = new DataTable();
                ds.Tables.Add(dt);
                cmd = new OleDbCommand("SELECT Emp_ID + First_Name FROM EMPLOYEE", con);
                cmd.CommandType = CommandType.Text;
                dAdapt = new OleDbDataAdapter(cmd);
                cBuilder = new OleDbCommandBuilder(dAdapt);
                dAdapt.Fill(dt);
                bind = new BindingSource();
                bind.DataSource = dt;

                dataGridView1.DataSource = bind;
               // dataGridView1.Columns[0].HeaderText = "ID";

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

What are the data types for Emp_ID and First_Name?

Number for Emp_ID and Text for First_Name

Be a part of the DaniWeb community

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