I have googled around for the connection string to connect with Sql Compact edition database. but i really have no idea how to do that. furthermore i dont know how to connect a form's fields to that database.
if i wana use ms sql server 2005 and dotn wana use sql compact edition then what i have to do?
I'm doing a project with vb.net (smart device) on visual studio 2008 and I need to connect to a database on the device itself (I do not have a physical device to test, only emulation). How should I go about doing it? I would like the database to be in the device on start up.
View 1 RepliesI have made a SQL Server Compact Edition Database File (.sdf) and created tables inside. However as I am new to SQL Server I don't know how to connect to the database using VB .NET.Code I have now:
Dim sqlcn As New sqlconnection()
Dim sqldataset As New DataSet()
Dim sqlda As SqlDataAdapter[code].....
I recently loaded my copy of MS Visual Studio 2008 Standard Edition, with Visual Basic, on to my new laptop, one with a Windows 7 operating system. This version of Visual Studio had been on my other laptop, a Windows Vista machine. When I attempt to run any of my Visual Basic applications which has a MSFlexGrid container on it, I get this error message "Unhandled exception has occurred in your application... The error is: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG). Also,
View 2 RepliesI am building a VB 2008 Express Edition application.I have built a database (with a single table) using SQL Server Compact 3.5 and have connected it to the project. I am able to view and edit the data using a DataGridView on a second form (tutorial made this very easy). I need to work with the data in the table within the application. how to easily load the entire table into an array or even read the table a row or cell at a time so that I can make all of the data available for manipulation within the application (the tutorials only seem to show how to display the data).
View 7 RepliesI have "Visual Studio 2008 Standard Edition" and "Crystal Reports XI Developer edition".I have to integrate crystal reports in my application. I am fine developing the reports using the "Crystal Reports IDE" but not sure on how can I integrate those reports into my application.I have downloaded and installed the reportviewer control but not sure how to use it for crystal reports.
View 1 RepliesI cannot get the VB monthcalendar control to obey any of the properties I set for it, or the commands I give it programatically. It works (sort of - but with obvious bugs) in the state it arrives when copied to a new form straight out of the toolbox, eg when I click on a date etc, however if I set the background colour in Properties (or programatically), or try to change the BoldedDates programatically (as per numerous examples I have found) it ignores me!
I can create a brand new project, new form, add the monthcalendar out of the toolbox, change its properties in the Properties window, & when I run it the changed properties (eg background colour) are totally ignored.
first of all sorry if this is not the right place to post this question. yesterday i bought Microsoft visual studio 2008, so as to develo web application, then i installed it in my pc. after installing it in my pc, i have seen microsoft Sql Server 2005, in my start menu programs. wow that is nice, but now i want to create database and then connect it with visual studio 2008, so how can do that? this is my frist time to use sql server, so where can i create tables and databases? and how can i connect it with visual studio 2008?
View 2 RepliesI would like to access to a SQL Server Database from my Visual Studio project.
I have SQL Server 2005 Express Edition installed on my PC and I have a database with some tables.
In Visual Studio, I open the Database Explorer and I try to create a database connection.
The Add connection dialog box proposes to enter a database *file name* but I cannot select a database *server* and a database *name*.
Perhaps, is it a restriction because it is a free version ?
Within Visual Web Developer 2008 Express Edition, I can select a database *server* and a database *name* !
I have Windows Vista Business on my machine and running visual studio 2005 (Version 8.0.50727.867 (vsvista.050727-8600)) as well as "ENU Service Pack 1 (KB926601)" and "Update for Microsoft Visual Studio 2005 Standard Edition - ENU (KB932232) "I'm trying to connect to SQL server 2008 Express via Visual Basic and I've gone through all the forums to try to resolve my issue and it seems that I have to install " Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support" However, when I try to do this I keep on getting the error "The upgrade patch cannot be installed by the Windows Installer service because the programme to be upgraded may be missing, or the upgrade patch may update a different version of the programme.
View 9 RepliesI'm using an MS Access database which has password (database password, not a workgroup or smth). I'm using 13 characters - with no special signs- only letters. When I try to open the DB from access it works fine, but when I try to run my Windows Form application from Visual Studio Connection String, I get a message that "Not a valid password".
[Code]...
I am trying to run this sample code [URL] I added reference to System.Data.SqlServerCe in project. I get the following error?
SqlCeException was unhandled
There was an error parsing the query. [ Token line number = 1,Token line offset = 8,Token in error = FROMUsers ]
myDA.Fill(myDataSet, "MyTable")
What is the difference between professional vs enterprise edition of visual studio.
View 2 RepliesI have Visual Studio 2005 Standard Edition. Can this be upgraded to Visual Studio 2005 Professional Edition, rather than purchasing a newer set of Professional Edition?
View 4 RepliesI couldn't find a quick answer on the official pages,is it possible to write VB projects in the express edition of Visual Studio that connect to a SQL Server that is not the included 'Express' server ?
View 1 RepliesI am having trouble using T4MVC VB with Visual Studio 2010 Express Edition.I can reference the T4MVC classes in my controllers, but I cannot access them in my views (where I actually need them).In the view, the following code is overwritten by intellisense as if the class MVC is invalid.[code]Which generates the error message 'Home' is not a member of 'Mvc'. It seems that in the view there is an Mvc namespace hiding the MVC class. This doesn't exist in the controller.After playing with it some more, it seems the classes aren't available in the View no matter what they're named. What decides what classes and namespaces are available in the view? The classes continue to be available in the controller, regardless of naming as well. I presume there has to be some filter or limit on what is available in the views?I was just watching this excellent video from Phil Haack, and it game me a clue.I need to modify the <pages> section in the web.config file. Now the question is, can I get that to use a class that's not in a namespace, as the MVC class is by default, otherwise I'll have to modify the T4 template to put it in a namespace and include that.
View 1 RepliesI am a visual basic developer and I use Microsoft Visual Studio 2010 Ultimate Edition. I've been making applications that can play only in my PC because it requires .NET Framework 4, which is not installed at even Windows 7 nor Windows Vista nor Xp. So, I decided to use Visual Studio 2008 which uses .NET Framework 3.5 SPI. It still doesn't run in common PCs. I believe it is pointless building applications that can perform only on programers' PCs. Is there any way to avoid using 4 or including it for the installation. I also downloaded .Net Framework 4.0 from this location [URL].. on a XP computer and my app couldn't perform because it was 3.5 SPI.
View 5 RepliesI have Visual Studio 2010 installed on a 64-bit OS with Crystal Reports for Visual Studio 2010 (obviously 64-bit edition as well). When I installed the runtime, their installation notes stated that if you develop 32-bit applications, you need install the 32-bit runtime, which I did. Testing the application and all is well.
However, this application is going to be distributed as x86 and x64. Now I have not yet converted my project to 64-bit, but should I now install the 64-bit runtime? How is this going to affect my 32-bit installation and report designs?
Secondly, when I distribute my application to the end-user, will they also be required to install the Crystal Reports runtime? Also according to their installation type (32-bit/64-bit)?
Lastly, I want to convert my project from x86 to x64. I understand you set this option by Build > Configuration Manager > (project) x64. Is it ok if I duplicate the entire project folder contents and setting only the duplicate project as x64?
How do I deploy my project in visual studio 2010 express edition? I dont see any setup and deployment template
View 6 RepliesI finally figure out where I could get the imagelibrary.I downloaded the 90 trial version of Visual Studio 2005 Professional Edition: [URL] opened the .img file with winRAR, did a search of the img file for *imagelibrary*.I was able to extract the imageLibrary from this without installing the trial version.Not sure where it was supose to extract to so I put it in:C:Program FilesMicrosoft Visual Studio 9.0Common7VS2005ImageLibraryI can find this folder in the form design and so far, it's working with my version of C# Express.
View 5 Repliesmake VBE add ins for Office using .Net?Detail:Using Visual Studio 2005 Team Edition targeting the .Net 2.0 platform with C#
View 4 RepliesI want to connect visual basic 2008 or 2005 to sql server using connection string or something elsejust like in VB6 I'm using a connection string but here at VB express i dont know =(Is there a way just like in asp.net to have connection string using?
View 1 RepliesMicrosoft Access 2007 A Students.mdb database file Visual Basic 2008 Express Edition. I was informed that one can connect to Access files with ease from the Express Edition and most of the tutorials on the internet also show this however I am encountering a problem.
I open Visual Basic 2008 Express Edition Start a new project, with a form, and then click on the Data window, and add new data sources from the Data menu.
I click on database. The problem starts with the data connection. I click New Connection Change the Data Source from Microsoft SQL Server Compact 3.5 to Microsoft Access Database File and instead of then leading back to the other window (as happens on the tutorials for me to browse for the mdb file). Another window pops up asking me to Add a Connection.
It has the data source listed as Access and asks for a Connection String under the misc section. I type in
CODE:
When I click on Ok I get this error: Format of the initialization string does not conform to specification starting at index 0.
The Test connection button works and says connection success whether the Connection String field is empty or not but when I click OK it still gives me the same error. So I can't leave it blank either
So basically I can't connect to the Access database since I can't change the connection type and it won't just let me browse and add the file anyway.
connecting to and manipulating a microsoft access 2007 database using code in visual basic 2008 express edition. It's for a project I'm doing for University that's due on the 12th of October:S.
View 12 RepliesIm looking for some advice on the deployment of an application using SQL Compact Edition.My application will only be used by two people on two separate desktops with file sharing enabled.My goal is to deploy the application and have the .sdf file located on one of the desktops in a shared folder. So the other person using the app can connect to that database too.What is the best way to setup the deployment of this so that I can place the DB in lets say c:DBMyDB.sdf
View 5 RepliesI'm development an application in vb 6.0 with SQLCE but when I try to make an update in a table I recive an error 3251 or -2147217887 (80040e21) [code]...
View 1 Repliescan the code below be modified for use with a SQL Server Compact edition DB? Public Function Querymode1(ByVal SpecifiedYear As String) As DataSet
'Dim DBConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=charlyX;Persist Security Info=False;Data Source=c:mydata" & DBName)
Dim DBConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=charlyX;Persist Security Info=False;Data Source=" & Trim$(MitsSetUpFile.MainDataLocation) & "" & MDBName)
[Code]...
Will i be able to successfully install 2010 beta 2 side by side 2008? because i want to test 2010 features and some development toolkits such as silverlight while i don't want to uninstall my visual studio 2008 professional.
View 2 RepliesI have a Visual Basic project and when working and modifying code, the compiler will crash and then a message will say something like "Microsoft visual studio encountered a problem and was shut down." I've tried editing code from the solution and the project. Both produce the error. Usually occurs when adding an "IF...Then..." condition. May work for hours but then crash. Solution will compile and build.
View 3 RepliesI am trying to do multiple joins within a single query in SQL Server CE. I know that SQL Server CE doesn't support multiple SELECTs but I can't find any information on multiple INNER JOINs. I keep getting token errors on ProjectItemMaster (after the FROM) and the first INNER JOIN. Warning this is a big ugly query used to generate reports.
[Code]...
If I can't uses multiple INNER JOINs I can I break the query down into a number of different queries but I would prefer not to. So it is easier to maintain a SQL Server CE and an SQL Server version of the program.