.net - How do I make SqlServerCe accessible from my C# app? -


I was just playing with database in C # 2010 Express and 'system.Data.' The complete thing showed me the system as an alternative to the SQLSCECCEC. Not sure what I did, but when I created a new app and added 'line using system'. Data.SqlServerCe; 'I got a "SqlServerCe is not present" error I tried to add some references but still does not work. Actually, whatever I am trying to do is connect to any database, but I still do not I could find that all samples do not know me, I do not know. I'm trying to connect the connection string with the SqlConnection by setting it to what I can imagine, but I get the errors I installed the SQL Server compact version, and I think I have the SQL Server (normal version?) Please feel disappointed! I want that very, very simple. I want a data table, I do not care where or how I store it because there is only one program that will use it, it is my program, and able to do SQL queries on it. Actually I do not even need to save it after the program is closed. If I can do SQL queries on them, then I will only use a datatable or 2D array. Please be great if you can give me a sample

If you have any error using that statement , Then you have to add the reference of that assembly.

On my XP box, its location is:

  c: \ program files \ Microsoft SQL Server Compact Edition \ v3.5 \ Desktop \  

You see that using VS2010, simply change 3.5 to the directory name with 4.0 .


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -