Query A Database To Get A List Of Files?
Mar 11, 2011
I have a question about error handling. I have a Try...Catch Error Handling block and with in the Try section I query a database to get a list of files that need to be opened by AutoCAD (using an AutoCAD script file) and a PDF generated of that DWG file. My problem is that sometimes a user has that particular drawing open that it detects to open up and PDF. I use the following code to determine if it is open or not.
[Code]...
Edit by Moderator: use code tags when posting code. Click on this post's quote button to see how.
View 10 Replies
ADVERTISEMENT
Apr 23, 2008
How to Filter a Database Query Using a List..
View 2 Replies
Jan 22, 2011
[Code] my issue is that now i need two cases, first i need a query that will return the date created and modified of the table and i also need to know if its possible to query a list of table names in the database ordered by date created but that have a certain thing in their names. for example the database contains the following tables: [Code] and what i need the query to return is the tables that contain "Data", settings and employees are for the other functions of the program. so the query should return the 4 data tables in order of date created. but i have no idea how to go about doing that in the query, does anyone know how this is done?
View 6 Replies
Apr 10, 2009
How do you carry out a query from a criteria e.g name entered by the user from a textbox. and then display the query results in a list box..
View 2 Replies
Apr 28, 2010
I am connecting to an Access database and using a parameter query with the LIKE operator to return all rows that match query. The string to search for is taken from a Textbox
sql =
"Select * FROM Allview WHERE Info Like" &
"*" &
CStr(TextBox1.Text) &
"*"
The query does not return any data in vb, but when run from access with same string, there is data returned.The connection to the database is done correctly, as I am able to return data with various other queries.
Partial code :
Dim
con As
New OleDb.OleDbConnection[code]....
View 8 Replies
Aug 27, 2010
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
View 2 Replies
May 29, 2009
i should say hi experts :D . Help me with this pretty code :)
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
View 11 Replies
Dec 14, 2009
I am trying to create a program which will read the files that exist in a directory, and then write in a text file the specific information (full file name, date created)i have found several code in the site but i cant make it work, the machine i am running the code is XP and i am using VB2008.The code i have found is the following:
Imports System.IO
Imports System.String
[code].....
View 1 Replies
Jun 3, 2010
I have a SQL Server table with a list of files (path + filename), and a folder with multiple layers and files in each layer. I'm looking for a way to reconcile the two without having to process the list twice. Currently, I'm doing this:
For Each f as FileInfo In FileListFromDatabase
If f.Exists is False, mark it as deleted in the database
Next
[Code]....
Is there a better way to do this? I'd like to avoid converting all the matching files (of which most will be) to FileInfo objects twice. Since I'm a T-SQL developer first, I'm picturing something like an OUTER JOIN of the two lists where they don't match. Something LINQ-ish?
View 1 Replies
Jun 9, 2011
How to list all files in a folder including subfolder files.
View 9 Replies
Aug 17, 2010
i have this right now:
ListBox1.Items.Clear()
Dim di As New IO.DirectoryInfo(TextBox1.Text)
Dim aryFi As IO.FileInfo() = di.GetFiles("*.*")[code]......
and that displays only the file name, like text.txt but i want it to display C:/Text.txt and all the files in the subfolders too, like C:/Program Files/Test2.txt but i just get test.txt from only the c:/ .
View 2 Replies
Aug 23, 2011
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].....
View 1 Replies
Sep 2, 2011
Dim query = From o In myContainer.MyObjects Select o.MyStringProperty Distinct
Dim myProperties As List(Of String) = query.ToList????? 'no way!!!'
"query" type is IEnumerable(Of String)
I tried to use the query directly as a DataSource of a (infragistic) combobox, but it throws me NullReferenceException, so I decided to convert it to a listof strings, to be a more "classical" datasource.
Dim values As List(Of String) = query.AsQueryable().ToList()
does not work either: Value of type 'System.Collections.Generic.List(Of System.Linq.IQueryable(Of String))' cannot be converted to 'System.Collections.Generic.List(Of String)'.
View 3 Replies
Jan 7, 2012
I have a few running totals and a name associated with these totals and was wondering if an array would be quicker to use instead of storing it in a database.Basically what happens is I need to search a name and if it exists I add the necessary amounts to the totals and if it doesn't exists I add a new record.
View 4 Replies
May 12, 2009
my query is this: I want all of the characters that are of a membership level in a given area that is of admin or above.
This is what I have so far:
Dim L As List(Of Character) = (From C In MasterCharacterList.Characters.Values _
Where Me.Item(C.CharID).DreamLevel.ContainsValue( _
(From L In _Levels Where L.Value.Admin Or L.Value.BotMaster Select L.Value.MemberLevel).ToList.ForEach) Select C)
Me, in this case, is the members collection.
So far, I can't get the query to turn into a list (hence no .tolist at the end.) I know there's something wrong here, but I'm not sure what.
View 6 Replies
Oct 7, 2011
The scenario is this, I have several variables that are set as a list(of objects). The values for these lists are populated during code via a SQL query. I want to be able to take these values and then use them within another SQL query. Each time the program runs the values will be different and there will be more or less within the list.
View 6 Replies
Mar 9, 2012
I have multiple file upload boxes on a form in my mvc3 application. Request.Files shows 3 files when I put a break point in the below function and look at it.. Problem is other than coding a counter and using a select case I dont see a way to handle saving each file name to the database column it belongs to... Is there away to assign the variable on the fly I guess you could say So that the foreach loop would drop the file in the correct column. Ie handoutFile1, handoutFile2 , handoutFile3, Etc. As it stands the below will overwrite the filename in handoutfile1 every time the loop is gone through. I thought about throwing a counter in the loop and just put a select case on it to assign the db column based on the counter number. Seems like a cheap work around though. [Code]
View 2 Replies
Sep 12, 2011
'Read RESX file and returns a List(Of ResXDataNode)[code]...
Provide two separate copies of the node? Or will the List and Linq query still be referencing the same data?
View 2 Replies
Dec 9, 2009
I am working on making a Windows based application within Visual Basic 2008 Express that could potentially be used for a music school as a project. This application is connected and bound to a Microsoft Access database. Within this application I have a form for adding a new appointment reservation. This form has a combo box that the user can select the lesson type (eg. "I want a piano lesson"). Upon being changed, a list box would be populated with the names of all instructors that have that selection as either their primary or secondary talent.So, my database is bound, the query is written (correctly...i hope), and I don't know how to 1) select the table column that I want displayed in the list box and 2) actually display the query results within the list box. Is this making sense? Probably not, bu
Private Sub cmbLessonType_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbLessonType.TextChanged
'populate the lboInstructor box
[code]....
View 5 Replies
May 8, 2009
I was speeding up my app by using compiled queries for queries which were getting hit over and over.I tried to implement it like this:
Function Select(ByVal fk_id As Integer) As List(SomeEntity)
Using db As New DataContext()
db.ObjectTrackingEnabled = False
[code].....
View 1 Replies
Mar 9, 2010
I was speeding up my app by using compiled queries for queries which were getting hit over and over.
I tried to implement it like this:
Function Select(ByVal fk_id As Integer) As List(SomeEntity)
Using db As New DataContext()
db.ObjectTrackingEnabled = False
[Code].....
View 1 Replies
Jun 3, 2009
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]....
View 2 Replies
Sep 14, 2010
Im just trying to figure out how to write an LDAP query to list all of the PCs in a specific OU.
View 3 Replies
Jun 28, 2011
I have this code:
[Code]...
View 3 Replies
Apr 13, 2012
I am trying to create a CLR SQL Stored procedure that uses a query and adds the results to a list in VB.NET. Through debugging I determined that my add statement for the reader into the List is somehow converting my data types and throwing an error when I attempt to execute the compiled Stored Procedure.The columns I am querying are Integers
Code:
Imports System
Imports System.Data
[code].....
View 3 Replies
Aug 15, 2011
I have a List<string> that contains paths, such as:
[Code]...
Given a given root, such as Root, I would like to "query" this list to return only the first level values, such as:
[Code]...
View 2 Replies
Mar 19, 2012
I have created a database that allows me to sort through the hundreds of pictures I have based on certain criteria. The file path for each picture is stored in a text box in the database (file path). I am currently using this code to copy the files to a new folder:
My.Computer.FileSystem.CopyFile(file_pathtextbox.text, �E:photo_gallary�)
However, this only copies the first file in my query not all the others. I am at a loss as how to loop through them all so they all end up in their new destination.
View 8 Replies
May 3, 2012
I have a query that 'selects' object of a type:
Dim l as IList(Of Foo) = (From dataRow As DataRow In table.Select()
Where CStr(dataRow("Column1")) = "A"
Select New Foo(CStr(dataRow("Column1")), _
CStr(dataRow("Column2")))).ToList()
What's happening is that if i set a break-point to the constructor of Foo and step, the constructor is hit and the parameters are loaded with the arguments. However, l has empty Foo objects (the members in every object are Nothing). What could be happening here?
View 1 Replies
Dec 22, 2011
I have Customers table in a database. I'd like to create List of CustomerNames using entity framework 4.1. How can I do that in Visual Basic?
Dim customerNames = (From c In _context.Customers
Select New With {c.CustomerName}).ToList()
brings a list of anonymous objects.
View 1 Replies
Jul 6, 2011
Is it wrong? Please suggest me correct way.
Public Function ReadXML() As List(Of String)
Dim list As New List(Of String)
Dim xmlDoc As XDocument = XDocument.Load("C:\MappingFile.xml")
[code].....
View 1 Replies
