Passing List values as Stored Procedure Parameters (SQL 2000, NET 2.0)

[R2d2Rabeau]

Hi,

How can I pass values from a List as stored procedure parameters?
[0] name= "Smith", age = 21
[1] name="Brown", age =46
[2] name="White", age=28
...

// data added to the List
 myDetailsPair.Add(new myPair(a, b));
 
// trying to pass values
    cmd_personalDetails.Parameters.Add("@name", SqlDbType.VarChar).Value = Convert.ToString(a);
 
    cmd_personalDetails.Parameters.Add("@age", SqlDbType.Int).Value = Convert.ToInt32(b);
 
.Value = a //does is not right
.Value = myPair.name //is not right

Or is there an easier solution?
I am using List because I need to pair data from 2 different sources together.

[R2d2Rabeau]

Any suggestion any one?

[nateraaaa]

Sounds like you should insert the data into a hashtable so that you can reference the Key Value pairs within the hashtable. See the following site for using hashtables in 2.0.

http://www.c-sharpcorner.com/UploadFile/pradeep.tiwari/PradeepTiwariHashtable11072006072247AM/PradeepTiwariHashtable.aspx?ArticleID=2548f7ef-c9f2-4259-969e-713d8b4d297f

My thought here is that you would loop through your dataset or datatable and check to see if the hashtable contains the value yet. If not add the values you want to the hashtable.

Here is an example.
Hashtable branches = new Hashtable();

foreach(DataRow row in data.Tables[0].Rows)
{
if(!branches.ContainsKey(row["branch_id"]))
{
branches.Add(row["branch_id"], row["branch_email"]);
}
}
 
foreach(DictionaryEntry entry in branches)
{
  //Pass the Key and Value to your stored procedure. The Key is the first column in your hashtable the Value is the second column in the hashtable. 
//NOTE: The hashtable will not output the items in the same order that they were inserted into the hashtable. This is because the hashtable uses an algorithm to increase the speed of searching.
  usp_stored_proc_name(entry.Key.ToString(), entry.Value.ToString());
}

Hope this helps.

Nathan