back end code :

using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace ADO1

{

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

{

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=FACULTY-35;Initial Catalog=ADODOTNET_LEARNING;User ID=SA;Password=aptech");

try

{

SqlCommand cmd = new SqlCommand("SELECT * FROM TBL_PRODUCT", con);

con.Open();

SqlDataReader rdr = cmd.ExecuteReader();

GridView1.DataSource = rdr;

GridView1.DataBind();

}

catch (Exception ex)

{

Response.Write("Error is " + ex);

}

finally

{

con.Close();

}

}

}

}

Front end code :

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ADO1.aspx.cs" Inherits="ADO1.ADO1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:GridView ID="GridView1" runat="server" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2">

<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />

<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />

<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />

<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />

<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />

<SortedAscendingCellStyle BackColor="#FFF1D4" />

<SortedAscendingHeaderStyle BackColor="#B95C30" />

<SortedDescendingCellStyle BackColor="#F1E5CE" />

<SortedDescendingHeaderStyle BackColor="#93451F" />

</asp:GridView>

</div>

</form>

</body>

</html>

web.config code :

<?xml version="1.0" encoding="utf-8"?>

<!--

For more information on how to configure your ASP.NET application, please visit

http://go.microsoft.com/fwlink/?LinkId=169433

-->

</connectionStrings>

<system.web>

</system.web>

</configuration>

HOW ATM MACHINE WORKS (A prototype code in C language)

#include <stdio.h>

#include <conio.h>

main()

{

l3:

int amount[3]{1000,2000,3000};

int code[3]{1234,2134,5555};

int c,i,index=-1,input;

l1:

printf("Enter the Code: ");

scanf("%d",&c);

for(i=0;i<3;i++)

{

if(c==code[i])

{

index=i;

}

}

if(index==-1)

{

printf("\nINVALID CODE.......\nEnter the code again........\n");

goto l1;

}

l2:

printf("\n-------------------------------------\n");

printf("\t\twelcome to ATM");

printf("\n-------------------------------------\n");

printf("press 1 for Deposite Amount---->\n");

printf("press 2 for Cash With Drawl---->\n");

printf("press 3 for Check Balance---->\n");

scanf("%d",&input);

switch(input)

{

case 1:

printf("Enter the amount that you want to deposite : ");

int deposite;

scanf("%d",&deposite);

amount[index]=amount[index]+deposite;

printf("%d credited in your account %d \n",deposite,&amount[index]);

break;

case 2:

printf("Enter the amount that you want to draw : ");

int draw;

scanf("%d",&draw);

if(draw>amount[index])

{

printf("YOU ARE EXCEEDING YOUR BALANCE AMOUNT......\n");

}

else{

amount[index]=amount[index]-draw;

printf("%d credited in your account %d \n",draw,&amount[index]);

}

break;

case 3:

printf("Your Balance Amount is %d",amount[index]);

break;

default:

break;

}

printf("\nDo you want to Continue.....(y/n)\n");

char e;

e=getchar();

scanf("%c",&e);

if(e=='y')

{

goto l2;

}

else

{

index=-1;

goto l3;

}

}

The Concept Academy By Ideas Solution

Wednesday 17 January 2018

Part-26 Sql Data Reader in asp.net with Try and Catch exception

back end code :

Front end code :

web.config code :

HOW ATM MACHINE WORKS (A prototype code in C language)

Pass Dynamically Added Html Table Records List To Controller In Asp.net MVC

About Me