Questions tagged [sql-server-ce-3.5]
74 questions
0
votes
1 answer
VB.net sql table not showing last rows
What I am doing-
Importing 406 rows into 5 sql tables from excel sheet.
After import, I am manually saving data one by one into each of the 5
tables on button click event and displaying on datagridview..
After saving each record, I am refreshing…
Steve
- 1
- 4
0
votes
1 answer
How do I show "NEXT" x items to the user?
I am learning MVC. I'm creating a simple website for demo, which stores products in Database and shows them to the user 10 per page. Now, how do I fetch "NEXT" 10/20 items from the database? I thought of adding auto-increment column to table and…
vish213
- 748
- 3
- 12
- 27
0
votes
3 answers
SQL limit error
I use this code in my project (SQL COMPACT):
"select Name
from Drug
where Name
like '" + Dname + "%'
limit 10"
Dname is a string value. The result is this error:
There was an error parsing the query.
[ Token line number = 1,Token line offset…
user2151285
0
votes
1 answer
Data Backup & Restore of SQL Server Compact 3.5 SP2 Edition?
Is data backup and restore functionality possible in SQL Server Compact 3.5 SP2 edition ?
I have developed and installed a C# desktop application which is working perfectly. My app can store and manipulate data.
Now I want to backup that data stored…
Zia_BD
- 1
- 3
0
votes
1 answer
Binding Issue WPToolkit ListPicker with SQL Server CE 3.5 DataContext Class Windows Phone 7.5
Well, well, this is my very first question in StackOverflow! I've been using this site since ages but I never had to ask something because I always found the answer in someone else's question lol Apparently this is not the case anymore lol.
Anyway,…
Snake
- 1
- 2
0
votes
0 answers
using IN condtion in SQL CE
How we can we pass list of values as parameters in SQLCE?
using the below code works (when directly passing list of values in query)
SqlCeCommand cmd = string.Format("Select VMID from Booking where (VMID in ({0})",
…
Ram
- 15,908
- 4
- 48
- 41
0
votes
1 answer
Working on SQL Server CE 3.5 file over lan for multiple users
I'm working on a project with C# (vs2010 environment) this project require a SQL Server CE 3.5 database for several functions. Working on a local .sdf for one user shows no problem but when I run my project with .sdf over network it gives me sql.ce…
Adir.el
- 43
- 2
- 10
0
votes
1 answer
Need help optimizing this query
I have a big problem with first run query form my SQL Server CE database.
I already applied this optimization Performance and the Entity Framework, but still first query take about 15 sec to run.
Something that I noticed when I run my application…
KF2
- 9,887
- 8
- 44
- 77
0
votes
1 answer
Entity Framework, DATALENGTH, SUM on different providers
SQL Server CE 3.5
SQL Server 2008
DataLenSumQuery:
SELECT SUM(DATALENGTH(Data)) FROM ...
On SQL Server CE the type of Data column is IMAGE
On SQL Server Standard the type of Data is varbinary(MAX), because Microsoft says IMAGE type for standard…
Didar_Uranov
- 1,230
- 11
- 26
0
votes
1 answer
How can I use a linq2sql database on wp7 mango, while maintaining blendability?
I'm trying to create a WP7 application using MVVM Light and SQL Server CE as a database. To accomplish this I generated a datacontext using sqlmetal.exe (1).
This works ok if I run the application on my phone. But when trying to display design time…
Tim
- 221
- 3
- 12
0
votes
2 answers
Having Trouble with Entity Framework. Adding a new row
Having Trouble with Entity Framework. I have been adding a new row to Iktato table but is not work.
CREATE TABLE [Iktato] (
[TIPACT] nvarchar(3),
[NRINREG] int NOT NULL identity(1,1),
[DATAINREG] datetime,
[NRACT] nvarchar(10),
[DATAACT]…
XYZ xyz
- 1
- 1
-1
votes
1 answer
How to connect ASP.NET Core Web API with SQL Server CE 3.5 database
I added System.Data.SqlServerCe.dll v3.5 in my ASP.NET Core Web API project, but I'm getting error while connecting to SQL Server CE database.
This is my code:
private static string DbFilePath = @"C:\Git\Forecaster\DB\THSTaxPro.sdf";
…
Ravindra Singh
- 11
- 1
-1
votes
1 answer
a parameter is missing. parameter ordinal = 1 dataAdapter
This is my code:
String client = textbox.text;
try {
connexion.da = new SqlCeDataAdapter("Select NOM_PRENOM ,NUM_FAC_CLI ,SOLDE_RESTANT ,DATE_FACT ,MODE_PAIEMENT from EXP WHERE NOM_PRENOM_CLI=@client ", connexion.objConn);
…
user3658555
- 17
- 1
- 5
-3
votes
1 answer
Cannot insert records into a SQL Server CE database
I cannot insert records into a SQL Server CE database. I have read lots of articles but I still did not receive a proper answer for that.
This is my code. Database is located in the bin folder of the project.
Dim strConnection As…
