Posted on: 8/7/2014 11:38:28 PM | Views : 449

Hi 
In below code the "AddDate" its save the current date of inserting data, what i am looking for that "EndDate" calculate 7 days and insert it automatically the end date since i click on the button. ex:
AddDate: 08/08/2014   and the EndDate: 15/08/2014


protected void InsertBanbox_Click(object sender, EventArgs e) { SqlConnection BoxBanCon = new SqlConnection(sc); SqlCommand BoxbanCMD = new SqlCommand(); string BoxBANsqlstat = "INSERT INTO Advbox (CompName, advimg, Country,website,AddDate,EndDate) VALUES (@CompName,@advimg,@Country,@website,@AddDate,@EndDate)"; BoxbanCMD.Connection = BoxBanCon; BoxbanCMD.CommandType = CommandType.Text; BoxbanCMD.CommandText = BoxBANsqlstat; BoxbanCMD.Parameters.AddWithValue("@CompName", TextBox1.Text); BoxbanCMD. ...

Go to the complete details ...