Could somebody help me with this

I think the best way would be to denormalize the score table, maybe something like this (sorry, I'm going to use regular SQL because I'm not very good with SQL server):

create table AREAS (
  areaName varchar2 primary key,
  description varchar2
);

create table CustScores (
  customerName varchar2 not null,
  areaName varchar2 not null references AREAS.areaName,
  score integer not null,
  primary key(customerName, areaName)
);

(note: in your actual code, you'll want to name your constraints, probably)

Now, you can query the list of all available areas like this:

select areaName from AREAS order by areaName;

You can use the results of this query to create your textboxes. Store the results in a List, not a flat array, and you can guarantee that you'll always have enough space. You can store the scores themselves in a Dictionary (i.e., a hashtable), like this:
IDictionary<string, int> scoreValues = new Dictionary<string, int>();
scoreValues["ROP"] = 42;

And you can query all scores for one particular customer like this:

select * from CustScores where customerName = ? order by areaName;

In order to insert scores for one customer, you'll probably want to do something like this:

insert Into CustScores(customerName, areaName, score) values (?, ?, ?)

One final note: it is a supremely bad idea to use string substitution to create SQL commands, because someone can make up a customer name like "' OR 1=1" and get full access to your database that way. It's better to use bind variables.

//This is done in clsDataAccess.cs page.

I have a table called Areas which has Area_id and AreaName. This is what I did so far;

public int MediaType()
    {
        string con = "Data Source=sasql01;Initial Catalog=sandbox; Persist Security Info=True;User ID=sa_sql;Password=str@teg1K@m3r1ka";
        SqlConnection conn = new SqlConnection(con);
        string fetch = "Select AreaName From Areas Order By AreaName";
        SqlCommand cmd = new SqlCommand(fetch, conn);
        SqlDataReader sdr = null;
        conn.Open();
        sdr = cmd.ExecuteReader();
        string MediaType = string.Empty;
        while (sdr.Read())
            MediaType = sdr[0].ToString();
        sdr.Close();
        conn.Close();

        return Convert.ToInt32(MediaType);

After this I have then defined an array

public int[] arrStores1
    {
        get { return new int[this.MediaType()]; }
        set { arrStores1 = value; }
    }


//This part was done in Default.aspx page.

private int storeValues(int[] arr, int pos, string[] val)
    {
        int adds = 0;
        for (int i = 0; i < val.Length; i++)
            arr[i] = Convert.ToInt32(val[i]);
        for (int i = 0; i < arr.Length; i++)
            adds += arr[i];
        return adds;
    }

I have a score table where I have the scores for all answers and that is different from the tblCustScores. The tblCustScores is filled up with the after the customer is done with the survey, i.e this table adds up all the values for the areas and puts them in the table tblCustScores. The Score table on the other hand has the AnswerID, AreaID, Cust_ID and all points for each answer per area is already stored in the Score table. I think you are confused with the tblCustScores and Score tables. The tblCustScores is blank but is filled once the customer is done with the survey. This is what I have to fill up the tblCustScores table.

public void surveySubmit(int score, int Radio, int ROP, int FSI, int BTV, int cable, int Direct_Mail)
    {
        string con = "Data Source=sasql01;Initial Catalog=sandbox; Persist Security Info=True;User ID=sa_sql;Password=str@teg1K@m3r1ka";
        SqlConnection conn = new SqlConnection(con);
        string fetch = String.Format("Insert Into CustScores(ROP, FSI, Cable, BTV, Radio,Direct_Mail, totalScore) values ({0},{1}, {2},{3}, {4}, {5}, {6})",ROP, FSI, cable, BTV, Radio, Direct_Mail, score);
        SqlCommand cmd = new SqlCommand(fetch, conn);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();

    }

There is my problem. Right now, this will allow me to store the values for only 6 areas. At some point if the areas are increased, then I will have to modify my code and so on and so on. Is there a way that I can fill up tblCustScores dynamically? Meaning, I can define as many areas to insert in the table I want. I hope this will make clear.

Thats right, I don't need the tblCustScores at all. Let me try your idea and see what I come up with.

That helped..thank you.