Am using grids in VB.net to display database records stored in Microsoft Access, the tables allow editing and deleting using the grid fields. Is there a way I can monitor whenever a user deletes or edits a record? I want to be able to view details of every update or deletion to certain records, such as the date and users who did it.
View 2 RepliesI have this program im making it is supposed to be a basketball game monitor. The user enters two teams and the 12 players on each team then it has you pick the 5 active players and takes you to the run form where you can start the game once started you can add things like fouls and baskets made and attempted if a player gets 5 fouls or you hit stop clock you change which players are active and its supposed to update the database through the dataset and dataadapter but it doesnt seem to update the database with the info put in the datagrid view.
Here is the code of the run form i will also attach source in zip file if needed to point out mess ups
Update: When you hit resume game after change of players is when it puts zero on everyone again.
Basketball-RealTime-Monitor.zip (322.22K)
Number of downloads: 74
Imports System.Data
[CODE]...
This is what I have for code:
Private Sub restoreDatabase(ByVal dbName As String)
Dim newDbName As String
newDbName = dbName.Substring(dbName.LastIndexOf("_") + 1)
My.Forms.portfolioGenerator.Close()
[Code] .....
It seems like it should be pretty simple, I take in a file name as a parameter, create a new name for it, delete it, then try to copy it back from an older version of the same file, and update the connection string. However, it continually tells me that "The file 'filenamehere' already exists." If I set overwrite to true then it goes through just fine, except it doesn't actually copy the file. Obviously I also check the folder, and the file does in fact Not exist...I've also checked all the file paths and what-not, they are all accurate.
I am developing an application that Monitors a specific folder for file changes such as modify deletion, update, etc. The only problem I have is , the application doesn't fire up File events.
Here is the code:
Imports System.IO
Imports System.Diagnostics
Public Class Form1
[CODE].............................
I've got a dual monitor setup, my main monitor is a Dell 20" 1680x1050 res, secondary is a Dell 17" 1280x1024.I've just updated my gfx driver (nvidia driver version 190.62).I'm using code like that shown below to get the screens and I always assumed that AllScreens(0) would be the primary screen and AllScreens(1) would be the secondary but this appears to be reversed since I updated my driver.
[code]...
Is my coding in error or is Windows reporting the screen information wrongly ? How can I be sure to set AllScreen(0) as the users primary screen and AllScreens(1) as their secondary ?
I am creating an application in vb.net in which many users can add, update, and modify data stored in sql, but one user at a time. Users have to login to the application and then they can start their work. I want to know how I can monitor their work after they log out, like which user updated the record and at which time.
View 1 RepliesI want to make a process monitor tool with WMI that monitor the processes created or deleted, but the code will not work. Note to reference System.Management,
CODE:
Code dowload:
CODE:
I'm using VB.NET 2008 (framework 3.5). I would like to check permanently if a new entry (row) is added to a table in particular, (is there some equivalent of the FileWatcher for DB ?...)
View 4 RepliesCan I monitor the registry for changes similar to how sysinternals process monitor does it in VB? I have checked many different articles and C# samples but not come any closer to getting an answer, I would like to know if there an easier way (a VB sample perhaps)that you folks can share. Ultimately I'd like to be able monitor other things too like file system, processes etc but wonder most about how the registry can be done in VB...Would using system.management be a start? Or WMI? if so is there a nice VB sample..
View 3 RepliesI am fresher in vb.net but I have experience in vb 6.0. But I want to connect database in sql server through sql connection. In that case how to create connection with window or sqlserver authintication mode and how to add or update new record in data base in batch transaction. Please help me with sample code.
So that I can understand eassily.
update statement, i am trying to update a row within a access 2007 database here is my code.
[Code]...
I am using vb.net with access database. I am using sql. How can i update database with the value 40'6"(Feet and inches values)
View 5 RepliesWhat is wrong with this code. It does not update the access database and no error.
Dim conn As New OleDbConnection
Dim sqlQRY As String = "SELECT * FROM StdMaster WHERE StuNo = " & txtStudentNo.Text & " ORDER BY StuNo"
[CODE]...
I have the following windows service file:
Imports System.ServiceProcess
Imports System.IO
Public Class fswService
[Code].....
2 problems: first, intellisense error saying: 'fswService' is a type and cannot be used as an expression. second, I can not figure out a way to pass on to the service the path of the folder to watch (which is stored at My.Settings.userPath).
I have this in my form closing event:
For Each FileFound As String In Directory.GetFiles(App_Path() & "tmp", "*.txt")
File.Delete(FileFound)
Application.DoEvents()
Next
For Each FileFound As String In Directory.GetFiles(App_Path() & "tmp", "*.txt")
File.Delete(FileFound)
Next
I used to run through an ultragrid with a for each loop and that took forever, I stumbled accross this way and it's much faster but I noticed today I still have some straggling .txt files after the form closes at times. Is there a way to actually verify all the files have been deleted before closing the form?
I ran the same for each loop twice to work it out but not sure if that works or worsens it. Also, I'm not entirely sure what that application.doevents does as I initially thought it would finish all above lines before continuing but that does not seem the case. Anyway, these .txt files files are about 500KB and up to 1000 of them at any one time so it's not instant but it's still pretty fast, faster then looping through a grid.
I have the following code to delete a row in an Access Database Table. It executes with no errors, but the row is not deleted.
Dim adpMasterRecipe As OleDb.OleDbDataAdapter
Dim dsMasterRecipe As New System.Data.DataSet
Dim iIndex As Integer
[code].....
I have an ASP.NET application which creates temporary PDF files (for the user to download).Now, many users over many days can create many PDFs, which take much disk space.What's the best way to schedule deletion of files older than 1 day/ 8 hours ?Preferably in the asp.net application itselfs...
View 8 RepliesDoes anybody know if it is possible to download email messages and send something to the email server to delete an email from the server using ASP.NET?
I have developed a program to download email information from my email server, but I can't figure out how to send something to the server to delete an email. I developed what I have using the resources at this location[url]...
I am sick and tired of all the junk mail I am getting and want to write my own program to delete emails from my email server based on criteria I create.
I have VB 3.0, VS 6.0, VS.NET 2003, VS.NET 2005, VS.NET 2008 and VS.NET 2010 Express. I have developed web sites and standalone programs using VB and ASP.NET. My experience and knowledge is not extensive, but i do have enough knowledge to create a VB program.
I want to make a very simple program that remove duplicate domain name from a txt file. First, it must have a Open file Button so that it can load list of url to Listbox.
So, the URLs will be loaded into listbox. Then It has 2 more button Start and Save button Lastly one counter to calculate how many URL in that listbox
So example.. let say I have a txt file which contains URLs
[URL]
I open this txt file and loaded it into listbox (can scroll)
Then when I press start button, it will delete the URL that has same domain name. so the output will look like this
[URL]
Then I can save the URL from listbox to my disc drive as text file
My question is for admin or moderator of this site. First time I make a new post and I am able to edit my post that time only. after a day past i was unable to edit or delete my post. How to delete or edit my previous post.
View 2 RepliesI am looking for maby something I am missing here in this code. My goal is to take the current user and delete there local settings/temp/ files. However some of these files are in use by the OS and that's what im running into a problem with. Here is what I have so far and it finds the dir easly and bam that's the brick wall access denied error because there is some files in there that are in use.
[Code]....
I have the following code to delete a row in an Access Database Table. It executes with no errors, but the row is not deleted.
Dim adpMasterRecipe As OleDb.OleDbDataAdapter
Dim dsMasterRecipe As New System.Data.DataSet
Dim iIndex As Integer
[Code]....
I was looking online for a application that can delete a file more secure then. Kill(C: est.txt")Then i had a thought.Maybe i can make my own.Is it possible to make a secure file deleter in vb.net or should i look into C++
View 5 Repliesis there a way to update a database row with the update command by first defining all parameters and then all values just like you can in the insert command? "insert into table1 (parameter1,parameter2,....) values (value1, value2,....)"something like "set table1 (parameter1, parameter2) values (value1,value 2,...) where ...."?because I only know the syntax to define each parameters value "set table parameter1=value, parameter2=value2... where"
View 8 RepliesI am using this code for row deleting in gridview. It should be like this "while it deleted a row, take row number 5 with serial no 5, serial field of row number 6 should become 5. means decrementing the serial number after one row deleted." but it is not happening while I delete row no 5 with serial 5, the row number 6 remains the same.
[Code]...
I'm lending a copy of my .exe on a memory stick and because I dont completely trust them, , I would like to build in a function that as soon as my app has finished doing what its doing And the big red X is hit it will delete itself, but my problem is that i cant put the deletetion in the form closing because the prog is still running, so what should I do? Is there a way that I can get the app to close as soon as the dedicated task is complete, It will remove itself from the memory stick but if the X is hit before the process is complete the then the prog will remain.
View 14 RepliesHere's my
Dim result As New DialogResult
result = MessageBox.Show("Are you sure you want to delete " & LoadedEmployee.EmployeeFull_name & "?", "Employee deletion confirmation", MessageBoxButtons.YesNo)
If result = DialogResult.Yes Then
**code here**
End If
I'm getting the following error: Object reference not set to an instance of an object.
Is there a way to detect if a file is being deleted,
1) Using the Del key
2) Using the Shift+Del keys
3) Using the above keys from a remote computer through a shared folder
And instead of deleting move it to another folder in the same computer. Basically when a user tries to delete a file or folder it should move it to a specified folder instead of deleting it.
I want to make a fairly simple program that would prevent file deletion of certain folders andor files that i would input into the program. Say if someone tried to delete the file it would display an error message.
View 3 RepliesAdding and deleting a web part zone at runtime. I have tried all possible ways through internet but no luck.
View 1 Replies