protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=mobilebanking;integrated security=sspi"); if (!IsPostBack) { con.Open(); com = new SqlCommand(" select name High_Balance_Customers from tblcurmain where balance =(select max(balance)from tblcurmain) ", con); da = new SqlDataAdapter(com); da.Fill(ds); ObjectList1.DataSource = ds; ObjectList1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=mobilebanking;integrated security=sspi"); if (!IsPostBack) { string ac1 = Request.QueryString["id"].ToString(); con.Open(); com = new SqlCommand("select top 5 dat Date, tim Time,trans Account_Id,amount Amount,trandetail Transaction_Type from tblcurtran where accid='" + ac1.ToString() + "' order by dat desc", con); da = new SqlDataAdapter(com); da.Fill(ds); ObjectList1.DataSource = ds; ObjectList1.DataBind(); con.Close(); } }
protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=mobilebanking;integrated security=sspi"); if (!IsPostBack) { string ac, da1; con.Open(); com = new SqlCommand("select uname user_name,cloan car_loan,hloan Home_loan,tloan Two_wheeler_loan,eloan education_loan from tblloan ", con); da = new SqlDataAdapter(com); da.Fill(ds); ObjectList1.DataSource = ds; ObjectList1.DataBind(); con.Close(); } }
protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=mobilebanking;integrated security=sspi"); if (!IsPostBack) { string ac, da1; ac = Session["accid1"].ToString(); da1 = Session["dat1"].ToString(); con.Open(); com = new SqlCommand("select tim Time,trans Account_Id,amount Amount,trandetail Transaction_Type from tblcurtran where dat= '" + da1.ToString() + "'and accid='" + ac.ToString() + "'", con); da = new SqlDataAdapter(com); da.Fill(ds); ObjectList1.DataSource = ds; ObjectList1.DataBind(); con.Close(); } }