i am trying to query multiple xml files automatically in order to get a specific data for each xml files. I have create a code but it only query one file at the time. Below is the code that i have created.
Imports System.Xml
Imports System.IO
Module ParsingUsingXmlTextReader
[Code]....
i'm currently making a client database program for work that stores data in multiple text files (so that the information won't be confused as to which info belongs to who in the database). Each client has his/her own text file, which isn't really a problem although i realize it's a bit messy. A listbox holds items, each item a person's name.When the listbox selected index is changed, the streamreader opens the corresponding textfile, which is as such: "John Doe.txt", and populates the correct textboxes with the information stored in "John Doe.txt".What I'm unfamiliar with is implementing a search function.
1. search query entered
2. streamreader reads through all txt files in a directory looking for matching keywords.
3. if a match is found in a txt file, it looks at the name ("John Doe.txt"), gets the corresponding listboxitem, and finally, once the textboxes have been populated with the info in the file, highlights the matching keywords.
4. then i figured if there was more than 1 match over more than 1 txt file, you could repeat the process and skip to the next match via the tab key (like the find feature of a WebBrowser or other such application).
What i don't understand is how to read multiple text files, search in keywords, highlight the matching keywords, or the tab function..I know that's a lot to ask on a forum, but I had nowhere else to turn.
Im wanting to pull some data from our Remedy Server every so often. Right now we're having to do it manually; Data > Import External Data or New Database Query. The connection is called AR System ODBC Connection Source. We have to log into the server and then it pulls the info into the sheet. Im needing even if have to setup a conection myself first to just have this conection run every couple or two and update the excel sheet. We're using excel 03, Remedy 7.
View 2 RepliesWhenever I run the form and complete the procedure then I need to go back to sql database and click on execute. I want to avoid everytime going back and executing each entry because if I don't execute everytime then the further other [b]form data [/b]will not be[b] retrieved[/b] properly as the [b]previous form[/b] will [b]not be updated[/b]. I hope ur understanding ...
[Code]...
just as the title says i want to zip/unzip files using vb ocde to make a standalone vb application. I saw a couple out there but didnt really know how to work with them
View 2 RepliesI'm trying to edit an existing xls and just overwrite it without a prompt to overwrite. I thought it was something like Excel.DisplayAlerts = False but that's erroring with 'DisplayAlerts' is not a member of excel.
So this is my current closing code that doesn't work.
oBook.SaveAs(ExcelFilename)
Excel.DisplayAlerts = False
oBook.close()
oExcel.Quit()
I have a working vb.net application which writes to an excel file. While trying to delpoy it I came across this error:"The following files may have dependancies that cannot be determined automatically. Please confirm that all dependancies have been added to the project.c:\program files\microsoft office\office12\excel.exe".
View 5 Replieson visual basic 2006 I made a programs which blocks illegal connection to my game server and it closes the some illegal programs.But I need to get the file from ftp when the important files is needed.I did ftp connection from server to my client but actually what i want to do is downloading files from my ftp of web automatically.It is not important whether your helping is about Vb.Net or Vb 2006 , it's up to you , I know how to change the codes from Vb 2006 to Vb.Net.How can I achieve to download file from ftp folder and how can I do to check the files whether they are downloaded or not ?
View 2 RepliesI have a website that has highly granulised access and hence requires many web.config files. The problem is I would like to trim the menu so that only certain users will have access to certain folders. I have enabled trimming and setup roles in the sitemap, however when I access the page the menu is not show, as I am authorized to view the default page which is not in a subfolder. When I type the url of a page in sub folder's I have access.
How should I handle this:
A site map for each web.config file - don't know how this will work Removing the sub web.config file to only use a single one
I am looking for a method to monitor a large group of folders and to rename files with a certain file extension automatically.
View 1 RepliesHow to use the saveFileDialog class to save a file as a PDF programmatically?
View 3 RepliesI'm trying to edit an existing xls and just overwrite it without a prompt to overwrite. I thought it was something like Excel.DisplayAlerts = False but that's erroring with 'DisplayAlerts' is not a member of excel.
So this is my current closing code that doesn't work.
oBook.SaveAs(ExcelFilename)
Excel.DisplayAlerts = False
oBook.close()
oExcel.Quit()
I know this is out there and probably illogical but I was wondering if it was possible to take multiple picture files and compact them into one file.... and then retrieve them from the program later? Way to combine any amount of image files into one file
Module Module1
Sub combine()
Dim img1 As New Bitmap("i1.jpg")
[CODE]...
I want my calculate button to automatically click multiple times upon the user clicking it once because it seems that it only works properly if it is clicked multiple times... I'm not sure if there is an error in my code.
Public Class frmford
Dim Make, Model, InitialPrice, Options, AirConditioningTax, GST, PST, Total, Subtotal, Finance, Months, RoofRack, SunRoof, SideAirBags, TintedGlass,
[Code]......
We bought a DIY security camera, the camera is making automatically mpegs if a movement is recognized. A picture can be made with a delivered program. We have the idea to make a program with the delivered dll files to make automatically pictures.
timestretchDMO.dll
GPIProxy.dll
expDMO.dll
DVCtrl.dll
DSPDMO.dll
how I can make my Application to automatically create preset folders with files when installing the application? The files should be under user/documents/MyApplication/Newpresetfolder
View 5 RepliesI had done my project and now I planning to make setup file for my application...During making the setup file,I had encountered this problem: The following files may have dependencies that cannot be determined automatically.
View 2 RepliesI'm developing an application to help law enforcement retrieve and analyze logs and other files left by the use of Pidgin (a multi-protocol messenger client). Right now I'm nearly done, but I want to add the ability to search chat logs for user-defined words or phrases and I don't even know where to begin.
Chat logs are stored as html documents in a folder/sub-folder/sub-folder/sub-folder fashion, where each sub-folder can have dozens of sub-folders inside of it, and the final sub-folder can have dozens if not hundreds of chat logs. If anybody could point me in the right direction, I'd be very grateful.
(Also, this is the first program I've written since about 2005, and I'm essentially teaching myself VB as I go. If you'd like to see what I've cobbled together so far, you can find the program here.)
I need to ASP.net Page that links automatically to files(pdf) stored in a folder in the same root of the web application..so the script will read the contents of the page , if the file is available in the folder it should create a link to it automatically and if not it stays static text.
View 1 Repliesmaking a simple web browser for work eeh, what like to know is if its possible to save a file of a particular extension to a particular file.I currently use googels chrome when downloading a file it places this (regardless of extension) in a downloads folder without asking where I ant to download this too.
View 2 RepliesI'm trying to copy multiple excel source files into one excel file. My current code is working only for 3 source files..If more than 3 files are there, it doesn't copy the data but creates blank work sheet in the output excel file. Lets say I have a source folder with 5 excel files. Each workbook contains one worksheet with data. It copies upto 3 worksheets along with data into output excel file.
Lets say excel1 contains A as work sheet, excel2 contains B as work sheet ,excel3 contains C as work sheet ,excel4 contains D as work sheet ,excel5 contains E as work sheet .Now my output excel file should look like..OutputExcel with A, B, C, D, E along with respective data.But my current code is giving output as A,B,C worksheets along with respective data but its creating blank sheet1,sheet2 in place of D & E.
SSIS Script Task Vb.Net Code:
Public
Sub Main()
Dim filePath
As
String =
[code].....
i have six textboxes from which the user can query the database. Now the user can decide to fill all the fields and query this i have done using AND OR in the sql syntax but the problem is when he decides to leave some blank my program is throwing an exception how can i skip the blank fields and only execute the WHERE clause for the filled boxes.
View 6 RepliesI have encountered a table with five fields refering to a customer list. The fields (c1, c2, etc..) are id's of the customer in the other table. Need a SQL statement that will resolve the customer names into a report with on line and the five entires. Example:
Table1
ID Description C1 C2 C3
1 PartyGroup 2 3 1
2 BeerFolk 1 0 2
[Code].....
I'm not sure how to do the following (in VB.NET), I'm hoping you will give me some insight or examples on how it can be done. My database is an SQL one.I have an assets table, which in it has the amount, growth percentage, income percentage. There are multiple assets per client.
I need to get the amount, growth and income into three separate boxes or variables and I'm not quite sure how to do this. The only other problem is that there would be two or three rows returned also, which need to have those three variables or textboxes again.
So for x amount of rows, I need 3 variables which the amount, growth and income will go into.
The reason I need everything into variables is that I can't find an effective way of showing each assets growth over x amount of years and the income it will produce into a data grid view. I'm able to do it if I specify what the growth and income are on the form, but not through the query.
I'm trying to figure out how to get a query for multiple columns in my dataviewgrid.. So far i havn't even been able to make a single column query work, when i search something in First_Name for example, it returns nothing. ive used query builer, ive written the code myself, nothing seems to work.
View 3 RepliesI have a report that I want to filter using a From Date Text Box (which is a string) and a To Date Text Box (which is a string) so the user will insert a start date and and end date to filter the report, how would I do that? This is what I have:
Try
Me.FuelTableAdapter.FillByDate(Me.ShuttleRunsDataSet.Fuel, FromTextBox.Text &
ToTextBox.Text)
[code]....
how to select multiple table in vb2010? i trying to create a login so i need to retrieve the data in 3 different tables in one database i have a code but not work.[code]
View 2 RepliesI am trying to link to a Access database at runtime using a SELECT FROM WHERE query, which I can do but.......
with the WHERE part I want to select several conditions, 4 actually and it is not working, what am I doing wrong?
Here is my code,
Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=V:GYMDBFLineProdSanderProduction.mdb")
[Code]....
I have an assets table, which in it has the amount, growth percentage, income percentage. There are multiple assets per client.
I need to get the amount, growth and income into three separate boxes or variables and I'm not quite sure how to do this. The only other problem is that there would be two or three rows returned also, which need to have those three variables or textboxes again. So for x amount of rows, I need 3 variables which the amount, growth and income will go into.
The reason I need everything into variables is that I can't find an effective way of showing each assets growth over x amount of years and the income it will produce into a data grid view. I'm able to do it if I specify what the growth and income are on the form, but not through the query.
how to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code
Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
txtCurrentUser.Text = Login.txtUser.Text
Dim strsql As String
[code]....
