I want to find column name in data table if exist do get the

Question

I want to update this table tbl_TempReport base on the matching field name found it DataTable (dt) this is my code : DataTable dt = GetDatafromDatabase(); //===== returns a DataTable string SQLT = SELECT * FROM tbl_TempReport; string colname; if (cn.State == ConnectionState.Closed) { cn.Open(); } SqlCommand cmdT = new SqlCommand(SQLT cn); SqlDataReader rt = cmdT.ExecuteReader(); while (rt.Read()) { // For each row print the values of each column. foreach (DataColumn column in dt.Columns) { foreach (DataRow row in dt.Rows) { colname = column.ColumnName.ToString(); if (colname == ID) { // break; rt.NextResult(); } else { rt.Read(); //if (rt[code].ToString() == colname) //{ //insert into tbl_TempReport to match the appropriate column string SQLP = UPDATE tbl_TemReport SET VALUEP = @VALUEP WHERE code = @code; SqlCommand cmdp = new SqlCommand(SQLP cn); cmdp.Parameters.AddWithValue(@VALUEP SqlDbType.Int).Value = row[column].ToString(); cmdp.Parameters.AddWithValue(@code SqlDbType.NVarChar).Value = rt[code].ToString(); cmdp.ExecuteNonQuery(); //} //ListBox1.Items.Add(row[column.ColumnName].ToString()); } //====== } } } i will appreciate your help as the is module in my project due to be submitted on Monday. Thank you and God blessing

Bhuvanesh Mohankumar · Answer

I am not sure what you exactly need so gave two set of options Option 1: If you want to verify the ID column is available in DataTable then try this code. string columnName = ID; DataTable dt = GetDatafromDatabase(); DataColumnCollection columns = dt.Columns; if (columns.Contains(columnName)) { \ Write your code logic } Option 2: Get value of Certain Column from Data Table. string countryName = USA; DataTable dt = GetDatafromDatabase(); int id = (from DataRow dr in dt.Rows where (string)dr[CountryName] == countryName select (int)dr[id]).FirstOrDefault(); Mark as answerif helpful.