TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Bind Dropdown, CheckboxList, RadiobuttonList, GridView and Repeater using Single Function Call
Satyajeet Kumar
Feb 03
2016
Code
3.8
k
0
1
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
expand
Default.aspx
<form id=
"form1"
runat=
"server"
>
<div style=
"border: solid 1px #ccc; padding: 2px 5px;"
> Dropdown <br />
<asp:DropDownList ID=
"DropDownList1"
runat=
"server"
></asp:DropDownList>
</div>
<div style=
"border: solid 1px #ccc; padding: 2px 5px;"
> Checkbox <br />
<asp:CheckBoxList ID=
"CheckBoxList1"
RepeatColumns=
"5"
runat=
"server"
></asp:CheckBoxList>
</div>
<div style=
"border: solid 1px #ccc; padding: 2px 5px;"
> GridView <br />
<asp:GridView ID=
"GridView1"
runat=
"server"
></asp:GridView>
</div>
<div style=
"border: solid 1px #ccc; padding: 2px 5px;"
> Repeater <br />
<asp:Repeater ID=
"Repeater1"
runat=
"server"
>
<ItemTemplate> <span style=
"border: solid 1px #ccc; padding: 2px 5px;"
>
<%#Eval(
"menu_name"
) %>
</span> </ItemTemplate>
</asp:Repeater>
</div>
<div style=
"border: solid 1px #ccc; padding: 2px 5px;"
> Radiobutton <br />
<asp:RadioButtonList ID=
"RadioButtonList1"
runat=
"server"
></asp:RadioButtonList>
</div>
</form>
Default.aspx.cs
protected
void
Page_Load(
object
sender, EventArgs e)
{
bindControl.binder(DropDownList1,
"select menu_id as value, menu_name as text from menuitem"
);
bindControl.binder(CheckBoxList1,
"select menu_id as value, menu_name as text from menuitem"
);
bindControl.binder(RadioButtonList1,
"select menu_id as value, menu_name as text from menuitem"
);
bindControl.binder(GridView1,
"select menu_name from menuitem"
);
bindControl.binder(Repeater1,
"select menu_name from menuitem"
);
}
bindControl.cs
using
System;
using
System.Collections.Generic;
using
System.Linq;
using
System.Web;
using
System.Web;
using
System.Web.UI.WebControls;
using
System.Web.UI;
using
System.Data;
using
System.Collections.Specialized;
using
System.Data;
using
System.Data.SqlClient;
namespace
ControlBinder
{
public
static
class
bindControl
{
public
static
void
binder(Object c,
string
sql)
{
SqlConnection sqlCon =
new
SqlConnection(
"Data Source=.; Initial Catalog=master; User ID=sa; Password=pass"
);
SqlCommand sqlCmd =
new
SqlCommand(sql, sqlCon);
SqlDataAdapter adp =
new
SqlDataAdapter(sqlCmd);
DataSet ds =
new
DataSet();
adp.Fill(ds);
Control item = (Control) c;
if
(item
is
DropDownList)
{
DropDownList ddl1 = (DropDownList) item;
ddl1.Items.Clear();
for
(
int
i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ddl1.Items.Insert(i,
new
ListItem(ds.Tables[0].Rows[i][
"text"
].ToString(), ds.Tables[0].Rows[i][
"value"
].ToString()));
}
ddl1.Items.Insert(0,
new
ListItem(
"0"
,
"--Select--"
));
}
if
(item
is
GridView)
{
((GridView) item).DataSource = ds;
((GridView) item).DataBind();
}
if
(item
is
CheckBoxList)
{
CheckBoxList ck = (CheckBoxList) item;
for
(
int
i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ck.Items.Insert(i,
new
ListItem(ds.Tables[0].Rows[i][
"text"
].ToString(), ds.Tables[0].Rows[i][
"value"
].ToString()));
}
}
if
(item
is
RadioButtonList)
{
RadioButtonList ck = (RadioButtonList) item;
for
(
int
i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ck.Items.Insert(i,
new
ListItem(ds.Tables[0].Rows[i][
"text"
].ToString(), ds.Tables[0].Rows[i][
"value"
].ToString()));
}
}
if
(item
is
Repeater)
{
((Repeater) item).DataSource = ds;
((Repeater) item).DataBind();
}
if
(item
is
DataList)
{
((DataList) item).DataSource = ds;
((DataList) item).DataBind();
}
}
}
}
DropDown
CheckboxList
RadiobuttonList
GridView