Cannot find namespace 'System.Data.SqlServerCe'

c# asp.net visual-studio-2008 sql-server-ce
Jack picture Jack · Jul 15, 2012 · Viewed 62.7k times · Source

I did include the System.Data.SqlServerCe dll, put using System.Data.SqlServerCe; in my code, but when I open the .NET page I get:

The type or namespace name 'SqlServerCe' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

I have nave no idea how to fix this. Thanks in advance.

Answer

Shiham picture Shiham · Jul 15, 2012

This can be solved confirming following 2 points:

  1. Check whether you already have System.Data.SqlServerCe namespace added to the References folder of your application. If its not there you may right click the References folder and select Add references option. From the popup window go to .Net tab and select System.Data.SqlServerCe from the list and click OK to add the namespace to the project.
  2. If you are OK with step 1, add using System.Data.SqlServerCe; to the top of your code behind file which uses the System.Data.SqlServerCe namespace.

Related questions

How to set session timeout in web.config

I have tried very hard but cannot find a solution on how to set session timeout value for in-process session for an ASP.Net web application. I am using VSTS 2008 + .Net 3.5 + C#. Here is what I wrote by myself to …

Read More
Access cell value of datatable

Can anyone help me how to access for example value of first cell in 4th column? a b c d 1 2 3 5 g n m l for example, how to access to value d, if that would be datatable? Thanks.

Read More
How to add New Column with Value to the Existing DataTable?

I have One DataTable with 5 Columns and 10 Rows. Now I want to add one New Column to the DataTable and I want to assign DropDownList value to the New Column. So the DropDownList value should be added 10 times to the …

Read More