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
Default

Have a look at this example...(although I dont know your exact meaning)
Code:
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];
  myDataAdapter.Fill(myDataSet);

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

--------------------------------------------
Mehdi.:)
Reply With Quote