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
System
Imports
System.Data
Imports
Telerik.Web.UI
Imports
System.Data.SqlClient
Public
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
Sub
End
Class