Application - Direct It To A Database Through A Menu Where You Select The File
Feb 12, 2011
Ive been learning to use visual basic doing this and i know the code needs clearing up but i made an app that is storring values in an mdf mysql datatable. I made the app so you will direct it to a database through a menu where you select the file.. This works allright on my machine but..When i put it on another machine with .net 4.0 installed it still complains about Mysql problems..So im guessing theres a part missing. Is there something i need to install on the other computer using my app?.
If so what?. Maybe theres another way i can connect to a database without haveing to install stuff on other computers to make it work?.
'Imports System.Windows.Forms.DataVisualization.Charting
Imports System.Data.SqlClient
Imports System
Imports System.IO
I am trying to use the System.Diagnostics.Process class.I have the following Windows Forms application. It consists of 1 Button and 1 TextBox. The only code is for the button click event as follows.
Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim myProcess As New Process()
I'm making a VB.NET application with an SQL Server 2005 in the background. Naturally the user can not edit the database directly but will use a number of UI features to be able to add and modify the data.However, there are a few tables that should be easily accessible from the admin interface such as specific information about a vendor. What's the easiest way to let the user edit this data freely? One way would be to use a DataGridView but this could appear complicated to the user, plus I'm not sure exactly when to save the edited data back to the database.
The best way that I can think of is to create custom dialog boxes for adding, deleting and changing the information, but this seems like too much work for such a small feature.
I want to (SQL) select from a table in an Oracle database, and show the results of the query in the VB application, in a Excel like manner (rows, columns, selectable, etc.). Or in a SQL developer manner. How can I do that? Browsed through a lot of tutorials and howtos on the internet, did not get anywhere. I think (and correct me if I am wrong) that it's gotta be something with DataGridView. But I don't know how to create and populate a datatable with the result of as Select statement, how to create a dataset.
I am wanting to create a menu based on items in my MS SQL database i have 3 tables
FormTbl
FormID - Int Eg (1)
FormName - nvarchar(50) Eg (Form1)
[CODE]...................
I can get the form names to be populated in to the menu and can open it my question is how do i set where the menu items will be placed. Eg File with FormHierarch 0 will be the very first one. Exit with FormHierarch 0.1 will be the very first one under File
Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim menu As New MenuStrip() Dim dst As DataTable = User.MenuItems(Me.ToolStripStatusLabel1.Text)
What I need to do is link the EXE to a dll that is in another directory out there somewhere. But I don't want to use the assembly namespace. I want to be able to set the direct path to the DLL. So basically this is how its setup
J:\AppBar.exe 'The executable that will need access to the C:\testdlls\EnvVarsPro.dll 'The DLL that the executable needs to be able to find.
So far I've come to the conclusion that the answer lays somewhere in the app.config file. This is what I've got for code...
I believe this is setup write. The publicKeyToken is set to null because its not strongly signed and I'm not exactly sure what culture is just yet. But for whatever reason it just doesn't work.You can see a commented line that does work but only if the executable accessing the DLL is in the directory above root. In order to bring organization to my file structure I need to do it with everything kind of put away and not smashed into one directory.
ok got a excel export I need to down load.I must log into the site to get it, special not standard login so I can't automate that.But once I login, I can use a browser to download the file direct from a URL. Works great, but I need to make a program to do this download portion.
I am trying to use direct sound to play a wav file, so I may animate a picture box while the wav file is playing. I have made a device object and a secondary buffer object and when I run the program I get an error message(see attached image), but after I click continue, the wav file plays and it plays every time I click the play wav button. I am using a test project to work out the bugs before I implement the direct sound in my other project. Below is the the code I am using. Can someone tell me what I am doing wrong? The code needs a form named form1, and a button named xPlayButton.
I have my program set up with four buttons, each of which I would like to open a specific mp3 file in Windows Media Player when I click on it. I have WMP in the program already, but I can't figure out how to set the buttons to call up the specific files, and autoplay them
I am using the following Select Statement to retrive data from my .csv file database:
Code: Dim comm As New OleDb.OleDbCommand("Select *, Left([Street Full Address], IIF(InStr(12,[Street Full Address],'-')>0, InStr([Street Full Address],'-')-1, Len([Street Full Address]))) as StreetFullAddress From " &
I'd like to disable the 'Refresh' option in the right-click menu for internet explorer. Our application uses Javascript, ASP.Net and VB, but I'm sure it'll need to be done through Javascript.
I'd like to disable the 'Refresh' option in the right-click menu for internet explorer. Our application uses Javascript, ASP.Net and VB, but I'm sure it'll need to be done through Javascript
I have a menu strip. In the menu strip I have something for some saved urls in the database, I called it Bookmarks. So I'm trying to fetch the items from the database and have it load in to the menu items.. but it keeps adding items and I only want them added once. [Code]
I am trying to build a nice-looking menu that allows users to select certain items. When they hover over the items, a nice highlight color fades in and then out when they leave the item. Anyways, it looks very nice, but I don't want to have to use a "page" style. (e.g., page 1 contains 6 items, click "Next" to go to the next page of 6 itesm) I'd like to allow the user to scroll through the items. I'll develop my own GUI for the scrollbar, however I have absolutely no idea where to start on actually fitting all of the items into like a 400x200 box, and allowing the user to scroll up and down through the items. The items are actual controls (e.g. each item contains a picturebox, a couple of labels, a couple of buttons collectively).
I connected to the Informix server using RazorSQL, created a stored procedure and tested it, getting the expected answer, so the procedure exists in the database in some form.
I then run the following code:
If ConnectToInformix() Then Dim cmd As New IfxCommand("dc_routeHasOutstandingQuantity", conn) cmd.CommandType = CommandType.StoredProcedure
[Code]....
This error does not occur when calling the stored procedure from a live SQL connection.
i m a vb.6.0 developer and now turned in vb.net. so i m new in vb.net.My problem is given below.i opened the word documents in webbrowser control and it is just showing a document page with rular. But my main problem is that i want to open whole word documents with tool &menu bar in webcontrol. i used the following code which is given below.
WebBrowser1.Navigate("C:dharmchandBlank.doc")i wrote this code in form_load events and when i run my application then it is showing just a page with rular. But not showing Menu bar & Standard or Formatting toolbar.
What I'm trying to accomplish is for the user to select a menu item(New Tester) from the MainForm(only used for menu)to open the NewTesterForm and enter a rating from 1 to 10( 10 being the best) for two different drinks. When the user clicks the ok button on the NewTesterForm it adds the new rating to the totals. It keeps adding the rating totals until a user clicks the cancel button which returns to the MainForm. When the user clicks on the MainForm menu item Summary, The SummaryForm opens and displays:
-average rating for each drink which drink had a higher rating(the name of the drink)the total number of testers
I am writing an application using Visual Basic Express 2008 and I need the right and the left mouse click to both act like the left mouse click. That is the right mouse click should not display a menu of any sort and be able to select items just as the left mouse click.
I've got a right-click menu that comes up in a treeview - with an option to ADD to that parent node or delete a child node.
Currently I'm using the SELECTEDNODE - but what I really want to do is change the "selected node" when the right-click occurs. But I'm having a hard time seeing how to do that...
How do you use this event properly??
Private Sub CapabilitiesTreeView_MouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles CapabilitiesTreeView.MouseClick Me.CapabilitiesTreeView.SelectedNode = End Sub
I have this problem, I can create a setup for my app/database but everyone can open the backend file which is an MS Access database. I want it so we can only access the database using the frontend app.
I have an application that I'm creating that uses VB6 for the maintenance programs, and visual studio 2005 to create the reports. At work we use reporting services to host the reports, but in my application I want to run the report from a menu within the application, not in reporting services. (A) Is this possible? I think I've read about a report viewer that can be embedded into .net applications. If I create a menu system in .net, that shells to execute the maintenance programs that are from vb6, or fires off the report viewer, does this sound feasible? The application is supposed to run connected to their SQL 2005 server via a VPN; I get blank looks when I ask them if they have reporting services installed...
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
I was able to create an application in VB.net that talks to a SQL Server CE database.Now i want to deploy this application using the publish feature with clickonce.An issue im having tho is when I install the application on another computer it keeps looking for my sql server on my development pc.
Ive added the .sdf when i package my solution but its still an issue.How do I change my connection string to connect to the .sdf file that I included in the package? this is my current connection string which looks at the sql server: connectionString = " Data Source=CHRIS-PCSQLEXPRESS;Initial Catalog=ce_db;Integrated Security=True"
I have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
I have made an app and I want to add it to " open with menu" sub menu which appears when user make right click on any file ie I made photo viewer app and I want to add it to "open with menu" so user when make right click on any photo and go to "open with menu" sub menu will find my app name to chose it to open the photo with it
