Am I Close Or Way Off The Mark?

I am trying to select rows from a SQL2000 database table and then write a random number back into each row. I have already looked into do it all in a SP but there are well documented limitations for the SQL RAND function when called in the same batch, so I need to somehow do in .Net what I already have working in classic ASP.

I can't get the  UPDATE (part two section) to compile. I don't know how to call the stored procedure inside the 'foreach' loop or extract the SP parameters.  I have it working in classic asp but am having a lot of trouble converting to .Net 2.0.  Is the below even close to working? 

// stored procedure to write externally generated random number value into database

PROCEDURE RandomizeLinks
@L_ID int,
@L_Rank int
AS
UPDATE Links SET L_Rank = @L_Rank
WHERE (L_ID = @L_ID)

// Part One select links that need random number inserted.

    public DataTable GetRandLinks()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString1A"].ConnectionString);
        SqlCommand cmd = new SqlCommand("RandomizerSelect001", con);
        cmd.CommandType = CommandType.StoredProcedure;
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd;
        DataSet ds = new DataSet();
        try
        {
            da.Fill(ds, "Random001");
            return ds.Tables["Random001"];
        }
        catch
        { throw new ApplicationException("Data error"); }
    }

    // Part Two I need two write a random number back into each row

    protected void Button1_Click(object sender, EventArgs e)
    {
        GetRandLinks();
        int LinkID;               // this generates unassigned local variable "LinkID' error
        int LRank;              // this generates unassigned local variable "LRank' error

        SqlConnection con2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString1A"].ConnectionString);
        SqlCommand cmd2 = new SqlCommand("RandomizeLinks", con2);
        cmd2.CommandType = CommandType.StoredProcedure;
        cmd2.Parameters.AddWithValue("@L_ID", LinkID);
        cmd2.Parameters.AddWithValue("@L_Rank", LRank);
        SqlDataAdapter da2 = new SqlDataAdapter();

        int RowIncrement;
        RowIncrement = 0;
        DataTable dt = GetRandLinks();
        foreach (DataRow row in dt.Rows)
        {
            System.Random myRandom = new System.Random();
            int LinkRank = myRandom.Next(25, 250);
            LRank = LinkRank;
            da2.UpdateCommand = cmd2;
            RowIncrement++;
        }
      
    }