or
Protected
Sub
UserNeedDatasource(sender
As
Object
, e
As
Telerik.Web.UI.GridNeedDataSourceEventArgs)
Dim
DataKey
As
String
=
Me
.Grid1.MasterTableView.DataKeyValues(
Me
.Grid1SelectedIndexes(0))(
"DataKeyName"
).ToString
Me
.Grid2.DataSource = MyDataSource.GetData(DataKey)
end
Sub
protected void RadGrid1_Load(object source, GridNeedDataSourceEventArgs e)
{
String ConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(ConnString);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(@"SELECT columns FROM tables)", conn);
DataSet myDataTable = new DataSet();
conn.Open();
try
{
adapter.Fill(myDataTable, "tables");
}
finally
{
conn.Close();
}
DataView myDataView = myDataTable.Tables["tabels"].DefaultView;
RadGrid1.MasterTableView.DataSource = myDataView;
RadGrid1.MasterTableView.DataBind();
}
<
telerik:RadAjaxPanel
ID
=
"RadAjaxPanel2"
runat
=
"server"
>
<
div
class
=
"EnterpriseNodes1"
>
<
telerik:RadComboBox
ID
=
"RadComboBox1"
runat
=
"server"
Skin
=
"WebBlue"
MarkFirstMatch
=
"true"
Visible
=
"false"
AllowCustomText
=
"true"
Filter
=
"StartsWith"
CssClass
=
"combo1"
NoWrap
=
"True"
OnItemDataBound
=
"RadComboBox1_ItemDataBound"
AutoPostBack
=
"false"
OnSelectedIndexChanged
=
"RadComboBox1_OnSelectedIndexChanged"
OnClientSelectedIndexChanged
=
"RadComboBox1_OnClientSelectedIndexChanged"
>
</
telerik:RadComboBox
>
<
br
/>
<
telerik:RadComboBox
ID
=
"RadComboBox2"
runat
=
"server"
Skin
=
"WebBlue"
MarkFirstMatch
=
"true"
Visible
=
"false"
AllowCustomText
=
"true"
Filter
=
"StartsWith"
CssClass
=
"combo2"
NoWrap
=
"True"
OnItemDataBound
=
"RadComboBox2_ItemDataBound"
AutoPostBack
=
"false"
OnSelectedIndexChanged
=
"RadComboBox2_OnSelectedIndexChanged"
OnClientSelectedIndexChanged
=
"RadComboBox2_OnClientSelectedIndexChanged"
>
</
telerik:RadComboBox
>
<
br
/>
</
div
>
</
telerik:RadAjaxPanel
>
function
RadComboBox1_OnClientSelectedIndexChanged(sender, args) {
__doPostBack(
'RadComboBox1'
,
''
);
}
function
RadComboBox2_OnClientSelectedIndexChanged(sender, args) {
__doPostBack(
'RadComboBox2'
,
''
);
}
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(!IsPostBack)
{
RadComboBoxItem item =
null
;
item =
new
RadComboBoxItem();
item.Value =
"1"
;
item.Text =
"Canada"
;
RadComboBox1.Items.Add(item);
item =
new
RadComboBoxItem();
item.Value =
"2"
;
item.Text =
"USA"
;
RadComboBox1.Items.Add(item);
item =
new
RadComboBoxItem();
item.Value =
"3"
;
item.Text =
"BC"
;
RadComboBox2.Items.Add(item);
item =
new
RadComboBoxItem();
item.Value =
"4"
;
item.Text =
"NB"
;
RadComboBox2.Items.Add(item);
item =
new
RadComboBoxItem();
item.Value =
"5"
;
item.Text =
"ON"
;
RadComboBox2.Items.Add(item);
item =
new
RadComboBoxItem();
item.Value =
"6"
;
item.Text =
"CAL"
;
RadComboBox2.Items.Add(item);
item =
new
RadComboBoxItem();
item.Value =
"7"
;
item.Text =
"FLA"
;
RadComboBox2.Items.Add(item);
item =
new
RadComboBoxItem();
item.Value =
"8"
;
item.Text =
"NY"
;
RadComboBox2.Items.Add(item);
RadComboBox1.Text =
""
;
RadComboBox1.ClearSelection();
RadComboBox1.Visible =
true
;
RadComboBox2.Text =
""
;
RadComboBox2.ClearSelection();
RadComboBox2.Visible =
true
;
}
}
protected
void
RadComboBox1_OnSelectedIndexChanged(
object
sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
FilterNext(
ref
RadComboBox1,
ref
RadComboBox2);
}
private
void
FilterNext(
ref
RadComboBox cbCurrent,
ref
RadComboBox cbNext)
{
if
(cbCurrent.Text ==
"Canada"
)
{
for
(
int
i = 0; i <= cbNext.Items.Count - 1; i++)
{
if
(cbNext.Items[i].Text ==
"BC"
|| cbNext.Items[i].Text ==
"NB"
|| cbNext.Items[i].Text ==
"ON"
)
{
cbNext.Items[i].Visible =
true
;
//WriteLog("true " + cbNext.Items[i].Text);
}
else
{
cbNext.Items[i].Visible =
false
;
//WriteLog("false " + cbNext.Items[i].Text);
}
}
}
if
(cbCurrent.Text ==
"USA"
)
{
for
(
int
i = 0; i <= cbNext.Items.Count - 1; i++)
{
if
(cbNext.Items[i].Text ==
"CAL"
|| cbNext.Items[i].Text ==
"FLA"
|| cbNext.Items[i].Text ==
"NY"
)
{
cbNext.Items[i].Visible =
true
;
//WriteLog("true " + cbNext.Items[i].Text);
}
else
{
cbNext.Items[i].Visible =
false
;
//WriteLog("false " + cbNext.Items[i].Text);
}
}
}
cbNext.DataBind();
}
protected void grvReport_ItemDataBound(object sender, GridItemEventArgs e) |
{ |
if (e.Item is GridDataItem) |
{ |
GridDataItem item = ((GridDataItem)e.Item); |
item["coltrainerList"].Text = item["coltrainerList"].Text.Replace(",", "<br/>"); |
} |
// Other unrelated stuff |
} |
if (item["coltrainerList"] != null) item["coltrainerList"].Text = item["coltrainerList"].Text.Replace(",", "<br/>"); |