I am new for working with vb dot net. I have developed sample project with Ms.Access data base and some pictures I have a doubt on how to package. If you have answer ,sent me a step by step procedure. I have to some custom installation also.
View 1 Repliesi did this code:
[Code]...
but this also did not take the user to the contents of Sample Pictures folder (i.e,the pictures present in that folder) when he clicks the button.
I am trying to read and save data into a access Database but using the rows and colunms valeu can
View 1 RepliesHow would you add data source to your combobox from a combobox that is connected to the access atabase?they are both ın the same form of course and the software language ıs Visual Basic. I ve got two comboboxes that I need to connect with eachother combobox1 is showing the "itemsonsell" from the "table_items" table from my access database, the second one should show the "prices" value from "table_items" depending on which "itemsonsell" item is chosen on combobox1,I ve done the solution below,but it didnt seem to be working,it is showing all the "prices" that are under the "table_items" table's "prices" class.
[Code]....
I need to connect Access 2007 Data base using VB.net application. (This is an AddIn working underAutodesk Inventor 2012 64 Bit).When I use a ODBC DSN (under C:WindowsSysWow64) I need to compile the application with targetas x86. But Inventor 2012 64 bit needs target as x64 or Any CPU. So ODBC - DSN not working. When I tried OLEDB as "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=database.mdb"It returns with an error Microsoft.Jet.OLEDB.4.0 not registered.
Provider=Microsoft.ACE.OLEDB.12.0; Data Source=c:database.accdb;Jet OLEDB:Database Password=password;"
This also gives the same error.
[code]....
Dear reader i have one problem,that is how to store the images in access data base from by using web cam ?
View 1 Replieshow i can make a connection of data base with access
View 1 RepliesHow to allow duplicate,orif I enter a duplicate, to display Msgbox.
View 2 Repliesi'm developing an application vb.net with mssql server as database. on my pc it works. but i don't know how to make it works on my customer's pc.anybody have some tutorial regarding the creation of a setup and deployment project with ms sql server.my first doubt is: how can i determinate the right connection string?
View 1 RepliesI am an old VB2 programmer and in the process of moving up. In VB2 I could obtain a data row via and index on an access table. I can not find an example on how to do this. I can retrieve a single row using a query, but an index would be faster. I know in Oracle use can use a hirt to direct the query to use the index.Here is what I was during in VB2 (Sample) with no hint.
Set Stock_Tbl = "DataBaseName".openTable(Stock_Tbl_Name)
Stock_Tbl.Index="Symbol_Idx"
Stock.Tbl.Seek="MSFT"
[code]....
I want to capture images and store it in access data base in vb.net 2005
View 4 RepliesI would like to build a base class for my SQL Data Access Layer. I have most of it based out, but have a question about how to handle errors within the base class. I have a method for ExecuteNonQuery, ExecuteReader, ect...
[Code]...
I downloaded some VB 2008 sample project from the net.Initially they seemed to run fine. But then they stopped running. They fall over when an attempt is made to connect to the northwind database. The error messge says something like "the sql or sql express and the northwind database has to be installed ". Which of course they are .
One possible reason that the code stopped working is that I tried to move the SQL on my Pc from one drive to another ( I moved it to another hard drive using cut and paste ). When I realise the Vb code had stopped working I simply reversed the above procedure, i.e cut and pasted back to the original drive.I think I should also add that there any different versions of sql on my PC, and I think the one that I cut and pasted is not the one used by the sample project.
Have built a project and associated it with a Setup&Deployment Project. The S&D project needs to contain 2 main folders (under User's Desktop) with various formats of files (xmls, txts, dlls) inside them and several subfolders. How can i copy/import these 2 folders and there sub-files/folders into my s&d project?
When adding them in the usual way, they are copied and defined a source path onto the current pc. You can understand what errors this might create when an another targeted pc does not contain those files to the exact location. Is there any way to copy them locally or somehow import them?
I am hoping that somebody here is familiar with the book, "Doing Objects with Visual Basic 2005" so this question makes more sense but I will try and ask it in a way that makes knowledge of the book irrelevant.The book contains a sample project that I am trying to use as a "framework" for all my new projects. The project shows you how to read and edit objects to and from a database and that part works great. The author then leaves the new and deletes up to the reader to do, which is a good way to learn. However I am having trouble with the it. My problem is that I am having trouble implementing my own ProcessNew InterfaceI think this is how it should be:
Public Function ProcessNew() As Boolean Implements IMDIChild.ProcessNew
Dim myGoal As Goal = TryCast(GoalBindingSource.AddNew, Goal)
myGoal.Goal = rtxtGoals.Text
[code].....
I wonder if it is possible to find a specific row and specific columns in data base file (Access) . You see , I am using a DataGridView control to show only SOME of the columns (fields) of a table from an Access file . For example , lets say that in the DataGridView control I only show the following fields :Field1 , Field2 and Field3 .Now , when the user selects an entry in the DataGridView control , I want to insert the text from Field4 into a text box on the form .
The problem , however , is that I don't know how to get the specific row in the data base file and also I don't know how to get the text in column (field) Field4 of that row .One thing that might be important is that the index of the row in the data base file is not necessarily the same with the index of the current row in the DataGridView control . This is because in the DataGridView control the rows are order by the contents in the ID Field .ol .
I have tried to find the sdk ('Windows Software Development Kit') mentioned in the 'GIF Encoder and Decoder Sample', but there are so many SDKs I can't find the one I need. I am using visual Studio 2005 Standard Edition on Windows XP. The language I program in is VB. Can someone point me to the right SDKs for the sample and OS and VS version?
View 3 Repliesi'm new at vb.net (though i have extensive vb6 experience and oracle experience), and i need a sample program/project which uses multiple queries (of the same oracle database namespace) to display counts in text boxes.user will use a pull down list to select action from there.
View 1 RepliesHow to implement Twain OCX in VB.NET project for scanning or loading pictures?
View 1 RepliesI have a web site project in which I added a "Class.vb" file to hold public functions/procedures/variables. I'm trying to access a function within this file from my code-behind file from an aspx page. I've called the Class file "Module1"; Publc Class Module1.[code]...
View 3 RepliesI want to publish my vb.net project, but when I publish the project, there is no access to database. It is showing error : "System.Data.OleDb.OleDbException: Could not find file 'C:\Documents and Settings\Administrator\Local Settings\Apps\2.0\N3WEXXZN.DE6\JHJXMQC9.9N6\mara..tion_c355efc190f94c5f_0001.0000_d27846b1540f4a39\EventsTable1.mdb'."
I am giving connection string as
"Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & My.Application.Info.DirectoryPath & "\EventsTable1.mdb"
OR
"Provider=Microsoft.JET.OLEDB.4.0;Data Source=|DataDirectory|\EventsTable1.mdb"
Why this error is occuring? Is there any other way to provide database path?
I am working on a Project which uses SQL Server,Crystal Report. And the project is almost complete and i am going to publish it.Now I dont want to add the Prerequisites for the project as it will make the size of the exe to some 400mb but my application exe is just 4mb.
Now currently i have seen something in the Reference Section of Project Properties.That is the dll Control that i am using for Buttons has the Column called Copy Local with a value of True but for CrystalDecission.Shared its just False, so is this value changing to True helps me or not... that is i should not have to include as Prerequisites for crystal report..
My suggestion is how to use the setup/deployment project - and also how to add it/incorporate it into the project being built.
View 3 RepliesI've created a deployment project to install my app using Visual Studio. How do I get the setup wizard to run my app at the end and pass it a command line parameter?
I need to set permissions on a folder so I was going to call my app with a parameter and do it from there whilst the user still has admin rights.
I'd like to sample the data from the Arduino @ roughly 200Hz. Is there a more efficient way to do this than using a timer (which is what I am currently using)? Currently I am using[code]....
View 3 Repliesive just completed my app and i created a setup and deployment project.Complier forced me to exclude wmp.dll
i get this error for about a second before the app launches. Losing my splash screen because of it
I thinks it has to do with the .dll, but ive no clue how to fix
PROBLEM #1: I have a program that accesses several XML files that are located in a subfolder called "xmlfiles." This folder is a sub-folder in my project. I am using "Application.Settings" to store the locations of the XML files. For example, I have an entry for "JobsXML" that has a string with the file path of the XML file to load. To get these files to load, I had to use relative references: The path settings for "JobsXML" is "......xmlfilesjobs.xml"
I have to go up 3 directories because the files are in "debugin" during design. This will not be the case at runtime. This arrangement works fine in the editor, but when I make a "ClickOnce" package, the relative path will no longer work for installed applications. The directory will be different.
How can I setup my code so that the "xmlfiles" subfolder will be correctly used at runtime? I need to be able to run this from my project folder under "My Documents/Visual Studio 2005/Projects/etc..." and also, I need it to work from the runtime directory that the user installs the program to. So if the user installs the package to "C:temp" then the code should use the setting for "JobsXML" by going to "C:empxmlfilesjobs.xml."
PROBLEM #2: There is an attribute in some of my XML files that is also, a relative file reference. I have another subfolder called "images" that also resides in my project. This folder contains images that are loaded at runtime. In my XML file, each node has an attribute, "filepath" that has a value of "......imagesfilename.jpg". I also need to be able to access this relatively, just like the XMLfiles I mentioned in PROBLEM #1.
I have tried different combinations of StartupPath, Path.Combine and a few others, with no success. I am new to this so I could use some sample code to put this together correctly.
I have a question for many years.. Suppose if I Deployed a project using Setup Project. After some time, I added some features or modify it on customer demand.
1) How do I make a upgrade project so that the user runs the setup and the new changes are upgraded on the client system.
2) How do I automatically create ODBC System DSN Connections.
I want to make exe file of my project but i don't know how make.P
View 5 RepliesI am trying to create a deployment project for a solution of many projects and two start-up projects. I understand that there are 2 primary outputs in this case. The solution will not work/make sense if either of the two outputs is not running.
At the moment, I have created a set-up project with the multiple outputs, but then I will have to open the outputs individually for them to work. I am wondering if there is a way to create a desktop icon that targets both outputs simultaenoulsy.