Disabling Editing on previous records but Adding new Records in data table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

I have an existing data table called POdatagridview. It is bound with a table in the SQL Server database. What I want to happen is to disable editing of the previous records in my front-end but I can able to add new records in the data table.

I tried disabling edit via Properties but, I couldn't add new records.

VB

Private Sub PODataGridView_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles POdDataGridView.CellContentClick
        Me.PODataGridView.AllowUserToAddRows = True
    End Sub

Please Help. Non-computer major here. :)

Posted 29-Oct-13 2:03am

Karen Lim Yeung

Updated 29-Oct-13 2:21am

Thanks7872

v2

Add a Solution

Comments

jaideepsinh 29-Oct-13 8:13am

Can you show us what you tried and paste you code here.

Karen Lim Yeung 29-Oct-13 8:17am

Private Sub PODataGridView_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles POdDataGridView.CellContentClick
Me.PODataGridView.AllowUserToAddRows = True
End Sub

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Madhu Nair · Answer 1 · 2013-10-29T18:53:00

Solution 1

Check for the Primary key value of the current row. If you are adding a new record then make the primary key value to -1 else original primary key value will be populated in the datatable. So while editing check if the primary key value for the current row is -1 or not. If -1 then allow editing. Else disable editing.

Posted 29-Oct-13 18:53pm

Madhu Nair

Comments

Karen Lim Yeung 30-Oct-13 1:04am

I think this will be an appropriate solution. Problem is I don't know to code the primary key. My primary key is the "No" column, where it is in an auto number.

Karen Lim Yeung 30-Oct-13 1:20am

I tried this code, but it doesn't work.

For Each col As DataGridTextBoxColumn In PODataGridView.Columns
If No.HeaderText = "-1" Then
PODataGridView.EditMode = True
Else
PODataGridView.EditMode = False
End If
Next

Madhu Nair 30-Oct-13 1:24am

It shouldn't be headertext it should be either cell value if you are using it in your grid or fetch the primary key value from the datatable for the selected row

Karen Lim Yeung 30-Oct-13 1:38am

It still doesn't work. :(
If NoDataGridViewTextBoxColumn.HeaderCell.DefaultNewRowValue = "-1" Then
PODataGridView.EditMode = True
Else
PODataGridView.EditMode = False
End If