Dynamically changing array

evgeny

I need something like this:

private void LoadFieldsNames(string table_name)
{
string[] fields = new string[100];

            switch (table_name)
            {
                case "step_result":
                     fields = {"ID", "UUT_RESULT", "STEP_PARENT", "LOOP_INDEX", "INTERACTIVE_EXENUM"};
                     break;
                case "uut_result"
                   fields = {"ID", "STATION_ID", "BATCH_SERIAL_NUMBER", "TEST_SOCKET_INDEX",};
                  break;
            }
            comboBoxSelField.Items.AddRange(fields);
        }

But i get an error. How can i manage the string propelly?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pravin More15y ago
Accepted answer
hi evgeny, here is solution for your problem......your modified code.....asumming that u want to show fields seperatly not comma seprated.........

private void LoadFieldsNames(string table_name)
{
switch (table_name)
{
case "step_result":
string[] fields = {"ID", "UUT_RESULT", "STEP_PARENT", "LOOP_INDEX", "INTERACTIVE_EXENUM"};
break;
case "uut_result"
string[] fields = {"ID", "STATION_ID", "BATCH_SERIAL_NUMBER", "TEST_SOCKET_INDEX",};
break;
}
foreach(string s in fields)
{
comboBoxSelField.Items.Add(s);
}
}
i hope this will solve your problem.
Thanx,
Pravin.
theLizard15y ago
Sam is right, you can get everything about a table from any database Sql Server, MySql, SQLite, ORACLE whatever, dynamically without hard coding like you have done.

For SQL Server: Try to get this to work for you...

          field = "column_name";
          sql = "SELECT column_name=syscolumns.name, datatype=systypes.name, ";
          sql += "length=syscolumns.length, allownull=syscolumns.isnullable ";
          sql += "FROM sysobjects JOIN syscolumns ON sysobjects.id = syscolumns.id ";
          sql += "JOIN systypes ON syscolumns.xtype=systypes.xtype ";
          sql += "WHERE sysobjects.xtype='U' AND sysobjects.name = '" + tableName + "'";
          sql += " ORDER BY sysobjects.name,syscolumns.colid";

        if (!sq.sqlConnect)
          return(values);

        sq.Command = sq.newCommand(server, sql);

                if (sq.Command == null || !sq.ExecuteReader(sq.Command))
          return(values);

        while (sq.read()){
          Array.Resize(ref values, values.Length+1);
          values[values.Length-1] = sq.get(field);}
Suthish Nair15y ago
This will not help, comboBoxSelField.Items.Add(fields)?
Sam Hobbs15y ago
Another solution would be to create a class for each table and have a method in the class that sets or returns the fields for the table. I assume however that the there are already methods for getting a list of field names for each table and if so then I sure would use that. Then if another table is added with a different set of fields there is no modification necessary.
evgeny15y ago
Thanks a lot!