can't select a row from datagrid and display it to textbox with sqldatasource connection

[dx7]

hi
i want to bind data from datagrid to textbox with sqldatasource.
so when i select a row in datagrid and display it in to textbox (formpanel), i have try but doesn't work..
please give the solution..

tr.aspx

	
<%@ Page Title="Transaksi Peminjaman" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeBehind="Transaksi.aspx.cs" Inherits="crud.Transaksi" %>
<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:loanConnectionString %>" 
            SelectCommand="SELECT [id], [idCustomer], [idJnsPinjam], [tgl_kmbl], [tgl_pnjm], [sisa_pinjam], [jml_pinjam], [bungaPerAngsuran], [AngsuranKe], [total] FROM [Trpnjam]">
        </asp:SqlDataSource>

<ext:FormPanel runat="server" Title="Transaksi Peminjaman" Icon="UserEarth">
        <Content>
        <ext:TextField runat="server" FieldLabel="ID Peminjaman" ID="idpinjam" />
        <ext:ComboBox StoreID="Store2" DisplayField="nm_customer" Editable="false" ValueField="idCustomer" runat="server" FieldLabel="ID Customer" ID="idcustomer" Mode="Local" EmptyText="Pilih Customer" />
        <ext:ComboBox StoreID="Store3" DisplayField="jenispinjam" Editable="false" ValueField="idJnsPinjam" Mode="Local" runat="server" ID="jenispinjam" FieldLabel="Jenis Pinjaman" EmptyText="Pilih Jenis Pinjaman" />
        <ext:DateField ID="tglpinjam" FieldLabel="Tanggal Pinjam" runat="server" />
        <ext:DateField ID="tglkembali" FieldLabel="Tanggal Pengembalian" runat="server" />
        <ext:NumberField ID="jmlpinjam" FieldLabel="Jumlah Pinjaman" runat="server" />
        <ext:NumberField ID="sisapinjam" FieldLabel="Sisa Pinjaman" runat="server" />
        <ext:NumberField ID="bunga" FieldLabel="Bunga Pinjaman" runat="server" />
        <ext:NumberField ID="total" FieldLabel="Total" runat="server" />
        <ext:NumberField ID="angsuran" FieldLabel="Angsuran Ke" runat="server" />
        <ext:Label ID="labelbind" runat="server" />
        </Content>
        <BottomBar>
        <ext:Toolbar runat="server">
        <Items>
        <ext:Button runat="server" ID="save" Text="Save" Icon="Disk" OnClick="btnInsert_Click" AutoPostBack="true" />
        <ext:Button runat="server" ID="Button1" Text="Edit" Icon="UserEdit" AutoPostBack="true" />
        <ext:Button runat="server" ID="Button2" Text="Delete" Icon="Delete" AutoPostBack="true" />
        </Items>
        </ext:Toolbar>
        </BottomBar>
        </ext:FormPanel>
             
                        
        <ext:Panel ID="Panel1" runat="server" Title="Transaksi Peminjaman" Icon="UserEarth"  AutoHeight="true" AutoWidth="true">
    <Content>
    <ext:GridPanel ID="GridPanel1" runat="server" AutoWidth="true"  AutoHeight="true">
    <Store>
    <ext:Store runat="server" ID="str1" DataSourceID="SqlDataSource1">
    <Reader>
    <ext:JsonReader IDProperty="id">
    <Fields>
    <ext:RecordField Name="id" />
    <ext:RecordField Name="idCustomer" />
    <ext:RecordField Name="idJnsPinjam" />
    <ext:RecordField Name="tgl_pnjm" />
    <ext:RecordField Name="tgl_kmbl" />
    <ext:RecordField Name="jml_pinjam" />
    <ext:RecordField Name="sisa_pinjam" />
    <ext:RecordField Name="bungaPerAngsuran" />
    <ext:RecordField Name="total" />
    <ext:RecordField Name="AngsuranKe" />
    </Fields>
    </ext:JsonReader>
    </Reader>
    </ext:Store>
    </Store>
    <ColumnModel ID="ColumnModel1" runat="server">
    <Columns>
    <ext:Column ColumnID="id" Header="ID TPeminjam" Width="100" DataIndex="id" />
    <ext:Column ColumnID="idcustomer" Header="ID Customer" Width="100" DataIndex="idCustomer" />
    <ext:Column ColumnID="idJnsPinjam" Header="ID JenisPinjaman" Width="150" DataIndex="idJnsPinjam" />
    <ext:DateColumn ColumnID="tgl_pnjm" Header="Tgl Pinjam" Format="dd-MMMM-yyyy" DataIndex="tgl_pnjm" />
    <ext:DateColumn ColumnID="tgl_kmbl" Header="Tgl Kembali" Format="dd-MMMM-yyyy" DataIndex="tgl_kmbl" />
    <ext:Column ColumnID="jml_pinjam" Header="Jumlah Pinjam" Width="150" DataIndex="jml_pinjam" />
    <ext:Column ColumnID="sisa_pinjam" Header="Sisa pinjam" Width="150" DataIndex="sisa_pinjam" />
    <ext:Column ColumnID="bungaPerAngsuran" Header="Bunga" Width="150" DataIndex="bungaPerAngsuran" />
    <ext:Column ColumnID="total" Header="Total" Width="80" DataIndex="total" />
    <ext:Column ColumnID="AngsuranKe" header="Angsuran Ke" Width="150" DataIndex="Angsuranke" />
    </Columns>
    </ColumnModel>
    <View>
    <ext:GridView ID="GridView1" runat="server" EnableRowBody="true">
    <HeaderRows>
    <ext:HeaderRow>
    <Columns>
    <ext:HeaderColumn Cls="x-small-editor">
    <Component>
    </Component>
    </ext:HeaderColumn>
    <ext:HeaderColumn>
    <Component>
        <ext:Label ID="Label1" Text="Filter by Jns Pinjam" runat="server" />
    </Component>
    </ext:HeaderColumn>
    <ext:HeaderColumn Cls="x-small-editor">
    <Component>
    <ext:TextField ID="TextField1" runat="server" />
    </Component>
    </ext:HeaderColumn>
    </Columns>
    </ext:HeaderRow>
    </HeaderRows>
    </ext:GridView>    
    </View>
    <SelectionModel>
    <ext:RowSelectionModel ID="RowSelectionModel1" runat="server" SingleSelect="true" >
    <Listeners>
    <RowSelect Handler="#{FormPanel1}.getForm().loadRecord(record);" />
    </Listeners>
    </ext:RowSelectionModel>
    </SelectionModel>
    <BottomBar>
    <ext:PagingToolbar ID="PagingToolbar1" runat="server" PageSize="10" StoreID="str1"></ext:PagingToolbar>
    </BottomBar>
    </ext:GridPanel>
    <ext:Button runat="server">
                    <DirectEvents>
                    <Click OnEvent="Button1_Click" />
                </DirectEvents>
    </ext:Button>
    </Content>
    </ext:Panel>

tr.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

protected void Page_Load(object sender, EventArgs e)
        {           
            str1.DataBind();
        }

[Vladimir]

Do not use Content, pleause Items for FormPanel

[Vladimir]

Also you have to specify DataIndex for each field are matched RecordField name

[dx7]

Do not use Content, pleause Items for FormPanel

Also you have to specify DataIndex for each field are matched RecordField name

hi vladimir, Thank you for your solution :)