| <asp:SqlDataSource |
| ID="SqlDataSource1" |
| runat="server" |
| ConnectionString="<%$ ConnectionStrings:ConnectionString %>" |
| ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" /> |
| <asp:SqlDataSource |
| ID="SqlDataSource2" |
| runat="server" |
| ConnectionString="<%$ ConnectionStrings:ConnectionString %>" |
| ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" > |
| <SelectParameters> |
| <asp:ControlParameter ControlID="lblWorkgroupID" PropertyName="Text" Type="String" Name="TO_WORKGROUP_FROM_SQL2" /> |
| </SelectParameters> |
| </asp:SqlDataSource> |
| <telerik:radgrid id="RadGrid_Incidents" AutoGenerateColumns="false" ShowHeader="false" runat="server" DataSourceID="SqlDataSource1" Skin="Default"> |
| <MasterTableView ClientDataKeyNames="TO_WORKGROUP_FROM_SQL2" DataKeyNames="TO_WORKGROUP_FROM_SQL1" HierarchyLoadMode="Client"> |
| <Columns> |
| <telerik:GridBoundColumn UniqueName="TO_WORKGROUP" DataField="TO_WORKGROUP_FROM_SQL1" /> |
| </Columns> |
| <NestedViewSettings DataSourceID="SqlDataSource2"> |
| <ParentTableRelation> |
| <telerik:GridRelationFields DetailKeyField="TO_WORKGROUP_FROM_SQL2" MasterKeyField="TO_WORKGROUP_FROM_SQL1" /> |
| </ParentTableRelation> |
| </NestedViewSettings> |
| <NestedViewTemplate> |
| <div style="max-height:100px; overflow:auto"> |
| <asp:Label ID="lblWorkgroupID" Text='<%# Eval("TO_WORKGROUP_FROM_SQL1") %>' Visible="false" runat="server" /> |
| <telerik:radgrid AutoGenerateColumns="false" id="Incidents_Grid" ShowHeader="false" runat="server" DataSourceID="SqlDataSource2" Skin="Default"> |
| <MasterTableView DataKeyNames="TO_WORKGROUP_FROM_SQL2" HierarchyLoadMode="Client"> |
| <Columns> |
| <telerik:GridBoundColumn UniqueName="DESCRIPTION" HeaderText="DESCRIPTION" DataField="DESCRIPTION" /> |
| <telerik:GridBoundColumn UniqueName="INCIDENT_ID" HeaderText="INCIDENT_ID" DataField="INCIDENT_ID" ItemStyle-Font-Size="8pt" /> |
| </Columns> |
| </MasterTableView> |
| </telerik:radgrid> |
| </div> |
| </NestedViewTemplate> |
| <ExpandCollapseColumn Visible="True" /> |
| </MasterTableView> |
| <ClientSettings Selecting-AllowRowSelect="true" /> |
| </telerik:radgrid> |
| String _User = "longjt";//HttpContext.Current.Request.ServerVariables["AUTH_USER"]; |
| SqlDataSource1.SelectCommand = "SELECT NAME as TO_WORKGROUP_FROM_SQL1 FROM SERVICE_MANAGER_ADM.ASSIGNMENTA1 WHERE OPERATORS = '" + _User + "'"; |
| SqlDataSource2.SelectCommand = "SELECT TO_WORKGROUP as TO_WORKGROUP_FROM_SQL2, TO_PERSON_VUNETID, DESCRIPTION, INCIDENT_ID, CREATED_ON FROM SERVICE_MANAGER_ADM.INCIDENT_REPORT_VIEW WHERE (TO_WORKGROUP = @TO_WORKGROUP) AND STATUS != 'Closed' AND STATUS != 'Resolved' ORDER By TO_PERSON_VUNETID, CREATED_ON"; |
| <telerik:RadGrid ID="dgLocations" runat="server" AutoGenerateColumns="False" Visible="false"> |
| <MasterTableView ShowHeadersWhenNoRecords="False" AllowNaturalSort="false" AllowSorting="true"> |
| <SortExpressions> |
| <telerik:GridSortExpression FieldName="LocationName" SortOrder="Ascending" /> |
| </SortExpressions> |
| <Columns> |
| <telerik:GridBoundColumn UniqueName="LocationCode" |
| DataField="LocationCode" HeaderText="Code" /> |
| <telerik:GridBoundColumn UniqueName="LocationName" |
| DataField="LocationName" HeaderText="Name" /> |
| <telerik:GridBoundColumn UniqueName="City" |
| DataField="City" HeaderText="City" /> |
| <telerik:GridBoundColumn UniqueName="State" DataField="State" |
| HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderText="State/Province" Resizable="false" /> |
| <telerik:GridTemplateColumn UniqueName="Select" HeaderText="Select"> |
| <ItemStyle HorizontalAlign="Center" /> |
| <HeaderStyle HorizontalAlign="Center" /> |
| <ItemTemplate> |
| <a onclick="returnValues(<%# Eval("LocationID") %>);" href="#">Select</a> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| </Columns> |
| </MasterTableView> |
| <ClientSettings> |
| <Resizing AllowColumnResize="true" ClipCellContentOnResize="false" EnableRealTimeResize="true" |
| ResizeGridOnColumnResize="true" /> |
| </ClientSettings> |
| </telerik:RadGrid> |
Cannot find the object "Appointment_Data" because it does not exist or you do not have permissions".
I know the object exists and I've tried creating everything from scratch while logged in with my windows system account as well as sa. How could sa not have permissions to insert data? Anyway, I'll keep trying but help would be appreciated!
Dim raditem1 As New RadComboBoxItem
Dim raditem2 As New RadComboBoxItem
Dim raditem3 As New RadComboBoxItem
Dim raditem4 As New RadComboBoxItem
If TypeOf e.Item Is GridEditableItem AndAlso e.Item.IsInEditMode Then
Dim txtuserName As TextBox = DirectCast(item.FindControl("txtuserName"), TextBox)
Dim txtpassword As TextBox = DirectCast(item.FindControl("txtpassword"), TextBox)
Dim lstbLocations As ListBox = DirectCast(item.FindControl("lstbLocations"), ListBox)
RadAjaxManager1.AjaxSettings.AddAjaxSetting(txtuserName, lstbLocations)
END IF
http://www.whitehouse.gov/
Thanks,
Hong