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;
}
by ssi
11. September 2013 10:57
private void SetColumns()
{
ssiMethods.clsStaticMethods.SetupGrid(dataGridView1, Color.LightSalmon, false);
for (int c = 0; c < dataGridView1.Columns.Count; c++)
{
DataGridViewColumn column = dataGridView1.Columns[c];
column.HeaderText = column.HeaderText.Replace("_", " ").ToUpper();
column.Width = 125;
if (column.HeaderText.Contains("AMOUNT"))
{
column.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
column.DefaultCellStyle.Format = "##0.00";
column.Width = 100;
}
if (column.HeaderText.Contains("STATUS"))
column.Width = 85;
}
}
by ssi
4. May 2013 17:49
{
string sSQL = "UPDATE tbl_Loan SET BorrowerName = @BorrowerName "
+ ",DateCreated = @DateCreated"
+ ",DateDue = @DateDue"
+ ",DateClosedString = @DateClosedString"
+ ",Suspensedescription = @Suspensedescription"
+ " WHERE Id = @RecordId ";
OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(ConnectionString);
OleDbCommand Cmd = new OleDbCommand(sSQL, objConn);
Cmd.Parameters.Add(new OleDbParameter("@BorrowerName", txtBorrowerName.Text));
Cmd.Parameters.Add(new OleDbParameter("@DateCreated", txtDateCreated.Text));
Cmd.Parameters.Add(new OleDbParameter("@DateDue", txtDateDue.Text));
Cmd.Parameters.Add(new OleDbParameter("@DateClosedString", txtClosed.Text));
Cmd.Parameters.Add(new OleDbParameter("@Suspensedescription", txtDesc.Text));
Cmd.Parameters.Add(new OleDbParameter("@RecordId", RecordID));
objConn.Open();
int nResult = Cmd.ExecuteNonQuery();
objConn.Close();
lblResult.Text = string.Format("Result: {0}", nResult == 1 ? "saved" : "err saving");
}
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 = "SELECT * FROM tbl_Loan";
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();
}