Sql Server Database is not responding in random manner

• Prashant Baranwal

  Newbie

  Points: 1

  More actions

  August 11, 2012 at 3:01 am

  #264961

  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.

• rVadim

  Hall of Fame

  Points: 3969

  More actions

  August 11, 2012 at 10:59 pm

  #1524817

  Did you try to google the following phrase?

  System.Data.DataRowView does not contain a property with the name

  --Vadim R.