Design Part1 | |
| |
General Conditions | |
Area | |
Analysis for Delhi | |
Plinth Area Rates | |
Schedules of Rates (Electrical) | |
Specifications Other | |
Specifications | |
Design Pattern | |
Other1 | |
Other | |
C# code---
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class cpwdnew_Documents_View_Publication : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConCPWD"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindRepeaterData();
BindRepeaterData1();
BindRepeaterData2();
BindRepeaterData4();
BindRepeaterData5();
BindRepeaterData6();
BindRepeaterData7();
BindRepeaterData8();
BindRepeaterData9();
BindRepeaterData10();
}
}
protected void BindRepeaterData()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD_Publication where category='Manuals' Order By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepDetails.DataSource = ds;
RepDetails.DataBind();
con.Close();
}
protected void BindRepeaterData1()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD_Publication where category='Government Condition of Contract' Order By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepDetails1.DataSource = ds;
RepDetails1.DataBind();
con.Close();
}
protected void BindRepeaterData2()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD_Publication where category='Area ' Order By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
Repeater2.DataSource = ds;
Repeater2.DataBind();
con.Close();
}
protected void BindRepeaterData3()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD_Publication where category='Analysis Delhi' Order By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
Repeater2.DataSource = ds;
Repeater3.DataBind();
con.Close();
}
protected void BindRepeaterData4()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD_Publication where category='Schedules of Rates (Electrical)' Order By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
Repeater4.DataSource = ds;
Repeater4.DataBind();
con.Close();
}
protected void BindRepeaterData5()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD_Publication where category='Design Pattrn' Order By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
Repeater5.DataSource = ds;
Repeater5.DataBind();
con.Close();
}
protected void BindRepeaterData6()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD_Publication where category='Schedules Other' Order By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
Repeater6.DataSource = ds;
Repeater6.DataBind();
con.Close();
}
protected void BindRepeaterData7()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD_Publication where category='Specifications' Order By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
Repeater7.DataSource = ds;
Repeater7.DataBind();
con.Close();
}
protected void BindRepeaterData8()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD_Publication where category='Specifications' Order By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
Repeater8.DataSource = ds;
Repeater8.DataBind();
con.Close();
}
protected void BindRepeaterData9()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD_Publication where category='Schedule ' Order By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
Repeater9.DataSource = ds;
Repeater9.DataBind();
con.Close();
}
protected void BindRepeaterData10()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD where category='Government Condition By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
Repeater10.DataSource = ds;
Repeater10.DataBind();
con.Close();
}/*
protected void BindRepeaterData11()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ADD_Publication where category='Other Order By PublicationYear desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepDetails11.DataSource = ds;
RepDetails11.DataBind();
con.Close();
}*/
}
Shakti Singh DulawatPosted Apr 24, 2017, 3:01 AM