I create my database with SQL server management 2005 Express and i must connect my application elaborated with VB.NET2008 express when i go Tools-connect to database a window appeeas;it demands to set database name But the problem is: i create my database with windows authentification and i don't know the path of the database
View 1 RepliesWith VB.net, I'm coding a simple application to get more used to the new .Net format.
I'd like to save all the information to a 'new' database file. how to create a database on the fly, once that is done i'll be able to connect to it no problem, but actually creating the file is proving difficult to work/find out.
Also, with vb.net and the newly created custom file, how can it be made to automatically open that information with the program?
Is there a method in installation to associate the file type with the new program? How can i check when the program loads if a database file has been 'double-clicked' (rather than just running from the .exe of the program) and proceed to load the data?
EDIT1 - Extra InfoThe windows application has many different fields and content etc, then i need to save that to a file that could later be loaded by 'double clicking'. I assumed the easiest way would be to create a mini-database for each unique file
which method is more efficient to use: DataAdapter and DataSet Or DataReader when importing data from a certain database table???
View 6 RepliesI'm Using Visual Studio 2005 and Mysql Database to create a windows application. The datagrid displays all the records. Since I don't know how to directly update from datagrid, thats why I have used textboxes for the respective datagrid fields. A load button is provided which on clicking puts the data on the respective textboxes. The data can be edited in the textbox. Problem is that I can't save this edited or modified data back into dattabase.
[Code]...
i am trying to create a program that connects to a database and shows table fields in listview in windows form i manage to do that but i want now to have a button to take the total of a column in a list box ,lets say from the column "money"?
View 9 RepliesWhen I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 RepliesMy question is does Visual Basic 2008 Express Edition provide a way for you to create a SQL Server 2008 Database using the Database Explorer ?
View 2 Repliesdoes VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 Repliesi am doing project of Order Accepting system for five star hotels.Scenario is Waiter will accept order using Window Mobile which is Connected to WiFi present in hotel.I want to communicate to database(Sql Server) present on My Machine (Computer present in kitchen) through WiFi and Add order into table present inside database. This should notify my application present on Compter and should print order. After completion of Order Application from kitchen will notify to waiter about completion. My problem is How to Communicate with database present on Remote computer using WiFi from windows Mobile.
View 2 RepliesI have produced an application which works with datasets but I now wish to provide the user the ability to add and admend records within the database.But i wish to do this in a seperate form.My current dataset instanciates classes onLoad.Should i try passing the Dataset to the new form class? although I have the problem where by when i pass the dataset to the form class using code below i get this problem:[code]Should i just create a create a new connection to the database and produce a new dataset for this form? or is there a better way to do this?
View 2 RepliesI'm working with .NET 3.5 and Nunit 2.5.10. I'm attempting to write some tests to validate our role-based security enforcement through the PrincipalPermissionAttribute at a class-level. The test appears to succeed (it gets a green checkmark) and the Assert.Throws call properly catches the exception, and all my other assertions about the exception pass. However, once TearDown is complete after a test has run, the exception is re-thrown by NUnit. So even though the test "passed", every one of the tests shows that an exception was unhandled exception was thrown 'while executing' the test run.
I'm guessing I'm doing something wrong, but can't figure it out. My test is:
Public Sub New_TheForm_NoRoles_DeniesAccess()
' attempt to create a new instance of the form, but it should throw an exception with an inner SecurityException
Dim ex As TypeInitializationException = Assert.Throws(Of
[Code]....
Basically, Initialize is normally called in the application with Nothing so that we use the Windows Principal. During unit testing, we instead initialize it with a GenericPrincipal that has no roles, so that we can test that a SecurityException is thrown.
The tests are passing, but NUnit just seems to be re-throwing the exception post-Teardown.
I am having two databases for the same application , one in windows and the other is web based.Since web based one have few functionalities I can't opt for a single database.At the same time I want to share Both databases to be updated with other's data so as to work error free with my module of appointment fixing.
View 2 RepliesOn my VB project, I used a third party software to make setup files which gives me option to install the application as per user's choice, however in windows 7 when the application is installed under Program Files/Application Path, the MS Access database that I have within it does not work, it becomes as read only due to UAC of windows 7. Is there anyway to get rid of the UAC by VB code which I can add to my application?
View 4 RepliesIs somebody having problems accessing a sql database in windows 7 64 bit?
View 5 RepliesQ 1- how can create a c or C++ Graphics program in windows 7(32-bit).
Q 2-- how can create connectivity to database in windows 7(32-bit) and which office packages(2003,2007,2010). Windows 7 can not create connection to data base through source code but a same windows xp project is open on windows 7 and create connection here. [ Dim a As New Main
[Code]...
I have a database app that I wrote in VB6 a while back that uses Access as the backend. I have installed the app on Windows 7 pc's and all works fine....most of the time.On some pc's I see an issue where if I replace, rename, or even remove the DB, my app (b/c of something to do with Windows 7) still sees and reads the information from the old DB. It seems no matter what I do, I cannot "remove" the .mdb file from the system. As one can imagine, this is making it very hard to replace the outdated db with an updated version. I never experienced anything like this running the app in the XP environment.
View 3 RepliesFinally got my hands on a windows phone 7, for development (Samsung Omnia 7), nice machine. I normally develop for WM6, which always you to connect to an sqlce database, I've found that in WM7 no database is available, what are my options XML, my own database etc,
View 3 Replieshow to create a database programmatically in VBtajinder
View 3 Repliescreate a SQL database from .net?
View 11 RepliesI have an FTP website that I created using Visual Web Developer 2008 Standard and I'm just now needing to store some data on it that would be accessed and modified by my winforms app. I added an SQL database to the website but found that an addon is necessary from the hosting service that I use that costs $ 10 a month. I was considering creating my own non SQL database.
For those of you that know about this subject do you think that it wouldn't at all be worth it to try. Should I just pay the extra $ 10 a month and use my SQL database or should I attempt to create my own non SQL database. If I did create my own non SQL database what are your suggestions. Could I make it secure and what would be the best way to communicate between my winforms app and my website database. The data I would be storing wouldn't be that much: User email addresses, some 12 character codes and a few other things perhaps.
I have been reading all about filling controls with information from the database but I can't find anything that really covers the simple question.I want to create a database with 4 different table names. Each table will be holding information from information the end user submits on my form.All I need in the database is tablenames so I can have the corresponding datatable control column on my form display data that is populated through my application.
View 1 RepliesI'm new to this VBexpress and programming but I would like to learn it.I have tried to follow avideo from Beth Massi on how to create database
at some point she right kliks and choos relationship.I dont have that at all...I cant even rightklik nad have something to choose..I can se that in the video there is an older version of VB and SQL.
How to create a database for medical shop database. m also getting the error unable to fit in memory.
View 3 RepliesI am using VB.Net in Visual Studio 2008 with a connected SQL Server Compact Database but for some reason I can not get a record to insert into my Database from my Windows Form.I have used the data connection on the form already to populate a couple of combo boxes but when it comes to commiting the data the sub runs through but there is no additional data in my database.my code is as follows
Private Sub cmdAddQuote_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAddQuote.Click
Dim cnData As New SqlCeConnection
Dim cdData As SqlCeCommand[code]......
Teh table only contains these 4 fields and another field which is an automatically generated number called nbrQuoteID .All of the fields are number fields but I have tried sending them as text to see if it made a difference (Threw up an error) but it didn't.
I have some problems with a vb.net application. My application was perfectly working on XP, but now on my windows 7, each time I want to connect to localhost, I have a driver problem (in french, that's why I don't put it here)...
View 1 RepliesI have a problem with connecting to a server which is another machine. When I try connecting to my machine with the following code, it works fine:
'connString = "Data Source = .sqlexpress;" & _
'"Initial Catalog = one;" & _
'"Integrated Security = SSPI"
[code]....
1. I have a windows service type of application that first creates a database on the local SQL server (and a table). It then starts putting data into the table.
2. This works fine when running as a normal application but due to permissions, when it is run as a service, it can create a database but then fails to connect to it to create the Table. I understand that because its a LOCAL SYSTEM service, SQL might have problems but why does it let it create a database but not a table?? .
3. Is there anyway I could hard code a USER NAME for this database my application creates and then use it to get in? As it uses an exclusive database, I don't want to prompt the user for an SA account (and their sql may not be mixed mode).
I'm a first time visitor and poster, but I'm definitly going to stick around. I'm running an old version of Visual Studio .Net Academic 2002 and the .Net framework 2.0. I'm stuck on an issue regarding the deployment of a few programs I've thrown together. They all work fine on my development machine, but the problem they all use SQL Server databases, and I can't find any specific help on deploying a windows application with a database on a machine that isn't set up basically just like my development machine.
I know that I need the .net runtime bootstrapper on the target machine, so I can run basic programs that dont use SQL databases. That's no problem. But what about programs that make heavy use of databases? How does one go about deploying it on target machines? Is there a SQL server bootstrapper?
[Code]...
I'm using VB.NET 2008 (framework 3.5). I would like to check permanently if a new entry (row) is added to a table in particular, (is there some equivalent of the FileWatcher for DB ?...)
View 4 RepliesI have done alot of work over the years designing MS Access DB's, but its getting to be problematic with end users needing to have access installed to use them. also if the MDB files have OLE's the file can get very large. I tryed using FoxPro years back and it sort of worked as long as we didnt use OLE's but I'm behind the times with that also. I'm currently not sure where to start, I have decided on a beginner style Dtabase project but need to know some things and then will need some help. Heres my requirements.A single Form, with multiple textboxes, about 6. i will list the names and such in a moment, it would be nice to have search, and images, some buttons too. I basically want to use the layout I use right now in Access but I want to code it from scratch.
Now I need to know what is the better way of going about this, Do I use a MDB Access file and go ahead and setup a table with all my fields, or Do I need to use SQL? Just a note I have never used SQL. Now I need to be able to save my SQL/MDB file for backup purposes.One of the problems with this DB is that while a user is keying in parts, if they run into a new manufacturer, they have to close the Data Entry form, open the manufacturer table and add them manuall then return to the data entry form. its slow and can cause issues . When I messed with VB DB's before I never could get the crystal reports thing to work at all. now I would like to add a textbox/field for picture, it will only host the image location eg. c:DBimages image01. jpg..You Know Your Addicted To Computers When - Your main computer is a 7 terabyte, Core2Quad 3 Ghz +, with 4 or more gigs ram, over 200 programs installed, and you would rather sit with it programming than go to the movies!I've got 13 PC's in the House and 7 are in my bedroom and my main one exceeds this set of stats.