Showing posts with label C#. Show all posts
Showing posts with label C#. Show all posts

Thursday, 8 November 2018

Verify that Strings Are in Valid Email Format

 public static bool isEmail(string pStrInputEmail)
 {
            string strRegex = @"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}" +
                @"\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\" +
                @".)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$";

            Regex re = new Regex(strRegex);
            if (re.IsMatch(pStrInputEmail))
            {
                return (true);
            }
            else
            {
                return (false);
            }
}

Wednesday, 29 August 2018

Check If Boolean Value Exist in a Data Table C#

bool BlnSelect = DTTable.AsEnumerable().Any(row => Convert.ToBoolean(1) == row.Field<bool>("SELECT"));
if (BlnSelect)
{
    return true;
}
else
{
    return false;
}

Boolean Value Column Data Filter A Data Table Dynamically Using LINQ With C#?

bool BlnSelect = DTResult.AsEnumerable().Any(row => Convert.ToBoolean(1) == row.Field<bool>("SELECT"));
if (BlnSelect)
{
DataTable _DTUpdate;
_DTUpdate = DTResult.AsEnumerable().Where(row => row.Field<bool>("SELECT") == true).CopyToDataTable();
return true;
}
else
{
return false;
}

LINQ Query on Data Table To Check If Record Exists

bool BlnSelect = DTTable.AsEnumerable().Any(row => Convert.ToBoolean(1) == row.Field<bool>("SELECT"));
if (BlnSelect)
{
    return true;
}
else
{
    return false;
}

Split Comma-Separated Values C#

string pStrCommaSeparatedList = "A,B,C,D,E,F,G,H";
string pStrResult = string.Empty;
string[] pStrCommaValues = pStrCommaSeparatedList.Split(',');
for (int i = 0; i < pStrCommaValues.Length; i++)
{
        pStrResult = pStrCommaValues[i].ToString();
}

Comma Separated String Filter Data Table C#

string pStrEmpEditValue = CmbValue.EditValue.ToString();

DataTable table = new DataTable();
table.Columns.Add("value", typeof(string));
string[] values = CmbValue.EditValue.ToString().Split(',');

for (int i = 0; i < values.Length; i++)
{
table.Rows.Add(new object[] { values[i].ToString().Trim() });
}

DataTable _Final = DTResultSave.Clone();
_Final.Rows.Clear();
foreach (DataRow item in table.Rows)
{
String author = item["value"].ToString().Trim();
//bool contains = DTResult.AsEnumerable().Any(row => author.ToString().ToUpper() == row.Field<String>("EmpCode"));
DataRow[] rowsToCopy;
rowsToCopy = DTResultSave.Select("EmpCode='" + author.ToString().ToUpper() + "'");
if (rowsToCopy.Any())
{
foreach (DataRow temp in rowsToCopy)
{
_Final.ImportRow(temp);
}
}
}

Data Set Empty Or Not Check C#

bool IsEmpty(DataSet _DataSet)
{
return !_DataSet.Tables.Cast().Any(x => x.DefaultView.Count > 0);
}