System Data Sqlclient Sqlexception Invalid Column Name Id

[Solved] System Data Sqlclient Sqlexception Invalid Column Name Id | Vb - Code Explorer | yomemimo.com
Question : System.Data.SqlClient.SqlException: 'Invalid column name 'id'.'

Answered by : cheerful-cobra-3nd3dgylte6m

//column name = regno
//Incorrect
sql = "Select id from Carreg order by id desc";
//System.Data.SqlClient.SqlException: 'Invalid column name 'id'.'
//correct
sql = "Select regno from Carreg order by regno desc";
//Change "id" into "regno". Then it works fine.

Source : | Last Update : Thu, 12 May 22

Answers related to system data sqlclient sqlexception invalid column name id

Code Explorer Popular Question For Vb