Get column names via Me.RowChanging's "e"?

[Infog]

I have written a chunk of code that automatically writes a SQL string, using parameters. The parameters themselves are easy, but getting the column names has been a problem.

Is possible to get column names from the "e" of the Me.RowChanging event? Otherwise, writing

"Insert Into TableName (each, column, name) Values (@0, @1, @2)" 

is going to be a bit more difficult.

The other pieces of information I have made use of are:

e.Row.Table.Columns.Count to iterate through each column index.
e.Row.Item(index) to use as the parameter name - "@1", etc.
e.Row.Item(index).GetType to get the System.Type, which I convert into a System.DbType

I could write a class that holds the column names of the dateset I made in the designer, but that would be silly (and counter-productive, too). The names of the columns are already in the dataset!

[MessyHeart]

Are you sure it's Me.Rowchanging? What's the instance type whose RowChanging event you are handling? Probably try to cast the sender object to the type and get the column name there.

However, the column name in the data table doesn't have to be same as the actual column name in the database

for eg., if the select query is: select dbColumn1 as DisplayColumn from Table, the column name from the datatable/dataset will be DisplayColumn. If you use this column name in your insert query, it will fail.

[Infog]

Thank you! I hadn't even thought of that.

At the moment, the dataset's column names are the same as the database column names. I have an ArrayList that stores a coding name and a database-use name for each table and an ArrayList that stores the names and connection strings for all the databases I connect to, so adding an ArrayList that stores coding-use/database-use column names for each database wouldn't be a problem.

Here is the start of the dataset code (just fyi):

Partial Class DataSet1
    Partial Class JobsDataTable
 
        Private Sub JobsDataTable_RowChanging(ByVal sender As System.Object, ByVal e As System.Data.DataRowChangeEventArgs) Handles Me.RowChanging

And this is what I'll be using to solve my problem:

 ' My records for manipulation
 Dim ds_Primary As DataSet1 = MDIParent1.DataSetMaster
 
' Get each column name for this table
For i = 0 To e.Row.Table.Columns.Count - 1
        'Use the CodeReference to find which in-memory table I need
        strSQL &= ds_Primary.Tables.Item(strCodeReference).Columns(i).ColumnName()
        If i + 1 = e.Row.Table.Columns.Count Then
                ' Finish the column names, and move to the parameter names
                strSQL &= ") ("
        Else
                ' Make way for the next column name
                strSQL &= ", "
        End If
Next i