Dataset. Type conversions.

Question

I am trying to assign a string value to a column in a dataset. But I get an error on compilation "Cannot convert type 'System.Data.DataColumn' to 'string'". This is the code: this.agencyDS1.Tables["Agencies"].Columns["AgencyId"] = "A90237"; Thanks.

chumzzz · Answer

That worked. Thanks so much for the help!

james · Answer

ahh..okay...then you want to do something like this... DataTable aTable = new DataTable(); DataColumn dtCol; DataRow dtRow; // Create Hour Column and add to the DataTable. dtCol = new DataColumn(); dtCol.DataType= System.Type.GetType(System.String); dtCol.ColumnName = Hour; dtCol.Caption = Hour; // Add the column to the DataColumnCollection. aTable.Columns.Add(dtCol); // Create rows for the table dtRow = aTable.NewRow(); dtRow[Hour] = 8:00AM-8:59AM; aTable.Rows.Add(dtRow); Does that help?

james · Answer

...unless of course you're trying to set the Caption for the column which would be like this.. dt.Columns[myColumn].Caption = myCaption;

chumzzz · Answer

Yes. I am trying to add a row by assigning a value to a column in my dataset. The dataset is agencyDS1. I want the column called AgencyId to be assigned the value A90237. Should I be adding a row before I do this? I am not sure I am doing this right. I am new to using Datasets. Thank you.

james · Answer

hmm... I'm not sure exactly what you're trying to do here a Column in any kind of table cannot be a string do you mean to be adding rows to your table and adding a string into a file of the row? -James