/ / / / / / / GridView Nesnesinde Satırdaki Verileri HyperLinke Tıklayarak DetailsView Nesnesinde Göstermek.

GridView Nesnesinde Satırdaki Verileri HyperLinke Tıklayarak DetailsView Nesnesinde Göstermek.

, , , , ,

 

Merhaba arkadaşlar bu makalemizde Sql veritabanımıza verileri GridView da göstereceğiz. GridView nesnesinin AutoGenerateColumns="False" yapıyoruz ve <Columns></Column> kısmına Hyperlink ekliyoruz. İlgili satırdaki bilgilerin detaylarını görmek istediğimizde o satırdaki Hyperlinke tıklayarak Detais.aspx sayfasındaki DetailsView da gösteriyoruz.   












Şekil 1



 

 

 

 

 

 

 

Şekil2

Default.aspx.cs

uusing System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

 

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

      

 

        if (!IsPostBack)

        {

            BindData();

        }

 

    }

    SqlConnection con;

    string constr;

    string sql;

    SqlCommand cmd;

    SqlDataAdapter da;

    DataSet ds;

    DataTable dt;

    protected void BindData()

    {

 

        {

            constr = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\kategori.mdf;Integrated Security=True";

            sql = "select * from [dbo].[Table]";

            con = new SqlConnection(constr);

            con.Open();

            cmd = new SqlCommand(sql, con);

            da = new SqlDataAdapter(cmd);

            ds = new DataSet();

            da.Fill(ds);

            con.Close();

           

           GridView1.DataSource = ds;

          GridView1.DataBind();

        }

    }

 

}

 

Default.aspx


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

 

<!DOCTYPE html>

 

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

        <div>

            <asp:GridView ID="GridView1" runat="server" Font-Names="Tahoma" Font-Size="Large" AutoGenerateColumns="False" BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4" GridLines="Horizontal">

                <Columns>

                    <asp:BoundField HeaderText="Id" DataField="Id" />

                    <asp:HyperLinkField

                        HeaderText="Yazar"

                        DataNavigateUrlFields="Id"

                        DataNavigateUrlFormatString="~/Details.aspx?Id={0}"

                        DataTextField="Yazar" />

                    <asp:BoundField HeaderText="Kitap" DataField="Kitap" />

                     <asp:BoundField HeaderText="Fiyat" DataField="Fiyat" />

                </Columns>

 

                <FooterStyle BackColor="White" ForeColor="#333333" />

                <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />

                <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />

                <RowStyle BackColor="White" ForeColor="#333333" />

                <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />

                <SortedAscendingCellStyle BackColor="#F7F7F7" />

                <SortedAscendingHeaderStyle BackColor="#487575" />

                <SortedDescendingCellStyle BackColor="#E5E5E5" />

                <SortedDescendingHeaderStyle BackColor="#275353" />

 

            </asp:GridView>

        </div>

    </form>

</body>

</html>

 

Details.aspx.cs

 

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

 

public partial class Details : System.Web.UI.Page

{

    SqlConnection con;

    string constr;

    string sql;

    SqlCommand cmd;

    SqlDataAdapter da;

    DataSet ds;

    int id;

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

 

            BindData();

        }

 

    }

 

    protected void BindData()

    {

 

        {

            id = Convert.ToInt32(Request.QueryString["Id"]);

            constr = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\kategori.mdf;Integrated Security=True";

            sql = "select * from [dbo].[Table]Where Id=" + id;

            con = new SqlConnection(constr);

            con.Open();

            cmd = new SqlCommand(sql, con);

            da = new SqlDataAdapter(cmd);

            ds = new DataSet();

            da.Fill(ds);

            con.Close();

 

            DetailsView1.DataSource = ds;

            DetailsView1.DataBind();

        }

    }

 

}

 

Details.aspx

 

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Details.aspx.cs" Inherits="Details" %>

 

<!DOCTYPE html>

 

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

        <div>

            <asp:DetailsView ID="DetailsView1" runat="server" CellPadding="4" Font-Names="Tahoma" Font-Size="Large" ForeColor="#333333" GridLines="None" Height="97px" Width="227px">

                <AlternatingRowStyle BackColor="White" ForeColor="#284775" />

                <CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />

                <EditRowStyle BackColor="#999999" />

                <FieldHeaderStyle BackColor="#E9ECF1" Font-Bold="True" />

                <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />

                <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />

                <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />

                <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />

            </asp:DetailsView>

        </div>

    </form>

</body>

</html>

 

Bir makalenin daha sonuna geldik. Bir sonraki makalede görüşmek üzere. Bahadır ŞAHİN

 








About Bahadır Şahin

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.

0 comments:

Yorum Gönder

Kaydol: Kayıt Yorumları ( Atom )

Öne Çıkan Yayın

GridView da Seçili Satırı DetailsView da Göstermek

Merhaba arkadaşlar bu makalemizde GridView nesnesi ile birlikte DetailsView nesanesini birlikte kullanacağız. GridView da seçili satırın de...