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 "Clients": cmSQL.CommandText = "SELECT [Code] ,[Telephone],[Name],[Outline],[Address],[Email] FROM [Register] WHERE [Discontinue]<>1"; cmSQL.CommandType = CommandType.Text; break; case "Services": cmSQL.CommandText = "SELECT [Sn],[TransDate],[RefNo],[Name],[Telephone] ,[ServiceRendered] ,[ValueOfService] ,[AmountPaid] ,[AmountChargedFromReward],[Username] FROM [RewardAssured].[dbo].[Services] ORDER BY [TransDate] DESC"; cmSQL.CommandType = CommandType.Text; 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(ex.Message, 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 [Sn] AS [RefNo],[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],[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 = 210; dGrid.Columns[2].Width = 210; dGrid.Columns[6].Width = 210; dGrid.Columns[9].Width = 210; dGrid.Columns[0].Width = 40; dGrid.Columns[11].Width = 50; MyModules.formatGrid(dGrid); return; } catch (Exception ex) { MessageBox.Show(ex.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } }