public void LoadLvList() { try { SqlConnection cnSQL = new SqlConnection(MyModules.strConnect); SqlCommand cmSQL = new SqlCommand("FetchUserAccessByPwd", cnSQL); cmdOk.Visible = true; cmSQL.CommandType = CommandType.StoredProcedure; switch (listQuery1) { case "SystemUser": cmSQL.CommandText = "FetchAllUserAccess"; // '-------------Accounts break; case "ActiveSchoolList": cmSQL.CommandText = "SELECT [Sn] AS RefNo,[SchName] ,[SchAddress],[State] FROM [RegisterSchool] WHERE InActive=0"; cmSQL.CommandType = CommandType.Text; break; case "AllPayRequest": cmSQL.CommandText = "AC_FetchAllPayRequest"; cmSQL.Parameters.AddWithValue("@BillType", qryPrm); break; } cnSQL.Open(); dataAdapter = new SqlDataAdapter(cmSQL); //"AC_FetchAllPaymentVouchers", strConnect) SqlCommandBuilder commandBuilder = new SqlCommandBuilder(this.dataAdapter); DataTable table = new DataTable(); table.Locale = System.Globalization.CultureInfo.InvariantCulture; this.dataAdapter.Fill(table); this.bindingSource.DataSource = table; cmSQL.Dispose(); DGrid.Refresh(); lblCount.Text = DGrid.Rows.Count.ToString(); //filterStatusLabel.Text = DGrid.Rows.Count.ToString + " of " + DGrid.Rows.Count.ToString SelColumn.Minimum = 1; SelColumn.Maximum = DGrid.Columns.Count; MyModules.formatGrid(DGrid); return; } catch (Exception ex) { MessageBox.Show("Ooops! ERROR :" + char.ConvertFromUtf32(13) + ex, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information); // MessageBox.Show("Ooops! ERROR", MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void LoadLvList(string strQ) { if (strQ == "" || strQ == null) { return; } try { strQryMain = strQ; string str; if (strQ == "<ALL>") { str = "SELECT RegisterStudent.Sn AS [RefNo],RegisterStudent.IDNo,[Name] AS [Student Name], [SchoolID],RegisterSchool.SchName AS [School Name] , [Degree],[CourseOfStudy] AS [Course Of Study],[StartYear],[EndYear],RegisterStudent.State AS [State of Origin],[LGA],RegisterStudent.Address,RegisterStudent.EmailAddress AS [Email Address],RegisterStudent.Telephone ,RegisterStudent.BankName AS [Bank Name] ,RegisterStudent.BankAcctNo AS [Account No],RegisterStudent.BankCode AS [Bank Code],RegisterStudent.BankAddress AS [Bank Address] ,RegisterStudent.Remark,RegisterStudent.InActive FROM RegisterStudent LEFT OUTER JOIN RegisterSchool ON RegisterStudent.SchoolID = RegisterSchool.Sn"; } else { // str = "SELECT RegisterStudent.Sn AS [RefNo],[Name] AS [Student Name], [SchoolID],RegisterSchool.SchName AS [School Name] , [Degree],[CourseOfStudy] AS [Course Of Study],[StartYear],[EndYear],RegisterStudent.State AS [State of Origin],[LGA],RegisterStudent.Address,RegisterStudent.EmailAddress AS [Email Address],RegisterStudent.Telephone ,RegisterStudent.BankName AS [Bank Name] ,RegisterStudent.BankAcctNo AS [Account No],RegisterStudent.BankCode AS [Bank Code],RegisterStudent.BankAddress AS [Bank Address] ,RegisterStudent.Remark,RegisterStudent.InActive FROM RegisterStudent LEFT OUTER JOIN RegisterSchool ON RegisterStudent.SchoolID = RegisterSchool.Sn WHERE " + strQ; str = "SELECT RegisterStudent.Sn AS [RefNo],RegisterStudent.IDNo,[Name] AS [Student Name], [SchoolID],SchName AS [School Name] , [Degree],[CourseOfStudy] AS [Course Of Study],[StartYear],[EndYear],RegisterStudent.State AS [State of Origin],[LGA],RegisterStudent.Address,RegisterStudent.EmailAddress AS [Email Address],RegisterStudent.Telephone ,RegisterStudent.BankName AS [Bank Name] ,RegisterStudent.BankAcctNo AS [Account No],RegisterStudent.BankCode AS [Bank Code],RegisterStudent.BankAddress AS [Bank Address] ,RegisterStudent.Remark,RegisterStudent.InActive FROM RegisterStudent WHERE " + strQ; } SqlConnection cnSQL = new SqlConnection(MyModules.strConnect); SqlCommand cmSQL = new SqlCommand(); cmSQL.Connection = cnSQL; cmSQL.CommandType = CommandType.Text; cmSQL.CommandText = str; cnSQL.Open(); dataAdapter1 = new SqlDataAdapter(cmSQL); SqlCommandBuilder commandBuilder = new SqlCommandBuilder(this.dataAdapter1); DataTable table = new DataTable(); table.Locale = System.Globalization.CultureInfo.InvariantCulture; this.dataAdapter1.Fill(table); this.BindingSource1.DataSource = table; cmSQL.Dispose(); dGrid.Refresh(); lblCount.Text = "List Count:" + dGrid.Rows.Count.ToString(); //filterStatusLabel.Text = DGrid.Rows.Count.ToString + " of " + DGrid.Rows.Count.ToString SelColumn.Minimum = 1; SelColumn.Maximum = dGrid.Columns.Count; dGrid.Columns[1].Width = 100; dGrid.Columns[2].Width = 210; dGrid.Columns[3].Width = 80; dGrid.Columns[4].Width = 210; dGrid.Columns[5].Width = 120; dGrid.Columns[0].Width = 40; dGrid.Columns[6].Width = 150; MyModules.formatGrid(dGrid); return; } catch (Exception ex) { MessageBox.Show(ex.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void LoadLvList(string strQ) { if (strQ == "" || strQ == null) { return; } try { strQryMain = strQ; string str; if (strQ == "<ALL>") { str = "SELECT [Sn] AS [RefNo],IDNo,[SchName] AS [School Name] ,[SchAddress] AS [School Address] ,[State],[EmailAddress] AS [Email Address] ,[Telephone] ,[BankName] AS [Bank Name],[BankAcctNo] AS [Account No],[BankCode] AS [Bank Code],[BankAddress] AS [Bank Address],[Remark],[InActive] FROM RegisterSchool"; } else { str = "SELECT [Sn] AS [RefNo],IDNo,[SchName] AS [School Name] ,[SchAddress] AS [School Address] ,[State],[EmailAddress] AS [Email Address] ,[Telephone] ,[BankName] AS [Bank Name],[BankAcctNo] AS [Account No],[BankCode] AS [Bank Code],[BankAddress] AS [Bank Address],[Remark],[InActive] FROM RegisterSchool WHERE " + strQ; } SqlConnection cnSQL = new SqlConnection(MyModules.strConnect); SqlCommand cmSQL = new SqlCommand(); cmSQL.Connection = cnSQL; cmSQL.CommandType = CommandType.Text; cmSQL.CommandText = str; cnSQL.Open(); dataAdapter1 = new SqlDataAdapter(cmSQL); SqlCommandBuilder commandBuilder = new SqlCommandBuilder(this.dataAdapter1); DataTable table = new DataTable(); table.Locale = System.Globalization.CultureInfo.InvariantCulture; this.dataAdapter1.Fill(table); this.BindingSource1.DataSource = table; cmSQL.Dispose(); dGrid.Refresh(); lblCount.Text = "List Count:" + dGrid.Rows.Count.ToString(); //filterStatusLabel.Text = DGrid.Rows.Count.ToString + " of " + DGrid.Rows.Count.ToString SelColumn.Minimum = 1; SelColumn.Maximum = dGrid.Columns.Count; dGrid.Columns[1].Width = 100; dGrid.Columns[2].Width = 210; dGrid.Columns[3].Width = 210; dGrid.Columns[7].Width = 210; dGrid.Columns[10].Width = 210; dGrid.Columns[0].Width = 40; dGrid.Columns[12].Width = 50; MyModules.formatGrid(dGrid); return; } catch (Exception ex) { MessageBox.Show(ex.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } }