vid4259
شنبه 29 شهریور 1393, 21:55 عصر
کد زیر برای اینکه اگه تعداد قطعه های زیر کمتر ومساوی 2 باشه اسم و تعداد قطعه هارو نشون ،کد درست کار میکنه ولی قطعا بهینه و استاندار نیست میشه راهنمایی کنید که چطوری بنویسمش!!!
OleDbConnection con = new OleDbConnection(connect);
con.Open();
OleDbCommand cmd = new OleDbCommand();
int num2=2;
int num1 = 1;
int num0 = 0;
cmd.CommandText = "select * from anbar where numkala='" + num2 + "'";
cmd.Connection = con;
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds, "Person");
cmd.CommandText = "select * from anbar where numkala='" + num1 + "'";
adapter.Fill(ds, "Person");
cmd.CommandText = "select * from anbar where numkala='" + num0 + "'";
adapter.Fill(ds, "Person");
dataGridView1.DataSource = ds.Tables["Person"];
dataGridView1.Columns[0].HeaderText = "کدقطعه";
dataGridView1.Columns[1].HeaderText = "نام قطعه";
dataGridView1.Columns[2].HeaderText = "تعداد";
dataGridView1.Columns[3].HeaderText = "قیمت -تومان ";
dataGridView1.Columns[0].Width = 95;
dataGridView1.Columns[1].Width = 350;
dataGridView1.Columns[2].Width = 95;
dataGridView1.Columns[3].Width = 215;
for (int counter = 0; counter < this.dataGridView1.Rows.Count; counter++)
{
if (counter % 2 == 0)
{
this.dataGridView1.Rows[counter].DefaultCellStyle.BackColor = Color.LightGray;
}
}
OleDbConnection con = new OleDbConnection(connect);
con.Open();
OleDbCommand cmd = new OleDbCommand();
int num2=2;
int num1 = 1;
int num0 = 0;
cmd.CommandText = "select * from anbar where numkala='" + num2 + "'";
cmd.Connection = con;
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds, "Person");
cmd.CommandText = "select * from anbar where numkala='" + num1 + "'";
adapter.Fill(ds, "Person");
cmd.CommandText = "select * from anbar where numkala='" + num0 + "'";
adapter.Fill(ds, "Person");
dataGridView1.DataSource = ds.Tables["Person"];
dataGridView1.Columns[0].HeaderText = "کدقطعه";
dataGridView1.Columns[1].HeaderText = "نام قطعه";
dataGridView1.Columns[2].HeaderText = "تعداد";
dataGridView1.Columns[3].HeaderText = "قیمت -تومان ";
dataGridView1.Columns[0].Width = 95;
dataGridView1.Columns[1].Width = 350;
dataGridView1.Columns[2].Width = 95;
dataGridView1.Columns[3].Width = 215;
for (int counter = 0; counter < this.dataGridView1.Rows.Count; counter++)
{
if (counter % 2 == 0)
{
this.dataGridView1.Rows[counter].DefaultCellStyle.BackColor = Color.LightGray;
}
}