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