Write a review of any Telerik product at devtoolcafe and automatically be entered into our monthly cash draw. First Prize $500!
Simply visit www.devtoolcafe.com/company/telerik and select the product of your choice
Good Luck!
Fiona Blake
Sales & Marketing Director
devtoolcafe, the developer tool and software component marketplace community
Follow us on Twitter Connect with us at LinkedIn Like us on Facebook
Hi,
I've a requirement of exporting data from a set of datatables present in a dataset to excel in winforms App. All I could find in Telerik online documentations is RadGridView to Excel Export.
Please let me know if datatables in a dataset can be exported using telerik's spreadsheet dlls
Thanks & Regards
Braj
This should be easy but I'm obviously missing something. I have a RadGrid on my web page. It loads correctly from my database. I also have an Edit icon on the RadGrid. I display an email address when clicked. This works as well. My email address displays and I can change the value and then update my database. My question is how to change the width of the email address? Not sure how to do this. It seems to be a textbox control but not certain. Any help would be appreciated. Thanks in advance!
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="frmViewUnitMaster.aspx.vb" Inherits="iTourism.WebForm1" %><%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server" > <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <div> <table style="width:100%;"> <tr> <td> </td> <td> <asp:Button ID="btnAdd" runat="server" Text="Add" Width="69px" /> <asp:Label ID="lblMessage" runat="server" Text="Label"></asp:Label> </td> <td> </td> </tr> <tr> <td> </td> <td> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="UMGrid"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="UMGrid" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadGrid ID="UMGrid" runat="server" AutoGenerateColumns="False" GridLines="None" AllowFilteringByColumn="True" AllowSorting="True" AutoGenerateEditColumn="True" AllowPaging="True" Width="60%" ViewStateMode="Enabled" CellPadding="10" CellSpacing="10" onupdatecommand="UMGrid_UpdateCommand" > <ClientSettings> <Selecting AllowRowSelect="True" /> <Scrolling AllowScroll="True" /> <Selecting AllowRowSelect="True"></Selecting> </ClientSettings><MasterTableView EditMode="EditForms" DataKeyNames="UnitCode"> <Columns> <telerik:GridBoundColumn DefaultInsertValue="" UniqueName="UnitCode" HeaderText="UnitCode" DataField="UnitCode" ReadOnly="True"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DefaultInsertValue="" UniqueName="UnitDesc" HeaderText ="Unit Description" DataField="Description" > </telerik:GridBoundColumn> </Columns> <EditFormSettings EditFormType="AutoGenerated" > </EditFormSettings></MasterTableView> </telerik:RadGrid> </td> <td> </td> </tr> </table> </div> </form></body></html>Imports SystemImports System.DataImports Telerik.Web.UIImports System.Data.SqlClientPublic Class WebForm1 Inherits System.Web.UI.Page Dim objclsUnitMaster As New clsUnitMaster Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load UMGrid.AutoGenerateDeleteColumn = True UMGrid.AutoGenerateEditColumn = True UMGrid.DataSource = (objclsUnitMaster.GetUnitCodeList).Tables("UnitMaster") UMGrid.DataBind() End Sub Protected Sub btnAdd_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAdd.Click Response.Redirect("frmUnitMaster.aspx") End Sub Private Sub UMGrid_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles UMGrid.ItemCommand If (e.CommandName = RadGrid.UpdateCommandName) Then
Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem) Dim newValues As New Hashtable e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem) 'not getting the updated value lblMessage.Text = newValues("Description").ToString End If
End Sub Private Sub UMGrid_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles UMGrid.NeedDataSource UMGrid.DataSource = (objclsUnitMaster.GetUnitCodeList).Tables("UnitMaster") UMGrid.DataBind() End Sub Public Sub UMGrid_UpdateCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles UMGrid.UpdateCommand ' Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem) 'Dim MyUserControl As UserControl = CType(e.Item.FindControl(GridEditFormItem.EditFormUserControlID), UserControl) Dim _UnitCode As Integer = 0 Dim _Description As String = "" Dim _Result As Long = 0 Dim _item As GridEditableItem _item = e.Item Try _UnitCode = Convert.ToInt32(DirectCast(_item("UnitCode").Controls(0), TextBox).Text)
'Unable to Get Updated Value using this also _Description = DirectCast(_item("Description").Controls(0), TextBox).Text _Result = objclsUnitMaster.UpdateUnitByCode(_UnitCode, _Description) If _Result = 0 Then lblMessage.Text = "Record Saved Successfully" Else lblMessage.Text = "Error While Saving Record" & " - " & _Result End If 'UMGrid.Rebind() Catch ex As Exception lblMessage.Text = ex.Message End Try End SubEnd Class