forodo
سه شنبه 26 شهریور 1392, 20:46 عصر
من کد زیر رو نوشتم ولی هیچ اتفاقی نمی افته.
لیبل ها رو 0 نشون میده.
private void GetUnitWord()
{
int aval = 0;
int dovom = 0;
int sevom = 0;
int chaharom = 0;
int panjom = 0;
try
{
OleDbDataAdapter daadda = new OleDbDataAdapter();
DataSet dssdds = new DataSet();
daadda.SelectCommand = new OleDbCommand();
daadda.SelectCommand.Connection = con;
daadda.SelectCommand.CommandType = CommandType.Text;
daadda.SelectCommand.CommandText = @"SELECT WordLevel
FROM tblLitner";
con.Open();
daadda.Fill(dssdds, "tblLitnerWord");
con.Close();
dataGridView1.DataSource = dssdds.Tables["tblLitnerWord"];
}
catch (Exception)
{
}
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
for (int j = 0; j < dataGridView1.Columns.Count - 1; j++)
{
if (dataGridView1.Rows[i].Cells[j].Value.ToString() == "1")
{
aval++;
}
else if (dataGridView1.Rows[i].Cells[j].Value.ToString() == "2")
{
dovom++;
}
else if (dataGridView1.Rows[i].Cells[j].Value.ToString() == "4")
{
sevom++;
}
else if (dataGridView1.Rows[i].Cells[j].Value.ToString() == "8")
{
chaharom++;
}
else if (dataGridView1.Rows[i].Cells[j].Value.ToString() == "16")
{
panjom++;
}
}
}
lblAval.Text = aval.ToString();
lblDovom.Text = aval.ToString();
lblsevom.Text = aval.ToString();
lblchaharom.Text = aval.ToString();
lblpanjom.Text = aval.ToString();
}
راستی این تابع در لود صفحه اجرا می شود.
لیبل ها رو 0 نشون میده.
private void GetUnitWord()
{
int aval = 0;
int dovom = 0;
int sevom = 0;
int chaharom = 0;
int panjom = 0;
try
{
OleDbDataAdapter daadda = new OleDbDataAdapter();
DataSet dssdds = new DataSet();
daadda.SelectCommand = new OleDbCommand();
daadda.SelectCommand.Connection = con;
daadda.SelectCommand.CommandType = CommandType.Text;
daadda.SelectCommand.CommandText = @"SELECT WordLevel
FROM tblLitner";
con.Open();
daadda.Fill(dssdds, "tblLitnerWord");
con.Close();
dataGridView1.DataSource = dssdds.Tables["tblLitnerWord"];
}
catch (Exception)
{
}
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
for (int j = 0; j < dataGridView1.Columns.Count - 1; j++)
{
if (dataGridView1.Rows[i].Cells[j].Value.ToString() == "1")
{
aval++;
}
else if (dataGridView1.Rows[i].Cells[j].Value.ToString() == "2")
{
dovom++;
}
else if (dataGridView1.Rows[i].Cells[j].Value.ToString() == "4")
{
sevom++;
}
else if (dataGridView1.Rows[i].Cells[j].Value.ToString() == "8")
{
chaharom++;
}
else if (dataGridView1.Rows[i].Cells[j].Value.ToString() == "16")
{
panjom++;
}
}
}
lblAval.Text = aval.ToString();
lblDovom.Text = aval.ToString();
lblsevom.Text = aval.ToString();
lblchaharom.Text = aval.ToString();
lblpanjom.Text = aval.ToString();
}
راستی این تابع در لود صفحه اجرا می شود.