First off I would like to apologies for multi posting as I posted this on the SQL forum but someone did suggest putting it here. Here is my problemOkay have developed a form in vb.net cf using sqlce. I know this is the vb.net section but I feel it's a data issue. I have a table called STORES which has a primary key of two columns (ST_STORECODE & ST_CY_CODE)
View 1 Replies
i'm trying to display a certain row from a sqlce DB, what shuld the sql command be? i'm using sqldatareader
View 1 RepliesI am trying to add a new record to a table, well first it checks if there is already a duplicate record in the table, and if not it makes one. If there is a duplicate, it tells the user.[code]
View 2 Repliesi want to insert onto a SqlCe (sdf) a data that contains a birth date, it reads from a .csv the TextLine(5) is the date in string format: "ddMMyyyy"
i convert to a VB DateTime(), it converts at this way: Day/Month/Year.After that, i insert it to the sql, everything good but the problem is, on the database is always showing as 01/01/1900, what im doing wrong?
Also i put a Console.WriteLine to check if there is any error, no errors as i expected.
apadronado.fecnac is an DateTime also my provider is an cultureinfo is an en-US
[Code]...
I'm attempting to insert rows into an SQLCE database, and it's returning that 1 row is affected, there's no exception, and no syntax error in the query as far as I can see - but it's having no effect, when I look in the table from the Database Explorer.
Here's the code, though it probably doesn't make a difference:
Using conn As New SqlCeConnection(My.Settings.DietSafetyCheckerReportsConnectionString)
conn.Open()
Using cmd As SqlCeCommand = conn.CreateCommand()
[code]....
i have design a window base application by using VB.NET 2008 and use database SQLCE 3.5 SP1. The application is working fine on all the window 32bits system, but if executive on window 64bits (like windows Vista 64) come out this error message.
[Code]...
I have used Access databases before so thought I'd try something different. My problem is that when I try to add a new record to one of the tables in the databasethe code runs through fine, but the data is not added into the table :S have probably missed something simple, but it's been a while since I did any projects using a database.Here's my code:
Imports System.Data.SqlServerCe
Public Class Form1
Dim con As SqlCeConnection = New SqlCeConnection("Data Source=C:UsersMattDocumentsVisual
[code].....
I get an error using the connection string (url...) to connect to my SQL CE saying that "Provider 'Microsoft.SqlServerCe. Client.3.5' is not registered in the local PC.".In my project I have a table connected (with the wizard) to the same database and it works fine, but when i try to connect with my own code it FAIL. [code]
View 1 RepliesI have filled a DataSet from a SQL Server table and I have also set up synchronisation with a local copy (for offline use). The local copy is saved to a SQL Compact Editon database file.
1. Create the connection string to the SQLCE DB
2. Execute a stored procedure (a copy resides in the DataSet) against the SQLCE database
My app currently uses both SQLExpress and SQLCE, depending on the choice of the user.In my database class I have non query command objects for the CE connection and non query command objects for the express version.
Essentially, this is duplicating code as Parameters.Add etc. has to be repeated on both objects.Is there a way just to add do it once on a common object?
Dim MyConnection As SqlConnection
Dim MyCEConnection As SqlCeConnection
Dim MyNQCommand As SqlCommand
Dim MyCENQCommand As SqlCeCommand
I am having some issues with an application written in VB.net.
As part of a routine, an sqlce database gets backed up before the routine then if an error occurred gets restored. I am using system.io methods copy and delete.
I have released all the objects (connections, commands, datareaders) asscociated with the sqlce database by disposing them if they are not nothing. I also do a GC.COLLECT however when my delete command runs, an error message says it is open by another process. The PROCEXP.exe process explorer tool says it is attached to 4 undefined processes. After a while in debug mode, these clear and I am able to delete the file. However this is not acceptable as my program cannot "wait around" until they are released! I was under the impression that object.dispose forced an immediate disposal rather than waiting for the garbage collector to clean up (if you were just to use object=nothing), but still there appears to be a finite time before these objects are released.
My question is, is there an alternative way of checking (programatically in vb) for what is holding open an sqlce database (or in fact any other file for that matter) then killing these processes?
I'm about to pull my hair out on this guys I do not know where I'm going wrong but basically I receive a web request response formatted in XML and I need to insert that data into an SQLCE database. I have tried using LINQ queries but there are no matching ID fields to Join or Group.
View 3 RepliesI want to access the Windows mobile SQLCE database from the desktop application when device is connected to my PC.
View 1 RepliesIn the below code, it is supposed to load the data from the dataset, into the table, so that I can view and navigate the records.My problem is, that when the statement runs, it errors with:
System.Data.ConstraintException was unhandled "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."
Here's the code:
[code]...
I've been getting this error when I try and use my model container:
No connection string named 'PFModelContainer' could be found in the application config file.
I have my edmx file in a separate project. I checked the app.config file and my model was there, and I also put it in my main project app.config file. Still doesn't work. Here's the connection string:
<connectionStrings>
<add name="PFModelContainer"
connectionString="metadata=res://*/PFModel.csdl|res:
[Code].....
I've been messing around trying to get an INSERT statement to work, and because of this, it has created lots of records in my database that I dont need or want.
The problem is, when I open up the table by right clicking on it in the database explorer and selecting "Show table data", I click on the record I want to delete and the following error comes up in a message box[code]...
I have an issue that I can't seem to tackle. Going on 3 weeks. I have a VB.NET app with an sqlce 3.5 database. I have created several tables in this database. I have attached them to my form using DataSet then BindingSets and so forth. Done this many time before. VS automatically created a TableAdapterManager for me.I was having an issue getting the Refresh of the primary key value of a newly inserted row. Ok, find out that sqlce does not do big transaction, or multiples rows at a time, found Beth Massi's blog on how to work around this:Ok, got it somewhat to work, but I had to take one of the tables out of the tableadaptermanager so I can update it by itself so insted of doing this:
frmMain.Validate()
frmMain.bsRunInformation.EndEdit()
frmMain.TableAdapterManager1.UpdateAll(frmMain.DS1)
[code].....
I know VB is still very popular, but does Microsoft put the same effort into developing VB as they do for C#? Will VB eventually fade away?
View 3 Repliesi have a question regarding how to developed a multiplayer games using VB. i am a student and beginner on VB world.i managed to create a simple Sudoku game using VB knowledge from the internet and some books.I am fan of Sudoku games published in newspaper everyday.but now i really interested on how to develop the multi-player version using the same coding. is it possible?
i tried to write a script on developed tic-tac-toe for multi-player based from a book using VB6 for an example but got many errors. how to develop a simple multiplayer for Sudoku? i'm using VB 2008 Express Edition.
I have developed an application in Visual Basic 2008. I really love the product.I am 99% done but am hung up on a Publish issue.I know the Publish feature is not a full install program - but it handles downloading the application prerequisits so well I really want to use it.My problem is the Install path. It installs my application is the strrangest drectory appdatalocal 615252-191891-919 (goes on for ever)
I can set the install directory to something simpler. Would love to get it in Program Files but will settle for AppData if it can be a reasonable directory name. If I have to tell a customer to look in that directory for some reason I would have to read off about 60-70 alpha numeric characters for the directory path - that isn't feasable.
Getting some errors with a loop. It's a log-in app that has username, passwords & account type stored in a SqlCe database. I would like it to sync with a larger database for updates that has not been made so i left it out but I have started to make a loop that would connect it to the larger DB and if connection failed would try a set number of times before stopping the program. I'm coding this project with Visual Studio 08 pro
Dim conndb As New SqlCeConnection("Data Source = |DataDirectory|\Mydb.sdf")
Dim x, y, z As Double
x = 1
y = x + 1
z = 5
[CODE]...
Can we deploy an application developed in VB2010 to Linux or Max
View 2 RepliesI've developed a very small in-house web application with visual basic on VS2010. Can anyone give me any advice or literature s to how i can put the site on a server?
View 5 RepliesI have recently developed and finished a software in which works like aim.But here's the problem, the server worked just fine for local friends because they lived only 25 miles from the server, so it was lag-less.But when uploaded to a web host, it lags every time it pings the server.The server is in PHP, so there's no need to buy a dedicated computer for 400$/month more.Here's the function in which the client constantly calls upon:
[Code]...
I was thinking about recoding the getpage function so that it would connect to a TCP server and constantly wait for new messages which I am still not sure if this might cause a lag if the host is in the US and the client is not(for example). provide me a remedy to this problem?
I want to Set Culture for Windows Service that I developed. Can someone recommend me a good read for or how to go about it.So far I have I Tried to do the Following OnStart() [code]
View 1 RepliesI am facing problems these days. I have VB Express 2008 with 3.5 .Net Frame Work. I develop applications but my applications dont run on the systems those have 2.0 framework or lower.How can I make my applications to run on all kinds of systems
View 2 RepliesIt works on my own computer where I have visual studio installed. I install the exe file with installutil and the service works fine. But when I install it on another computer where only the framework is present, I still can install it with installutil BUT I can't start it. I get something along this Could not start the Search service on Local computer. Error 1053: The service did not respond to the start or control request in a timely fashion.[code]...
View 2 RepliesI ve developed a salary calculating software using vb.net.... Its working fine and i ve converted it to an exe file... My drawback is it can be copied and pasted in another system very easily... I want to generate a key for the exe file and while installing the key should be used and when installation is completed ,the key should not be used again
View 4 RepliesI have developed a windows application which performs a series of database operations like select, insert, update. I am connecting to Oracle database and its working fine in development system. But, when I deployed this application, I am getting error at StartConnection (which opens the DB connection). After installing OracleClient in client system, its working fine. Now, my question is that do I need to install OracleClient to every user? If so, it will be hectic to do so as its size is around 200 MB and its not possible to ask all the users to install it just for a small application. I have tried adding some OracleClient files like orannzbb11.dll, oraciei11.dll, iraops11w.dll etc. But in vain! Could anyone please suggest me a work-around or a way to accomplish this?
View 1 RepliesI developed a class with a function which checks the availability of a certain url (standart=www.google.be)
Option Strict On
Option Explicit On
''' <summary>
''' Returns a value indicating your ability to connect to a certain server url
[code].....
which automated the system. Is it possible to implement this completely in a class? (meaning the class ++ the application events part)
