Source code for New user in CCFD - 2

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class pgTransaction : System.Web.UI.Page

{

    DataAccess data = new DataAccess();

    int CreditLimit = 0;

    int sumAmount = 0;

    bool Amt = false;

    bool Place = false;

    protected void Page_Load(object sender, EventArgs e)

    {

        txtCardNo.Focus();

        lblError.Visible = false;

        txtAmt.Text = Session["amt"].ToString();

    }

    protected void txtCardNo_TextChanged(object sender, EventArgs e)

    {

        //TO check the user is blocked user or not

        data.DBCmdOpen("Select * from fraud where cardNo='" + txtCardNo.Text + "'");

        data.dr = data.cmd.ExecuteReader();

        if (data.dr.HasRows)

        {

            lblError.Text= "Sorry Your Account Was Disabled";

            lblError.Visible = true;

            data.DBReaderClose();

        }

        else

        {

            data.DBReaderClose();

            data.DBCmdOpen("Select * from card where cardNo='" + txtCardNo.Text + "'");

            data.dr = data.cmd.ExecuteReader();

            if (data.dr.HasRows)

            {

                data.dr.Read();

                txtACNO.Text = data.dr["ACNO"].ToString();

                txtACName.Text = data.dr["holderName"].ToString();

                txtBankName.Text = data.dr["BankName"].ToString();

                txtAddress.Text = data.dr["holderAddress"].ToString();

                txtPalce.Focus();

                btnSubmit.Enabled = true;

            }

            else

            {

                lblError.Text = "Sorry Invalid Card Number";

                lblError.Visible = true;

                txtCardNo.Focus();

                btnSubmit.Enabled = false;

            }

            data.DBReaderClose();

        }

    }