Hi,
say i have 3 columns in a table in my dB:
Col 1: somenumber (int)
Col 2: id (int)
Col 3: description (varchar(30))

i want to retrieve rows from the dB, bind it to a control but want to
display the data with "somenumber" processed before displayed, in this
format:
Col 1: functionX(somenumber)
Col 2: id
Col 3: description

After the user updates the data in the control, the dB is updated with the
reverse function of functionX applied to the userinput to get 'somenumber'.

How can i do this, without using things like stored procedure?

TIA.

Cen,

In a simple way.

http://www.vb-tips.com/default.aspx?ID=c4832a2a-2b95-4ded-93d9-4deb7fa4a0b8

The main part of the sample is at the bottom

I hope this helps,

Cor

Datagrid with search capabilities, how to implement it?
System.Data and System.Data.SqlClient - Which one should I use ?
What am I doing worng...?
Transaction Problem after upgrading ASP.Net + C# App. from .Net 2.0 beta to .Net 2.0 Professional
GetChildRows.Length = 0