Table Creation Command in SQL Server
create table tabCandRegistration
(
CandName varchar(20),
DateofBirth date,
Age int,
JoinDate date,
EmailID varchar(20),
[Password] varchar(10)
)
Needed Stored Procedure
create procedure sp_GetAllCandidateRecords
as
begin
select CandName,EmailID,DateOfBirth as DOB,Age,JoinDate
from tabCandRegistration
end
add the following on web.config file
<connectionStrings>
<add name="SampleDBConStr"
connectionString="Data Source=PC377553;
Initial Catalog=SampleDB;
Integrated Security=True;"/>
</connectionStrings>
RecordDisplayUDColumns.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="RecordDisplayUDColumns.aspx.cs" Inherits="WebDemo01.RecordDisplayVersion3" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td>
<h3>Candidate Records...</h3>
</td>
</tr>
<tr>
<td>
<asp:GridView ID="GridView1" runat="server" Width="600px" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="CandName"
HeaderText="Name"
ItemStyle-BackColor="#009933"
ItemStyle-ForeColor="White" />
<asp:BoundField DataField="DOB" HeaderText="DOB"
DataFormatString="{0:dd/MM/yyyy}"
ItemStyle-HorizontalAlign="Center"/>
<asp:BoundField DataField="Age" HeaderText="Age"
DataFormatString = "{0} years"/>
<asp:BoundField DataField="JoinDate" HeaderText="JoinedOn"
DataFormatString = "{0:dd/MM/yyyy}"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="EmailID" HeaderText="Email" />
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
RecordDisplayUDColumns.aspx.cs
using System;
//Added...
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace WebDemo01
{
public partial class RecordDisplayUDColumns : System.Web.UI.Page
{
protected void
Page_Load(object sender, EventArgs e)
{
DisplayCandidateRecords();
}
private void
DisplayCandidateRecords()
{
//Step1
(Connection estab)
string conStr = ConfigurationManager
.ConnectionStrings["SampleDBConStr"].ConnectionString;
SqlConnection con = new SqlConnection(conStr);
con.Open();
//step2
(Initialize command object with a query)
SqlCommand cmd = new SqlCommand
("sp_GetAllCandidateRecords", con);
cmd.CommandType = CommandType.StoredProcedure;
//Step3
(Initialize adapter with cmd object)
SqlDataAdapter da = new SqlDataAdapter(cmd);
//Step4: Fill
dataset
DataSet ds = new DataSet();
da.Fill(ds);
//Step5 :
populate GridView with records...
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
}
No comments:
Post a Comment