Running trough a Table of a DataSet

[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 <brtag.

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

[Rad [Visual C# MVP]]

On Wed, 15 Nov 2006 22:53:08 +0100, "Tor Inge Rislaa"
<to************@rislaa.nowrote:

>

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 <brtag.

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

You have 2 was of going about it
1) Replacing the newlines with <BRas 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
<BRinserted

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

[Peter Bromberg [C# MVP]]

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

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Tor Inge Rislaa" wrote:

>

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 <brtag.

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

[Tor Inge Rislaa]

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.

"Rad [Visual C# MVP]" <no****@nospam.comskrev i melding
news:g3********************************@4ax.com...

On Wed, 15 Nov 2006 22:53:08 +0100, "Tor Inge Rislaa"
<to************@rislaa.nowrote:

>>

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 <brtag.

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

You have 2 was of going about it
1) Replacing the newlines with <BRas 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
<BRinserted

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

[Peter Bromberg [C# MVP]]

Ok, one more time: that should have been:

foreach (DataRow row in Artikler.Rows)

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Tor Inge Rislaa" wrote:

>

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 <brtag.

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

[Tor Inge Rislaa]

Thank you Peter

TIR
"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.comskrev i melding
news:FA**********************************@microsof t.com...

Ok, one more time: that should have been:

foreach (DataRow row in Artikler.Rows)

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Tor Inge Rislaa" wrote:

>>

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 <brtag.

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