Update record in Database using Cache in ASP.Net

Hi Nishu,

Take reference to below code change acordingly to your requirement.

Code

C#

protected void Update(object sender, EventArgs e)
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    SqlConnection con = new SqlConnection(constr);
    SqlCommand cmd = new SqlCommand();
    if (Cache["dt"] == null)
    {
        if (ddllocation.SelectedValue == "0")
        {
            cmd = new SqlCommand("SELECT CustomerId,Name,Country FROM CustomerTest", con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            Cache["dt"] = dt;
            gvCustomers.DataSource = dt;
            gvCustomers.DataBind();
        }
        else
        {
            cmd = new SqlCommand("UPDATE StockLedgernewLocation SET StartDate=@StartDate,EndDate=@EndDate,CompID=@CompID,BranchID=@BranchID,SLocationID=@SLocationID where ProductID<>0 and CLosingqty<>0", con);
            cmd.Parameters.AddWithValue("StartDate", "");
            cmd.Parameters.AddWithValue("@EndDate", "");
            cmd.Parameters.AddWithValue("@CompID", "");
            cmd.Parameters.AddWithValue("@BranchID", "");
            cmd.Parameters.AddWithValue("@SLocationID", "");
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            Cache["dt"] = dt;
            gvCustomers.DataSource = dt;
            gvCustomers.DataBind();
        }
    }
    else
    {
        DataTable dt = Cache["dt"] as DataTable;
        gvCustomers.DataSource = dt;
        gvCustomers.DataBind();
    }
}

VB.Net

Protected Sub Update(ByVal sender As Object, ByVal e As EventArgs)
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Dim con As SqlConnection = New SqlConnection(constr)
    Dim cmd As SqlCommand = New SqlCommand()

    If Cache("dt") Is Nothing Then

        If ddllocation.SelectedValue = "0" Then
            cmd = New SqlCommand("SELECT CustomerId,Name,Country FROM CustomerTest", con)
            Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)
            Dim dt As DataTable = New DataTable()
            da.Fill(dt)
            Cache("dt") = dt
            gvCustomers.DataSource = dt
            gvCustomers.DataBind()
        Else
            cmd = New SqlCommand("UPDATE StockLedgernewLocation SET StartDate=@StartDate,EndDate=@EndDate,CompID=@CompID,BranchID=@BranchID,SLocationID=@SLocationID where ProductID<>0 and CLosingqty<>0", con)
            cmd.Parameters.AddWithValue("StartDate", "")
            cmd.Parameters.AddWithValue("@EndDate", "")
            cmd.Parameters.AddWithValue("@CompID", "")
            cmd.Parameters.AddWithValue("@BranchID", "")
            cmd.Parameters.AddWithValue("@SLocationID", "")
            Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)
            Dim dt As DataTable = New DataTable()
            da.Fill(dt)
            Cache("dt") = dt
            gvCustomers.DataSource = dt
            gvCustomers.DataBind()
        End If
    Else
        Dim dt As DataTable = TryCast(Cache("dt"), DataTable)
        gvCustomers.DataSource = dt
        gvCustomers.DataBind()
    End If
End Sub