Datagrid problem

[juya]

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!

[Cor Ligthert [MVP]]

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!

[KnighT]

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.

[juya]

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!

[Cor Ligthert [MVP]]

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!