Hi Praveen,
You could always use a substring function on a dataview but you have to do it on a row by row basis. It means, a loop is to be used to get the required length on a column.
Ex:
DataTable dt = yourDataView.ToTable();
for(int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i][column] = dt.Rows[i][column].ToString().Substring(0, 100);
}
yourDataView = dt.AsDataView();
Or, you could create a new column in the dataview and use
myDataColumn.Expression on it to get the required data.
Click Here[
^]
Please do take a look at it and give your best shot.
Thank you,
Vamsi