DataGridView and # in column names

Hi Dino,

The error gets thrown specifically because of the “#” character that’s present in your tables, because when you automatically bind the DataGridView, the dataset would try to prepend “col” to the column name and it’s an invalid character for an identifier.

The workaround would be to ultimately map the tables manually to a new binding source, or to just rename the table columns.
I guess setting everything manually won’t be an issue since the queries work fine.

Here’s a small example of what you can potentially do :

SqlConnection cn = new SqlConnection("\\your_connection_string");
SqlDataAdapter cmd = new SqlDataAdapter();
DataTable dt = new DataTable("your_test_table");
cmd.SelectCommand = new SqlCommand();
cmd.SelectCommand.Connection = cn;
cmd.SelectCommand.CommandText = "your_select_query";
cmd.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();

Best regards,
Alaa