// Datatable TabUser only with UserName check
public DataSet1.TabUserDataTable GetUserName(string username)
{
try
{
_tableUserTableAdapter.FillByUserName(_userDataSet.TabUser, username);
return(_userDataSet.TabUser);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Search Users by UserName.
/// </summary>
/// <param name="userName">string userName</param>
/// <returns>UserDS.TabUserDataTable</returns>
/// <exception cref="ex">Exception</exception>
public UserDS.TabUserDataTable GetUsersByUserName(string userName)
{
try
{
userName = "******" + userName + "%";
_userDataSet = new UserDS();
_tabUserTableAdapter.FillByUserName(_userDataSet.TabUser, userName);
return(_userDataSet.TabUser);
}
catch (Exception ex)
{
//Error log simulate
Console.WriteLine(ex.ToString());
Console.WriteLine(ex.GetBaseException().ToString());
throw;
}
}