این کدهارو کلا به جای کد های فرمتون بزارید
using Stimulsoft.Report;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace LeaveManagement
{
public partial class Frm_ViewVorod : Form
{
public Frm_ViewVorod()
{
InitializeComponent();
}
static OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Bank.mdb;Persist Security Info=True");
OleDbDataAdapter da = new OleDbDataAdapter("", con);
DataSet ds = new DataSet();
private void Frm_ViewVorod_Load(object sender, EventArgs e)
{
BindData();
}
private void BindData(string str = "")
{
DataTable dt = new DataTable();
DataBase db = new DataBase();
string where = " where 1=1 ";
if (!string.IsNullOrEmpty(str))
where += string.Format(" and (VNDate like '%{0}%')", str);
dt = db.MySelect("select * from Tbl_VorodExit " + where);
DGV_Vorod.DataSource = dt;
//DGV_Vorod.Columns.Cast<DataGridViewColumn>().ToLis t().ForEach(f => f.SortMode = DataGridViewColumnSortMode.NotSortable);
DGV_Vorod.Columns[0].Width = 30;
DGV_Vorod.Columns[1].Width = 30;
DGV_Vorod.Columns[2].Width = 30;
DGV_Vorod.Columns[9].HeaderText = "تاریخ ";
DGV_Vorod.Columns[10].HeaderText = "ق.ظ / ورود";
DGV_Vorod.Columns[11].HeaderText = "ق.ظ / خروج";
DGV_Vorod.Columns[12].HeaderText = "ب.ظ / ورود";
DGV_Vorod.Columns[13].HeaderText = "ب.ظ / خروج";
DGV_Vorod.Columns[3].Visible = false;
DGV_Vorod.Columns[4].Visible = false;
DGV_Vorod.Columns[5].Visible = false;
DGV_Vorod.Columns[6].Visible = false;
DGV_Vorod.Columns[7].Visible = false;
DGV_Vorod.Columns[8].Visible = false;
DGV_Vorod.Columns[14].Visible = false;
countVorod();
}
private void countVorod()
{
// نمایش تعداد رکوردهای ثبت شده
int count;
count = System.Convert.ToInt32(DGV_Vorod.Rows.Count);
//count--;
label_count.Text = count.ToString();
for (int i = 0; i < DGV_Vorod.Rows.Count; i++)
{
DGV_Vorod.Rows[i].Cells["colprint"].Value = false;
}
}
private void چاپToolStripMenuItem_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
DataRow row;
dt.Clear();
dt.Columns.Add("PersonID");
dt.Columns.Add("Fname");
dt.Columns.Add("StartTimeAM");
dt.Columns.Add("EndTimeAM");
for (int i = 0; i < DGV_Vorod.RowCount; i++)
{
if (bool.Parse(DGV_Vorod.Rows[i].Cells["colprint"].Value.ToString()))
{
row = dt.NewRow();
row["PersonID"] = DGV_Vorod.Rows[i].Cells[4].Value.ToString();
row["Fname"] = DGV_Vorod.Rows[i].Cells[5].Value.ToString();
row["StartTimeAM"] = DGV_Vorod.Rows[i].Cells[10].Value.ToString();
row["EndTimeAM"] = DGV_Vorod.Rows[i].Cells[11].Value.ToString();
dt.Rows.Add(row);
}
}
StiReport s = new StiReport();
s.Load(Environment.CurrentDirectory + @"\Report\reportvorod.mrt");
s.Compile();
s.RegData("ds.DT6", dt);
s.Show();
}
private void DGV_Vorod_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
//try
//{
// var a = DGV_Vorod.Rows[e.RowIndex].Cells[3].Value;
// if (e.ColumnIndex == 0) //delete
// {
// DialogResult result = FarsiMessage.Show("آیا مطمئنید که می خواهید این رکورد را حذف کنید؟", "اخطار", FarsiMessageBoxButtons.YesNo, FarsiMessageBoxIcons.Question);
// if (result == DialogResult.Yes)
// {
// DataBase db = new DataBase();
// db.DoCommand("delete from Tbl_Vorod where VorodID=" + a.ToString());
// FarsiMessage.Show("رکورد مورد نظر از بانک حذف گردید", "حذف اطلاعات", FarsiMessageBoxButtons.OK, FarsiMessageBoxIcons.Information);
// BindData();
// }
// }
// if (e.ColumnIndex == 1) //edite
// {
// Frm_NewVorod f = new Frm_NewVorod();
// f.idVorod = Convert.ToInt32(a);
// f.ShowDialog();
// BindData();
// }
//}
//catch
//{
//}
}
private void Frm_ViewSaati_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
this.Close();
}
}
}