I am creating a excel application in VB.net using VisualStudio 2008.while adding reference Microsoft.office.interop.excel we have both managed ( On the .NET TAB) and unmanaged (on the COM TAB).currently i am referencing the COM tab but it is not showing the errors properly.
can i use the excel interop on .NET tab?which one is the better way to reference and what is the difference between those two?
how can i use Ms-Excel as a backend database in visual studio 2008 applications, if is it possible
View 2 RepliesI'm looking to call an excel macro (excel version 07) within a separate visual studio application (visual studio express 2010). Basically, a user clicks a browse dialog button to select a xls or xlsm file which is then added to a listbox. Next, I would like the macro to run when another button is clicked. The macro looks at the first column in excel and moves the listed .tif images from one folder to another. I referenced the excel libraries, but seem to be getting hung up on a few code statements (''''ERROR see code below). I would like to run the macro within visual studio for any selected excel file or add the macro somehow to the selected excel file and run it.
'Here is the button click procedure
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
filenames = lstFiles.SelectedItem
[Code].....
I am using visual studio to create an application that opens an excel file and then for each entry in the first column the entry in the second column is stored in an array. Then excel opens two other workbooks and for each entry in the first column it searches for a match in these other two workbooks and stores the corresponding value in an array.
Anyway, the problem is closing excel afterwards. I have used the thread: [URL] to work through the basics of cleaning up. I used the cleanup code provided and added the WithEvents caveat. I do not have strict option on.
I believe the problem is the fact that I have three workbooks open.
This is my cleanup code: (wrkbk, wrkbk2, wrkbk3 are the workbooks; datasheet, datasheet2, datasheet 3 are the worksheets; excel is the application)
Code:
GC.Collect()
GC.WaitForPendingFinalizers()
GC.Collect()
[Code]....
I got the impression that order was important in the cleanup procedure so I have tried some variations of moving the workbooks and worksheets around.
I am trying now Visual Studio 2008 beside VB6. As I want to create an .exe file but can't see the option for creating exe.
View 6 RepliesI am creating a web chat facility in visual studio 2008 using Visual Basic,I want to be able to highlight certain keywords that are sent and received to each user?
View 1 Replieshow to create table in visual studio 2008
View 2 RepliesI have Visual Studio 2008 Professional and I'm trying to make it so I can click a button to send the application to the System Tray and then click the icon in the System Tray to make the application come back.
Can anyone provide me a method or sample code to do this?
I am trying to show my excel chart in visual basic listbox and it does not work. I have added the reference of microsoft.office.interop.excel in my code i have put the range of column "A" and i do not know how to change the range to where the chart is in the excel.
Here is my code!
[Code]....
I have attached the excel file screen shot if that can help in any way...So basically When i click on the button in VB than it should show me the excel chart. My code just shows me the column "A" which shows me the "data" column only from the excel file.
I've cracked the reading Outlook emails from a specific folder in a VB 2008 program but now I need to append my parsed data to end of an existing Excel Spreadsheet. where I can look for some code samples of now to do this?
View 3 RepliesI am an absolute newbie in both oracle and visual basic. I have covered some basics as tutorials and want to develop a database using Visual basic as front end and Oracle as back end. I have Visual Studio 2008 installed and I will use Visual Basic from that. I also have Oracle 10g express edition installed on my system.
View 6 RepliesVisual Basic Project - Student Check In Form using an Access database backend This form needs to draw information from an Access database containg tables for STUDENT, INSTRUCTOR, and SECTION. These all need to have primary keys and ids. When (the user) clicks on the drop down box that displays all the sections:
{Table Tennis 1, Table Tennis 2, Table Tennis 3, Billiards 1, Billiards 2, Billiards 3}This should populate the listbox or datagrid from the STUDENT table with the Students that have the same SECTIONID as the SECTION selected in the drop down menu above.
After the Student list has been populated (the user) clicks on a student name in the listbox/datagrid and this inserts that student into the CHECKEDIN table that has a datagrid/listbox associated with it.
This is a great project to practice connecting a database to Visual Studio 2008 .net and playing with the data that has been pulled in. You could use SQL instead of Access.
I use visual studio 2008.and am create the web application.to open xml code window.to click design view.to drag and drop the one text box.
View 1 RepliesI have to develop an application using MS Visual Studio 2005 or above with the following objective:
* The application should allow users to create as many new forms as they want and each form should behave like a MS Visual Studio WinForm. By saying that it should be a container for drag and drop of controls from the toolbox that I will develop....
* Once the user design's each screen to his taste by placing various controls on the form, he should be able to save the form as a screen. Of course I have to provide functionality for each of the controls such as if he drags a button on to the form, he should be able to specify what action it has to perfom when clicked when the application is put into run mode. Quite similar to regular windows form button.
* My application should have two modes: a DESIGN MODE, where user can drag, drop controls and specify what they should do when put into RUN MODE. This is quite similar to MS Visual Studio designer.
* Last but not least is to be able to access the application via the browser with the same look and feel his desktop version.
I have to develop an application using MS Visual Studio 2005 or above with the following
objective:* The application should allow users to create as many new forms as they want and each form should behave like a MS Visual Studio WinForm. By saying that it should be a container for drag and drop of controls from the toolbox that I will develop....
* Once the user design's each screen to his taste by placing various controls on the form, he should be able to save the form as a screen. Of course I have to provide functionality for each of the controls such as if he drags a button on to the form, he should be able to specify what action it has to perfom when clicked when the application is put into run mode. Quite similar to regular windows form button.
* My application should have two modes: a DESIGN MODE, where user can drag, drop controls and specify what they should do when put into RUN MODE. This is quite similar to MS Visual Studio designer.
* Last but not least is to be able to access the application via the browser with the same look and feel his desktop version.
I am trying to make a web application in VB.NET using Visual Studio 2008 that will accept login credentials and compare them with an Access database for authentication/validation. I found lots and lots of examples for how to do this with a Windows Form App, but none with a ASP.NET Web App. tried to modify the steps for a web app but I'm not sure how to make it work. The database connection is good and the query seems to work fine. Here's where I'm having trouble. In the tutorial, he says to use:
01 Private Sub But_Validate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles But_Validate.Click
02 Private Sub But_Validate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles But_Validate.Click
03 Dim r = Me.UsersTableAdapter1.ValidateUserNamePassword(Me.Txt_UserName.Text,Me.Txt_Password.Text)
[code]....
No matter what I put in for the username and password (as long as they are valid values) I always get a "success," never a failure. I know my query is working right because I put a gridview on the page and bound it to the result from the query; when I type in a user/pass that is not in the database the gridview is blank, when I type in a correct user/pass the gridview displays that row from the database.
VS 2008 / VB.Net / WinForms I have an application setting (Settings.settings) for a project and I am using Click Once deployment. I used the VS Editor to create the setting and I can see the setting in the app.config file
<applicationSettings>
<MyApp.Win.My.MySettings>
<setting name="MySetting" serializeAs="String">
<value>False</value>
[code]....
I'm trying to create a video conferencing application using visual studio 2008 and programming language vb.net.
View 3 RepliesI've made a fairly good Windows form application to solve quadratic equations, but I am having a hard time understanding the publication process microsoft uses in Visual Studio. I'd like to distribute my programm as freeware on my blog.
View 5 RepliesStupid question, but how do I get access to this Explorer? The says: To create a performance session for Windows client application:
(1) Open the solution in the Visual Studio IDE.
(2) On the <B>Analyze</B> menu, click <B>Launch Performance Wizard</B>.
(3) From the <B>Which of the following available targets would you like to profile?</B> drop-down list, select the name of the application that you want to profile, and then click <B>Next</B>. You can add more binaries later.
(4) Accept the default Sampling profiling method, and then click Next.
(5) Click <B>Finish</B>.
Only problem is that there is no <B>Analyze</B> menu in the IDE.
I am creating reports in Crystal Reports that is integrated within Visual Studio 2008, and I noticed that some of the features are disabled. One is the ability to link tables with a Right Outer Join or Full Outer Join. I also cannot "Show SQL Query" in Crystal Reports. Is this something I can enable or do I have to purchase or upgrade?
View 1 RepliesI need to convert the following code to work in a visual studio 2008 windows form application, the moment ObjectQuery, ManagementObjectSearcher, ManagementObject and ManagementObjectCollection are not valid.
im objectQuery As New ObjectQuery("SELECT * FROM Win32_NetworkAdapter WHERE NetConnectionId IS NOT NULL")
Dim searcher As New ManagementObjectSearcher(Scope, objectQuery)
[code].....
The environment will not create a resource file for a newly created Windows Forms Application. When I add a button Visual Studio displays a dialog "File Exist". That'sall, plus an OK button. There is no file name or the file name is in unreadable characters.The dialog comes from Visual Studio because the title is "Microsoft Visual Studio".There is no resource file so it must be that the resource file cannot be created.I uninstalled and reinstalled Visual Studio 2008. It did not change anything.I believe the problem was caused by opening the same project rapidly twice on an i7 laptop. I have done this unintentionally before and I can testify that unpredictable
View 2 RepliesI wish to turn on the Single Instance Application choice in Visual Studio 2008 properties. To do so, I must choose "Enable Application Framework". When I do that, my ONLY choice is to choose a Startup Form, not a Startup object. This makes no sense to me. I have a tray application, and I check to see which form I should load, a logon form, or the main form. But since I am forced to choose a startup form, I MUST load the logon or main form to begin with. But I don't want to. I want startup code to determine which one to load first. So then I am playing with making the OTHER form invisible, even if the startup form, but that is a mess.
View 4 RepliesA new question on a different topic =) took a break from coding and now comes GUI. I created a new tab in the form by selecting tab control. then I have this. changed the backcolor of the tabpage1 to control (to make it look for realistic with the actual form)
[Code]...
Will i be able to successfully install 2010 beta 2 side by side 2008? because i want to test 2010 features and some development toolkits such as silverlight while i don't want to uninstall my visual studio 2008 professional.
View 2 RepliesI have a Visual Basic project and when working and modifying code, the compiler will crash and then a message will say something like "Microsoft visual studio encountered a problem and was shut down." I've tried editing code from the solution and the project. Both produce the error. Usually occurs when adding an "IF...Then..." condition. May work for hours but then crash. Solution will compile and build.
View 3 RepliesIm creating an unmanaged DLL in Visual Studio 2010.In order to test my DLL I have created another project with Visual Basic and i've attached it to the solution.VB code calls to my InstallHook function in the DLL, passing a delegate of the callback function at VB. Then the DLL creates a hook and everytime a key is pressed the VB callback is called receiving the key and some other params as argument.
Well, the problem is that after some keys has been pressed, and the buffer in the VB callback reaches a specific size, the program crash. To be more specific, when the callback is called by the last time and it writes into its buffer in VB, it's like it overlaps in somewhere because the next time the callback is going to be called in the DLL, the program crash without reach the callback (the pointer in the dll is fine)I dont understand well the architecture of .Net and i dont know exactly what could be wrong, but im very confident in the code i've done and the problem should be something technical with the memory management in .Net.
Edit: I forgot to say that if I call the callback from within the VB code, then it works fine. The callback is normally called from a WndProc installed in the same window.
i want to create a login form in vb using the visual studio 2010 and i am using the following code:-
[Code]...
I'm trying to create heirarchy of classes in vb.net. I was able to achieve it in csharp by using the following tags in .csproj
<Compile Include="ClassA.cs">
<DependentUpon>ClassB.cs</DependentUpon>
</Compile>
Below snippet in the solution explorer would be as follows
I need to achieve the same in vb.net.
I'm new to vb.net. Can anybody tell me the alternative of <DependUpon> attribute used in .csproj equivalent in .vbproj. For some reason, this attribute seems to be ignored in the .vbproj even though it is displayed in the visualstudio2010 intellisence.