I've cobbled together a C# program that takes a .csv file and writes it to a DataTable. Using this program, I can loop through each row of the DataTable and print out the information contained in t...

I have: DataTable Table = new DataTable; SqlConnection = new System.Data.SqlClient.SqlConnection("Data Source=" + ServerName + ";Initial Catalog=" + DatabaseName + ";Integrated Security=SSPI; Conn...

I have a table with 1 column: 'Status' I want to add in another column named 'Action', its value will be as follow: if Status = 'Yes' Then Action = 'Go', otherwise, Action = 'Stop'. I used this fo...

I am trying to set a default value for a DataColumn. How do you set a default value for DataColumn (column3) for the below code DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[]...

I have a DataColumn of DateTime, I would like to know how I can have only the sooner date (min) and the later date (max). Thanks

I have a DataTable obtained from a SQL DataBase, like this: using (SqlCommand cmd = new SqlCommand(query, _sqlserverDB)) { using (SqlDataAdapter adapter = new SqlDataAdapter(cmd)) { DataSet dat...

In C# & .NET, can one create a DataView that includes only a proper subset of the DataColumns of a given DataTable? In terms of relational algebra, one assigns a RowFilter in order to perform ...

I have a table payments that has a null-able integer column named payMonth. I have the following class and list: public class months { public int payMonth { get; set; } public string monthName {...

I am trying to create a DataTable and bind it to a DataGridView. It works, but I can't set columns headers via the Caption property. It displays headers using the ColumnName ("City") instead. MSDN ...

I have a datatable with one column: this.callsTable.Columns.Add("Call", typeof(String)); I then want to add a row to that datatable, but want to give a specific index, the commented number is th...

Is there a better way than this to check if a DataColumn in a DataTable is numeric (coming from a SQL Server database)? Database db = DatabaseFactory.CreateDatabase(); DbCommand cmd = db.GetStor...

I need to iterate the columnname and column datatype from a specific row. All of the examples I have seen have iterated an entire datatable. I want to pass a single row to a function to do a bunch ...

I have a DataTable with column such as # of Students and would like to sort by this in descending order. Here is my code: ... dt.Columns.Add(new DataColumn("# of Students", typeof(string))); // d...

I am retrieving data from an MSSQL server using the SqlDataAdapter and DataSet. From that DataSet I am creating a DataTable. My goal is to convert each column of the table into a string where the e...

I have a Datatable with many columns, and a datagrid in which I need to display only a few of those columns. I need a codesample of how to do it. I found a whole bunch of examples telling me to tur...

I have a DataTable that has several DataColumns and DataRow. Now i would like to handle an event when cell of this DataRow is changed. How to do this in c#?