View Single Post
  #2 (permalink)  
Old August 27th, 2004, 07:43 AM
mehdi62b mehdi62b is offline
Friend of Wrox
Join Date: Jul 2004
Location: Tehran, , Iran.
Posts: 623
Thanks: 0
Thanked 1 Time in 1 Post

Have a look at this example...(although I dont know your exact meaning)
public void AddSqlParameters() 
// ...
// create myDataSet and myDataAdapter
// ...

  myDataAdapter.SelectCommand.Parameters.Add("@CategoryName", SqlDbType.VarChar, 80).Value = arraylist[0];
  myDataAdapter.SelectCommand.Parameters.Add("@SerialNum", SqlDbType.Int).Value = arraylist[1];

also instead of SqlParameters you can work with objDataRow.ItemArray for filling your arraylist according a row in your datasource.

Reply With Quote