Wednesday, July 25, 2018

DATE DATA TYPE CALCULATION IN ASP.NET | Sradha webcreations

DATE DATA TYPE CALCULATION IN ASP.NET


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.Security;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class LIBRARY : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void ButtonTOTALDAY_Click(object sender, EventArgs e)
    {
        string sCardNumber;
        string sBookNumber;
        string sStudentName;
       
        string sIssuedDate=TextBoxISSUE.Text;
        DateTime d1=Convert.ToDateTime(sIssuedDate);

        string sReturnDate=TextBoxRETURN.Text;
        DateTime d2=Convert.ToDateTime(sReturnDate);
     
        int iNumberOfDay;

        sCardNumber = TextBoxCARD.Text;
        sBookNumber = TextBoxBOOK.Text;
        sStudentName = TextBoxNAME.Text;
        
       iNumberOfDay = ((TimeSpan)(d2-d1)).Days;
       TextBoxNOOFDAY.Text = Convert.ToString(iNumberOfDay);

    }

    protected void ButtonSAVE_Click(object sender, EventArgs e)
    {
        string connectionstring= ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
        string insertsql = "insert into library(cardnumber,bookname,name,issueddate,returndate,noofday)values(@cardnumber,@bookname,@name,@issueddate,@returndate,@noofday)";

  using (SqlConnection myconnection = new SqlConnection(connectionstring))
        {
            myconnection.Open();
       SqlCommand mycommand = new SqlCommand(insertsql,myconnection);
           mycommand.Parameters.AddWithValue("@cardnumber",TextBoxCARD.Text);
           mycommand.Parameters.AddWithValue("@bookname",TextBoxBOOK.Text);
            mycommand.Parameters.AddWithValue("@name",TextBoxNAME.Text);
            mycommand.Parameters.AddWithValue("@issueddate",TextBoxISSUE.Text);
            mycommand.Parameters.AddWithValue("@returndate",TextBoxRETURN.Text);
            mycommand.Parameters.AddWithValue("@noofday",TextBoxNOOFDAY.Text);

            mycommand.ExecuteNonQuery();
            myconnection.Close();
             }
        TextBoxCARD.Text = string.Empty;
        TextBoxBOOK.Text = string.Empty;
        TextBoxNAME.Text = string.Empty;
        TextBoxISSUE.Text = string.Empty;
        TextBoxRETURN.Text = string.Empty;
        TextBoxNOOFDAY.Text = string.Empty;
    }
 }Bottom of Form


No comments:

Post a Comment