示例#1
0
        private void ReportStart_Click(object sender, EventArgs e)
        {
            string report  = "SELECT COUNT (*) AS [Общее количество договоров] FROM CONTRACTS WHERE ID_MANAGER = '" + Manager.id + "'";
            string report1 = "SELECT * FROM CONTRACTS WHERE ID_ORDER = (SELECT * FROM ORDERS) AND ID_MANAGER = '" + Manager.id + "'";

            res = DataBaseWork.Load(report1);
            ReportView.DataSource = res;
        }
示例#2
0
 public static void Loading(string query, DataGridView grid)
 {
     res                        = DataBaseWork.Load(query);
     grid.DataSource            = res;
     grid.Columns["ID"].Visible = false;
 }
示例#3
0
 public static void Loading(string query, DataGridView grid)
 {
     res             = DataBaseWork.Load(query);
     grid.DataSource = res;
 }