That won't work either because I still need column sorting in the datagrid/dataview and 00 will come before 99 whereas 1999 will come before 2000.
I was hoping for a Regex solution, but it appears there is not one. I guess I am left with formatting it on the ItemDataBind event. - Robert Beaubien - Sr. Programmer - Kool Software - -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:27 AM To: dotnet Subject: RE: Regex in ASP.NET Datagrid Another method is to pull the information out of the database already formatted. Select substring(field,2,2) as yr from table Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Robert Beaubien [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:24 PM To: dotnet Subject: RE: Regex in ASP.NET Datagrid I have. Either I am blind, or they don't seem to clearly cover string manipulation. They only seem to cover common string formats (Dates,Currency, etc). - Robert Beaubien - Sr. Programmer - Kool Software - -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:15 AM To: dotnet Subject: RE: Regex in ASP.NET Datagrid You should probably research the DataFormatString attribute of the datagrid. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Robert Beaubien [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:07 PM To: dotnet Subject: Regex in ASP.NET Datagrid Is there a Regex expression I can use to display part of a string in a ASP.NET databound datagrid? Example, I have a SQL text field varchar(4) that contains a year value (1999, 2000, 2001, etc.). I want to only display the last 2 characters in the datagrid. How do I do that with a Regex expression? Thanx, - Robert Beaubien - Sr. Programmer - Kool Software - --- You are currently subscribed to dotnet as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/ --- You are currently subscribed to dotnet as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/ --- You are currently subscribed to dotnet as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/ --- You are currently subscribed to dotnet as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/ --- You are currently subscribed to dotnet as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/
