By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,234 Members | 1,869 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,234 IT Pros & Developers. It's quick & easy.

Datagrid problem

P: n/a
Hi all,

I have been struggling with datagrid for more than a week. I pretty new
to datagrid, have never used it before.

All I am trying to do is Edit the TDBGrid in Visual basic. I am
populating the Datagrid from a adodb recordset. Here is my code

Dim rssqldb As ADODB.Recordset
Set rssqldb = gfGetData(Conn, 10, "exec payroll" & "'12/01/06'")
TDBGRID1.datasource = rs

I have set the properties for allowupdate,allowinsert, etc to be true.
Datamode is in bound mode.

I can see the data in the Datagrid, but cannot edit it. Can anyone pls
Help!

Dec 13 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
juyja,
The datagrid is not mad for a recordset. What is in fact also not with
complete dotnet.

Can you tell a little bit what you want because the datagrid exist as Web
and windowform media.

In fact it is using a datatable and than a dataadapter.

As well tell what kind of database you are using, maybe we have than a
sample for you.

Cor

"juya" <ma******@yahoo.comschreef in bericht
news:11*********************@73g2000cwn.googlegrou ps.com...
Hi all,

I have been struggling with datagrid for more than a week. I pretty new
to datagrid, have never used it before.

All I am trying to do is Edit the TDBGrid in Visual basic. I am
populating the Datagrid from a adodb recordset. Here is my code

Dim rssqldb As ADODB.Recordset
Set rssqldb = gfGetData(Conn, 10, "exec payroll" & "'12/01/06'")
TDBGRID1.datasource = rs

I have set the properties for allowupdate,allowinsert, etc to be true.
Datamode is in bound mode.

I can see the data in the Datagrid, but cannot edit it. Can anyone pls
Help!

Dec 14 '06 #2

P: n/a

juya wrote:
Hi all,

I have been struggling with datagrid for more than a week. I pretty new
to datagrid, have never used it before.

All I am trying to do is Edit the TDBGrid in Visual basic. I am
populating the Datagrid from a adodb recordset. Here is my code

Dim rssqldb As ADODB.Recordset
Set rssqldb = gfGetData(Conn, 10, "exec payroll" & "'12/01/06'")
TDBGRID1.datasource = rs

I have set the properties for allowupdate,allowinsert, etc to be true.
Datamode is in bound mode.

I can see the data in the Datagrid, but cannot edit it. Can anyone pls
Help!
Check out this link:
http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

Datagrids are not very easy to work with. Are you using the visual
designer, or strictly source code ?

I think you need to write code to handle the edit. I think I got this
working once by tweaking the datagrid properties from the form designer.

Dec 14 '06 #3

P: n/a
The database is sql server. I am also using visual basic. Thanks and
any help would be greatly appreciated.


Cor Ligthert [MVP] wrote:
juyja,
The datagrid is not mad for a recordset. What is in fact also not with
complete dotnet.

Can you tell a little bit what you want because the datagrid exist as Web
and windowform media.

In fact it is using a datatable and than a dataadapter.

As well tell what kind of database you are using, maybe we have than a
sample for you.

Cor

"juya" <ma******@yahoo.comschreef in bericht
news:11*********************@73g2000cwn.googlegrou ps.com...
Hi all,

I have been struggling with datagrid for more than a week. I pretty new
to datagrid, have never used it before.

All I am trying to do is Edit the TDBGrid in Visual basic. I am
populating the Datagrid from a adodb recordset. Here is my code

Dim rssqldb As ADODB.Recordset
Set rssqldb = gfGetData(Conn, 10, "exec payroll" & "'12/01/06'")
TDBGRID1.datasource = rs

I have set the properties for allowupdate,allowinsert, etc to be true.
Datamode is in bound mode.

I can see the data in the Datagrid, but cannot edit it. Can anyone pls
Help!
Dec 14 '06 #4

P: n/a
Juya,
The database is sql server. I am also using visual basic. Thanks and
any help would be greatly appreciated.
That was not my question

Repeating, is it for a web or a windowsform application.
In other words is it ASPNET or not.

Cor
"juya" <ma******@yahoo.comschreef in bericht
news:11*********************@l12g2000cwl.googlegro ups.com...
The database is sql server. I am also using visual basic. Thanks and
any help would be greatly appreciated.


Cor Ligthert [MVP] wrote:
>juyja,
The datagrid is not mad for a recordset. What is in fact also not with
complete dotnet.

Can you tell a little bit what you want because the datagrid exist as Web
and windowform media.

In fact it is using a datatable and than a dataadapter.

As well tell what kind of database you are using, maybe we have than a
sample for you.

Cor

"juya" <ma******@yahoo.comschreef in bericht
news:11*********************@73g2000cwn.googlegro ups.com...
Hi all,

I have been struggling with datagrid for more than a week. I pretty new
to datagrid, have never used it before.

All I am trying to do is Edit the TDBGrid in Visual basic. I am
populating the Datagrid from a adodb recordset. Here is my code

Dim rssqldb As ADODB.Recordset
Set rssqldb = gfGetData(Conn, 10, "exec payroll" & "'12/01/06'")
TDBGRID1.datasource = rs

I have set the properties for allowupdate,allowinsert, etc to be true.
Datamode is in bound mode.

I can see the data in the Datagrid, but cannot edit it. Can anyone pls
Help!

Dec 15 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.