Hello everyone,
I've created a database in MS-SQL and used it in my application.
But sometimes it doesn't responds randomly and throws an exception System.Data.DataRowView' does not contain a property with the name 'service_name' while the column is in my table.
Later on I've been dropped that DB and again created a new DB with new name but the problem remain persist.
But this issue has not been occurred with the other existing DBs.
I'm using this connection string:
<add name="testCon" connectionString="Data Source=Comp1;Initial Catalog=TestDB;Persist Security Info=True;User ID=test;Password=test;" providerName="System.Data.SqlClient"/>
and using this command on code behind
"select t.id, t.service_name from dbo.[Table_Name] t"
By using this command I'm filling a Drop Down-List and above prob raises.
This works properly on SQL but occurred at front-end
Please provide some proper solution ASAP.
Thanks in advance.