How to check if a column with a given name exists in a datarow

vb.net datarow
Dr. Rajesh Rolen picture Dr. Rajesh Rolen · Dec 31, 2009 · Viewed 33.4k times · Source

I want to insert a value from loop in datarow so before entering value in datarow, I want to check that a perticular column NAME exist in table or not.

Please tell me how can I check it. (vb.net preferred).

Answer

Dr. Rajesh Rolen picture Dr. Rajesh Rolen · Dec 31, 2009

I got the answer.and its working . its:

  If dr.Table.Columns.Contains("columnname") = True Then
   --your work---
  End If

Related questions

How do I find out if a column exists in a VB.Net DataRow

I am reading an XML file into a DataSet and need to get the data out of the DataSet. Since it is a user-editable config file the fields may or may not be there. To handle missing fields well I'd …

Read More
how to search DataTable for specific record?

Hi, I have a windows form with 10 text fields and 1 combobox. When the user selects a record in the combo-box I want to find that record in my form datatable variable (called dtBranches) then populate my 10 textfields from the datarow. …

Read More
changing values of a column in datatable in vb.net

I want to loop through a databale and change the values of a specific column in that datatable. eg: the database returns Request_ID, Desc, Date and Status_Ind. The Status_Ind column contains integer values. I dont want to …

Read More