/// <summary> /// Function to view all details from user Table based on parameter /// </summary> /// <param name="strUserName"></param> /// <param name="strRole"></param> /// <returns></returns> public List <DataTable> UserCreationViewForGridFill(string strUserName, string strRole) { UserSP spUser = new UserSP(); List <DataTable> ListObj = new List <DataTable>(); try { ListObj = spUser.UserCreationViewForGridFill(strUserName, strRole); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(ListObj); }
/// <summary> /// User Creation GridFill /// </summary> public void GridFill() { try { UserSP spUser = new UserSP(); DataTable dtblUserCreation = new DataTable(); string strSearchUserName = txtSearchUserName.Text.Trim(); string strSearchRole = cmbSearchRole.Text; dtblUserCreation = spUser.UserCreationViewForGridFill(strSearchUserName, strSearchRole); dgvUserCreation.DataSource = dtblUserCreation; } catch (Exception ex) { MessageBox.Show("UC:7" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }