Hi,

I work on a winform application.

I have a datagridview which has a column "Phone".
I want to format it so that it appears 123-456-7890 format. As of now the hyphens are not there.

How can i do it?
I found some solution online which goes like this:
string.Format("({0}) {1}-{2}",
phoneNumber.Substring(0, 3),
phoneNumber.Substring(3, 3),
phoneNumber.Substring(6));

But, the problem here is, i have to select the column in the gridview programmatically. How can i do this?

Is there any other way to set the phone number format?

Thanks in Advance

string columnName = "Column Name";
string formattedValue=string.Empty;
for(int i=0;i<datagridview.Rows.Count;i++)
{
formattedValue = datagridview.Rows[i].Cells[columnName].Value;
formattedValue = string.Format("({0}) {1}-{2}",
formattedValue.Substring(0, 3),
formattedValue.Substring(3, 3),
formattedValue.Substring(6));
datagridview.Rows[i].Cells[columnName].Value = formattedValue;
}

Is this what you wanted???

- Paras

'If currrow = dgvLookupMaintenance.CurrentRow.ToString Then

For i = 0 To colcollection.Count

If dgvLookupMaintenance.Columns(i).Name = "Phone" Then

Dim strpnum As String = dgvLookupMaintenance.CurrentCell.Value

dgvLookupMaintenance.CurrentCell.Value = String.Format("({0}) {1}-{2}", strpnum.Substring(0, 3), strpnum.Substring(3, 3), strpnum.Substring(6))

Exit For

End If

Next


let me check with your code

thanks

string columnName = "Column Name";
string formattedValue=string.Empty;
for(int i=0;i<datagridview.Rows.Count;i++)
{
formattedValue = datagridview.Rows[i].Cells[columnName].Value;
formattedValue = string.Format("({0}) {1}-{2}",
formattedValue.Substring(0, 3),
formattedValue.Substring(3, 3),
formattedValue.Substring(6));
datagridview.Rows[i].Cells[columnName].Value = formattedValue;
}

Is this what you wanted???

- Paras

'If currrow = dgvLookupMaintenance.CurrentRow.ToString Then

For i = 0 To colcollection.Count

If dgvLookupMaintenance.Columns(i).Name = "Phone" Then

Dim strpnum As String = dgvLookupMaintenance.CurrentCell.Value

dgvLookupMaintenance.CurrentCell.Value = String.Format("({0}) {1}-{2}", strpnum.Substring(0, 3), strpnum.Substring(3, 3), strpnum.Substring(6))

Exit For

End If

Next


let me check with your code

thanks