View Single Post
  #2 (permalink)  
Old May 27th, 2004, 03:21 PM
bmains bmains is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

SQLConnection cn = New SQLConnection(strConnectionString);
SQLDataAdapter adp = New SQLDataAdapter;
adp.InsertCommand = New SQLCommand("ADDItem", cn);

adp.InsertCommand.Parameters.Add("@Param1", SQLDbType.VarChar, 10).Value = strValue;
... repeat 3 times ...

cn.Open();
adp.InsertCommand.ExecuteNonQuery();
cn.Close();

Something like that.

Brian