Mask single column in datatable in C#

Question

1.00/5 (1 vote)

See more:

I have datatable to view in gridview. Now i need to mask 1st 6 digit of "AdminNumber" column content to "XXXXXX895".

DataTable Input:

AdminNumber Name
245637895 sham
124563789 Ram

I need Datatable output as:

AdminNumber Name
XXXXXX895 Sham
XXXXXX789 Ram

I have tried, but iam getting format the string option:

gridview.DataSource = dtSource;
     gridview.Columns[0].FormatString = "######";

Iam getting wrong output as

AdminNumber Name
XXXXXXXXX Sham
XXXXXXXXX Ram

What I have tried:

gridview.DataSource = dtSource;
     gridview.Columns[0].FormatString = "######";

Posted 1-Jun-18 3:02am

Vinodh Muthusamy

Updated 7-Jun-18 8:52am

Add a Solution

Comments

[no name] 1-Jun-18 11:43am

Maybe do this better in your SQL allready if possible?

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gerry Schmitz · Answer 1 · 2018-06-01T06:23:00

Solution 1

Working with Computed Columns (C#) | Microsoft Docs[^]

Posted 1-Jun-18 6:23am

Gerry Schmitz

Comments

Maciej Los 7-Jun-18 14:33pm

5ed!

Maciej Los · Answer 2 · 2018-06-07T08:53:00

In addition to solution#1 by Gerry Schmitz[^], i'd like to provide C# example, how to create masked column ;)

C#

dt.Columns.Add("MaskedNumber", typeof(string));
dt.Columns["MaskedNumber"].Expression = "'XXX-XX-'+SUBSTRING(CONVERT(Number, System.String),6,4)";

result:

Number    FName  LastName MaskedNumber
781637895 sham   C        XXX-XX-7895 
558563789 Ram    M        XXX-XX-3789

Finally, you have to hide DataGridView's column[0] ;)

Mask single column in datatable in C#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Mask single column in datatable in C#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us