I have been automating MS Project with VB.Net. I can open .mpp files and access all the objects I need. Now the customer has asked to open these files from Project Server. I cannot get MS Project to Open with the server connection.
View 3 Replies
I have a program that needs to access the files that are open by another program on the computer.When my application comes up I can easily see if the other application is running with the .net Process.GetProcessesByName method
Dim MyProcesses() as Process = GetProcessesByName("AnApplication")
For Each Instance as Process in MyProcesses
If MsgBox("application is running - do you want to end it?", MsgBoxStyle.YesNo or MsgBoxStyle.Question, "Warning") = MsgBoxResult.Yes then
[code].....
The problem is that the Instance.Kill does not allow the application to end gracefully. In VB6 you could use the SendMessage API to send a close message to the application and it would end gracefully - i.e. give the user the normal closing prompt. This just slays the application - leaving any open files in their potentially incomplete state, etc.
I'm trying to put together a quick example for another thread about treeviews, and I'm getting a problem when I have a recursive routine, getting the message.
Quote:
There is already an open DataReader associated with this Command which must be closed first.
I'm a tad confused as I am explicitly creating a new command every time through the loop, so I'm not sure (unless its something ADO is doing behind the scenes) how the datareaders higher up the tree are interfering.
Here's my code :
Private Sub SetupChildren(ByVal ParentID As Integer, ByRef ParentNode As TreeNode)
Dim MyCommand As New SqlCommand("SELECT * FROM Groups WHERE ParentGroup=@ParentGroup", m_myConnection)
[Code]...
Obviously I could close the data reader down before calling the next level of recursion but it would prevent the code continuing the loop at the current level when it had finished processing children.
1- How to add ?
2- The best in i/o file or in sql database.
3- how to add & update & delete.
how do i create sequential files and use objects at the same time. can i get a program and its code if that's possible?
View 1 RepliesI have two xml files. I have to read them and return as a List( Of object). Here is my function.
Public Function GetData(ByVal name As String, ByVal city As String) As List(Of Object)
'Return Nothing
End Function
How best to manage multiple dat files for serializable objects of the same class. If one of my data files goes past a particular size, I want to create a new file. I then loop through both files when I do processing. Is there any easier way to do this and what's the best size to do this at in terms of performance?
View 1 Repliesi load a page via WebBrowser.document class, I want to literally "click" elements in the DOM using VB.net programmatically. I dont want to use the classic WebRequest class.how can i do this ?
View 1 RepliesCan I access elements in the Web Browser object while surfing ?
Like push a button or fill text box ?
I am trying to import a bunch of excel 2003 files all with A:H columns and they are under the same headings etc. into a table in access 2003 database. This is a module in access im making. Im using a file search to look for every file that begins with Format (which they all do ) to get at all the files in the folder path. is there a more efficient way to do this? somehow select all files in a folder? and import each to the same table in access? The DoCmd.TransferSpreadsheet seeems to take each file path individually so I'm not sure how to get each file name in the folder to import it.
I have this at the moment:
Sub Import()
Dim db As Database
Set db = CurrentDb
[Code].....
Ok I know this question has been asked to death but I still have not seen a good answer. I have created an application in VS2010 using VB.NET. In my application I have an error log that is an XML file located in the Public gstLocalErrorLogLocation As String = Application.StartupPath & "ErrorLog"that gets written to in the event of an error so I can trouble shoot application easier. My application also downloads files from our FTP site and puts the files in Public gstLocalDownloadLocation As String = Application.StartupPath & "download"So I have files that get read and written to as well and created and deleted all in the Application.StartupPath which is either "c:Program Files(Application Directory)(Some Directory)(Some File)" or "c:Program Files (x86)(Application Directory)(Some Directory)(Some File)" depending on 32bit or 64bit Windows 7.
After creating the setup I install it on my test machine that have both Windows 7 32bit and 64bit.Everything in the application works great till I have to write to, delete or creat a file in those directories above. I know it is an access issue and the UAC. This will get installed on numerous systems so the options I have seen to change file or folder permission on the computers manually is not an option.What has to happen is after I install the application it just works like when you install it on XP. Some post have suggested that you us a user with administrator privilages or group which is all fine and dandy but the user I have used to test the application has all of that.
So what I am asking is how do you create an application with VS2010 in VB.NET that after creating a setup package and installing on Windows 7 will just work with out "Access to the path c:Program Files(Application Directory)(Some Directory)(Some File) is denied." If I have to install this on 100 Windows 7 computers it has to be a concreate no manually doing anything just install and work like when we installed on XP.
Actually I want add some folders and files to MSI. Through custom action i want to copy that added folders and files to some destination/target folder.
View 1 Replies(using VB2008) I am trying to automate Access from VB.Net. To do this, I added two libraries to my project, Microsoft.Office Interop.Access v12.0.0.0, and dao v10.0.4504.0. This seems to give me all the necessary commands, yet when I tried to open up an Access database via the following code:
CODE:
I have an application that can read certain types of files, and I have it working so that if you do "open with" from windows, it automatically starts the application and opens the selected file.
Unfortnately, I cannot get it to work for more than one file.
System.Environment.GetCommandLineArgs() contrains the following:
System.Environment.GetCommandLineArgs(0) = name and path to the .exe
System.Environment.GetCommandLineArgs(1) = name and path to the first file selected to be opened
System.Environment.GetCommandLineArgs().Length is 2 when the user tries to open 1 file, which makes sense since the first argument is the .exe itself and the 2nd is the path to the file, but it does not increase to 3 if the user tries to open 2 files... meaning that System.Environment.GetCommandLineArgs(2) is never populated Here is some sample code that shows the problem: It will recognize no files or 1 file being opened, but if you try to open multiple it will only show the first.
[Code]...
I'm trying to develop a program that turns matrices into their reduced Echlon forms. The user specifies the number of Columns & Rows for the matrix, which is generated by the following Sub Routine
Private Sub ButCreate_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles ButCreate.Click
'Columns and Rows are specified by the user
rows = TxtRows.Text
columns = TxtColumns.Text
'clears all of the controls(text boxes) from the TableLayoutContainer
[Code] .....
How to do is access/manipulate those newly created textBoxes. After the user enters values to those boxes, I want to assign each of their columns to an array.
I have an application which is grouped in a MainApplication and serveral Modules (DLL's) The Main Application is basicly a Form with a NavigationBar on the Left Side (like in Outlook 2003) and an MDI-Parent. There is also a Simple Login Routine on this Form. I store the UserName after Loggingn to a Property. The DLL's holds functionallity and Forms for various Sections for example there is a Employee.dll which holds functions and a form to show all Employees.
On Loading of the Main Application I loop trough all dll's in a "Module"-Folder and extract NavigationItems from them which I add to the MainForms NavigationPanel. I don't have a reference to the Modules because I want to make it as flexible as possible so that it is possible to delete a Dll form the Module directory in order to remove the functionality from the MainApplication. The Modules could work also without the MainApplication if they are Complied as an exe insted of DLL of course. This works fine so far.
[Code]...
I have an application in vb .net that I would like to have access to objects in a sharepoint site. Some of the things I would like to do from vb is create folders in my sharepoint site, have access to files that are on my sharepoint site. We have sharepoint servers at corporate so that is where my site resides.
View 4 RepliesI opened vs 2008 and used the server explorer for the first time to create a connection to my SQL 2005 db. The solution explorer pulled in all the tables, the database diagram etc. My question is how do I access that database connection and work with it using ADO objects? Do I need a reference to ADO?
View 4 RepliesAccessing Dlls functions/objects using VBScript
View 2 RepliesI don't know if I explained this in my title, this is what i want to do. (In VB on a active server page) I have 5 buttons called but1.....but2. Right now I have the following code to make them invisible
but1.Visible=false;
but2.Visible=false;
but3.Visible=false;
but4.Visible=false;
but5.Visible=false,
Is there a way to access the objects by using a string, example
for(i=i;i<6;i++
items("but"+str(i)).visible=false
I have a Repeater Control which I bind to a list of Products
Repeater.DataSource = ProductRepository.GetProducts();
Later (in another module), I need to retrieve the products from the Repeater, but it seems not to work with Repeater.Item.DataItem (which is then null).
My question is, is there any reference to the products in the Repeater-Items? Or do I have to set it myself via id field etc. What would be the easiest way to get the "underlying" product objects?
I was given a ppt slide with 12 chart objects and a text box for each. see the zip attachment. This is a collection of metrics that we track and chart monthly. The previous custodian of this duty would manually open each and update the datagrid for each and add comments as needed. I want to automate this process using vb2008 express. I have a basic handle on windows forms and sql tables, but don't have a clue how to access these chart objects and text boxes in the ppt slide. I've tried adding the slide to my project - like an image, but nogo.
I thought I could update the slide using my form controls, taking data entered on the data grid, create my SQLdb and update the slide. There is a one to one relationship for each item on the form and the ppt slide - 12 ea (charts & boxes) on both. My issue is how to define the chart object (mschart) in vb and update the ppt slide.
url...If you check out the images on that website you will notice that in their program, it has the textbox and user icon thing and everything and they have transparencies set.Is there anyway to access those "objects" and just throw it on the screen? How exactly are they doing that? Did they make their own graphics? And if they did, how are they letting it do the transparency, because I know laying a picturebox over a picturebox won't accomplish that.
View 10 RepliesI want to do the following in Vb.NET 2005 windows form
1. saving Ms-office documents in Access 97 using VB.NET
2. Opening the saved document in Access 97 using VB.NET and show to user after user clicking a link correspoding to the record
3. After user modified the document/xls file, it should once again save into Access 97 database.[URL]..This document explains how to open and save a document from BLOG fields.But without physically saving the document into local hard disk, is it possible to open in OLE control? and after modifing saving back to Access 97 database.
Access objects on a dynamically created UserControl an a dynamically created tab page. I can usually find the answers to most of my questions via the Google Gods, but not this time. I hope the collective that is StackOverFlow can help! I have a form that has a TabPageControl and on that page a collection of labels and text boxes via a usercontrol.
On the form I have a button that allows the user to create a new tabpage, when the code adds a new page, it automatically adds the UserControl collection, all good so far. I can't get my head around how to access the objects on the newly created tabpage. What I need to be able todo is take the index of the tabpage that has focus and translate that against the UerContol name, but I havn't a clue how to do it! [Code]
I have a class assignment and I am having some difficulty with an Access 2010 database and OLE objects in the database. I have the database imported into the project and I am able to view the records from the database that I have in labels and combo boxes.
I used the database DataSoure wizard to create my connection string and import the Access database. In the DataSouce window I set the DataSet for the "Flag" column that contains my pictures to use a picture box object type and added the data bound object to my form.
When I run the application all the field from the database show as expected however, the picture box object does not display the images from the database. When I check the picture box object in the designer the properties window shows that the image source is bound to my database with the little database icon and the data bindings are all correct.
im used to C programming.
Private Sub SaveAsToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveAsToolStripMenuItem.Click
timedate.Stop()[code]......
The problem is that if I save a file I get "myfile.GDL" if I overwrite that I get a new file "myfile.GDL.GDL" ect.the other problem being that the filtering in the windows save/open dialog wont show .GDL files unless I select "all files".
How do i open exe files with in my form with a command button
View 4 RepliesMy project is a PDF file format database. How can I view these PDF files in VB.net? And what database should I use to store these PDF Files?
View 1 RepliesHow do I open Visual Basic .vbp files?
View 1 Replies
