Running trough a Table of a DataSet

  • Thread starter Thread starter Tor Inge Rislaa
  • Start date Start date
T

Tor Inge Rislaa

I have a dataset with a table "Artikler". Before I bind the table to a
DataList in my Web Form I want to update the value of each row of the field
"PreText" in the table. (I don't want to update the database only the local
data of the DataSet Table) I want to replace all the occuranse of chr(13)
with the <br> tag.





01 myDataAdapter.Fill(myDataSet, "Artikler")

02 code for running trough the table and update the field "PreText" for
all rows

03 DataList1.DataSource = myDataSet.Tables("Artikler")

04 DataList1.DataBind()



I need some help filling in the code of line 02



TIRislaa
 
I have a dataset with a table "Artikler". Before I bind the table to a
DataList in my Web Form I want to update the value of each row of the field
"PreText" in the table. (I don't want to update the database only the local
data of the DataSet Table) I want to replace all the occuranse of chr(13)
with the <br> tag.





01 myDataAdapter.Fill(myDataSet, "Artikler")

02 code for running trough the table and update the field "PreText" for
all rows

03 DataList1.DataSource = myDataSet.Tables("Artikler")

04 DataList1.DataBind()



I need some help filling in the code of line 02



TIRislaa
Click to expand...


You have 2 was of going about it
1) Replacing the newlines with <BR> as you output the datalist, using
the Replace method of the string object
2) Doing it in your sql statement such that the data already has the
<BR> inserted

Looping after loading will introduce a performance penalty, especially
if you have a lot of data

Depending on how many pages you have, method 2 might be less hassle
 
foreach (DataRow row in Artikler)
{

row["PreText"]=((string)row["PreText"]).Replace("\n","<BR>");
}

I think \n is the chr(13), if not then its the \r in the \r\n end of line
sequence.
Cheers.
Peter
 
The problem with the replacement in the SQL statement is that the datatype
of the datafield is TEXT and this is not a valid parameter within the
replace syntax. If you know of a better method then using replace in
Transact SQL I would like to know about it.
 
Back
Top