You would still need to go through the DataTable class. But you can do so using your DataRow instance by using the Table property. foreach (DataColumn c in dr.Table.Columns) //loop through the columns. { MessageBox.Show(c.ColumnName); }
Which version of .NET are you using? Since .NET 3.5, there’s an assembly System.Data.DataSetExtensions, which contains various useful extensions for dataTables, dataRows and the like. You can try using row.Field<type>(“fieldName”); if that doesn’t work, you can do this: DataTable table = new DataTable(); var myColumn = table.Columns.Cast<DataColumn>().SingleOrDefault(col => col.ColumnName == “myColumnName”); if (myColumn != null) … Read more
You need to loop over loadDT.Columns, like this: foreach (DataColumn column in loadDT.Columns) { Console.Write(“Item: “); Console.Write(column.ColumnName); Console.Write(” “); Console.WriteLine(row[column]); }
Just keep going with your code – you’re on the right track: //call SQL helper class to get initial data DataTable dt = sql.ExecuteDataTable(“sp_MyProc”); dt.Columns.Add(“NewColumn”, typeof(System.Int32)); foreach(DataRow row in dt.Rows) { //need to set value to NewColumn column row[“NewColumn”] = 0; // or set it to some other value } // possibly save your Dataset … Read more
You can simply check like this: return row.Table.Columns.Contains(columnName);
For .Net Framework 3.5+ DataTable dt = new DataTable(); DataRow[] dr = dt.Select(“Your string”); DataTable dt1 = dr.CopyToDataTable(); But if there is no rows in the array, it can cause the errors such as The source contains no DataRows. Therefore, if you decide to use this method CopyToDataTable(), you should check the array to know … Read more
You should try if (row.Table.Columns.Contains(“US_OTHERFRIEND”)) I don’t believe that row has a columns property itself.
You can use ImportRow method to copy Row from DataTable to DataTable with the same schema: var row = SourceTable.Rows[RowNum]; DestinationTable.ImportRow(row); Update: With your new Edit, I believe: var desRow = dataTable.NewRow(); var sourceRow = dataTable.Rows[rowNum]; desRow.ItemArray = sourceRow.ItemArray.Clone() as object[]; will work