Stack Overflow
Stack Overflow

Questions tagged [sqlcedatareader]

29 questions
2
votes
1 answer

How to Escape special characters in Microsoft SQL CE

NB: I am using Microsoft SQL Compact Edition 3.5 I have a table of users.I have the display name as user input and I need to query all the user whose display name matches the input. select TOP (1) * from users where display_name like 'Abby…
Able Johnson
  • 551
  • 7
  • 29
2
votes
1 answer

WinCE7 0xc0000005 Native exception on Execute reader

I am developing a simple application for Motorola MC32N0 on WinCE7.0 using VS2008 SP1 having .net Compact Framework 3.5 and SQL Server CE 3.5SP1. Whenever I try to read from database I get this error. A native exception has occurred in…
Ali Umair
  • 1,386
  • 1
  • 21
  • 42
1
vote
1 answer

C# SqlCeDataAdapter not updating values from database when calling Adapter.Update() after changing values from datagridview

i have a code which contains a local database 'database1.sdf' along with table 'Employees' with some values. I am adding all rows from database to a datagridview using Datagridview.Datasource property. All rows are fetching from table! Fine! when i…
Lazy Programer
  • 171
  • 1
  • 1
  • 12
1
vote
1 answer

Group two database tables

I have a database with two tables Table 1: Members Member1 Member2 Member3 Member4 Table 2: Groups Member1 | Group1 Member1 | Group2 Member2 | Group1 Member3 | Group1 Member3 | Group2 Member3 | Group3 Member4 | Group1 Member4 | Group2 Member4 |…
ola
  • 11
  • 2
1
vote
1 answer

Fastest way to query SQL Server CE database file in Windows Mobile 6.5?

I have a large .sdf database file on windows mobile device that I need to query. The file has 40,000 records. I am trying to cut the time it takes to execute the query. Currently it is about 8 seconds, which is a lot of time for user to wait for the…
22332112
  • 2,337
  • 5
  • 21
  • 42
1
vote
2 answers

Connect to an older version of SQL Server Compact database without upgrading

I am using VS2013 to connect to a .sdf database file and am getting this error: The database file has been created by an earlier version of SQL Server Compact. Please upgrade using SqlCeEngine.Upgrade() method. Here is my code: string…
user2985419
  • 553
  • 3
  • 9
  • 23
1
vote
1 answer

Passing a property in a generic way?

I'm reading an SqlCeDataReader and assessing values like so: if(reader["abc"] != DBNull.Value) Abc = (int)reader["abc"]; if(reader[dude] != DBNull.Value) Dude = (string)reader[dude]; int Abc { get; set; } string Dude { get; …
meds
  • 21,699
  • 37
  • 163
  • 314
0
votes
0 answers

SQL Server CE : reading performance

I use a SQL Server CE database for some simulation results. When I test the reading speed the benchmark-times differ greatly. dbs are split to 4 .SDF files (4 quartals) 302*525000 entries overall four SqlCeConnections they are opened before reading…
c_ph_r
  • 207
  • 3
  • 13
0
votes
0 answers

How to write a query in SQL server CE to check data before updating?

I'm trying to write a query that can compare each row of a DGV with SQL Server CE and if there were any row that its first and third column is equal to one of SQL rows, do nothing and if there were no duplicate value, then add that complete row to…
Alex
  • 33
  • 7
0
votes
0 answers

Generating RDLC Report of General Ledger in C# windows Form Application

This is the screenshot I have taken from Accounting software and I want to create a similar type of report using C# Windows Form Application, I have a data against all account numbers, What I think of is running multiple quires for all account…
mumerarif
  • 1
  • 2
0
votes
1 answer

SQL Query returns wrong boolean result

Good day guys, I am developing an windows form app using VB.Net. 1 part of my app will accumulate data from a csv file into a local database. I had written a function where I can check whether the particular entry exist in the local database before…
Hari
  • 718
  • 3
  • 9
  • 30
0
votes
1 answer

VB.NET Application using SQL or Local DB

I'm working on an application and am trying to offer the ability to use a "Local" database or a SQL Server database. What I'm trying to work out is the best Local DB format to use and how to write the queries. At the moment i have been playing with…
Stephen Pefanis
  • 305
  • 1
  • 3
  • 16
0
votes
3 answers

How to use one combo box to filter results for another in C# with a local database

I've spent a good bit of time searching the internet for an answer and can't come up with anything. Basically I have a very small database that consists of 5 tables total. My problem right now deals with just two of the them though. I have one…
B_Martin
  • 13
  • 4
0
votes
2 answers

Fatest way to insert data in Sql Server CE

I have been working on C# Compact Framework 4.0 for my product. I have an server and an mobile and i have to synchronize all the data from the server to my mobile device . Usually around 6000 entries will be inserted into my mobile device on an…
user3383301
  • 1,891
  • 3
  • 21
  • 49
0
votes
1 answer

How to connect to local sdf file?

I'm creating a simple windows C# form application. but I cannot connect to local database file (.sdf) i'm using using System.Data.SqlServerCe; This is my app.config file
Sachith
  • 191
  • 1
  • 7
  • 15
1
2