I tried the following code but it did not work.
Private Sub PasswordDataGridView_UserDeletingRow(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewRowCancelEventArgs) Handles PasswordDataGridView.UserDeletingRow
[Code]....
This program is going to submit GET data to our webpage. However, we don't want users accessing the webpage any other way than the program. We can prevent users from sharing the program using HWID authentication, but nothing prevents them from using a packet scanner to get the URL of the webpage. We thought about user-agent authentication, which we will implement, but user-agents can easily be spoofed.
how can we prevent users from accessing the webpage directly, instead of through the program?
Currently we will be implementing:
HWID Authentication to use the program User-Agent Authentication to access the web page Instant IP Blacklisting to anyone accessing the webpage without the proper User-Agent
how do I prevent my users for more than one simultaneous login per account. I am using Vb.Net SQL.
View 2 RepliesThe app uses several forms to let the user enter information. In each form the info is entered into textboxes and dealt with elsewhere when the "Enter" button is clicked. A lot if the info entered is used in calculations and so must not contain alpha characters, only numbers. What is the best way of examining each entry and identifying any that are not numbers, so that I can ask the user for a correction with a MsgBox?Prevent Users Entering Letters Instead of Numbers?
View 10 RepliesI have a project that uses a number of DataGridView controls. Most of the cells are of the DataGridViewTextBoxCell persuasion. I declare my controls like so:Dim MyCell as DataGridViewCell Later I specify whether they are DataGridViewTextBoxControls or DataGridViewComboBoxCells like so:
MyCell = New DataGridViewTextBoxCell MyCell = New DataGridViewComboBoxCell None of the places in my code require the ability for the users to enter their own values in the Combo Boxes. That is, they are either hard-coded or the values are gathered from other data within the application.
Currently, users can highlight a combo box control defined as shown above and begin typing anything they like. For example, I have one combo box that offers the user a selection of integers between 1 and 9. I can highlight the combo box cell and enter "Hello, World!" if I'd like.What does it take to disable this ability? I'm sure there's a property, but I have yet to find it. I have searched the Internet, and have found only the ability to have user-entered values added to the list and a stream of data-binding tutorials.
I have built a vb.net web application. I have tried to make it secure, with all users requiring a password to get in. The only problem is that if anyone can guess (or detect using some kind of hacking tools) the url of the javascript file, they can download it and read it, without even having to log in first.
Is there any way that this can be prevented?
I have written a program in VB 2010 that dumps documentation info into an Excel file. Basically, the Excel file is a log file that keeps track of revisions for design drawings at an engineering firm.
There are approximately 20 people that have access to this program. However, I've run into issues where multiple users may be using the program and trying to send info to the Excel file at the same time. The Excel file is set to read only. My program opens the file with write access, and dumps the info into the appropriate cells, then closes the file. If one person is in the process of using the program, it causes an error with another persons system if they try to use it at the same time.
In some cases, it causes my program to crash, and it leaves the Excel file open on someones system.
Typically, my program would only have the Excel file open for a couple seconds. So, the issues mentioned above are rare, but they do happen.
I'm looking for ideas to prevent this issue from occuring.
I have created a scrabble game that generates random letters. For the user to type in a word using the random letters they have to type it in a text box.
I want my program to prevent users from typing in letters that are not provided in the text box and to allow them to type in the random letters that are provided.
I have a datagridview control that displays a list of expenses. I would like to code a button that will delete the record from the DGV and the DB table. Then I would like it to update so the DGV still shows up the updated DGV
View 3 RepliesI have a form with a DataGridView binding to an Access database. Everything works fine and it populates perfectly. Except when I delete a record. I get the following. I found a few threads about the issue but I cannot resolve the issue. Can some one give me a step by step to resolve this. [Code]
View 4 Repliesi am working on datagridview vb.net 2005 i am trying to modify the data with datagridview control the problem is the data is virtually modified in datagridview but no Change happened in my sql server 2005 database
View 6 RepliesI have a DataGridView in my Form. I am adding a handler as follows:
Private Sub DataGridView1_SelectionChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGridView1.SelectionChanged
If Me.DataGridView1.SelectedRows.Count > 0 Then
[Code]...
I have a datagrid and am using excel to store te data in. how can i delete ive tried a few things but nothing seems to work.including just the top line of code with dispatch = @Dispatch, and so on with all my column names
[Code]...
I want to delete several records from a datagridview.
I can delete one by one, but not all in one go. I want to select several rows and then delete.
My code is:
Dim delContacts As String
'strDelContacts = DataGridView1.SelectedRows.Count
strDelContacts = DataGridView1.SelectedCells.Count
[Code].....
i have a datagrid which i add values with this code
Me.dgAppraisal.Rows.Add(Me.cmbAssementArea.Text, Me.NumericUpDownArea.Text, Me.txtremark.Text, Me.txtcoment.Text)
What i want to do is to prevent duplicate entries of values in a column.I am using this code but it is not working.
If Me.dgAppraisal.Rows.Count > 0 AndAlso Me.dgAppraisal.Rows.Contains(Me.cmbAssementArea.Text) Then
ErrorProvider.SetError(Me.dgAppraisal, "Employee has already been assessed on
[Code].....
This is such a basic question, I'm almost embarassed to ask it. How do I loop through seleted rows in a DataGridView and remove the rows?I've tried this, but it doesn't work. After one row is removed, the index is all screwed up.
[Code]...
I have a List of an object, set to DataSource of a BindingSource, set to DataSource of a DataGridView. Then I added a DataGridViewButtonColumn which I want a click to remove that record from the collection. So I simply call collection. RemoveAt (e.rowIndex) from the DataGridView CellClick event. However this produces an IndexOutOfRange Exception; "1 does not have a value"..
So is happening here? I have maybe a vague idea, but would like to understand exactly which events are failing etc.. and what do i need to do to perform this action properly?
EDIT: This seems not to happen if I use a BindingList.. But when using a List, I get this problem..
I am trying to delete a row if the program finds a duplicate entry.
View 3 RepliesI want to let others to delete selected row in the following datagrid view and I have written it like this. Now when I select a row and press the delete button I can remove the selected row
but it will not update the database which meant it will not deleting the above row.
I have bound my datagrid view using databinding.
Private Sub dgvAllInvoices_UserDeletingRow(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewRowCancelEventArgs) Handles dgvAllInvoices.UserDeletingRow
If MessageBox.Show("Do you really want to Delete this Invoice ?", "SD Technology", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = DialogResult.Yes Then
[Code] .....
I'm implementing drag and drop functionality between two datagridviews. This works as intended with one exception: it is possible to drag and drop within the same datagridview. This results in duplicated rows. I want to limit the functionality so that I can only drag from one datagridview to another.[code]
View 3 Repliesvs 2005 sql 2005 developer/I have a datagridview with 4 columns .I want the user to be able to use the arrow keys to move through the rows and just two of the columns.I want the other two rows to behave like a label that cannot get the focus. Nor be selected.I have been messing arround with the "cell enter" event but the language wont let me set the selected cell from within that routine.
View 4 RepliesI have a datagridview. If the user adds a new row, and then clicks away from the grid. How can i stop them from doing this?
I want them to finish the row add first or cancel it. I want to then update the table adapter in the grid's leave event.
If the row validation fails, i want to display a message and re-focus to the cell in question.
The first problem i am running into is that the focus continues to go to the control that the user clicked on to move away from the grid.
How do i cancel that event?
As an example, if the grid is on a tab page and the user clicks on another tab page, i want to prevent that page from displaying if there is an error on the row that is being added to the grid.
I was hopeing for a cancel option in the lost focus event of the grid.
the Datagridview is included in first tabpage. first tabpage is the search form and the second tabpage is the record detail view. user is switching and working between those two continuously.
The problem is that everytime user selects the tabpage1 the datagridview repaints itself. there is about 6000 rows in datagridview so it takes about 2-3 sec to paint itself. I know the delay is normal and can't avoid that. but it affects the tabpage selection. tabpage1 isn't selected completely until the Datagridview1 finishes it job. in this time the tabpage1 and tabpage2 gets combined and confused.
is there a way to put datagridview processing in backgroundworker or something that doesn't affect main UI ?
How would I delete only the successful inserted rows for insert and then move the non successful rows up and allow the user to correct the data and get it ready for an insert. If I dont delete the successful rows then I will have multiple inserts of the same dataRow and we dont want that! And if I don't move the data up then it will have blank rows uptop and will end the try and not insert the corrected data. You can better see what logic I am trying to perform at the bottom of my code, right after I insert into the database.
Here is my code.
Private Sub btnLaserGenerateTicket_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLaserGenerateTicket.Click
'Function declarations
'Object declarations
Dim localOutputServer As SQLServer = Nothing
'Variable declarations (Form)
[Code] .....
I have MS ACCESS database and a table name as ALARM.table fields areDate- property ate/timeTime- property date/timeMessage - property textnow I am updating the datagridview in alarm conditions,and when I press delete button I want that the selected row must be deleted., my code is
Dim conn As OleDb.OleDbConnection
Dim strSQL As String
Dim strConn As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:gcodeuser.accdb;
[code].....
I am having problems deleting any rows from a cascaded DGV. I get a run time error complaining that I am breaking a constraint almost as if LINQ is try to delete from the parent table. I have 2 DGVs on a form one displaying Species and the other all SubSpecies for the currently selected species and that works fine.
However when I try to delete a SubSpecies I get the following exception:- An attempt was made to remove a relationship between a Species and a SubSpecies. However, one of the relationship's foreign keys (SubSpecies.SpeciesID) cannot be set to null. At first I thought the error was raised by SQL server due to the Cascading Delete limitations on L2S but the error message for that is very different the DataContext.Log doesn't show any attempt to change the data.
The code used to bind the DGV's is as follows:-
Protected Sub BindControls()
Try
DC = New DataClassesWhatToPlantDataContext
[code]....
Here's my code. It gaves me an IndexOutOfRange exception. What's wrong with it?
[Code]...
With a DataGridView bound to a bindingsource, which is filled by da.fill(ds) . How do I go about deleting selected rows when the UserDeletingRow event is fired? I've used the following code in the event:
Dim dsEmplTran As New DataSet
daEmplTran.Fill(dsEmplTran)
dsEmplTran.Tables(0).Rows(dgvEmplTran.SelectedRows(0).Index).Delete()
Dim cb As New SqlCommandBuilder(daEmplTran)
[Code].....
I'm almost embarassed to ask it. How do I loop through seleted rows in a DataGridView and remove the rows?[code]
View 2 RepliesI have now got a DataGridView on a form with a toolstrip which automatically created for me when I dragged the DataGridView from the DataSources on the Solution explorer window. I now would like to know how can I have a pop out window saying " Are you sure you would like to delete xxx?" with a OK button and Cancel button.
View 7 Replies