Lütfen bilgilerinizi girin
E-Posta Adresi ya da Takma Ad
Parola
Parolamı Unuttum
Beni Hatırla
ANASAYFA
SORU SOR
SORULAR
UZMANLAR
‹
Sorduğum Sorular
›
‹
Takip Ettiğim Sorular
›
‹
Verdiğim Cevaplar
›
‹
Arşivimdeki Sorular
›
‹
İlgilendiğim Alanlardaki Sorular
›
sonergonul
Profili
|
Mesaj At
|
Takip Et
Tweet
Kategoriler
.NET
C#
İstatistikler
Soru Kapalı
12 yıl önce
yazılmış
12 yıl önce
güncellenmiş
6 üye
izlemiş
Gridview Freeze Pane Ekleme
Bu soru iptal edilmiştir...
Selamlar
Şu şekilde kodlanmış bir Gridview kontrolüm var.
<dil><asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" DataKeyNames ="HESAP_NO,DOVIZ_KOD"
Font-Names="Verdana" Font-Size="Small" AllowSorting="True"
onrowdatabound="GridView1_RowDataBound"
onrowupdating="GridView1_RowUpdating" onrowcommand="GridView1_RowCommand"
PageSize="2" BackColor="White" BorderColor="#999999" BorderStyle="Solid"
BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical" >
<Columns>
<asp:ButtonField ButtonType="Image" ImageUrl="~/images/InsertButton.gif"
CommandName="Insert" />
<asp:ButtonField ButtonType="Image" ImageUrl="~/images/SelectButton.gif"
CommandName="Select" />
<asp:CommandField ShowEditButton="True" ButtonType="Image"
EditImageUrl="~/images/EditButton.gif" cancelimageurl="~/images/CancelButton.gif"
updateimageurl="~/images/UpdateButton.gif" ItemStyle-Wrap="False" >
<ItemStyle Wrap="False"></ItemStyle>
</asp:CommandField>
<asp:TemplateField HeaderText="HESAP" SortExpression="HESAP_NO">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("HESAP_NO") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="MÜŞTERİ" SortExpression="MUS_K_ISIM">
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("MUS_K_ISIM") %>'></asp:Label>
<asp:SqlDataSource ID="SqlDataSource4" runat="server"
ConnectionString="<%$ ConnectionStrings:SqlServerCstr %>"
InsertCommand="INSERT INTO MEMO
VALUES(@M_HESAP_NO, @S_TARIH, @S_TUTAR, @DOV_KOD, @G_NOT, @G_KISI, 4,
@login, GETDATE())"
SelectCommand="SELECT * FROM MEMO A, P_SONUC B, P_KUR C
WHERE A.S_SONUC = B.SONUC_KOD
AND A.S_KUR = C.DOV_KOD
AND B.LANG = 1
AND ([M_HESAP_NO] = @M_HESAP_NO)"
UpdateCommand="UPDATE MEMO
SET S_SONUC = @SONUC_KOD
WHERE NOT_ID = @NOT_ID"
>
<SelectParameters>
<asp:QueryStringParameter Name="M_HESAP_NO" QueryStringField="T_HESAP_NO"
Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:ControlParameter Name="M_HESAP_NO" ControlID="Label1" PropertyName="Text" />
<asp:Parameter Name="S_TARIH" Type="DateTime"/>
<asp:Parameter Name="S_TUTAR" />
<asp:Parameter Name="DOV_KOD" />
<asp:Parameter Name="G_NOT" />
<asp:Parameter Name="G_KISI" />
<asp:SessionParameter Name="login" SessionField="login" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="NOT_ID" />
<asp:Parameter Name="SONUC_KOD" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="ChildGridView1" runat="server" DataKeyNames="NOT_ID" Visible="False"
DataSourceID="SqlDataSource4" AutoGenerateColumns="False" >
<Columns>
<asp:CommandField ShowEditButton="True"/>
<asp:TemplateField HeaderText="Not No">
<ItemTemplate>
<asp:Label ID="LabelNotID" runat="server" Text='<%# Eval("NOT_ID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Görüşülen">
<ItemTemplate>
<asp:Label ID="LabelGorKisi" runat="server" Text='<%# Eval("G_KISI") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Görüşen">
<ItemTemplate>
<asp:Label ID="LabelGrKisi" runat="server" Text='<%# Eval("OPERATOR") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Söz. Tarih">
<ItemTemplate>
<asp:Label ID="LabelSozTarih" runat="server" Text='<%# Eval("S_TARIH","{0:d}") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Söz. Tutar">
<ItemTemplate>
<asp:Label ID="LabelSozTutar" runat="server" Text='<%# Eval("S_TUTAR","{0:n2}") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Kur">
<ItemTemplate>
<asp:Label ID="LabelKur" runat="server" Text='<%# Eval("DOV_CINS") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Gör. Tarih">
<ItemTemplate>
<asp:Label ID="LabelGorTarih" runat="server" Text='<%# Eval("A_TARIH","{0:dd/MM/yyyy HH:mm}") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Söz Durum">
<ItemTemplate>
<asp:Label ID="LabelSozDurum" runat="server" Text='<%# Eval("SONUC_ACK") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:SqlDataSource ID="SqlDataSource7" runat="server"
ConnectionString="<%$ ConnectionStrings:SqlServerCstr %>"
SelectCommand="SELECT SONUC_KOD, SONUC_ACK FROM P_SONUC WHERE (SONUC_KOD > 3 AND LANG = 1) OR (SONUC_KOD < 0 AND LANG = 1)" >
</asp:SqlDataSource>
<asp:DropDownList id="lstSONUC" runat="server" AppendDataBoundItems="false"
DataSourceID="SqlDataSource7"
DataTextField="SONUC_ACK" DataValueField="SONUC_KOD"
SelectedValue='<%# BIND("SONUC_KOD") %>'>
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Not">
<ItemTemplate>
<asp:TextBox ID="TxtNot" runat="server" Text='<%# Eval("G_NOT") %>' Height="35" TextMode="MultiLine" ReadOnly="True">
</asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:DetailsView id="MemoDetailView" DataSourceID="SqlDataSource4"
Runat="Server" AutoGenerateRows="False" Visible="False" OnModeChanged="MemoDetailView_ModeChanged">
<Fields>
<asp:TemplateField HeaderText = "Görüşülen">
+0
-0