ado.net

  1. A

    Specific cast is not valid in linq query when compare two tables

    Problem Error display in linq query "specific cast is not valid" at System.Data.DataRowExtensions.UnboxT`1.ValueField(Object value) at System.Data.DataRowExtensions.Field[T](DataRow row, String columnName) LinqQuery give error var query1 = (from x in table1.AsEnumerable()...
  2. 1

    Question Dynamically Insert single record into MS access from SQL server

    Hi ALL, I have two databases(SQlserver and MS Access) with same schemas (same tables). SQL server database has data but Access has no data (blank database). My goal : when user enters a ClientId and click insert button then I need to retrive that single record from all tables in sql server...
Top Bottom