Sep 08, 2011, 12:32 AM
can't select a row from datagrid and display it to textbox with sqldatasource connection
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
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.csusing 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();
}
Last edited by dx7; Sep 08, 2011 at 4:30 AM.