Regex: Stripping Unwanted Chararcters

by ssi 10. June 2016 07:51
public static string StripLeadingZeros(string sAlphaNumberText)
       {
           /*
            * That will trim trailing zeros if they appear after the period in a decimal number (it will always leave a single zero).
            *  It also accounts for numbers that appear at the very end.
            */
           string sRet = "";
 
           sRet = Regex.Replace(sAlphaNumberText,
                        @"(?<=\.\d+?)0+(?=\D|$)",
                        String.Empty);
           return sRet;
       }
 
       public static string StripWhitespace(string sAlphaNumberText)
       {
           /*
            * sStrip Whitespace
            */
           string sRet = "";
 
           sRet = Regex.Replace(sAlphaNumberText, @"\s+""");
           return sRet;
       }
       public static string StripAllButNumbers(string sAlphaNumberText)
       {
           /*
            * strip all characters except numbers
            */
           string sRet = "";
 
           sRet = Regex.Replace(sAlphaNumberText, @"[^\d]"String.Empty);
           return sRet;
       }
       public static string StripNumbers(string sAlphaNumberText)
       {
           /*
            * sStrip Numbers
            */
           string sRet = "";
 
           sRet = Regex.Replace(sAlphaNumberText, @"[\d-]"string.Empty);
           return sRet;
       }
 
       public static string StripAllSpecialCharacters(string sAlphaNumberText)
       {
           /*
            * Strip All Special Characters
            */
           string sRet = "";
 
           sRet = Regex.Replace(sAlphaNumberText, "[^0-9a-zA-Z]+""");
           return sRet;
       }

Tags: , , ,

Blog | CSharp | Regex

Set DataGridView Columns

by ssi 11. September 2013 10:57

private void SetColumns()
{
ssiMethods.clsStaticMethods.SetupGrid(dataGridView1, Color.LightSalmon, false);



for (int c = 0; c &lt; dataGridView1.Columns.Count; c++)
{
DataGridViewColumn column = dataGridView1.Columns[c];
column.HeaderText = column.HeaderText.Replace(&quot;_&quot;, &quot; &quot;).ToUpper();

column.Width = 125;
if (column.HeaderText.Contains(&quot;AMOUNT&quot;))
{
column.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
column.DefaultCellStyle.Format = &quot;##0.00&quot;;
column.Width = 100;
}
if (column.HeaderText.Contains(&quot;STATUS&quot;))
column.Width = 85;
}

}

Tags: , ,

Blog | CSharp

private void btnSave_Click(object sender, EventArgs e)

by ssi 4. May 2013 17:49
{
string sSQL = &quot;UPDATE tbl_Loan SET BorrowerName = @BorrowerName &quot;
+ &quot;,DateCreated = @DateCreated&quot;
+ &quot;,DateDue = @DateDue&quot;
+ &quot;,DateClosedString = @DateClosedString&quot;
+ &quot;,Suspensedescription = @Suspensedescription&quot;
+ &quot; WHERE Id = @RecordId &quot;;

OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(ConnectionString);

OleDbCommand Cmd = new OleDbCommand(sSQL, objConn);

Cmd.Parameters.Add(new OleDbParameter(&quot;@BorrowerName&quot;, txtBorrowerName.Text));
Cmd.Parameters.Add(new OleDbParameter(&quot;@DateCreated&quot;, txtDateCreated.Text));
Cmd.Parameters.Add(new OleDbParameter(&quot;@DateDue&quot;, txtDateDue.Text));
Cmd.Parameters.Add(new OleDbParameter(&quot;@DateClosedString&quot;, txtClosed.Text));
Cmd.Parameters.Add(new OleDbParameter(&quot;@Suspensedescription&quot;, txtDesc.Text));
Cmd.Parameters.Add(new OleDbParameter(&quot;@RecordId&quot;, RecordID));

objConn.Open();
int nResult = Cmd.ExecuteNonQuery();
objConn.Close();
lblResult.Text = string.Format(&quot;Result: {0}&quot;, nResult == 1 ? &quot;saved&quot; : &quot;err saving&quot;);
}

Tags: , ,

Blog | CSharp

string sAccessFilePath = SuspenseMgrAccess

by ssi 4. May 2013 17:46

 

 

Properties.Settings.Default.AccessFilePathAndname;

if (File.Exists(sAccessFilePath))
{
ConnectionString = SuspenseMgrAccess.Properties.Settings.Default.AccessConnectionString;
OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(ConnectionString);

String QueryString = &quot;SELECT * FROM tbl_Loan&quot;;
OleDbCommand Cmd = new OleDbCommand(QueryString, objConn);

objConn.Open();
OleDbDataReader reader = Cmd.ExecuteReader();

OleDbDataAdapter dataAdapter = new OleDbDataAdapter(QueryString, objConn);
OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapter);
DataTable table = new DataTable();
dataAdapter.Fill(table);

dataGridView1.DataSource = table;
objConn.Close();
}

Tags: , ,

Blog | CSharp

Calendar

<<  September 2025  >>
MoTuWeThFrSaSu
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345

View posts in large calendar

RecentComments

None

Development Team @ Shelbysys

We develop custom database applications for our clients. Our development tool of choice is MS Visual Studio. 

Quotations

"Fill the unforgiving minute with sixty seconds worth of distance run."
Rudyard Kipling