BackOffice Database Application FrontEnd
Jan 15, 2011
I'm working on a project where there will be a MySQL database containing data that will mostly be displayed on the web using PHP. However, there is a need here for a back-office data entry application (linked to the same MySQL database) that is feature rich and easy to use.what I'm trying to understand is where we are at with web-based frontends. I find that there are still so many events and features that I can make use of in a Windows Desktop GUI written in something like C#, VB.Net or MS Access. I don't have a lot of experience programming UI for web but it's my impression that it's still more difficult and takes longer to get similar or the same functionality using non-MS web technologies (I dislike ASP.net, sorry) as compared to programming the desktop portion in a traditional desktop application language like C#, VB.Net, or MS Access.
jQuery and jQuery UI are definately making things easier. Also, there's very rich online applications like Google Docs and Zoho but it's my impression that these are programmed by some of the top web UI programmers around, not to mention that it takes longer to write it and intensive testing to make it work in all of your target browsers. It also takes extra time and code to "block" browsers that don't meet the requirements.I know I may not have given enough information here but I'm not sure what I'm missing. If you have questions just leave a comment below so I can edit this post and answer the questions.
View 1 Replies
ADVERTISEMENT
Sep 14, 2010
I would like to create a windows forms frontend application to some command line utilities.
1. How can I launch a command line program with arguments from a vb application?
2. How can I pipe information that is returned by that program back into a textbox? Such as status information.
View 4 Replies
Aug 1, 2011
Im trying to develop a frontend for a database project I have been working on, I am using a combobox to select a meal_name and need the primary key to update another table for orders, How can I retreive the primary key using the meal name selected.below is the code I am using to add meal names to the combobox
Private Sub ComboBox1_MouseEnter(ByVal sender As Object, ByVal e As System.EventArgs) Handles ComboBox1.MouseEnter
Dim myRow As DataRow
Dim CmdStr As String[code].........
View 4 Replies
Oct 26, 2009
I have some really nice Python code to do what I need to do.I don't particularly like any of the Python GUI choices though. wxPython is nice, but for what I need, the speed on resizing,refreshing and dynamically adding controls just isn't there. I would like to create the GUI in VB.NET.I imagine I could use IronPython to link the two,but that creates a dependency on a rather large third-party product. I was perusing the MSDN documentation on Windows IPC and got the idea to use sockets. I copied the Python echo server code from the Python documentation and in under 5 minutes was able to create a client in VB.NET without even reading the System.Net.Sockets documentation, so this certainly doesn't seem too hard.
View 2 Replies
Jan 27, 2011
The small company I work for just started using this command-line software and it's rather confusing and tedious. I was wondering if it would be feasible to make a GUI frontend and how I would start going about it.If possible, I would like to have it get data to fill in dropdown boxes and such, but at the very least I'd like to be able to hit a button and perform whatever task.
View 1 Replies
Jan 17, 2012
I begain in 1971 learning TRS-80 Model III Basic language...later taught myself Lotus 1-2-3 and then DBase. Later, graduated to Visual Basic Stopped at VB 6.0. Now I need to move up to VB 2010...I have been programming for our company for sometime and use VB 6.0 as a front end for numerous Access DB applications.Can you recommend a good book (or books) out there that can help me with using VB 2010 as a frontend for Access?..just need the basics to be able to make connections, query the tables, return the data, update data, etc.
View 6 Replies
Jun 17, 2009
I am writing a GUI frontend for varius console programs and i am in need of assistance... the CHKDSK.exe program is causing trouble.I am using this code:
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim argstr as string = "F: /V"
Dim p As Process[code].....
This code works for ALL other programs i have tried except chkdsk... i also tried using this loop for reading:
While
p.StandardOutput.EndOfStream = False
RichTextBox6.Text = RichTextBox6.Text & Chr(13) & p.StandardOutput.ReadLine()[code]....
View 3 Replies
Sep 22, 2009
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 Replies
Jan 20, 2011
In vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
View 2 Replies
Jul 20, 2011
When I install my application, some forms are unable to connect to the database.
I say some because, when my login form works totally fine. Authentication happens.
But once I go into the main application, and open other windows, I start to get these error mesages:
[URL]
View 4 Replies
Apr 8, 2010
i need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
View 2 Replies
Oct 31, 2009
I have made a database application that uploads a database via FTP here is the code:
Code:
note this line:
Code:
ContactDB.mdf is the database in my application what would i have to insert for it to upload the database i have tried it as it is and its failing i could locate its full path on my machine that works but what happens when i want the application to go on someone elses pc?
View 4 Replies
Jul 21, 2006
With 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
View 3 Replies
May 11, 2009
I need to code a program that makes use of a database. It's gotta be for a local business, so I chose a pub lol. The database has the following columns: Beverage; Cost; Total number of sales; Income.
What the application needs to do is basically work as a cash register. Each beverage gets its own button, each click on the particular button displays the total due that the customer has to pay.
That, and the same button has to edit the database fields and update them or add to the values.
View 1 Replies
Jun 21, 2010
i m trying to write codes for new user to fill in the form, then the new data will into my database,however, my codes doesnt work, i cant figure out what's wrong with my codes. below are my codes:
Imports System.Data.OleDb
Public Class NewUser
Inherits System.Web.UI.Page
[Code].....
there is no error encounter, however,the adding is failed and no new data can be add in.
View 4 Replies
Apr 1, 2011
so this is more of a question about application security.Say I have a application that authenticates to a database. The Users table has the following fields: UserID, UserName, Password,Salt, Active, Permissions.
The permissions field will be related to another table called "Permissions" that has a unique ID and it describs the level of access the user has to the system (reporting, add/remove users, etc).Now the question is, when the user autheticates and executes an action on the application that requires a certain level of permissions, is it better to have a class the holds an authenticated user or is it better to have the application query the database for the users permission level?
View 1 Replies
May 4, 2011
i have published my website...its a dynamic site..so i have database connectivity..now i want to make an application in VB to update my database using my application..i mean i do not want to login to the site and update my database rather update it using my application..i want to connect my application to the database of the published site and update it from anywhere i want using the application...is it possible??
How can i do it??Please point me to the right direction...its urgent.
View 3 Replies
Nov 15, 2010
My application has an access2007 db as its database. I am trying to create a backup/restore utility in my application that allows the user to take the backup or restore the database file "StudentsData.accdb" which is in the application folder. I tried the filecopy method but it gives me an error saying that the "file is not accessible, as it is being used by a process." I believe it is my application process that is using the file.
How do I stop my application accessing the database? I have database connections which i have written in code and all of them close with their respective forms.
View 6 Replies
Aug 7, 2010
I am looking to make a small application which uses 3 stages of combo boxes to filter results into subcatagories. Once the filtering is selected - I want the user to be presented with some advice, maybe even a small picture.I want the application to gather its information run from a database which will be network based via a mapped network drive on our network. There may only be 4 colums in that database. I want to be able to update the database as required.
View 3 Replies
Jan 23, 2010
I am not sure what I am doing wrong I can connect to my database on my personal computer yet I am unable to have someone else use it without getting an error. system.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, This works on my PC so I am not sure what I am not including in the project when I compile or what?
View 4 Replies
May 13, 2010
i have 1 database in sql server and i want to encrypt database. and i can connect to this database by my application
View 2 Replies
Jan 13, 2009
I am trying to create an application that needs to have a database. I would like to know which one you recommend using. I have programmed in php using mysql but I do not think that is feasible for a windows application. I want something that does not have to install something else with my application.
View 32 Replies
Jun 5, 2011
i have a problem with using vb.net application, i want to take backup of my database from my vb.net application so that user clicks the button and backup can be copied in a drive .
View 1 Replies
Sep 8, 2009
I have VB 2008 and SQL 2008. I need tutorials to teach me how to create and connect, update, delete alter etc a Front End VB app to a SQL2008 DB.
View 6 Replies
Jan 21, 2012
Ive spent AGES trying to get my application to connect to a SQL database finaly it works but now i have no idea to view specific records or add records ANY help would be brilliant
[Code]...
View 5 Replies
Jun 7, 2011
I have connected my vb .net forms to the MYSQL database but when i comes to publishing, i do not get the database on the published application.
View 4 Replies
May 5, 2011
I integrated my database in my web application. Previously I was just referring it to SQL server 2008 by defining a connection. Everything worked fine data was being fetched, calculations are done. Now when i integrated my database in the web application, problems arose.
Dim cost3 As Double
cost3 = Dataset.Tables(0).Rows.Item(0)(0).ToString
The problem is with this the error says: Cannot Convert type String "" to double. Before no such problem showed.
View 2 Replies
May 3, 2011
Please how do I link my database to the application?
View 3 Replies
Nov 3, 2009
I want to Make DATA Base Application ! Who Save DATA in XML?
View 6 Replies
Nov 19, 2011
i want to have a built in database for my project this is what i did so far, i placed the mdb file inside the project
[Code]...
View 1 Replies
