<
asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:Trident_SLURPConnectionString %>"
DeleteCommand="DELETE FROM [Core_Support] WHERE [IssueNumber] = @IssueNumber"
InsertCommand="INSERT INTO [Core_Support] ([Customer], [InitialContact], [InitialEngineer], [AddressName], [AddressNumber], [AddressStreet1], [AddressStreet2], [AddressStreet3], [AddressCity], [AddressCounty], [AddressCountry], [AddressPostCode]) VALUES (@Customer, @InitialContact, @InitialEngineer, @AddressName, @AddressNumber, @AddressStreet1, @AddressStreet2, @AddressStreet3, @AddressCity, @AddressCounty, @AddressCountry, @AddressPostCode)"
SelectCommand="SELECT * FROM [Core_Support] ORDER BY [IssueNumber]"
SELECT [Address1_Name], [Address1_Line1], [Address1_Line2], [Address1_Line3], [Address1_City], [Address1_County], [Address1_PostalCode], [Address1_Country] FROM Trident_Professional_IT_Services_MSCRM.dbo.Account as CRM
join Core_Support as CS on CS.Customer =CRM.Name"
UpdateCommand="UPDATE [Core_Support] SET [Customer] = @Customer, [InitialContact] = @InitialContact, [InitialEngineer] = @InitialEngineer, [AddressName] = @AddressName, [AddressNumber] = @AddressNumber, [AddressStreet1] = @AddressStreet1, [AddressStreet2] = @AddressStreet2, [AddressStreet3] = @AddressStreet3, [AddressCity] = @AddressCity, [AddressCounty] = @AddressCounty, [AddressCountry] = @AddressCountry, [AddressPostCode] = @AddressPostCode WHERE [IssueNumber] = @IssueNumber">
<DeleteParameters>
<asp:Parameter Name="IssueNumber" Type="Decimal" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Customer" Type="String" />
<asp:Parameter Name="InitialContact" Type="String" />
<asp:Parameter Name="InitialEngineer" Type="String" />
<asp:Parameter Name="AddressName" Type="String" />
<asp:Parameter Name="AddressNumber" Type="Int32" />
<asp:Parameter Name="AddressStreet1" Type="String" />
<asp:Parameter Name="AddressStreet2" Type="String" />
<asp:Parameter Name="AddressStreet3" Type="String" />
<asp:Parameter Name="AddressCity" Type="String" />
<asp:Parameter Name="AddressCounty" Type="String" />
<asp:Parameter Name="AddressCountry" Type="String" />
<asp:Parameter Name="AddressPostCode" Type="String" />
<asp:Parameter Name="IssueNumber" Type="Decimal" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Customer" Type="String" />
<asp:Parameter Name="InitialContact" Type="String" />
<asp:Parameter Name="InitialEngineer" Type="String" />
<asp:Parameter Name="AddressName" Type="String" />
<asp:Parameter Name="AddressNumber" Type="Int32" />
<asp:Parameter Name="AddressStreet1" Type="String" />
<asp:Parameter Name="AddressStreet2" Type="String" />
<asp:Parameter Name="AddressStreet3" Type="String" />
<asp:Parameter Name="AddressCity" Type="String" />
<asp:Parameter Name="AddressCounty" Type="String" />
<asp:Parameter Name="AddressCountry" Type="String" />
<asp:Parameter Name="AddressPostCode" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
I also need the edit form fields which are outlined in the parameters above, to be automatically filled a selection is made in the GridDropDownBox.
Obviously, it's not working. What am I doing wrong?
:-)


| var BodyObj = document.getElementsByTagName("body")[0]; |
| var CloseButtonElement = document.createElement("input"); |
| CloseButtonElement.setAttribute("type", "button"); |
| CloseButtonElement.value = "Ok" |
| CloseButtonElement.onclick = function() { alert("blabla") }; |
| BodyObj.insertBefore(CloseButtonElement, BodyObj.firstChild); |
function
ShowWindow(role){
var win = window.radopen("~\Help.aspx?role=" + role, "HelpWindow");
return false;
}
"~" not redirecting to the base directory.
My Help.aspx file is on base directory.How do I browse this page from other directories.
thanks!
| <telerik:RadGrid ID="gridEmployees" runat="server" GridLines="None" AutoGenerateColumns="False" |
| AllowMultiRowSelection="False" OnSelectedIndexChanged="gridEmployees_SelectedIndexChanged" |
| ShowHeader="False" AllowPaging="true" PageSize="20"> |
| <MasterTableView DataKeyNames="EmployeeId"> |
| <Columns> |
| <telerik:GridNumericColumn DataField="EmployeeId" UniqueName="EmployeeId" Visible="false" /> |
| <telerik:GridBoundColumn DataField="FullName" UniqueName="FullName" /> |
| </Columns> |
| </MasterTableView> |
| <ClientSettings EnablePostBackOnRowClick="true"> |
| <ClientEvents OnCommand="gridEmployees_Command" OnMasterTableViewCreated="gridEmployees_MasterTableViewCreated" /> |
| <Selecting AllowRowSelect="true" /> |
| </ClientSettings> |
| <PagerStyle Mode="NumericPages" /> |
| </telerik:RadGrid> |
| $.ajax({ |
| cache: false, |
| contentType: "application/x-www-form-urlencoded", |
| data: searchData, |
| dataType: "json", |
| type: "GET", |
| url: "/Services/EmployeeService.svc/FindEmployees", |
| success: function(data, textStatus) { |
| var gridEmployees = $find("<%= gridEmployees.ClientID %>"); |
| var employeesTable = gridEmployees.get_masterTableView(); |
| employeesTable.set_dataSource(data.Employees); |
| employeesTable.dataBind(); |
| employeesTable.set_virtualItemCount(data.VirtualItemCount); |
| }, |
| }); |
| [ServiceContract(Name="EmployeeService", Namespace="Provisior.Services")] |
| [AspNetCompatibilityRequirements( |
| RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)] |
| public class EmployeeService |
| { |
| [OperationContract] |
| [WebGet(ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Bare)] |
| public FindEmployeesResult FindEmployees(string searchTerm, int startIndex, int maximumRows) |
| { |
| var employees = new List<EmployeeInfo>(); |
| for (int i = 1; i <= 20; i++) |
| { |
| employees.Add(new EmployeeInfo |
| { |
| EmployeeId = i, |
| FullName = "Employee " + i |
| }); |
| } |
| return new FindEmployeesResult { Employees = employees, VirtualItemCount = 500 }; |
| } |
| } |