or
1 answer
76 views
hi,
i want to use images from web in my rad editor. Currently Rad editor provides image manager functionality which allows us to use images from local system only. i want to know is there any method by which i can use web images (by giving web URL of images). Due to business requirement i can't use HTML mode of the RAD Editor, so can't inject images through HTML.
Please suggest a solution.
Raghav
Rumen
Telerik team
answered
on
25 Apr 2011
2 answers
53 views
Hi -
Im new to telerik controls.
Im working with the Grid control and have a question regarding master/detail.
There is a black arrow > in each master record line when running the Grid.
Clicking on master records with no details in database displays the "no record" message.
If there was a detail record in the database, it would have been displayed. Working ok.
But is is possible to hide the > arrow on master records that dont have any detail records present?
Second, Hiow do I enable images to replace "edit" and "Delete" text. ?
Please advice.
kind r
Bjørn.
Im new to telerik controls.
Im working with the Grid control and have a question regarding master/detail.
There is a black arrow > in each master record line when running the Grid.
Clicking on master records with no details in database displays the "no record" message.
If there was a detail record in the database, it would have been displayed. Working ok.
But is is possible to hide the > arrow on master records that dont have any detail records present?
Second, Hiow do I enable images to replace "edit" and "Delete" text. ?
Please advice.
kind r
Bjørn.
Bjørn-Tore
Top achievements
Rank 1
Rank 1
answered
on
25 Apr 2011
1 answer
153 views
When i click the add new button .
add new button in RadToolBarButton
it's not working ,
look my code tell the suggestion
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Location.aspx.cs" Inherits="TBS_HelpDesk.Views.Assets.Location"
MasterPageFile="~/Views/Shared/MasterPage.Master" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<asp:Content ID="aboutContent" ContentPlaceHolderID="MainContent" runat="server">
<telerik:RadCodeBlock runat="server" ID="radCodeBlock">
<script type="text/javascript">
function onToolBarClientButtonClicking(sender, args) {
var grid = $find("<%=RadGrid1.ClientID %>");
debugger;
var comandName = args.get_item().get_commandName();
if (comandName == "Filter") {
if (grid.get_masterTableView().get_isFilterItemVisible()) {
grid.get_masterTableView().hideFilterItem();
}
else {
grid.get_masterTableView().showFilterItem();
}
}
}
function getOuterHTML(obj) {
if (typeof (obj.outerHTML) == "undefined") {
var divWrapper = document.createElement("div");
var copyOb = obj.cloneNode(true);
divWrapper.appendChild(copyOb);
return divWrapper.innerHTML
}
else
return obj.outerHTML;
}
function PrintRadGrid() {
var previewWnd = window.open('about:blank', '', '', false);
var sh = '<%= ClientScript.GetWebResourceUrl(RadGrid1.GetType(),String.Format("Telerik.Web.UI.Skins.{0}.Grid.{0}.css",RadGrid1.Skin)) %>';
var shBase = '<%= ClientScript.GetWebResourceUrl(RadGrid1.GetType(),"Telerik.Web.UI.Skins.Grid.css") %>';
var styleStr = "<html><head><link href = '" + sh + "' rel='stylesheet' type='text/css'></link>";
styleStr += "<link href = '" + shBase + "' rel='stylesheet' type='text/css'></link></head>";
var htmlcontent = styleStr + "<body>" + getOuterHTML($find('<%= RadGrid1.ClientID %>').get_element()) + "</body></html>";
previewWnd.document.open();
previewWnd.document.write(htmlcontent);
previewWnd.document.close();
previewWnd.print();
previewWnd.close(); // working
}
</script>
</telerik:RadCodeBlock>
<div style="width: 760px; height: 600px;">
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="RadGrid1">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadGrid1" UpdatePanelHeight="" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadGrid ID="RadGrid1" runat="server" Skin="Office2007" AllowAutomaticInserts="True"
AllowAutomaticUpdates="True" GridLines="None" AutoCompleteType="Disabled" AllowFilteringByColumn="True"
AllowPaging="True" AllowSorting="True" OnRowDataBound="RadGrid1_RowDataBound1"
OnItemCommand="RadGrid1_ItemCommand">
<ExportSettings>
<Pdf PageHeight="297mm" PageWidth="210mm" />
</ExportSettings>
<MasterTableView ShowHeadersWhenNoRecords="true" AutoGenerateColumns="False" CommandItemDisplay="Top"
EditMode="PopUp" EditFormSettings-PopUpSettings-Modal="true">
<CommandItemTemplate>
<telerik:RadToolBar ID="RadToolBar1" runat="server" OnClientButtonClicking="onToolBarClientButtonClicking">
<Items>
<telerik:RadToolBarButton Text="Cancel editing" CommandName="CancelAll" ImageUrl="images/Cancel.gif"
Visible='<%# RadGrid1.EditIndexes.Count > 0 || RadGrid1.MasterTableView.IsItemInserted %>'>
</telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="Add new" CommandName="InitInsert" ImageUrl="../../images/AddRecord.gif"
Visible='<%# !RadGrid1.MasterTableView.IsItemInserted %>'>
</telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="Filter" CommandName="Filter" ImageUrl="../../images/Filter 3.gif">
</telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="Print" CommandName="Print" onclick="PrintRadGrid()">
</telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="Refresh" CommandName="RebindGrid" ImageUrl="../../images/Refresh.gif">
</telerik:RadToolBarButton>
</Items>
</telerik:RadToolBar>
</CommandItemTemplate>
<PagerStyle BackColor="#D8EBFC" Mode="NextPrevNumericAndAdvanced" />
<HeaderStyle CssClass="dataheadcolor" />
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>
<Columns>
<telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderStyle-Width="10px">
<HeaderStyle Width="10px"></HeaderStyle>
</telerik:GridEditCommandColumn>
<telerik:GridNumericColumn DataField="AddressID" HeaderText="Address ID" SortExpression="AddressID"
UniqueName="AddressID" FilterControlWidth="20px" HeaderStyle-Width="120px" ReadOnly="true">
</telerik:GridNumericColumn>
<telerik:GridBoundColumn DataField="Address_Location_Name" HeaderText="Address Name"
SortExpression="Address_Location_Name" UniqueName="Address_Location_Name" FilterControlWidth="40px"
HeaderStyle-Width="130px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_Line1" HeaderText="Line1" SortExpression="Address_Line1"
UniqueName="Address_Line1" FilterControlWidth="40px" HeaderStyle-Width="80px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_Line2" HeaderText="Line2" SortExpression="Address_Line2"
UniqueName="Address_Line2" FilterControlWidth="40px" HeaderStyle-Width="80px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_City" HeaderText="City " SortExpression="Address_City"
UniqueName="Address_City" FilterControlWidth="40px" HeaderStyle-Width="90px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_State" HeaderText="State" SortExpression="Address_State"
UniqueName="Address_State" FilterControlWidth="40px" HeaderStyle-Width="90px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_Country" HeaderText="Country" SortExpression="Address_Country"
UniqueName="Address_Country" FilterControlWidth="40px" HeaderStyle-Width="90px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_Postal_Code" HeaderText="Postal Code"
SortExpression="Address_Postal_Code" UniqueName="Address_Postal_Code" FilterControlWidth="40px"
HeaderStyle-Width="90px">
</telerik:GridBoundColumn>
<telerik:GridButtonColumn CommandName="Delete" ButtonType="ImageButton" HeaderStyle-Width="10px">
<HeaderStyle Width="10px"></HeaderStyle>
</telerik:GridButtonColumn>
</Columns>
<EditFormSettings ColumnNumber="3" CaptionFormatString="Create">
<EditColumn UniqueName="EditCommandColumn1">
</EditColumn>
<FormTemplate>
<table cellspacing="2" cellpadding="1" width="100%" border="0">
<tr>
<td>
<asp:Label runat="server" Text="AddressID" ID="label1"></asp:Label>
</td>
<td>
<asp:TextBox Width="200px" ID="AddressID" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("AddressID") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
Location Name
</td>
<td>
<asp:TextBox Width="200px" ID="Address_Location_Name" AutoCompleteType="Disabled"
runat="server" Text='<%# Bind("Address_Location_Name") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
Line1
</td>
<td>
<asp:TextBox Width="200px" ID="Address_Line1" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_Line1") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
Line2
</td>
<td>
<asp:TextBox Width="200px" ID="Address_Line2" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_Line2") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
City
</td>
<td>
<asp:TextBox Width="200px" ID="Address_City" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_City") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
State
</td>
<td>
<asp:TextBox Width="200px" ID="Address_State" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_State") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
Country
</td>
<td>
<asp:TextBox Width="200px" ID="Address_Country" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_Country") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
Postal Code
</td>
<td>
<asp:TextBox Width="200px" ID="Address_Postal_Code" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_Postal_Code") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Button ID="Button1" runat="server" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'>
</asp:Button>
<asp:Button ID="Button2" runat="server" Text="Cancel" CausesValidation="false" CommandName="Cancel">
</asp:Button>
</td>
</tr>
</table>
</FormTemplate>
<PopUpSettings Modal="True"></PopUpSettings>
</EditFormSettings>
</MasterTableView>
<ClientSettings>
<Selecting AllowRowSelect="True" EnableDragToSelectRows="True" />
</ClientSettings>
</telerik:RadGrid>
</div>
</asp:Content>
using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using Telerik.Web.UI;
namespace TBS_HelpDesk.Views.Assets
{
public partial class Location : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataTable dtTable = new DataTable();
string conn = ConfigurationManager.ConnectionStrings["TBSHelpDeskLiveDB_ConnectionString"].ToString();
SqlDataAdapter sqladp = new SqlDataAdapter();
SqlConnection sqlconn = new SqlConnection(conn);
sqlconn.Open();
try
{
string selectQuery = "SELECT AddressID, Address_Location_Name, Address_Line1,Address_Line2,Address_City,Address_State,Address_Country,Address_Postal_Code FROM [Addresses] order by AddressID asc";
sqladp.SelectCommand = new SqlCommand(selectQuery, sqlconn);
sqladp.Fill(dtTable);
RadGrid1.DataSource = dtTable;
}
finally
{
sqlconn.Close();
}
}
protected void RadGrid1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("id", e.Row.RowIndex.ToString());
e.Row.Attributes.Add("onclick", "MarkRow(" + e.Row.RowIndex.ToString() + ");");
// e.Row.Attributes.Add("onkeydown", "SelectRow('" + GridView1.ClientID + "'," + e.Row.RowIndex.ToString() + ")");
}
}
protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
{
DataTable dtTable = new DataTable();
string conn = ConfigurationManager.ConnectionStrings["TBSHelpDeskLiveDB_ConnectionString"].ToString();
SqlDataAdapter sqladp = new SqlDataAdapter();
SqlConnection sqlconn = new SqlConnection(conn);
SqlCommand sqlcmd = new SqlCommand();
if (e.CommandName == RadGrid.PerformInsertCommandName)
{
GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;
TextBox Address_Location_Name = (e.Item as GridEditFormInsertItem)["Address_Location_Name"].Controls[0] as TextBox;
TextBox Address_Line1 = (e.Item as GridEditFormInsertItem)["Address_Line1"].Controls[0] as TextBox;
TextBox Address_Line2 = (e.Item as GridEditFormInsertItem)["Address_Line2"].Controls[0] as TextBox;
TextBox Address_City = (e.Item as GridEditFormInsertItem)["Address_City"].Controls[0] as TextBox;
TextBox Address_State = (e.Item as GridEditFormInsertItem)["Address_State"].Controls[0] as TextBox;
TextBox Address_Country = (e.Item as GridEditFormInsertItem)["Address_Country"].Controls[0] as TextBox;
TextBox Address_Postal_Code = (e.Item as GridEditFormInsertItem)["Address_Postal_Code"].Controls[0] as TextBox;
try
{
sqlconn.Open();
string insertQuery = "INSERT INTO [Addresses] ([Address_Location_Name], [Address_Line1],[Address_Line2],[Address_City],[Address_State],[Address_Country],[Address_Postal_Code]) VALUES ('" + Address_Location_Name.Text + "','" + Address_Line1.Text + "','" + Address_Line2.Text + "','" + Address_City.Text + "','" + Address_State.Text + "','" + Address_Country.Text + "','" + Address_Postal_Code.Text + "')";
sqlcmd.CommandText = insertQuery;
sqlcmd.Connection = sqlconn;
sqlcmd.ExecuteNonQuery();
string selectQuery = "SELECT AddressID, Address_Location_Name, Address_Line1,Address_Line2,Address_City,Address_State,Address_Country,Address_Postal_Code FROM [Addresses] order by AddressID asc";
sqladp.SelectCommand = new SqlCommand(selectQuery, sqlconn);
sqladp.Fill(dtTable);
RadGrid1.DataSource = dtTable;
sqlconn.Close();
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + ex.Message));
}
RadGrid1.MasterTableView.IsItemInserted = false;
RadGrid1.DataBind();
e.Canceled = true;
}
else if (e.CommandName == RadGrid.UpdateCommandName)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
RadNumericTextBox AddressID = (e.Item as GridEditableItem)["AddressID"].Controls[0] as RadNumericTextBox;
TextBox Address_Location_Name = (e.Item as GridEditableItem)["Address_Location_Name"].Controls[0] as TextBox;
TextBox Address_Line1 = (e.Item as GridEditableItem)["Address_Line1"].Controls[0] as TextBox;
TextBox Address_Line2 = (e.Item as GridEditableItem)["Address_Line2"].Controls[0] as TextBox;
TextBox Address_City = (e.Item as GridEditableItem)["Address_City"].Controls[0] as TextBox;
TextBox Address_State = (e.Item as GridEditableItem)["Address_State"].Controls[0] as TextBox;
TextBox Address_Country = (e.Item as GridEditableItem)["Address_Country"].Controls[0] as TextBox;
TextBox Address_Postal_Code = (e.Item as GridEditableItem)["Address_Postal_Code"].Controls[0] as TextBox;
try
{
sqlconn.Open();
string updateQuery = "UPDATE [Addresses] SET [Address_Location_Name] = '" + Address_Location_Name.Text + "', [Address_Line1] = '" + Address_Line1.Text + "',[Address_Line2] ='" + Address_Line2.Text + "',[Address_City] = '" + Address_City.Text + "',[Address_State] = '" + Address_State.Text + "',[Address_Country] = '" + Address_Country.Text + "',[Address_Postal_Code] = '" + Address_Postal_Code.Text + "' WHERE [AddressID] = '" + AddressID.Text + "'";
sqlcmd.CommandText = updateQuery;
sqlcmd.Connection = sqlconn;
sqlcmd.ExecuteNonQuery();
string selectQuery = "SELECT AddressID, Address_Location_Name, Address_Line1,Address_Line2,Address_City,Address_State,Address_Country,Address_Postal_Code FROM [Addresses] order by AddressID asc";
sqladp.SelectCommand = new SqlCommand(selectQuery, sqlconn);
sqladp.Fill(dtTable);
RadGrid1.DataSource = dtTable;
sqlconn.Close();
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to update Employee. Reason: " + ex.Message));
}
RadGrid1.EditIndexes.Clear();
RadGrid1.DataBind();
e.Canceled = true;
}
else if (e.CommandName == RadGrid.DeleteCommandName)
{
GridDataItem item = (GridDataItem)e.Item;
string AddressID = item["AddressID"].Text;
try
{
sqlconn.Open();
string deleteQuery = "DELETE FROM [Addresses] WHERE [AddressID] ='" + AddressID + "'";
sqlcmd.CommandText = deleteQuery;
sqlcmd.Connection = sqlconn;
sqlcmd.ExecuteNonQuery();
string selectQuery = "SELECT AddressID, Address_Location_Name, Address_Line1,Address_Line2,Address_City,Address_State,Address_Country,Address_Postal_Code FROM [Addresses] order by AddressID asc";
sqladp.SelectCommand = new SqlCommand(selectQuery, sqlconn);
sqladp.Fill(dtTable);
RadGrid1.DataSource = dtTable;
sqlconn.Close();
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to delete Id. Reason: " + ex.Message));
e.Canceled = true;
}
}
}
}
}
add new button in RadToolBarButton
it's not working ,
look my code tell the suggestion
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Location.aspx.cs" Inherits="TBS_HelpDesk.Views.Assets.Location"
MasterPageFile="~/Views/Shared/MasterPage.Master" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<asp:Content ID="aboutContent" ContentPlaceHolderID="MainContent" runat="server">
<telerik:RadCodeBlock runat="server" ID="radCodeBlock">
<script type="text/javascript">
function onToolBarClientButtonClicking(sender, args) {
var grid = $find("<%=RadGrid1.ClientID %>");
debugger;
var comandName = args.get_item().get_commandName();
if (comandName == "Filter") {
if (grid.get_masterTableView().get_isFilterItemVisible()) {
grid.get_masterTableView().hideFilterItem();
}
else {
grid.get_masterTableView().showFilterItem();
}
}
}
function getOuterHTML(obj) {
if (typeof (obj.outerHTML) == "undefined") {
var divWrapper = document.createElement("div");
var copyOb = obj.cloneNode(true);
divWrapper.appendChild(copyOb);
return divWrapper.innerHTML
}
else
return obj.outerHTML;
}
function PrintRadGrid() {
var previewWnd = window.open('about:blank', '', '', false);
var sh = '<%= ClientScript.GetWebResourceUrl(RadGrid1.GetType(),String.Format("Telerik.Web.UI.Skins.{0}.Grid.{0}.css",RadGrid1.Skin)) %>';
var shBase = '<%= ClientScript.GetWebResourceUrl(RadGrid1.GetType(),"Telerik.Web.UI.Skins.Grid.css") %>';
var styleStr = "<html><head><link href = '" + sh + "' rel='stylesheet' type='text/css'></link>";
styleStr += "<link href = '" + shBase + "' rel='stylesheet' type='text/css'></link></head>";
var htmlcontent = styleStr + "<body>" + getOuterHTML($find('<%= RadGrid1.ClientID %>').get_element()) + "</body></html>";
previewWnd.document.open();
previewWnd.document.write(htmlcontent);
previewWnd.document.close();
previewWnd.print();
previewWnd.close(); // working
}
</script>
</telerik:RadCodeBlock>
<div style="width: 760px; height: 600px;">
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="RadGrid1">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadGrid1" UpdatePanelHeight="" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadGrid ID="RadGrid1" runat="server" Skin="Office2007" AllowAutomaticInserts="True"
AllowAutomaticUpdates="True" GridLines="None" AutoCompleteType="Disabled" AllowFilteringByColumn="True"
AllowPaging="True" AllowSorting="True" OnRowDataBound="RadGrid1_RowDataBound1"
OnItemCommand="RadGrid1_ItemCommand">
<ExportSettings>
<Pdf PageHeight="297mm" PageWidth="210mm" />
</ExportSettings>
<MasterTableView ShowHeadersWhenNoRecords="true" AutoGenerateColumns="False" CommandItemDisplay="Top"
EditMode="PopUp" EditFormSettings-PopUpSettings-Modal="true">
<CommandItemTemplate>
<telerik:RadToolBar ID="RadToolBar1" runat="server" OnClientButtonClicking="onToolBarClientButtonClicking">
<Items>
<telerik:RadToolBarButton Text="Cancel editing" CommandName="CancelAll" ImageUrl="images/Cancel.gif"
Visible='<%# RadGrid1.EditIndexes.Count > 0 || RadGrid1.MasterTableView.IsItemInserted %>'>
</telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="Add new" CommandName="InitInsert" ImageUrl="../../images/AddRecord.gif"
Visible='<%# !RadGrid1.MasterTableView.IsItemInserted %>'>
</telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="Filter" CommandName="Filter" ImageUrl="../../images/Filter 3.gif">
</telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="Print" CommandName="Print" onclick="PrintRadGrid()">
</telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="Refresh" CommandName="RebindGrid" ImageUrl="../../images/Refresh.gif">
</telerik:RadToolBarButton>
</Items>
</telerik:RadToolBar>
</CommandItemTemplate>
<PagerStyle BackColor="#D8EBFC" Mode="NextPrevNumericAndAdvanced" />
<HeaderStyle CssClass="dataheadcolor" />
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>
<Columns>
<telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderStyle-Width="10px">
<HeaderStyle Width="10px"></HeaderStyle>
</telerik:GridEditCommandColumn>
<telerik:GridNumericColumn DataField="AddressID" HeaderText="Address ID" SortExpression="AddressID"
UniqueName="AddressID" FilterControlWidth="20px" HeaderStyle-Width="120px" ReadOnly="true">
</telerik:GridNumericColumn>
<telerik:GridBoundColumn DataField="Address_Location_Name" HeaderText="Address Name"
SortExpression="Address_Location_Name" UniqueName="Address_Location_Name" FilterControlWidth="40px"
HeaderStyle-Width="130px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_Line1" HeaderText="Line1" SortExpression="Address_Line1"
UniqueName="Address_Line1" FilterControlWidth="40px" HeaderStyle-Width="80px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_Line2" HeaderText="Line2" SortExpression="Address_Line2"
UniqueName="Address_Line2" FilterControlWidth="40px" HeaderStyle-Width="80px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_City" HeaderText="City " SortExpression="Address_City"
UniqueName="Address_City" FilterControlWidth="40px" HeaderStyle-Width="90px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_State" HeaderText="State" SortExpression="Address_State"
UniqueName="Address_State" FilterControlWidth="40px" HeaderStyle-Width="90px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_Country" HeaderText="Country" SortExpression="Address_Country"
UniqueName="Address_Country" FilterControlWidth="40px" HeaderStyle-Width="90px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Address_Postal_Code" HeaderText="Postal Code"
SortExpression="Address_Postal_Code" UniqueName="Address_Postal_Code" FilterControlWidth="40px"
HeaderStyle-Width="90px">
</telerik:GridBoundColumn>
<telerik:GridButtonColumn CommandName="Delete" ButtonType="ImageButton" HeaderStyle-Width="10px">
<HeaderStyle Width="10px"></HeaderStyle>
</telerik:GridButtonColumn>
</Columns>
<EditFormSettings ColumnNumber="3" CaptionFormatString="Create">
<EditColumn UniqueName="EditCommandColumn1">
</EditColumn>
<FormTemplate>
<table cellspacing="2" cellpadding="1" width="100%" border="0">
<tr>
<td>
<asp:Label runat="server" Text="AddressID" ID="label1"></asp:Label>
</td>
<td>
<asp:TextBox Width="200px" ID="AddressID" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("AddressID") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
Location Name
</td>
<td>
<asp:TextBox Width="200px" ID="Address_Location_Name" AutoCompleteType="Disabled"
runat="server" Text='<%# Bind("Address_Location_Name") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
Line1
</td>
<td>
<asp:TextBox Width="200px" ID="Address_Line1" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_Line1") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
Line2
</td>
<td>
<asp:TextBox Width="200px" ID="Address_Line2" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_Line2") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
City
</td>
<td>
<asp:TextBox Width="200px" ID="Address_City" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_City") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
State
</td>
<td>
<asp:TextBox Width="200px" ID="Address_State" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_State") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
Country
</td>
<td>
<asp:TextBox Width="200px" ID="Address_Country" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_Country") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
Postal Code
</td>
<td>
<asp:TextBox Width="200px" ID="Address_Postal_Code" AutoCompleteType="Disabled" runat="server"
Text='<%# Bind("Address_Postal_Code") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Button ID="Button1" runat="server" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'>
</asp:Button>
<asp:Button ID="Button2" runat="server" Text="Cancel" CausesValidation="false" CommandName="Cancel">
</asp:Button>
</td>
</tr>
</table>
</FormTemplate>
<PopUpSettings Modal="True"></PopUpSettings>
</EditFormSettings>
</MasterTableView>
<ClientSettings>
<Selecting AllowRowSelect="True" EnableDragToSelectRows="True" />
</ClientSettings>
</telerik:RadGrid>
</div>
</asp:Content>
using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using Telerik.Web.UI;
namespace TBS_HelpDesk.Views.Assets
{
public partial class Location : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataTable dtTable = new DataTable();
string conn = ConfigurationManager.ConnectionStrings["TBSHelpDeskLiveDB_ConnectionString"].ToString();
SqlDataAdapter sqladp = new SqlDataAdapter();
SqlConnection sqlconn = new SqlConnection(conn);
sqlconn.Open();
try
{
string selectQuery = "SELECT AddressID, Address_Location_Name, Address_Line1,Address_Line2,Address_City,Address_State,Address_Country,Address_Postal_Code FROM [Addresses] order by AddressID asc";
sqladp.SelectCommand = new SqlCommand(selectQuery, sqlconn);
sqladp.Fill(dtTable);
RadGrid1.DataSource = dtTable;
}
finally
{
sqlconn.Close();
}
}
protected void RadGrid1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("id", e.Row.RowIndex.ToString());
e.Row.Attributes.Add("onclick", "MarkRow(" + e.Row.RowIndex.ToString() + ");");
// e.Row.Attributes.Add("onkeydown", "SelectRow('" + GridView1.ClientID + "'," + e.Row.RowIndex.ToString() + ")");
}
}
protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
{
DataTable dtTable = new DataTable();
string conn = ConfigurationManager.ConnectionStrings["TBSHelpDeskLiveDB_ConnectionString"].ToString();
SqlDataAdapter sqladp = new SqlDataAdapter();
SqlConnection sqlconn = new SqlConnection(conn);
SqlCommand sqlcmd = new SqlCommand();
if (e.CommandName == RadGrid.PerformInsertCommandName)
{
GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;
TextBox Address_Location_Name = (e.Item as GridEditFormInsertItem)["Address_Location_Name"].Controls[0] as TextBox;
TextBox Address_Line1 = (e.Item as GridEditFormInsertItem)["Address_Line1"].Controls[0] as TextBox;
TextBox Address_Line2 = (e.Item as GridEditFormInsertItem)["Address_Line2"].Controls[0] as TextBox;
TextBox Address_City = (e.Item as GridEditFormInsertItem)["Address_City"].Controls[0] as TextBox;
TextBox Address_State = (e.Item as GridEditFormInsertItem)["Address_State"].Controls[0] as TextBox;
TextBox Address_Country = (e.Item as GridEditFormInsertItem)["Address_Country"].Controls[0] as TextBox;
TextBox Address_Postal_Code = (e.Item as GridEditFormInsertItem)["Address_Postal_Code"].Controls[0] as TextBox;
try
{
sqlconn.Open();
string insertQuery = "INSERT INTO [Addresses] ([Address_Location_Name], [Address_Line1],[Address_Line2],[Address_City],[Address_State],[Address_Country],[Address_Postal_Code]) VALUES ('" + Address_Location_Name.Text + "','" + Address_Line1.Text + "','" + Address_Line2.Text + "','" + Address_City.Text + "','" + Address_State.Text + "','" + Address_Country.Text + "','" + Address_Postal_Code.Text + "')";
sqlcmd.CommandText = insertQuery;
sqlcmd.Connection = sqlconn;
sqlcmd.ExecuteNonQuery();
string selectQuery = "SELECT AddressID, Address_Location_Name, Address_Line1,Address_Line2,Address_City,Address_State,Address_Country,Address_Postal_Code FROM [Addresses] order by AddressID asc";
sqladp.SelectCommand = new SqlCommand(selectQuery, sqlconn);
sqladp.Fill(dtTable);
RadGrid1.DataSource = dtTable;
sqlconn.Close();
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + ex.Message));
}
RadGrid1.MasterTableView.IsItemInserted = false;
RadGrid1.DataBind();
e.Canceled = true;
}
else if (e.CommandName == RadGrid.UpdateCommandName)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
RadNumericTextBox AddressID = (e.Item as GridEditableItem)["AddressID"].Controls[0] as RadNumericTextBox;
TextBox Address_Location_Name = (e.Item as GridEditableItem)["Address_Location_Name"].Controls[0] as TextBox;
TextBox Address_Line1 = (e.Item as GridEditableItem)["Address_Line1"].Controls[0] as TextBox;
TextBox Address_Line2 = (e.Item as GridEditableItem)["Address_Line2"].Controls[0] as TextBox;
TextBox Address_City = (e.Item as GridEditableItem)["Address_City"].Controls[0] as TextBox;
TextBox Address_State = (e.Item as GridEditableItem)["Address_State"].Controls[0] as TextBox;
TextBox Address_Country = (e.Item as GridEditableItem)["Address_Country"].Controls[0] as TextBox;
TextBox Address_Postal_Code = (e.Item as GridEditableItem)["Address_Postal_Code"].Controls[0] as TextBox;
try
{
sqlconn.Open();
string updateQuery = "UPDATE [Addresses] SET [Address_Location_Name] = '" + Address_Location_Name.Text + "', [Address_Line1] = '" + Address_Line1.Text + "',[Address_Line2] ='" + Address_Line2.Text + "',[Address_City] = '" + Address_City.Text + "',[Address_State] = '" + Address_State.Text + "',[Address_Country] = '" + Address_Country.Text + "',[Address_Postal_Code] = '" + Address_Postal_Code.Text + "' WHERE [AddressID] = '" + AddressID.Text + "'";
sqlcmd.CommandText = updateQuery;
sqlcmd.Connection = sqlconn;
sqlcmd.ExecuteNonQuery();
string selectQuery = "SELECT AddressID, Address_Location_Name, Address_Line1,Address_Line2,Address_City,Address_State,Address_Country,Address_Postal_Code FROM [Addresses] order by AddressID asc";
sqladp.SelectCommand = new SqlCommand(selectQuery, sqlconn);
sqladp.Fill(dtTable);
RadGrid1.DataSource = dtTable;
sqlconn.Close();
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to update Employee. Reason: " + ex.Message));
}
RadGrid1.EditIndexes.Clear();
RadGrid1.DataBind();
e.Canceled = true;
}
else if (e.CommandName == RadGrid.DeleteCommandName)
{
GridDataItem item = (GridDataItem)e.Item;
string AddressID = item["AddressID"].Text;
try
{
sqlconn.Open();
string deleteQuery = "DELETE FROM [Addresses] WHERE [AddressID] ='" + AddressID + "'";
sqlcmd.CommandText = deleteQuery;
sqlcmd.Connection = sqlconn;
sqlcmd.ExecuteNonQuery();
string selectQuery = "SELECT AddressID, Address_Location_Name, Address_Line1,Address_Line2,Address_City,Address_State,Address_Country,Address_Postal_Code FROM [Addresses] order by AddressID asc";
sqladp.SelectCommand = new SqlCommand(selectQuery, sqlconn);
sqladp.Fill(dtTable);
RadGrid1.DataSource = dtTable;
sqlconn.Close();
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("Unable to delete Id. Reason: " + ex.Message));
e.Canceled = true;
}
}
}
}
}
1 answer
56 views
Hi,
I have radgrid. i am using export to excelML from radgrid. i want give caption or header like "Employee Report 2011-2012". how to get set manually in code behind?
Is there any possible way this one?
Thanks,
Dhamu.
I have radgrid. i am using export to excelML from radgrid. i want give caption or header like "Employee Report 2011-2012". how to get set manually in code behind?
Is there any possible way this one?
Thanks,
Dhamu.
Daniel
Telerik team
answered
on
25 Apr 2011
1 answer
461 views
I have a treeview control embeded into a combobox. I am binding the tree to a sqldatasource, Then I select the first child node of the tree and set it as selected and this all works. What I haven't figured out is how to use the selected node of the tree and set the selected text/value of the parent combobox. I'm trying to do this server-side in c#.
Also I would like to have the tree expanded to show the branch of the tree that has the selected node. If the user selects the dropdown then the tree would show the highlighted selected node.
An example would be greatly appreciated.
Thanks,
Marc
Also I would like to have the tree expanded to show the branch of the tree that has the selected node. If the user selects the dropdown then the tree would show the highlighted selected node.
An example would be greatly appreciated.
Thanks,
Marc
1 answer
165 views
Hi,
i have a gouping in radgrid and i don´t want the order he put, its possible to put the same order that came from DB?
this is my code
i have a gouping in radgrid and i don´t want the order he put, its possible to put the same order that came from DB?
this is my code
<telerik:RadGrid ID="gridAreasAndTopic" runat="server" EnableTheming="false" OnNeedDataSource="gridAreasAndTopics_NeedDataSource" Skin="WebBlue" AutoGenerateColumns="False" ShowFooter="true"> <MasterTableView AutoGenerateColumns="false" EditMode="InPlace" ShowFooter="True" TableLayout="Auto" GroupLoadMode="Client"> <GroupByExpressions> <telerik:GridGroupByExpression> <SelectFields> <telerik:GridGroupByField FieldName="areaName" FieldAlias="Area" /> </SelectFields> <GroupByFields> <telerik:GridGroupByField FieldName="areaName"></telerik:GridGroupByField> </GroupByFields> </telerik:GridGroupByExpression> </GroupByExpressions> <PagerStyle Mode="NextPrevAndNumeric" /> <Columns> <telerik:GridBoundColumn DataField="idArea" HeaderText="idArea" Visible="false" ItemStyle-Width="0%"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="idTopic" HeaderText="idTopic" Visible="false" ItemStyle-Width="0%"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TopicName" Aggregate="Count" HeaderText="TopicName" ItemStyle-Width="100%"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn> <ItemTemplate> <asp:ImageButton ImageUrl="~/App_Themes/InsticcLayout/images/box/error.png" runat="server" ID="lnkDeleteAreaTopic" Text="Add" OnClick="lnkDeleteAreaTopic_Click" CausesValidation="false"> </asp:ImageButton> </ItemTemplate> </telerik:GridTemplateColumn></Columns><HeaderStyle HorizontalAlign="Center" /><ItemStyle HorizontalAlign="Left" /><FilterItemStyle HorizontalAlign="Center" /><GroupHeaderItemStyle HorizontalAlign="Left" /></MasterTableView> <ClientSettings AllowGroupExpandCollapse="True"></ClientSettings></telerik:RadGrid>
Mira
Telerik team
answered
on
25 Apr 2011
1 answer
353 views
Hi,
I have a grid and button,which is inside a update panel.
My requirement is to update the grid on button click.
but when i click on button grid is not updating.
Is there anything I have to set in webpage.
Please help me
.
I have a grid and button,which is inside a update panel.
My requirement is to update the grid on button click.
but when i click on button grid is not updating.
Is there anything I have to set in webpage.
Please help me
.
Mira
Telerik team
answered
on
25 Apr 2011
3 answers
101 views
Hello, i'm student , i'm learning web programing
i saw transparent background of telerik demo , but i don't know do this
http://demos.telerik.com/aspnet-ajax/combobox/examples/default/defaultcs.aspx
what's should i do ?
THANK
i saw transparent background of telerik demo , but i don't know do this
http://demos.telerik.com/aspnet-ajax/combobox/examples/default/defaultcs.aspx
what's should i do ?
THANK
Kate
Telerik team
answered
on
25 Apr 2011
1 answer
1.2K+ views
Hello Team,
I am using Radajax manager,in the OnAjaxRequest event , i am writing server side method that fetches the records from the database. What happens is, Some times the ajax request gets time out and completed before the methods gets processed [ I mean fetch all the records from the backend and complete the necessary things].
How could i accomplish it by increasing the ajax request timeout.
here with i have attachedthe code for your reference. That will gives you some idea what i am talking.
ClientSide
<script type="text/javascript" language="javascript">
<!--
var gstrPrimaryColor = '#ff6600';
var gstrSecondaryColor = '#ffdba6';
window.onload = function()
{
// setTimeout (function(){
var ctrl = window["<%= rdAMErroredRecords.ClientID %>"];
ctrl.ajaxRequest("InitialPageLoad");
// },
// 50000);
}
function responseEnd(sender, eventArgs) {
// var vartemp=document.getElementById('<%= hdnServiceRequestEnd.ClientID %>').value;
// if(vartemp!=0)
MakeTableChanges('ErrorRecords');
// MakeTableChanges('CXErrorRecords');
}
function MakeTableChanges(tableName){
var rows = document.getElementById(tableName).getElementsByTagName('tr');
var n = rows.length;
for(var i=2; i<n; ++i){
var cells = rows[i].getElementsByTagName('td');
var tmp = cells[1].innerText;
var index = tmp.indexOf('|');
if(index == 0){
tmp = tmp.substring(1);
tmp = '- ' + tmp;
}
cells[1].className = 'cssField ErroredCol';
cells[1].innerText = tmp.replace(/[|]/gi,'\n -');
}
}
-->
</script>
</telerik:RadCodeBlock>
<telerik:RadScriptManager ID="rdSMErroredRecords" runat="server" EnablePageMethods="true" >
</telerik:RadScriptManager>
<telerik:RadAjaxManager ID="rdAMErroredRecords" runat="server" OnAjaxRequest="rdAMErroredRecords_AjaxRequest"
ClientEvents-OnResponseEnd="responseEnd" >
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="rdAMErroredRecords">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="pnlErrorRecords" LoadingPanelID="lpnlErrorRecords" />
<telerik:AjaxUpdatedControl ControlID="rdgErroredRecords" LoadingPanelID="lpnlErrorRecords" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
server Side Code:
protected void rdAMErroredRecords_AjaxRequest(object sender, Telerik.Web.UI.AjaxRequestEventArgs e)
{
if (e.Argument == "InitialPageLoad")
GenerateHTMLReportForErroredRecords();
}
Please help me on this.
Thanks and Regards!
chithuraj.j
I am using Radajax manager,in the OnAjaxRequest event , i am writing server side method that fetches the records from the database. What happens is, Some times the ajax request gets time out and completed before the methods gets processed [ I mean fetch all the records from the backend and complete the necessary things].
How could i accomplish it by increasing the ajax request timeout.
here with i have attachedthe code for your reference. That will gives you some idea what i am talking.
ClientSide
<script type="text/javascript" language="javascript">
<!--
var gstrPrimaryColor = '#ff6600';
var gstrSecondaryColor = '#ffdba6';
window.onload = function()
{
// setTimeout (function(){
var ctrl = window["<%= rdAMErroredRecords.ClientID %>"];
ctrl.ajaxRequest("InitialPageLoad");
// },
// 50000);
}
function responseEnd(sender, eventArgs) {
// var vartemp=document.getElementById('<%= hdnServiceRequestEnd.ClientID %>').value;
// if(vartemp!=0)
MakeTableChanges('ErrorRecords');
// MakeTableChanges('CXErrorRecords');
}
function MakeTableChanges(tableName){
var rows = document.getElementById(tableName).getElementsByTagName('tr');
var n = rows.length;
for(var i=2; i<n; ++i){
var cells = rows[i].getElementsByTagName('td');
var tmp = cells[1].innerText;
var index = tmp.indexOf('|');
if(index == 0){
tmp = tmp.substring(1);
tmp = '- ' + tmp;
}
cells[1].className = 'cssField ErroredCol';
cells[1].innerText = tmp.replace(/[|]/gi,'\n -');
}
}
-->
</script>
</telerik:RadCodeBlock>
<telerik:RadScriptManager ID="rdSMErroredRecords" runat="server" EnablePageMethods="true" >
</telerik:RadScriptManager>
<telerik:RadAjaxManager ID="rdAMErroredRecords" runat="server" OnAjaxRequest="rdAMErroredRecords_AjaxRequest"
ClientEvents-OnResponseEnd="responseEnd" >
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="rdAMErroredRecords">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="pnlErrorRecords" LoadingPanelID="lpnlErrorRecords" />
<telerik:AjaxUpdatedControl ControlID="rdgErroredRecords" LoadingPanelID="lpnlErrorRecords" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
server Side Code:
protected void rdAMErroredRecords_AjaxRequest(object sender, Telerik.Web.UI.AjaxRequestEventArgs e)
{
if (e.Argument == "InitialPageLoad")
GenerateHTMLReportForErroredRecords();
}
Please help me on this.
Thanks and Regards!
chithuraj.j
Mira
Telerik team
answered
on
25 Apr 2011
3 answers
112 views
Hi,
I am using RadGrid,it contains following add,update,delete and multiselect operations,Total no of Columns in my grid is 20.
But am using inline edit ,and i have given MasterTableView width 150%. In edit mode all the controls are coming properly.But while adding, i have mentioned InsertItemDisplay at Bottom.For 20 columns controls are getting overlapped.How to use the mastertableview scroll bar for InsertItemDisplay.
Is it Possible to provide scroll bar for Insert Item display also.
I am using 2008 Q2 release.
Or Is there any Solution in Latest 2011 Q1 Release.
Please Help Me.
Thanks.
Pavlina
Telerik team
answered
on
25 Apr 2011
