Help converting VB.NET script to C# from Ch 5

spinz2112 · August 28th, 2010, 05:21 PM

What is the c# equivalent of the following code from Chapter 5, page 162?
Thanks

Code:

        ' get columns
        Dim dt As DataTable = CType(Dts.Variables("SourceColumns").Value, DataSet).Tables(0)
        Dim SourceColumns As List(Of String) = New List(Of String)
        For Each dr As DataRow In dt.Rows
            SourceColumns.Add(dr(0))
        Next

spinz2112 · August 28th, 2010, 06:34 PM

I think I figured it out, the following does work, not sure if it is the most efficient way to do it.
Thanks

Code:

            DataTable dt = new DataTable();
            DataSet ds = new DataSet();
            ds = Dts.Variables["SourceColumns"].Value as DataSet;
            dt = ds.Tables[0];

            List<string> sourceColumns = new List<string>();
            foreach (DataRow dr in dt.Rows)
            {
                sourceColumns.Add(dr[0].ToString());
            }

domino · January 5th, 2011, 10:12 PM

DataTable dt = ((DataSet)Dts.Variables("SourceColumns").Value).Ta bles(0);
List<string> SourceColumns = new List<string>();
foreach (DataRow dr in dt.Rows) {
SourceColumns.Add(dr(0));
}