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 Replies
I have widows7 on my dell notebook than tried to make my personal program on vb 2008
I wand to make program that i can input data and update, delete records from access7
I have this code that gives me the user logged on name of a remote computer, but if i run the program in certaing computers, it returns with the error "Not Available Due Restrictions" which is set if the scope cant connect... why it connects fine in some computers and other not..is there something i have to add to the code for it to run fine in any computer
[Code]...
Is there a way to make an update for your program that the 'user' can update the app without re installing the whole program?
View 1 RepliesOn my website I have user records. For the user records page I have three options you can do with each user record. Delete, Update and Email are my checkboxs's that I am trying to use.
<Input Type=CheckBox Name=Delete OnClick="False" Value=<=rs("num")%>><br>
<Input Type=CheckBox Name=Update OnClick="False" Value=<%=rs("num")%>><br>
<Input Type=CheckBox Name=Email OnClick="False" Value=<%=rs("num")%>>
What I want to be able to do with these check box's is when one of these slections are made, I want to be able to pass the value of the selected checkbox by pressing a button over to another page where I have a IF statement. Then value of the selected checkbox runs though the IF statement and matchs with the option in the IF statement.
[Code]...
So I guess what I am looking for is how do I get the value of the checkbox to pass over to another page and run through my IF to match with an option in my IF statement.
I want to know how to Update / delete the table records in ASPNETDB.MDF in single update / delete query ?
View 1 Replieshow to display data in grid view using code that you can edit, update and delete the data...do i need to have a stored proc in this?
View 4 RepliesI can add new/delete info to data, but cannot update/edit, I have tryd everything that I could, but no luck on my side, I have put txt file of my page.
View 5 RepliesI'm developing an application for my ping SQL Server 2005 as database and VB.Net 2008. Ive created the form and successfully connected all text boxes etc. Using the code, I have managed to open the database and fill the dataset. However when I BIND the Datagrid datasource to the Dataset, I can only see the COLUMN NAMES in the datagrid and not the rows or the data. How to Insert, Update and Delete data. I'm fairly new to VB.Net but I have used VB6 before
Private Sub cmdAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAdd.Click
Dim con As New OleDb.OleDbConnection
Dim dbprovider As String
Dim dbsource As String
Dim ds As New DataSet
[Code] .....
How to Insert, Delete and Update Data in a Datagridview using MySql as the database? There is a textboxes and button that adds data in the database and i want it to be refresh the datagridview.
View 3 Repliesi m using fallowing code for update, delete and save data it's working very well when i save new recored but when i update and delete recored it's showing error message "Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information."
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If thismode = 0 Then
row = ds.Tables("state").NewRow()
row.Item("state") = TextBox1.Text
[code].....
I am working in this and I am kinda confused about it, I have to add,update, and delete in the database this is what I have so far.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
I need to make a CRUD application using the XML and VB.net. How to create, write, read, update, delete the data only using XML file and VB.net.
View 10 Replieshow retrive and delete data in vb.net. I am using access database.
View 2 RepliesWhich method is professional to insert, update, delete data using either MS Access database or SQL database?
1) Using wizard to connect the database
2) Writing code manually such as
"INSERT INTO CUSTOMERS(CNO, CNM, CTY, TEL, TDT, NTS, UID) VALUES(@CNO, @CNM, @CTY, @TEL, @TDT, @NTS, @UID)")
I need to insert data from one form (Collection_Form) to 2 database tables. Like, Collection form data to be added in the following 2 tables:
1) Customer_Account
2) Collection_Account
how to add, insert, delete and search data in vb 2008 using mysql databases.
View 1 RepliesI got a system which i want to insert, delete, update the data into my database and the data from database will be display using datagrid. The below is the coding for one of my button, delete.
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Try
btnSearchEmpNo.Enabled = False[code].....
Now I wanna set when user click on this button to delete a employee (for example) then the datagrid that i have in my application will not show the data of the deleted employee but in the background, the employee haven't been deleted from database.The employee only will be deleted from database when the user click on SAVE button.I know this application have to use RowState but how?
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'm trying to update a data user using vb.net2008 and sql server management studio express for my backend. the error says "must declare the scalar variable "@username" here's the code .[code]...
View 14 RepliesHow can i delete selected row from data grid using delete button [code]...
View 4 RepliesI created a Security Log On that starts when i turn the computer On.Like the Windows Log On.
I managed to disable alt+F4, alt+tab, window key, ctrl+esc, but i have only one problem disabling the task manager or the CTRl+Alt+Delete Button, is there a way or any codes to disable this? im using VB.net 2005.
I am building a simple form wicht allows the user to update the data on it.I use this
Imports System
Imports System.Data
Imports System.Data.OleDb[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'm trying to create a program, that upon opening, will read an input file containing a delimited employee record. The record will contain the name of the employee, their salary and the number of years they have been employed.I'm looking to display only the name of the employees in sorted order(alphabetically) and then when the user of the program selects a particular employee, I want to display the salary and number of years for that employee.I would like the user to be able to edit the recors for the employee and I would also like to have a way for the user to be able to add/remove an employee record and update the input file before the program is closed.
View 5 Replieshow can i stop ctrl alt delete f4 windows task manager in my application
View 6 RepliesIs there any way to automatically update the data viewing on a datagridview when data is changed in the database by some other processes/Program?
View 4 RepliesI have a program that records time data in database when the user performs task. When I published the program for user install, I did not specify any update location. So, since initial creation, whenever I need to update the software, I simply install the new .exe file and this overwrites the old version and erases all data created by the old version (similar to uninstall and reinstall). Is there a way to only install updates to the software so that all data is not erased each time I need to update? Seems like this would be simple, but I can't figure out how to do it and am quite new to programming. I will eventually want to have the software check for updates online, but I need to understand how to update from a local file location first (without erasing current data).
View 3 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 the code for displaying data from database to gridview....If i am doing any changes in GridView and it has to update in database.[code]...
View 1 RepliesI want to launch a bunch of threads, each performing the same task, and know in main() when each finishs and it if it was successful or failed.The solution offered was to use a ConcurrentQueue, but other posts have recommended using a BackgroundWorker Class, or a thread pool.Is there a definitive answer?Again, all threads perform the same code and have a pass/fail result. I want to run more than there are available threads so as soon as one thread finishes I will launch another asap - I want tehm to stress a remote systems as much as possible (reather than stressing my local PC with too many threads, so I will need to experiment to determine the optimal number of threads).
View 4 Replies
