c# string to variable

Question

I want use string as variable ( string + int = variable )

public DataTable Add_new(string t1,string t2,string t3,string t4,
                         string t5,string t6,string t7,string t8,
                         string t9,string t10)
    {
        OleDbParameter[] param = new OleDbParameter[10];

        for (int i = 1; i < 11; i++)
        {
            param[i-1] = new OleDbParameter(""+i+"", OleDbType.VarChar);
            param[i-1].Value = ("t"+i);
        }
        DataTable dt = new DataTable();
        dt = DAL.selectdata("Add_Code", param);
        return dt;
    }

how convert ("t"+i) to variable t1 not "t1"

Mustafa ShazLy
– Mustafa ShazLy

2015-08-07 22:57:46 +00:00
Commented Aug 7, 2015 at 22:57 — Mustafa ShazLy
– Mustafa ShazLy, Commented Aug 7, 2015 at 22:57
You can click "edit" to update your question.

3Dave
– 3Dave

2015-08-07 23:32:24 +00:00
Commented Aug 7, 2015 at 23:32 — 3Dave
– 3Dave, Commented Aug 7, 2015 at 23:32

Guffa · Accepted Answer · 2015-08-07 23:09:39Z

You can put the values in an array, then you can access them by index:

public DataTable Add_new(string t1,string t2,string t3,string t4,string t5,string t6,string t7,string t8,string t9,string t10) {
  string[] t = { t1, t2, t3, t4, t5, t6, t7, t8, t9, t10 };

  OleDbParameter[] param = new OleDbParameter[10];

  for (int i = 1; i < 11; i++) {
    param[i-1] = new OleDbParameter(i.ToString(), OleDbType.VarChar);
    param[i-1].Value = (t[i - 1]);
  }
  DataTable dt = new DataTable();
  dt = DAL.selectdata("Add_Code", param);
  return dt;
}

Another approach is to turn the parameters into a params array. You call it the same way, but it is an array when it arrives:

public DataTable Add_new(params string[] t) {
  if (t.Length != 10) throw new ArgumentsException("The method should be called with 10 parameters.");

  OleDbParameter[] param = new OleDbParameter[10];

  for (int i = 1; i < 11; i++) {
    param[i-1] = new OleDbParameter(i.ToString(), OleDbType.VarChar);
    param[i-1].Value = (t[i - 1]);
  }
  DataTable dt = new DataTable();
  dt = DAL.selectdata("Add_Code", param);
  return dt;
}

Note: Those values that you send into the method probably has some meaning. You should consider to have meaningful names for the parameters, and perhaps just write the code for creating ten parameters. Having a loop doing it is convenient, but it's not very easy to maintain.

Nathu · Accepted Answer · 2015-08-07 23:14:30Z

2

Why not pass it as a:

List<String> T;

instead of

string t1,string t2,string t3,string t4,string t5,string t6,string t7,string t8,string t9,string t10

and then:

for (int i = 1; i < 11; i++)
{
     param[i-1] = new OleDbParameter(""+i+"", OleDbType.VarChar);
     param[i-1].Value = (T[i-1]);
}

so it will be

public DataTable Add_new(List<String> T) {

  OleDbParameter[] param = new OleDbParameter[10];

  for (int i = 1; i < 11; i++) {
    param[i-1] = new OleDbParameter(i.ToString(), OleDbType.VarChar);
    param[i-1].Value = (T[i-1]);
  }
  DataTable dt = new DataTable();
  dt = DAL.selectdata("Add_Code", param);
  return dt;
}

edited Aug 7, 2015 at 23:14

answered Aug 7, 2015 at 23:02

Nathu

2621 gold badge5 silver badges23 bronze badges

1 Comment

Guffa Over a year ago

The index in a list (just as an array) is zero-based, so that should be T[i - 1].

SILENT · Accepted Answer · 2015-08-07 23:52:21Z

Your implementation doesn't make sense. Regardless, the following would work for your request.

public DataTable Add_new(string t1, string t2, string t3, string t4,
                         string t5, string t6, string t7, string t8,
                         string t9, string t10)
        {
            OleDbParameter[] param = new OleDbParameter[10];
        for (int i = 1; i < 11; i++)
        {
            param[i - 1] = new OleDbParameter("" + i + "", OleDbType.VarChar);

            switch("t" + i)
            {
                case "t1":
                    param[i - 1].Value = t1;
                    break;
                case "t2":
                    param[i - 1].Value = t2;
                    break;
               //Recreate up to t10
            }
        }
        DataTable dt = new DataTable();
        dt = DAL.selectdata("Add_Code", param);
        return dt;
    }

John Wu · Accepted Answer · 2015-08-07 23:28:53Z

-1

Try this

public DataTable Add_new(params string[] t)
{
    OleDbParameter[] param = new OleDbParameter[10];

    for (int i = 0; i <= 10; i++)
    {
        var paramName = String.Format("t{0}", i+1);
        param[i] = new OleDbParameter(paramName, OleDbType.VarChar);
        param[i].Value = (t[i]);
    }
    DataTable dt = new DataTable();
    dt = DAL.selectdata("Add_Code", param);
    return dt;
}

answered Aug 7, 2015 at 23:28

John Wu

52.5k8 gold badges50 silver badges92 bronze badges

Collectives™ on Stack Overflow

c# string to variable

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related