Dynamically changing array

Question

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?

Pravin More · 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.

theLizard · Answer

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.namesyscolumns.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 Nair · Answer

This will not help comboBoxSelField.Items.Add(fields)?

Sam Hobbs · Answer

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.

evgeny · Answer

Thanks a lot!