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.

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

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

            catch (Exception ex)

Recommended Answers

What are the data types for Emp_ID and First_Name?

Jump to Post

All 2 Replies

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 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.