I am trying to find some VB code examples on how to read the MFT/FAT Tables from NTFS and FAT32 drives. I am trying to scan the drive and to detect all deleted files and unallocated clusters on a particular drive.
View 4 Replies
I have the code given below for reading and displaying all the drives on a computer.However,it does not read the NTFS mounted volume..I need the program just to read the mounted drive,
Module Module1
Sub Main()
For Each drive As String In System.Environment.GetLogicalDrives()
[Code].....
I'm trying to make it so that it reads the xml, gets all the tables and puts all the tables names into the combobox..
i have tried..
ds1.ReadXml(meDirectory & "saves.xml")
With ComboBox1
.DisplayMember = "name"
[Code]....
I am trying to read records from a table base on unique values read from another table and want to write these records depending on value from a For Loop into different tables. This is code is what i have so far and it only read the last value of the loop and does not even write it to the appropriate table. [Code]
View 2 RepliesI'm trying to read data in Visual Studio from multiple tables. How do you read data from different tables? Do I have to create
[Code]....
[Code]...
I have Memberships and Bookings tables in database containing an attribute cust_id which is primary key in Memberships and reference key in Bookings. When i am executing data reader I want it to read cust_id values from membership table but it is reading it from the bookings table.....
[Code]...
Using Visual Basic 2008 express, I would like to access a database with 2 tables, one table (useraccounts) which has Users and Password and ID, and the other table which has information (linktable). Basically I would like to do a login form which reads from the table useraccounts and be able to create new users which will write into the database.
Another is that I have a form with a number of links which I would like to store in the table 'linktable' and it basically just gets the links from the table and straight to the form where it is used. I have tried using access or the .mdf files that visual basic has but I have been unable to find an answer for either.
I wouldn't mind using either access or the .mdf file for the database, I would just like it to work. Overall I am trying to get:
Login form which reads from database table 'useraccounts' and has a new user feature
Just a form that can read / write to the database once the save button is clicked.
how to read all the tables returned by SQL Stored Procedure? My Stored procedure returns two tables:
ID Name
-----------
1 Jeff
2 Joe
[code]....
i want to read data from both of these tables. I tried using SQLDataReader and then populating into datatables but then i can only read the values of 1st table. I want to read both the table values. How do i do it?
Can any one provide me the link or give me an idea how to read all the tables returned by SQL Stored Procedure?
My Stored procedure returns two tables:
ID Name
-----------
1 Jeff
2 Joe
ID Pages
----------
1 2
i want to read data from both of these tables. I tried using SQLDataReader and then populating into datatables but then i can only read the values of 1st table. I want to read both the table values. How do i do it? please let me know if you guys have any ideas how to deal with this.
this project im working on is giving me a headache. am trying to write a program to recognie both ntfs and ext3 fileformats and enable the copying of files between them. ive done the ntfs bit and my problem is how do i implement the ext3 file system reader and writer using visual basic.net.any references would be really useful.
View 1 RepliesAssessing NTFS user folder permissions
View 4 RepliesI have a piece of code to debug. Because of unknown bugs it creates a dummy filename. I want to track all the pieces of code who fires that creates the dummy filename, so I can change the dummy file creation to a thrown exception. Since I the dummy filename is stored on a string, I plan to modify that string to contain an invalid NTFS filename, maybe containing invalid chars. Is there a reason to prefer some invalid chars over others? There are some predefined invalid NTFS filename destined to this purpose? (I may think of AUX , COM1 , LPT1 or PRN , but those names run the risk of start sending data to a port instead of throwing an exception).
View 1 RepliesI need to build an app that can create a network share and give it full read/write permissions to everyone.
I have this code to create/delete network shares: [Code] But it only changes the NTFS permissions, not the share permissions. I'm running Windows 7 RC (64-bit) using Visual Basic 2008 Express. Does anyone have any ideas on how to change the share permissions, not ntfs?
Basically, we have an application which batch creates a large amount of files (pairs of PNG plus ASCII). The file count can exceed the one million.The first time the application ran the results were quite disappointing. The files get stored in folder structures of maximum 2000 files per folder. The tree depth gets only to two levels (root + packs folders). So the results would be stored in folders like "pack1","pack2"..."packn" each containing no more than 2000 files (1000 pairs in essence).
So getting back to the results, what happened was that although the application reported over 1.4 million files written, the results were that files were missing from the filesystem and others were corrupt (PNG cant be read and ASCII were blank filled with spaces).The speed that the files were written was not anything great (about 7 files per sec) and the total size ranged from 160K to 1.5M (rarely). The PNG images are 2000x2000 in size although I doubt it has anything to do with my problem.
Everything is done in pure .NET (image and ascii generation).The OS that has been tried was Win 2000 Advanced Server, Win 2003 Server plus XP Pro. The hardware ranged from Dual Core Workstation to high spec servers. The irony is that on the XP system the number of corrupt files was quite low where on the other two all hell broke loose. There were event logs written stating Event ID 2021 on the Win 2000 system and Paging faults on XP, which lead me to the next approach.
We wrapped the code to do an Application.DoEvents every second and refresh various statistic UI components. We obviously added Stream.Flush().Plus we added code to check the files (re-read them) once they are written. Even added "WriteThrough" option to avoid the OS cache! The result was stuggering as no errors were report yet the NTFS table again got corrupted!Now we inserted Thread.Sleep(100) after writing and then reading to confirm the file. Obviously this is slowing down the process but hope to have more stable results.
Reading and article about Event ID 2021 we saw it was suggesting to modify registry values, but the IT dep did not wish to accept this as they believe it is an application error.In pseudo code, here is more or less what is done:
<try>
<Create Image in memory>
<Open stream to filesystem>
[code]....
I'm trying to make a small app that reads MFT from a NTFS drive and lists deleted files and their names. The code is not ordered since its not finished yet. I made it basing on information a read at ntfs.com and some other examples found on the net. But the problem itself is the following. I have hard disk with to NTFS partitions, the main one having 250 GB and the second one having 1,5 GB. If I execute my code on the smaller drive, (using D as parameter for readfile api), I get the list of all deleted files exactly (I checked it with a recovery file app).
The problem is when I execute it on the other drive (C where Windows is installed, 7 if it matters), the problem is that I cant find any deleted file!!. The code gets all the files from MFT and then saves in a string variable only the deleted ones, I found that after deleting one file, it also disappears from the MFT (at least using my code). So, there may be some other way in which NTFS marks deleted files? As you see in my code, I iterate through the MFT entries and, from those that start with FILE, I take bytes 22 and 23 (0 base) and evaluate, if its value is 0 then its deleted, otherwise, it isn't (its a file or directory I think).
Public Structure SECURITY_ATTRIBUTES
Dim nLength As Integer
Dim lpSecurityDescriptor As Integer
Dim bInheritHandle As Boolean
End Structure
[Code] .....
I need to gain access to Windows NTFS unique FileID...via VB.NET 2003...I found Kernel APIs ZwQueryDirectoryFile... calls which can return this info.
View 3 RepliesI am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
have a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped)
da.Update(dt) << This line
'da = dataadapter
[code].....
In my datagridview I was fill in using join tables (table1 = pr_employees, table2 = pr_employee_deduction). My problem now is during save button I want to update records from table2 only.[code]
View 3 RepliesWe are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
I have a 5 tables in my database and i want to access all my tables togather at a time.e.g.I have a code for one table i.e. rs.Open "select * from Group_info", con, adOpenDynamic, adLockBatchOptimistic. instead of Group_info table i want to access 5 tables also as Login_table,User_info table,group_name table etc. How i do that
View 11 RepliesSQL statements:
SQL = "SHOW TABLES;"
Try
conn.Open()
The remarked area works fine when I'm accessing a specific table. I've successfully inserted the products_model field into the combobox too. The datagridview does show the table names in the db using the SHOW TABLES sql statment, but I'm not understanding how to get this info into the combobox instead.
I am trying to make a database, fill it with tables and then fill the tables. I am having problems connecting to the server and am really not sure why. I have posted this thread in two areas of this site because I was not sure what was the best area to put it in. [code]
View 3 RepliesI am working on a project in VB 2008 and need it to do this:Read first line from text file (using Openfile)Enter line into textbox on formDo some other codeThen Read second linefrom text fileEnter line into same text boxand loop until we have gone through text fileI am not sure how to read line by line from text file then enter it in textbox. I can open the Openfile and get the filename and everything, but I just am not sure how to read from it or enter that line into the textbox.Here is what I have, its not much but its a start:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim FileReader As StreamReader
[code]....
I have a dictionary object (let's call it _do) I am using to cache some values for use in a multi-threaded program. I have a single controlling parent thread, with a timer function _doTimer() which can kick off child threads with a new instance of class MyThreadObject in each. My parent thread has _do as a property and with each time _doTimer() gets called, it may or may not repopulate _do depending on cacheflag settings. I pass a reference to _do to each instance of MyThreadObject and those threads at some point read the values of _do but DO NOT write to it.
What I want is to ensure that the child threads do not try and read _do whilst the parent thread is writing to it. Same thing but very slightly different -> I also don't want the parent thread to write to _do whilst the child threads are reading from it. However there is no problem with 1 child thread reading the values of _do at the same time as another child thread is reading the values - so ideally I do not want each child thread to completely lock out read access, only locking out Write access.. The code is roughly like this:
[Code]....
Private Sub frmReportExpenses_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim objDatasetExpence As New dSetExpences // dataset object named as dSetExpences
Dim objRptExpence As New rptExpences // Crystal report object
Dim MyCommand As New OleDbCommand()
[code]....
This code show error "Report has no tables"i want to show crystal report using Access 2003 Database pragmatically. blank report is added in project and trying to fill it DataSet object.
I signed up for a free 30 of Azure. I logged in, created a database. I am able to connect (=Test Connectivity). But that's it. I don't see anyway to create tables, etc. Also how can I connect this db to vb.net (I am using vs.net 2010)?
View 3 RepliesI've been programming an application for someone, and have run into various questions.
View 2 RepliesI really need assistance for this multiple problem am facing here. Let me take you to my hell: I've got three tables in my database that are:
1) tbAthlete (athleteID, nationID, gameID, fname, lname)
2)tbNation (nationID, nation)
3)tbGame (gameID,game)
I connected the database to vb and created a (form1) based on a query that use all fields except IDs. that form1 is just good as displaying and navigating throug records. Now i wanted to link that form1 to another form(2) which will allow me to update and add new record. in the form2, country and game need to be combobox as there is no need to enter new record for them. so when adding new record, only "tbAthlete" table get affected. form1 works as excpected. how do i go for the form2
How to check whether two tables in SQL are the same using vb.net? Would u mind giving me the code?
View 2 Replies
