sql server table displaying and updating from a datagrid 
Author Message
 sql server table displaying and updating from a datagrid

hello everyone,

i would like to connect a sql server table to a datagrid on a form,
but would like to be ableto change the records. how can i achieve
this? i seached for MSDN library but i think i have not looked at the
right pages because i could not find thr right code.

i need your help and would liekt to thank you in advance...

kindest regards,

cuneyt terzi



Sun, 05 Oct 2003 20:25:16 GMT  
 sql server table displaying and updating from a datagrid
Hi,

If you have used the data environment, have you made sure that the command
that you have created is not in Read Only? (Open the properties of the
command, select the Advanced tab, and select 'Optimist', to be able to
change data.

It worked for me.

Cordially,

Daniel



Quote:
> hello everyone,

> i would like to connect a sql server table to a datagrid on a form,
> but would like to be ableto change the records. how can i achieve
> this? i seached for MSDN library but i think i have not looked at the
> right pages because i could not find thr right code.

> i need your help and would liekt to thank you in advance...

> kindest regards,

> cuneyt terzi



Sun, 05 Oct 2003 20:54:33 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. DataGrid Control / SQL Server doesn't update data

2. Very Urgent:display/insert a picture into SQL server table

3. Updating A SQL server table through DAO and ODBC In Access 2000

4. Updating attached SQL Server Tables

5. Acc2000: Access tables attached to SQL-Server won't update

6. Simple update to a row in a table in a SQL Server database

7. Help me: Update SQL Server table through sqlDataAdapter...

8. SQL Server table update

9. Simple update to a row in a table in an SQL Server database

10. Update SQL Server table

11. Opening a SQL Server Table from a VB form for update

12. ADO, SQL Server Updating Recordset using 2 Tables

 

 
Powered by phpBB® Forum Software