VS 2008 Database Driven Application?
Jan 22, 2010
So. I'm making a tool for an online game called Shin Megami Tensei.In this game you can fuse Demons, depending on what family of the first demon you fuse and the second demon you fuse come from, and their levels, the outcome changes.This is unimportant though.
However, the application is driven by a database, the application consists of a Demonic Compendium (Index of the demons, including race, family, stats, levels etc.).This application is meant for usage by the community playing SMT, and here is the problem; a person without Microsoft SQL Server cannot run this application.I can't ask the community, some of which aren't very techy, to install Microsoft SQL Server 2005 Express Edition just in order to run this program.
You see my problem?Is there a way to get the program running on other computers that doesn't have MS SQL Server installed?
View 5 Replies
ADVERTISEMENT
Sep 2, 2010
I 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 Replies
Jun 24, 2010
I am trying to have letter templates (word documents) that are stored in sql server VarBinary(max) to be accessed via a web application where they will be edited and saved back to sql server by directors of our company. Then various managers will be able to select an existing template (word document), make any additions, and mail merge with a list of customers to print or save the letters.
I am looking to open up word within a web page much like you would an email in outlook, edit it with spell check and the like, and then save it back in sql server. I am able to get word to open from a file but it is outside of the web application in a separate word document. I am storing the word document in sql server but am unable to open it in word without having to save it to a disk (why should you have to go to a disk for viewing or editing?). I am able to programmatically mail merge but that is in a separate word application.
I am finding bits and pieces on the web but nothing that will pull things together such as embedding word but in a windows app not a web app. Mail merge from a file not from a database, converting a byte array to word in a directory but not on a web page.
View 1 Replies
Nov 27, 2011
I want to create a very simple (to begin with) database driven application. The company I work for have very kindly said they will host any SQL database I create, they have a remote server that we all connect to for files etc.
So I want to be able to create an SQL database that they can host and have my colleagues and I install the application local on our machines.
[Code]...
View 6 Replies
Jun 28, 2011
I am designing a desktop application that will be driven by local data. I am trying to determine the best way to accomplish this. The database would contain about 10-12 tables if I use a database and I would imagine no more than 10000 records in any one table (but honestly 99% of users would not have more than 1000 records). I am thinking about using SQL Server Compact.
Is this a good solution? I can certainly include this in my installation, but I am just wondering if anyone knows of a better solution? If this is the best solution, how would you suggest that I create the tables upon deployment? Should I just run "queries" with create table statements in them from my vb application or include a database file or what?
View 1 Replies
Jan 21, 2009
What is a event driven application.
View 2 Replies
Nov 15, 2009
I'm trying to construct a database driven VB.Net app that pulls a list of registered accounts from a database and displays the usernames of throes accounts in menu, so the user can select one and a new form open (where they work with it).what I have so far is the constructor for the MDI parent window.[code]What I want to happen is when a user clicks on the context menu a new MDI child form is created and the data in user is passed, however because AddressOf doesn't like passing data this doesn't work.I've looked at delegates and landa expressions but don't think either of them do what I need, the other option is to make my own subclass of the ContextMenuStrip class, which 1) handles the clicks the way I want to and 2) sounds like a nightmare.Before I launch into what I think will be a hell of a lot of work, am I missing something? is their a simple way to do what I want to do? or if not will sub-classing ContextMenuStrip work and if not any ideas as to what will (and if it will, any ideas as to how to start learning how to do that)
View 1 Replies
Jun 27, 2012
I am trying to match words driven from a database in a string input using VB .NET
The syntax I am using is so simple:
[Code]...
View 1 Replies
Jul 19, 2008
How To on a database driven login form. I'll include the Administration Backend to go along with it soon. Dial-Up users should not use this thread, it is image heavy
[Code]...
View 17 Replies
Aug 11, 2011
I hope I got all that in this question title. Let me explain. We are starting on small desktop app that will snowball into a big app with many forms. The database is SQL Server. It will have classic stored procs/functions performing classic CRUD functions. Given a table or stored proc in SQL Server what is the quickest way to create a form with all the hooks to maintain a table.
For e.g. lets assume I have table like this (most code below is pseudo code)
Table Employee
{
Name varchar(30)
DOB Datetime
Address varchar(100)
}
From this as source I want to create my Target which is form with 3 labels and 3 textboxes with add delete modify buttons (or OK button to add if not exists or modify if exists)
[Code]..
The code generation tool or technique that will be used should generate the correct db hooks (create SQL parameters, SqlCommand, execute sql.. basic try catch etc. Is there any open source tool to do this ? Some trick or templated approach via VS 2010 ? Worst case any third party tool ?
View 3 Replies
Aug 23, 2011
I'm another newbie with VB (2010) so please bear with me. I am attempting to make a method that is event driven by data threads on the Ethernet port. Simply put, the method is to wait until a data thread from a "Control By Web" 5-input device sends an "information update" data packet to the application, with the application then processing the information. This application is on a private, well controlled network, with no access to the internet. I have a method that is working right now reading data packets when invoked with a timer (see code below) but I really need it to be event driven.
' this is added at the top of the class
Dim tcplistener As New TcpListener(IPAddress.Any, ip_port)
'this is added in the "form1_load" module
[code]....
View 1 Replies
Feb 9, 2010
event driven programming
View 1 Replies
Feb 17, 2010
I am trying to build a dynamic validator for a data entry application. I want to be able to query a table for the validators relating to the current task and then be able to reference class properties based on the description of the validators returned.
ex. Validator = "person/firstname"
How do I get to _clsPerson.FirstName?
View 2 Replies
Jan 31, 2010
I'm new to programming and am trying to learn how to developed data driven application and was wondering which method is recommended? I know there are some debates out there but most of the books I have recommend using object binding, but it doesn't offer any concrete information on how to implement it. I went to MSDN and most, if not all, the documentations are on dataset. So I guess my questions is, object vs dataset, which do you use?
View 9 Replies
May 12, 2009
I am using VS2008 Pro. I have a simple DVD database built. I'm trying to make a data driven app to store my dvd collection.One of my tables is Actors and is structured as follows.[code]On a form in my app I have a combobox. I'm trying to make it list FirstName LastName ie. Will Smith. I know how to make a query that'll take the LastName and FirstName fields and list it as Actor. I'm having a heck of a time getting it to do that in the combobox as it'll only let me use one field for the display and won't let me use the query I've made.[code]I keep getting some error about schema don't match default query. I know I could simply change the table to only have one field that holds first and last name, but from what I understand that's not proper db practice. I've searched this site and google until I was blue in the face at looking at soulutions that don't match what I'm trying to do.
View 3 Replies
Sep 7, 2010
I am using a vb.net 2008 application with sql database on webserver , Can I run this application through Internet explore with static ip address i.e. Can I use this application on internet with static IP Address
View 3 Replies
Feb 24, 2010
i'm trying to make an application using ms access database. This application is for our class, simply to enter students data and institutions details. However, i got stuck with combo; here is my question and the application background?
I have a database named "StudentData" with table "StudentDetails" with "RECNO" which is Auto Numbered (and is Primary key) and a number of different fields which accepts Students Name, class, accedemic year and so on.
What i want to do with the RECNO is, i want to make a combobox which will be filled with the record number of the students, when i click on any number from the dropdown list, i want the other fields like the txtName (for students name), txtClass, txtACYear etc to be field with each RECNO they belonged to.
View 6 Replies
Mar 9, 2011
I'm still trying to understand and use Use Cases and Test Driven Development, but having a hard time crossing the line. I'm hoping someone can provide a good example of how setting a datasource and/or databinding a gridview could be accomplished using Test Driven Development. Here is my pseudo approach at it.
[Code]...
View 3 Replies
Apr 25, 2009
How to implement an observer pattern in VB.NET?
Currently I have a lot of working code in VB6 which the company wants me to migrate to VB.NET. Well, that would normally be straightforward ... yes? Unfortunately, not so in our case.... recently, our company decided that I need to modify it to implement the MVC (Model View Controller) paradigm to make it truly OOP and adaptable to TDD (Test Driven Development).
Currently, my move was to start with a simple one, opening a form and then grabbing a piece of text from a textfile and putting it as the caption of the form... now, that is easy.
The problem lies in trying to implement observer patterns ... in the observer pattern I cannot simply call the usual me.caption = mytextstream.ReadLine from the form_load event instead, I need to use objects that would use an interface to register themselves as observers as the form loads but not necessary having to be residing in the form_load event... in fact ... if there is somehow a way for me to make such a thing happen before the code goes through the form_load event then that would more completely separate the View layer from the controller layer which gets implemented through the use of observers and observer related patterns.
View 2 Replies
Nov 30, 2011
Public Class Form1
Class Member
Public Name As String
[code]....
This is what i have so far and its giving me headaches to fix it someone please help with this code assuming that the names and phone numbers of all members are stored in alphabetical order by last name , then by first name in text file residents.txt
View 1 Replies
Dec 16, 2010
i am about develop an application and i want to do the following.
1. use vb.net 2008 for the application
2. use mysql database as the database for the application
Question:
1. is it possible to package the application by adding the mysql database so that during deployment it will be installed as well eg. vb.net 2008 and access database can be attached and deployed without installing any file to support
View 3 Replies
Feb 17, 2011
I am trying to develop an application using VS 2008 connected to MySQL database. Previously in vb6 i was using adodb and now when i googled and got a few sample projects done using VS2008 in which most of the module codes were OLEDB.....To which method should i stick to...?
View 2 Replies
May 13, 2010
I have an application that uses an access database to fill datasets. My problem is that I have three related tables, when I add a new users to the customers table The parts table fills with data saved in the database with a cust_id of -1.
I discovered that this is caused by adding a part, not saving it and deleting the customer. I Can add code to stop the user from deleting a customer that has parts but I do not have access to the live database to delete the record that are incorrect.
Is there something I can do to delete the rows that have an id of -1 on the load statment?
View 1 Replies
Apr 13, 2009
i 'm develloping an application that uses a sql server database, in my computer where i'm programming i installed the sql server in the same language of the OS, in the tests of the application everything worked fine. Biut after migrating the db to the main server, the values went crazy.. After some research and tests, i saw that the language of the sql server was in english and that was the problem.
My language settings says that the decimal separator is "," and the agrupment digit it's ".", and the sql server works in the other way "." is the decimal separator and the "," it's the agrupment digit. In my code i was using the CDEC to pass the values to the DB, to solve this i removed the cdec and send the parameter as a string (So if i send 2,33 to DB with CDEC i get 233 if i send the 2,33 string i get 2.33). This works for now, but i don't know if in the future i'll have problems...
View 1 Replies
Jul 10, 2009
I'm building a multi language application, but in the application, there will be some data that will be retrieved from the db. In the db I have two tables (Access Groups, Teams) the two tables are related, there are some groups, that have teams, example (sellers can belong to team 1, team 2, team 3...). The data that will change it's the names for the access groups and the names for the teams. The only way that I can think to do this, is to have the different values for all the languages in the code, or some auxiliar file, and when loading the application I'll truncate the two tables and fill them with the current language values. By the way those values never change...
View 5 Replies
Aug 24, 2011
My application/project has an Access Database as its Project DataSource. I have a DataSet Designer (.xsd), with many TableAdapters, some of which I've created via the Designer. I have 2-10 users/foreman on any given workday, with their own Netbook and my ClickOnce Application.Users will add/edit/delete records in each of their own versions of the App/DataBase, XML files, representing changes, are created and upload to an ftp server.The corner I've painted myself into:When my Project Manager downloads these XML files using his own version of the application, analyzes each reported item, confirms and updates his version what is the best way to propagate those updates back to each user without having to update the project db and publish again?
View 4 Replies
Apr 10, 2012
I have recently developed a back end database in SQL server 2008 R2 and attached it to a application in VB express 2010.Everything works fine and when i publish the application, it works fine on my machine, but once i try to setup up the application on another machine i get the error message: A network related or instance specific error occurred while establishing a connection to SQL Server. Server was not found or not accessible please verify the instance name is correct or allow remote connections.I have read numerous forums on this saying about changing the connection string and instance name.but with being novice i dont understand what needs to be changed etc.The sql server allows remote connections, but i am unsure what else needs changing to allow the application to work with the database on another machine.
View 5 Replies
Oct 28, 2009
how can i use Ms-Excel as a backend database in visual studio 2008 applications, if is it possible
View 2 Replies
Oct 29, 2009
This is my first client server application using vs2008(vb) + sqlserver 2008. how can i hide my database schema,tables from application users through management studio..?
View 5 Replies
Aug 29, 2011
i am doing a small project for my business and i got stuck with this 2 weeks ago and still no progress.I have an access db table "store" that has columns: (filldate,brand,model,plateno,mileage,litres) where i am storing these info each time a car in my company fills gas. For example8/25/2011,Renault,Megane,5487844,3943,20).What i want to do now is to display in a datagrid the total consumption of gas (litres) with the kilometers driven (mileage) between 2 dates.
View 2 Replies
