datagrid control & stored procedures - how to use together

From: steve (steve_at_earthlink.net)
Date: 07/26/04 

Date: Mon, 26 Jul 2004 10:39:37 -0700

I'm trying to write a small app using vb.net going to SQL Server 2k, and
using
Imports System.Data.SqlClient

Imports System.Data.SqlTypes.

I'm using all stored procedures, necessarily, and am having quite a bit of
trouble interogating, updating, and generally manipulating the datagrid
control.

The control apparently presumes access directly to tables, which is
unacceptable in my environment. I've yet to see any examples of using stored
procedures to fill the datagrid control, and stored procs to interface with
the control and update the db.

I realize this isn't keeping with the way Microsoft designed the control,
but my environment requires -all- access to the db to be abstracted through
stored procedures.

Can anyone point me to some decent code examples - using a grid control in
vb.net - and using stored procs /TDS to select from and update the db ?

Thanks -

Relevant Pages

  • Re: SP Source Control Options
    ... > relies heavily on Stored Procedures on SQL 7. ... > What options are there to implementing Source Control on ... Script them out of SQL Server, ... control system. ...
    (microsoft.public.sqlserver.security)
  • Re: SP Source Control Options
    ... > relies heavily on Stored Procedures on SQL 7. ... > What options are there to implementing Source Control on ... Script them out of SQL Server, ... control system. ...
    (microsoft.public.sqlserver.security)
  • Re: This seems slow...Why???
    ... Is your table bound to a control or controls? ... I've gotta form with the following code in the ... > The DataAdapter is using Stored Procedures and I'm seeing dismal ... performance on my local development machine. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Prevent direct connections
    ... If this is not possible then you can apply some control by denying direct access to user tables and only allowing it through stored procedures. ... Mark Allison, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Beyond Freedom and Dignity: A Philosophical Review
    ... A learning machine is "controlled" by it's environment in the sense that by ... the future behavior of the robot will be changed. ... This is what is meant by the machine being under the control of the ...
    (comp.ai.philosophy)