void daramadEmrooz()
{
string mah2, rooz, tDay;
if (PC.GetMonth(DateTime.Now) < 10)
mah2 = "0" + PC.GetMonth(DateTime.Now).ToString();
else
mah2 = PC.GetMonth(DateTime.Now).ToString();
if (PC.GetDayOfMonth(DateTime.Now) < 10)
rooz = "0" + PC.GetDayOfMonth(DateTime.Now).ToString();
else
rooz = PC.GetDayOfMonth(DateTime.Now).ToString();
tDay = PC.GetYear(DateTime.Now).ToString() + "/" + mah2 + "/" + rooz;
con.ConnectionString = Properties.Settings.Default.DataBaseConString;
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
//cmd.CommandText = "select * from tbldaramadha";
con.Open();
cmd.CommandText = "Select count(*) from tblDaramadha where tarikh=?";
cmd.Parameters.AddWithValue("p1", tDay);
int n = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Parameters.Clear();
if (n >= 1)
{
cmd.CommandText = "Select daramad from tblDaramadha where tarikh=?";
cmd.Parameters.AddWithValue("p1", tDay);
OleDbDataReader dr = cmd.ExecuteReader();
//string emdaramad = Convert.ToString(cmd.ExecuteScalar());
cmd.Parameters.Clear();
while (dr.Read())
{
label7.Text = dr["daramad"].ToString() + " تومان";
}
}
else
{
label7.Text = "ثبت نشده";
}
con.Close();
}
کد خودم اینه