This is a migrated thread and some comments may be shown as answers.

bind to griddropdowncolumn

3 Answers 85 Views
Grid
This is a migrated thread and some comments may be shown as answers.
dingen
Top achievements
Rank 1
dingen asked on 15 Dec 2009, 06:16 AM
Hi

Is there an example of how to bind to a griddropdowncolumn from behind the code? Also in this case what is the best way to use this in een inline editing mode in a RadGrid?

thanks

D

3 Answers, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 1
answered on 15 Dec 2009, 06:53 AM
Hello,

Checkout the following help documentation on customizing/configuring GridDropDownColumn.
Customize/Configure GridDropDownColumn

-Shinu.
0
dingen
Top achievements
Rank 1
answered on 15 Dec 2009, 12:41 PM
Hi

Next question is: how can i update courtesy value in the row after editing and selecting a new value for Title of courtesy in the editmode? Code + aspx page attached:

regards
D

Imports System 
Imports System.Configuration 
Imports System.Data 
Imports System.Data.Common 
Imports System.Data.SqlClient 
Imports System.Globalization 
Imports System.Web.SessionState 
Imports System.Web.UI 
Imports System.Web.UI.WebControls 
Imports Telerik.Web.UI 
 
Partial Public Class Dropdown 
    Inherits System.Web.UI.Page 
 
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 
        RadGrid1.DataSource = EmployeesData 
    End Sub 
 
 
    Private Sub Page_PreRender(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.PreRender 
        If Not MyBase.IsPostBack Then 
            Me.RadGrid1.MasterTableView.Items(0).Edit = True 
            Me.RadGrid1.MasterTableView.Rebind() 
        End If 
    End Sub 
 
 
    Private Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource 
        RadGrid1.DataSource = EmployeesData() 
        Me.EmployeesData.Tables("Employees").PrimaryKey = New DataColumn() {Me.EmployeesData.Tables("Employees").Columns("EmployeeID")} 
 
    End Sub 
 
 
 
    Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound 
        If (TypeOf e.Item Is GridEditableItem AndAlso CType(e.Item, GridEditableItem).IsInEditMode) Then 
            Dim editeditem As GridEditableItem = CType(e.Item, GridEditableItem) 
            Dim editman As GridEditManager = editeditem.EditManager 
 
            Dim editor As GridDropDownColumnEditor = CType(editman.GetColumnEditor("CourtesyCombo"), GridDropDownColumnEditor) 
 
 
            Dim alCourtesy = New ArrayList() 
 
            Dim mr As New courtesy() 
            mr.TitleOfCourtesy = "mister" 
            Dim mrs As New courtesy() 
            mrs.TitleOfCourtesy = "missus" 
 
            alCourtesy.Add(mr) 
            alCourtesy.Add(mrs) 
            editor.DataSource = alCourtesy 
             
            editor.DataBind() 
 
        End If 
 
    End Sub 
 
    Public Shared Property EmployeesData() As DataSet 
        Get 
 
 
            Dim MyEmployeesData As DataSet = New DataSet 
 
            Dim ConnString As String = ConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString 
            Dim conn As SqlConnection = New SqlConnection(ConnString) 
            Dim adapter As SqlDataAdapter = New SqlDataAdapter 
            adapter.SelectCommand = New SqlCommand("SELECT EmployeeID, FirstName, LastName, TitleOfCourtesy, HireDate FROM Employees", conn) 
 
            adapter.Fill(MyEmployeesData, "Employees") 
 
 
            Return MyEmployeesData 
        End Get 
 
        Set(ByVal value As DataSet) 
 
        End Set 
    End Property 
 
End Class 
 
Public Class courtesy 
    Dim _TitleOfCourtesy As String 
    Property TitleOfCourtesy() As String 
        Get 
            Return _TitleOfCourtesy 
        End Get 
        Set(ByVal value As String) 
            _TitleOfCourtesy = value 
        End Set 
    End Property 
 
End Class 
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Dropdown.aspx.vb" Inherits="TelerikProbeer.Dropdown" %> 
<%@ 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"
    <div> 
        <telerik:RadScriptManager ID="RadScriptManager1" runat="server"
        </telerik:RadScriptManager> 
        <telerik:RadGrid ID="RadGrid1" runat="server" Width="96%" GridLines="None" AutoGenerateColumns="False" 
            PageSize="13" AllowSorting="True" AllowPaging="True" ShowStatusBar="true"
            <MasterTableView DataKeyNames="EmployeeID" AllowMultiColumnSorting="True" Width="100%" 
                CommandItemDisplay="Top"
                <Columns> 
                    <telerik:GridButtonColumn UniqueName="DeleteColumn" Text="Delete" CommandName="Delete" /> 
                    <telerik:GridBoundColumn UniqueName="FirstName" SortExpression="FirstName" HeaderText="First name" 
                        DataField="FirstName" /> 
                    <telerik:GridBoundColumn UniqueName="LastName" SortExpression="LastName" HeaderText="Last name" 
                        DataField="LastName" /> 
                         
                    <telerik:GridDropDownColumn UniqueName="CourtesyCombo" ListDataMember="Employees" 
                        SortExpression="TitleOfCourtesy" ListTextField="TitleOfCourtesy" ListValueField="TitleOfCourtesy" 
                        DataField="TitleOfCourtesy" HeaderText="Title of courtesy"
                    </telerik:GridDropDownColumn> 
       
                    <telerik:GridBoundColumn UniqueName="HireDate" SortExpression="HireDate" HeaderText="Hire date" 
                        DataField="HireDate" DataFormatString="{0:d}" /> 
                    <telerik:GridEditCommandColumn UpdateText="Update" UniqueName="EditCommandColumn" 
                        CancelText="Cancel" EditText="Edit"
                        <HeaderStyle Width="85px"></HeaderStyle> 
                    </telerik:GridEditCommandColumn> 
                </Columns> 
                <EditFormSettings CaptionFormatString="Edit details for employee with ID {0}" CaptionDataField="EmployeeID"
                    <FormTableItemStyle Width="100%" Height="29px"></FormTableItemStyle> 
                    <FormTableStyle GridLines="None" CellSpacing="0" CellPadding="2"></FormTableStyle> 
                    <FormStyle Width="100%" BackColor="#eef2ea"></FormStyle> 
                    <EditColumn ButtonType="ImageButton" /> 
                </EditFormSettings> 
            </MasterTableView> 
        </telerik:RadGrid> 
    </div> 
    </form> 
</body> 
</html> 
 

0
Princy
Top achievements
Rank 1
answered on 15 Dec 2009, 01:50 PM
Hello,

You can access the RadComboBox in the UpdateCommand, retrieve the combobox selected text and reflect changes in the database. Here's an example:
c#:
protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e) 
    { 
        GridEditableItem editItem = (GridEditableItem)e.Item; 
        RadComboBox combo = (RadComboBox)editItem["CourtestCombo"].Controls[0]; 
        string strtxt = combo.Text; 
        //pass the combo value to the update query. 
 
    }  

Thanks
Princy.
Tags
Grid
Asked by
dingen
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 1
dingen
Top achievements
Rank 1
Princy
Top achievements
Rank 1
Share this question
or