Get Previous month values in mysql
Hi,
Can anybody pls tell me how to retrieve previous month data. for ex, i have a dotnet application in which i'm generating a salary slip for each & every employee monthly. in that if i click generate for the a particular employee, the previous month salary has to be retrieved from the database. For that if i put DateTime.Now.Month.ToString();, it displays present month. but i need to generate previous month using code. pls help me..
This is my code....
private void Page_Load(object sender, System.EventArgs e)
{
// string Connection = ConfigurationSettings.AppSettings["LOGINVERIFICATION"];
// string query="select USERNAME from USERMASTER where EID='"+Session["username"].ToString()+"'";
OdbcConnection con=new OdbcConnection(ConfigurationSettings.AppSettings["LOGINVERIFICATION"]) ;
OdbcCommand com=new OdbcCommand("select * from Salary",con) ;
OdbcDataReader dr;
con.Open();
dr=com.ExecuteReader();
// OdbcConnection con=new OdbcConnection(Connection);
// OdbcCommand com=new OdbcCommand(query,con);
// OdbcDataReader dr;
// con.Open();
// dr=com.ExecuteReader();
// HttpCookie myCookie = new HttpCookie("ACTUALSALARY"); //("UserSettings");
// myCookie["ActualSalary"]=Session["ActualSalary"].ToString();
// Response.Cookies.Add(myCookie);
// TextBox3.Text=Session["username"].ToString();
// TextBox2.Text=Session["usertype"].ToString();
// TextBox1.Text=Session["user"].ToString();
//TextBox15.Text=Session["ActualSalary"].ToString();
displayrecord();
dr.Close();
con.Close();
}
private void displayrecord()
{
OdbcConnection con=new OdbcConnection(ConfigurationSettings.AppSettings["LOGINVERIFICATION"]) ;
con.Open() ;
OdbcDataAdapter da=new OdbcDataAdapter("select Name,EID,Designation,SALARY,HRA,MRA,CCA,NDAYS,EARNEDSALARY,EARNEDHRA,EARNEDMRA,EARNEDCCA,GrossSalary,EPF,ESI,PTAX,LOAN,Total,NetSalary from Salary where EID='"+Session["username"].ToString()+"'",con);
OdbcDataReader dr;
OdbcCommand com=new OdbcCommand("select Name,EID,Designation,SALARY,HRA,MRA,CCA,NDAYS,EARNEDSALARY,EARNEDHRA,EARNEDMRA,EARNEDCCA,GrossSalary,EPF,ESI,PTAX,LOAN,Total,NetSalary from Salary where EID='"+Session["username"].ToString()+"'",con) ;
DataSet ds=new DataSet();
da.Fill(ds);
dr=com.ExecuteReader();
dr.Read();
// SqlConnection1.Open();
// SqlDataAdapter SqlDataAdapter1 = new SqlDataAdapter("SELECT * FROM Member", SqlConnection1);
// SqlDataReader objReader;
// SqlCommand SqlCommand1 = new SqlCommand("SELECT * FROM Member", SqlConnection1);
// SqlDataAdapter1.Fill(dsMember);
// objReader = SqlCommand1.ExecuteReader();
// objReader.Read();
TextBox1.Text=dr["Name"].ToString();
TextBox3.Text=dr["EID"].ToString();
TextBox2.Text=dr["Designation"].ToString();
TextBox5.Text = dr["SALARY"].ToString();
TextBox8.Text=dr["HRA"].ToString();
TextBox10.Text=dr["MRA"].ToString();
TextBox12.Text=dr["CCA"].ToString();
TextBox4.Text=dr["NDAYS"].ToString();
TextBox6.Text=dr["EARNEDSALARY"].ToString();
TextBox9.Text=dr["EARNEDHRA"].ToString();
TextBox11.Text=dr["EARNEDMRA"].ToString();
TextBox13.Text=dr["EARNEDCCA"].ToString();
TextBox7.Text=dr["GrossSalary"].ToString();
TextBox16.Text=dr["EPF"].ToString();
TextBox17.Text=dr["ESI"].ToString();
TextBox18.Text=dr["PTAX"].ToString();
TextBox19.Text=dr["LOAN"].ToString();
TextBox14.Text=dr["Total"].ToString();
TextBox15.Text=dr["NetSalary"].ToString();
string dt=DateTime.Now.Month.ToString();
string dy=DateTime.Now.Year.ToString();
// lblyear.Text=dy.ToString();
if(dt.ToString()=="1")
{
lblmonth.Text="January" + " " +dy.ToString();
}
else
if (dt.ToString()=="2")
{
lblmonth.Text="February" + " " +dy.ToString();
}
else
if (dt.ToString()=="3")
{
lblmonth.Text="March" + " " +dy.ToString();
}
else
if (dt.ToString()=="4")
{
lblmonth.Text="April" + " " +dy.ToString();
}
else
if (dt.ToString()=="5")
{
lblmonth.Text="May" + " " +dy.ToString();
}
else
if (dt.ToString()=="6")
{
lblmonth.Text="June" + " " +dy.ToString();
}
else
if (dt.ToString()=="7")
{
lblmonth.Text="July" + " " +dy.ToString();
}
else
if (dt.ToString()=="8")
{
lblmonth.Text="August" + " " +dy.ToString();
}
else
if (dt.ToString()=="9")
{
lblmonth.Text="September" + " " +dy.ToString();
}
else
if (dt.ToString()=="10")
{
lblmonth.Text="October" + " " +dy.ToString();
}
else
if (dt.ToString()=="11")
{
lblmonth.Text="November" + " " +dy.ToString();
}
else
if (dt.ToString()=="12")
{
lblmonth.Text="December" + " " +dy.ToString();
}
// txtbox_password.Text = objReader("MemberPassword");
// txtbox_confirmpass.Text = objReader("MemberPassword");
// txtbox_name.Text = objReader("MemberName");
// txtbox_birthdate.Text = objReader("MemberDOB");
// txtbox_nric.Text = objReader("NRIC");
// txtbox_address.Text = objReader("MemberAddress");
// txtbox_contact.Text = objReader("MemberPhone");
// txtbox_email.Text = objReader("MemberEmail");
// Dropdown_Gender.SelectedValue = objReader("Gender");
// DropDown_Age.SelectedValue = objReader("Age");
// DropDown_Income.SelectedValue = objReader("Income");
// DropDown_Children.SelectedValue = objReader("NumofChildren");
// DropDown_HearUs.SelectedValue = objReader("HowDidYouKnowAboutUs");
dr.Close();
con.Close();
}
Don't mstake me for such lengthy code.. bcoz i'm new to .net & mysql..
Anybody pls help me..
Regards
Vijay.