private void LoadWaiterData() { Security.AccessUser clsAccessUser = new Security.AccessUser(); try { string searchkey = "" + txtSearch.Text; if (searchkey.Length >= 16) // this is the defined no of burnt card no { searchkey = searchkey.Replace("%", "").Replace("?", ""); //strPassword = searchkey.Remove(0, 10); searchkey = searchkey.Remove(10, searchkey.Length - 10); } System.Data.DataTable dt = clsAccessUser.Waiters(searchkey, 100, "Name", SortOption.Ascending); clsAccessUser.CommitAndDispose(); this.dgStyle.MappingName = dt.TableName; dgWaiter.DataSource = dt; dgWaiter.Select(0); dgWaiter.CurrentRowIndex = 0; } catch (IndexOutOfRangeException) {} catch (Exception ex) { clsAccessUser.CommitAndDispose(); MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadWaiterData() { Security.AccessUser clsAccessUser = new Security.AccessUser(); try { string searchkey = "" + txtSearch.Text; System.Data.DataTable dt = clsAccessUser.Waiters(searchkey, 100, "Name", SortOption.Ascending); clsAccessUser.CommitAndDispose(); dgWaiter.DataSource = dt; dgWaiter.Select(0); dgWaiter.CurrentRowIndex = 0; } catch (IndexOutOfRangeException) {} catch (Exception ex) { clsAccessUser.CommitAndDispose(); MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadWaiterData() { Security.AccessUser clsAccessUser = new Security.AccessUser(); try { string searchkey = "" + txtSearch.Text; System.Data.DataTable dt = clsAccessUser.Waiters(searchkey, 100, "Name", SortOption.Ascending); clsAccessUser.CommitAndDispose(); this.dgStyle.MappingName = dt.TableName; dgWaiter.DataSource = dt; dgWaiter.Select(0); dgWaiter.CurrentRowIndex=0; } catch (IndexOutOfRangeException){} catch (Exception ex) { clsAccessUser.CommitAndDispose(); MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error); } }
private void LoadWaiterData() { Security.AccessUser clsAccessUser = new Security.AccessUser(); try { string searchkey = "" + txtSearch.Text; if (searchkey.Length >= 16) // this is the defined no of burnt card no { searchkey = searchkey.Replace("%", "").Replace("?", ""); //strPassword = searchkey.Remove(0, 10); searchkey = searchkey.Remove(10, searchkey.Length - 10); } System.Data.DataTable dt = clsAccessUser.Waiters(searchkey, 100, "Name", SortOption.Ascending); clsAccessUser.CommitAndDispose(); this.dgStyle.MappingName = dt.TableName; dgWaiter.DataSource = dt; dgWaiter.Select(0); dgWaiter.CurrentRowIndex=0; } catch (IndexOutOfRangeException){} catch (Exception ex) { clsAccessUser.CommitAndDispose(); MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error); } }