Search DaniWeb - sqlce

SQLCE 7 Years Ago by kim_boto Hi, i would like to know if it is ok to use SQLCE for a big software like SCHOOL MANAGEMENT SYSTEM or LIbrary Management System. If NO. Why? Thank You for your help.. Re: SQLCE 7 Years Ago by rubberman Try a major SQL DBMS such as MySQL or Postgres. They are free, and are better than SQLCE. Re: SQLCE 7 Years Ago by rproffitt > February 2013, Microsoft announced that SQL Server Compact Edition had been deprecated. Many systems need longer life spans so your choice to start with a deprecated product. Issue with SQLCE query 14 Years Ago by anoop4real Hi, I have an sqlce query where I dynamically constructs the string by appending different …+null" ideally the result should be Pepsi but the sqlce interprets it as "null" and hence my query… Re: Issue with SQLCE query 14 Years Ago by Momerath Show your code where you get and construct the query string, it will make it easier to understand and help you :) Re: Issue with SQLCE query 14 Years Ago by anoop4real [QUOTE=Momerath;1320375]Show your code where you get and construct the query string, it will make it easier to understand and help you :)[/QUOTE] Hi, I just put a null check for the subname for the whole query and fixed the problem, but I had to duplicate the code. -anoop Problem adding rows to database 18 Years Ago by student_help … the moment I am trying to add rows to a sqlce database accept i have an bug in my code which… Web synchronization with SQL server 2005 14 Years Ago by Tunisien86 … new directory select default website ->next->in Alias: SQLCE-> 2 messages appear successively OK OK-> next->… Inserting GUID into datatable 14 Years Ago by bchaney … primary key. i'm using vb 2010 .net framework with sqlce server making my datatables. the column is AutoNumber which i… Password Authentication for windows forms 13 Years Ago by AlBars … db error in my dbqueries class file. I am using sqlce for testing purposes. [code] public DataSet Login(string Username, string… Why Dataset bound Datagridview not showing latest data from Database 13 Years Ago by jazzyb I am creating one application visual basic and sqlce I have two forms name Form1 and Form2. I used … Save(store) TabPage 13 Years Ago by stevesharp … that you can't serialize interfaces. I'm using a SqlCe database but I couldn't find a way to store… Datagridview changing cell values on leave 13 Years Ago by bogenbroom … the others are fine. I have 2 tables in an sqlce db. the first is books(id, title, copyright) and the… ExecuteResultSet using vb.net and sql server2008 10 Years Ago by kdejan87 This is writen using vb.net and sqlCe. I'm interested how this could be written in SQL server 2008 and vb.net. Dim rs As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Updatable Or ResultSetOptions.Scrollable) DataSource on windows mobile 6 (cant connect to sqlce database file [sdf]) 17 Years Ago by SGiorgos Hi, I am currently developing an application using vb.net 2005 and windows mobile 6 sdk,and sql server ce for my database. I try to connect to the database i created using the following code: I get an identifier expected error pointing the dot[.] .The code is this [INLINECODE] ("Data Source ="[B].[/B]\ MyDatabase.sdf;"")[/… Re: DataSource on windows mobile 6 (cant connect to sqlce database file [sdf]) 17 Years Ago by williamrojas78 Hi I think the problem is that the syntax of your command is wrong. You have: [CODE] conn = New SqlCeConnection("Data Source =".\ MyDatabase.sdf;"") [/CODE] it should be: [CODE] conn = New SqlCeConnection("Data Source =.\ MyDatabase.sdf") [/CODE] I use this and it works. [CODE] dim data_base … Re: DataSource on windows mobile 6 (cant connect to sqlce database file [sdf]) 17 Years Ago by SGiorgos [QUOTE] "\Program Files\My App\MyDB.sdf"[/QUOTE] is this relative to the windows mobile path(emulator) or the local computer path ? Re: DataSource on windows mobile 6 (cant connect to sqlce database file [sdf]) 17 Years Ago by williamrojas78 This is relative to the PPC (mobile device) path. That is the location of the database in the PPC - I use the same directory as my application. Re: DataSource on windows mobile 6 (cant connect to sqlce database file [sdf]) 17 Years Ago by SGiorgos Hi, Thank you . Now the path seems to work. The other problem is I cant add data to the database. The code I use is: [code] Dim MyConnection As SqlCeConnection Dim sqlstring As String = "INSERT INTO Titles VALUES ('2','1','0')" Dim data_base As String = "\Program Files\vbdata\vbdata.sdf" … Re: DataSource on windows mobile 6 (cant connect to sqlce database file [sdf]) 17 Years Ago by williamrojas78 Hi your code is not executing the command (i think); try this: [CODE] Dim MyConnection As SqlCeConnection Dim sqlstring As String = "INSERT INTO Titles VALUES ('2','1','0')" Dim data_base As String = "\Program Files\vbdata\vbdata.sdf" MyConnection = New SqlCeConnection("Data … Re: DataSource on windows mobile 6 (cant connect to sqlce database file [sdf]) 17 Years Ago by SGiorgos hi, I have also tried the code you provided with no luck again :/ Re: DataSource on windows mobile 6 (cant connect to sqlce database file [sdf]) 17 Years Ago by williamrojas78 Hi I just noticed that you are missing the field names in the sql command, you have: [CODE] Dim sqlstring As String = "INSERT INTO Titles VALUES ('2','1','0')" [/CODE] and it should be: [CODE] Dim sqlstring As String = "INSERT INTO Titles(fileld0, field1, field2) VALUES ('2','1','0')" [/CODE] I just tried it on my … Re: DataSource on windows mobile 6 (cant connect to sqlce database file [sdf]) 17 Years Ago by SGiorgos thnx a lot, everything is working like a charm :) The net thing now is how to query the emulators database :p ( i mean through visual basic query manager ) . Because when i insert data through the emulator and then close the emulator the database is not stored anywhere . thnx again :) update sqlce commandbuilder 16 Years Ago by cpopham I am trying to learn VB .NET again. Have not used in a long time. I have bound my controls to my datatable and then I put values into the controls, I then have a button that I am trying to get to add/update the rows to the database. It acts like it works fine no errors or anything, but whn I look at the table data after the update, it is all null… Re: update sqlce commandbuilder 15 Years Ago by WaterboyVB Hi All, Has anyone figured this out? I currently have the same issue, when I attempt an INSERT INTO or UPDATE it updates a dataset and not the SQL CE Server itself. Any help is appreciated. Re: DataSource on windows mobile 6 (cant connect to sqlce database file [sdf]) 15 Years Ago by clj1973 I am trying to do a similar thing with VB 9 and win mobile 6. when the button is clicked i want to run a query against northwind.sdf. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim data_base As String = ".\northwind.sdf" Dim dap As SqlCeDataAdapter = New … Re: Database Connection in Visual Studio 2005 17 Years Ago by fkatan I use visual studio 2005,sqlce & datagrid to view and edit data but I couldn't add or edit data in datagrid would u pls. help me thanks Re: Mobile Application - SQLserver2005(sp3)+CE+IIS_SUBSCRIPTION ERROR 15 Years Ago by Paua … out [url]http://social.msdn.microsoft.com/forums/en-US/sqlce/thread/fb5cb5fb-c7ef-44e3-802d-ca00f2a8c439/[/url] NEW ERROR: (Sql… Re: vb.net help codes 14 Years Ago by kvprajapati |[URL="http://social.msdn.microsoft.com/forums/en-US/sqlce/thread/dc31ea59-5718-49b6-9f1f-7039da425296/"]DataDirectory[/URL]| is … Re: vb.net database connectivity throrgh windows form application 14 Years Ago by kvprajapati [b]>it gives no error but when i open my database table to see the inserted data it is not working.[/b] Connection string with [URL="orums/en-US/sqlce/thread/dc31ea59-5718-49b6-9f1f-7039da425296"]|DataDirectory|[/URL] will write any changes at database under the Bin\Debug.