or
| <telerik:RadGrid ID="rgMonthly" runat="server" GridLines="None" OnColumnCreated="rgMonthly_ColumnCreated" |
| OnDetailTableDataBind="rgMonthly_DetailTableDataBind" OnItemDataBound="rgMonthly_ItemDataBound" |
| OnNeedDataSource="rgMonthly_NeedDataSource"> |
| <MasterTableView DataKeyNames="GroupID"> |
| <DetailTables> |
| <telerik:GridTableView Width="100%" runat="server" DataKeyNames="GroupID"> |
| <ParentTableRelation> |
| <telerik:GridRelationFields DetailKeyField="GroupID" MasterKeyField="GroupID" /> |
| </ParentTableRelation> |
| </telerik:GridTableView> |
| </DetailTables> |
| </MasterTableView> |
| </telerik:RadGrid> |
| protected void Page_Init(object source, System.EventArgs e) |
| { |
| BindSelectedInfo(); |
| } |
| protected void BindSelectedInfo() |
| { |
| try |
| { |
| DTSelectedAccts = TAAcctPi.GetData(Int32.Parse(Session["id"].ToString())); |
| for (int i = 0; i < 1; i++) |
| { |
| dsAccountProjections.dtAcctPiRow SelectedAcct = DTSelectedAccts[i]; |
| usrAccountOverview AccountOverview = (usrAccountOverview)LoadControl("~/usrAccountOverview.ascx"); |
| AccountOverview.ID = "usr" + SelectedAcct.SlAcct6Num; |
| AccountOverview.Acct.AcctNum = SelectedAcct.SlAcct6Num; |
| AccountOverview.PullAcctInfo(); |
| pnlHolder.Controls.Add(AccountOverview); |
| } |
| } |
| catch (Exception ex) |
| { |
| } |
| } |
| protected void rgMonthly_NeedDataSource(object source, GridNeedDataSourceEventArgs e) |
| { |
| if (!e.IsFromDetailTable) |
| { |
| rgMonthly.DataSource = DMonthlyExpenditures.GetMonthlyExpendituresByGroup(_Acct.AcctNum, firstMonthID, lastMonthID, lastMonthID); |
| } |
| } |
| protected void rgMonthly_DetailTableDataBind(object source, GridDetailTableDataBindEventArgs e) |
| { |
| GridDataItem parentItem = e.DetailTableView.ParentItem; |
| DataTable dtBind = DMonthlyExpenditures.GetMonthlyExpendituresBySubAcct(_Acct.AcctNum, firstMonthID, lastMonthID, lastMonthID, Int32.Parse(parentItem["GroupID"].Text)); |
| if (dtBind.Rows.Count > 0) e.DetailTableView.DataSource = dtBind; |
| } |
| <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> |
| <AjaxSettings > |
| <telerik:AjaxSetting AjaxControlID="RadGrid1" > |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="RadGrid1"/> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| </AjaxSettings> |
| </telerik:RadAjaxManager> |
| <telerik:RadGrid ID="RadGrid1" runat="server"> |
| <MasterTableView Name="masterView" GridLines="None" EditMode="PopUp" CommandItemDisplay="Top"> |
| <CommandItemSettings AddNewRecordText="Add new entry" RefreshText="Refresh" /> |
| <EditFormSettings UserControlName="Control1.ascx" EditFormType="WebUserControl"> |
| </EditFormSettings> |
| </MasterTableView> |
| </telerik:RadGrid> |
| <%@ Control Language="vb" AutoEventWireup="false" CodeBehind="Control1.ascx.vb" Inherits="TestClientScriptRegister.Control1" %> |
| <asp:Button ID="Button1" runat="server" Text="Button" /> |
| Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load |
| Me.Page.ClientScript.RegisterClientScriptBlock(GetType(String), "Test", Me.GetScript(), True) |
| Me.Button1.Attributes("OnClick") = "Test()" |
| End Sub |
| Private Function GetScript() As String |
| Dim sb As New System.Text.StringBuilder() |
| sb.Append("function Test() {") |
| sb.Append("alert('what?');") |
| sb.Append("}") |
| Return sb.ToString() |
| End Function |
| public void BindData() |
| { |
| //Default.PK; |
| //int theUser; |
| //string email = Environment.UserName + "recyclingit.com"; |
| string sqlConnection = "Data Source=DESQL2008;Initial Catalog=DrawOnTime;User Id=ontimeweb;Password=ontime1234;", query; |
| query="select IncidentId, IncidentNumber, ReportedDate, Users.FirstName + ' ' + Users.LastName as 'IT Employee Assigned', StartDate, CompletionDate, WorkflowSteps.StepName" + |
| " from incidents left join Users on Users.UserId=Incidents.AssignedToId left join WorkflowSteps on WorkflowSteps.WorkflowStepId=Incidents.WorkflowStepId where Incidents.ReportedByCustomerContactId = @PK"; |
| SqlConnection dbconn = new SqlConnection(sqlConnection); |
| dbconn.Open(); |
| SqlCommand myCommand = new SqlCommand(query, dbconn); |
| //myCommand.CommandType = CommandType.Text; |
| //SqlCommand secondCommand = new SqlCommand("select CustomerContactId from CustomerContacts where Email = @email", dbconn); |
| //secondCommand.CommandType = CommandType.Text; |
| SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand); |
| DataSet ds = new DataSet(); |
| myCommand.Parameters.AddWithValue("PK", Default.PK); |
| myAdapter.Fill(ds); |
| //sqlquery.Parameters.AddWithValue("email", email); |
| myCommand.ExecuteScalar(); |
| RadGrid1.DataSource = ds; |
| RadGrid1.DataBind(); |
| TemplateColumn workFlow = new TemplateColumn(); |
| RadGrid1.Columns.Add(workFlow); |
| dbconn.Close(); |
| } |