Dynamic Members c#

[rottmanj]

I am working on a class that will allow me to insert data into any mysql table that I pass into the class. For the most part I have everything done except for adding parameters to the sql query.

What I have done is pass an ArrayList of column names/ column types into my method, and then I take this data and parse it out and build my query from there. The one issue I have is, when adding parameters to the query, I am unable to figure out how to take the data I passed in and use it in conjunction with MySqlDbType.

Here is a short snippet
cmd.Parameters.Add(fldName, MySqlDbType.VarChar); // static way to add

Here is my current code base. Just as a short fyi, the array list is a multidimensional arraylist. I know the code below is wrong, just now sure how to use the string fldType as a member of MySqlDbType.

            for (int i = 0; i < (fldCol[0] as ArrayList).Count; i++)
            {
                string fldName = "@" + (fldCol[0] as ArrayList)[i].ToString();
                string fldType = (fldCol[1] as ArrayList)[i].ToString();
                fldType = fldType .Replace("(", "");
                fldType = fldType .Replace(")", "");
 
                cmd.Parameters.Add(fldName, MySqlDbType[fldType]);
 
                cmd.Parameters[fldName].Value = dataCol[i];
            }
 

[Plater]

Have you considered using cmd.Parameters.AddWithValue() instead?
Then you would say:
cmd.Parameters.AddWithValue(MyParamName,MyParamVal ue);

It determines the correct sql type from the object type passed to MyParamValue

[rottmanj]

Doh, no I didn't even thing about using AddWithValue.

Now it works the way that I want it to. Thank you for your help.

[rottmanj]

This does open another question for me though.

At another point in my app, I have to use something similar to my question above.

I have to use a dynamic member in order to pull data.

Here is the code I am testing with.

qbFld is the field name I want to pull from the quickbooks file. Just not sure how to create a dynamic member.

                                if (customer != null || fldArr[k].ToString() != null)
                                {
                                    string qbFld = fldArr[k].ToString();
 
                                    dataCol.Add(customer.qbFld.GetValue().ToString());
 
                                }
 

[Plater]

Are the fields being returned as parameters or as a dataset?

[rottmanj]

They are being returned as a dataset in an ArrayList.

[Plater]

Well if you know the name of the column you want, you should be able to access it via an index somehow, or pull it from a dataset/datatable directly

[rottmanj]

Trying to pull it as an index is not really a possibility as the column names indexes are not the same as the indexes in my qb database file.

Trying to pull it directly from the array is more along the lines of what I am looking to do. But not sure how to do that, since the member qbFld does not exist. Ideally (pseudo codeesk) i would look like something below.

 
                                if (customer != null || fldArr[k].ToString() != null)
                                {
                                    string qbFld = fldArr[k].ToString();
 
                                    dataCol.Add(customer.dbFld.GetValue().ToString());
 
                                }
 

[rottmanj]

Just to give a better example of what it looks like when it is static.

If I wanted to pull the data from the FirstName field I would use this.

dataCol.Add(customer.FirstName.GetValue().ToString ());

In my arraylist there is a string that contains the fieldname FirstName.

What I am trying to figure out is how to take the data from the array, and convert the string into the member FirstName(and the rest), so that I can add the data to the arraylist dataCol.

[Plater]

Can you create the array with the 'column name' AS the index?
Like a Dictionary<string, object>?

[rottmanj]

Yes I can, I wind up with something like below, just not sure what to do with it.

FirstName,string
LastName,string