473,320 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Datagrid Question

Hi,

I have a datagrid in a VB.NET form with a set number of rows that the
user is required to fill out. But I don't want to allow the user to
add or delete rows from the datagrid. The only way I have found to do
disable this functionality is to set datagrid.ReadOnly or
datagrid.Locked equal to true - but when I do this, the user isn't
able to change the information in the cells. Is there some way to
disable the add/delete row functionality for the datagrid but leave
the editing functionality intact?

Joy
Nov 21 '05 #1
3 1848

<si***********@yahoo.com> schrieb
I have a datagrid in a VB.NET form with a set number of rows that the
user is required to fill out. But I don't want to allow the user to
add or delete rows from the datagrid. The only way I have found to do
disable this functionality is to set datagrid.ReadOnly or
datagrid.Locked equal to true - but when I do this, the user isn't
able to change the information in the cells. Is there some way to
disable the add/delete row functionality for the datagrid but leave
the editing functionality intact?


Hi Joy,

have a look at the example given here:
http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q653q

and add:

((DataView)cm.List).AllowDelete = false;

Cheers

Arne Janning
Nov 21 '05 #2

Thank you! But do you have a version of that code in VB.NET?? I am
struggling to convert it from C# to VB.NET.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 21 '05 #3
"Joy Labadie" <si***********@yahoo.com> schrieb

Thank you! But do you have a version of that code in VB.NET?? I am
struggling to convert it from C# to VB.NET.


Dim connString as String = "Provider=Microsoft.JET.OLEDB.4.0;data
source=C:\northwind.mdb"
Dim sqlString as String = "SELECT * FROM customers"
Dim connection as OleDbConnection = _
new OleDbConnection(connString)
Dim dataAdapter as OleDbDataAdapter = _
new OleDbDataAdapter(sqlString, connection)
Dim ds as DataSet = new DataSet()
dataAdapter.Fill(ds, "customers")
dataGrid1.DataSource = ds.Tables("customers")
Dim cm as CurrencyManager = CType(me.BindingContext( _
dataGrid1.DataSource, dataGrid1.DataMember), _
CurrencyManager)
DirectCast(cm.List, DataView).AllowNew = False
DirectCast(cm.List, DataView).AllowDelete = False

Cheers

Arne Janning
Nov 21 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: magister | last post by:
Hello, I have xml like this.... <test> <question>sdfsa</question> <section><question>43ga</question> <question>asdf</question> </test>
0
by: Randy | last post by:
Hello, I have two questions... I have a datagrid. I'm capturing the cell via HitTestInfo. The first question is fairly simple. I'm using an example of how to capture the row/column I found on the...
3
by: BBFrost | last post by:
Ok, I know how to count the number of selected datagrid rows using the code below. What has me stumped is how to determine when the selected rows within a datagrid have been changed. The...
6
by: BBFrost | last post by:
I'm using Net 1.1 (2003) SP1 & Windows 2000 Here's the issue ... Rows 12 thru 24 are selected in a datagrid. The user now unselects rows 12 thru 24 and selects rows 45 thru 70 ??? How can...
2
by: pei_world | last post by:
I want to implement a key hit with enter to dropdown a combobox that is in the datagrid. in this case I need to override its original behaviours. I found some codes from the web. Does anyone know...
2
by: Dominic | last post by:
Hi guys, I'm not sure if this question belongs to FAQ, but I couldn't find a concrete answer. I created a Datagrid control using ItemTemplate, but it's NOT a in-place editing datagrid. One of...
2
by: Sky | last post by:
Hello: Another question about trying to wring functionality from a DataGrid... Have a DB table of "Contacts" -- 14 or more fields per record Show in datagrid -- but only 5 columns (First,Last,...
3
by: Danky | last post by:
Hello Masters! Anyone can help me with the datagrid, well, the app load a lot of data from DB and it show on the datagrid, and well, I need to allow paging and.... the issue is with the event...
4
by: Jan Nielsen | last post by:
Hi all I'm a former Access developer who would like to implement a many-to-many relation in about the same way you do in Access: With a subform and a combo box. Is it possible to use a...
13
by: pmcguire | last post by:
I have a DataGrid control for which I have also created several new extended DataGridColumnStyles. They behave pretty nicely, but I can't figure out how to implement Selected Item formatting for...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.