Afternoon all, I'm working on one of my very first modules and have stumbled on an early stumbling block (to coin a phrase).

I'm testing out what can be done with modules and have worked through the great examples on adefwebserver.  However, I'm a little stuck.  Rather than go full on DAL+ I'm doing my experiments with direct communication to the DB, using the 'SuperSimple' module as my starting point.

Reading data is great, but now I'd like to insert some data.  I'm constructing my SQL string OK but when I come to run it against the DB my (very new) .net skills are coming unstuck.

The datagrid read is done thus:

With Me.GridViewResults
            .DataSource = CType(DataProvider.Instance().ExecuteSQL(mySqlString.ToString), IDataReader)
            .DataBind()
        End With

And I'd like to be able to INSERT a row using a similar mechanism, my insert statement is contained within a stringbuilder called sqlstring.  I'm drawing together the data from a number of text boxes and then manually creating the string.  (I know I should be using SPs but... it's my first semi serious module)

Help would be much appreciated, then I can crack on with making my modules do what they really should be doing!

Thanks very much in advance!

-- Chris

Thanks mcsenow,

I'd not stumbled across these resources before but I'll take a look.

-- Chris