示例#1
0
        private void to_print(DataGridView dgv)
        {
            FRM_PRINT frmPrint = new FRM_PRINT();
            //frmPrint.dataGridView1

            //create table with three columns
            DataTable t = new DataTable();

            t.Columns.Add("ID", typeof(string));
            t.Columns.Add("FULL NAME", typeof(string));
            t.Columns.Add("POSITION", typeof(string));
            t.Columns.Add("OFFICE", typeof(string));
            //add data to table
            for (int i = 0; i < dgv.RowCount; i++)
            {
                string[] arrVals = new string[4];
                arrVals[0] = dgv.Rows[i].Cells[0].Value.ToString();
                arrVals[1] = dgv.Rows[i].Cells[1].Value.ToString();
                arrVals[2] = dgv.Rows[i].Cells[2].Value.ToString();
                arrVals[3] = dgv.Rows[i].Cells[3].Value.ToString();
                t.Rows.Add(arrVals);
            }

            //bind table to datagridview
            frmPrint.dataGridView1.DataSource = t;
            frmPrint.ShowDialog();
        }
示例#2
0
        private void save_to_print(DataGridView dgv)
        {
            string listEmps = "";

            for (int i = 0; i < dgv.RowCount; i++)
            {
                //string theID = dgv.Rows[i].Cells["ID"].ToString();

                if (i >= dgv.RowCount - 1)
                {
                    listEmps += dgv.Rows[i].Cells["ID"].Value.ToString();
                }
                else
                {
                    listEmps += dgv.Rows[i].Cells["ID"].Value.ToString() + ":";
                }
            }

            int last_id;

            using (SqlConnection conn = new SqlConnection(Global.connStr))
            {
                string stmt = "insert into tblTest (test_event_code, test_employees) OUTPUT INSERTED.test_event_id values (@test_event_code, @test_employees)";
                using (SqlCommand comm = new SqlCommand(stmt, conn))
                {
                    comm.Parameters.Add("@test_event_code", SqlDbType.VarChar, 50).Value = "00001";
                    comm.Parameters.Add("@test_employees", SqlDbType.Text).Value         = listEmps;
                    conn.Open();
                    last_id = Convert.ToInt32(comm.ExecuteScalar());
                    conn.Close();

                    conn.Dispose();
                    comm.Dispose();
                }
            }

            Global.print_test_id = last_id;
            FRM_PRINT frmPrint = new FRM_PRINT();

            frmPrint.ShowDialog();
        }
        private void btnMDPrint_Click(object sender, EventArgs e)
        {
            FRM_PRINT frmPrint = new FRM_PRINT();

            frmPrint.ShowDialog(this);
        }