[Dnsmail-cvs] projeler/grafik-io DataGrid.aspx,NONE,1.1 DataGridButtonColumn.aspx,NONE,1.1 DataGridE

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/dnsmail/projeler/grafik-io
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12766/grafik-io

Added Files:
	DataGrid.aspx DataGridButtonColumn.aspx 
	DataGridEditProducts.aspx DataGridHyperLink.aspx 
	DataGridSortExpression.aspx DataListEditsql.aspx 
	DataListEvents.aspx DataListSelected.aspx DataListStyles.aspx 
	Default.aspx.cs Default2.aspx Default2.aspx.cs Default3.aspx 
	Default3.aspx.cs Telefonrehberi.ldb Telefonrehberi.mdb 
	Web.Config datagridsiralama.aspx datagridsiralama.aspx.cs 
	default.aspx musteriler.mdb repeater.aspx repeater.aspx.cs 
	repeater2.aspx repeater2.aspx.cs 
Log Message:
Projenin ilk dosyalari

--- NEW FILE: Default3.aspx ---
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>

<!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>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:DataList ID="DataList1" runat="server" DataKeyField="Id" DataSourceID="SqlDataSource1">
            <ItemTemplate>
                Id:
                <asp:Label ID="IdLabel" runat="server" Text='<%# Eval("Id") %>'></asp:Label><br />
                Ad:
                <asp:Label ID="AdLabel" runat="server" Text='<%# Eval("Ad") %>'></asp:Label><br />
                Soyad:
                <asp:Label ID="SoyadLabel" runat="server" Text='<%# Eval("Soyad") %>'></asp:Label><br />
                Telefon:
                <asp:Label ID="TelefonLabel" runat="server" Text='<%# Eval("Telefon") %>'></asp:Label><br />
                Adres:
                <asp:Label ID="AdresLabel" runat="server" Text='<%# Eval("Adres") %>'></asp:Label><br />
                Sehir:
                <asp:Label ID="SehirLabel" runat="server" Text='<%# Eval("Sehir") %>'></asp:Label><br />
                Email:
                <asp:Label ID="EmailLabel" runat="server" Text='<%# Eval("Email") %>'></asp:Label><br />
                <br />
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="TextBox2" runat="server" Text='<%# Eval("Ad") %>'></asp:TextBox>
                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("Id") %>'></asp:TextBox>
                <asp:Button ID="Button1" runat="server" Text="Button" />
            </EditItemTemplate>
        </asp:DataList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TelefonrehberiConnectionString3 %>"
            ProviderName="<%$ ConnectionStrings:TelefonrehberiConnectionString3.ProviderName %>"
            SelectCommand="SELECT [Id], [Ad], [Soyad], [Telefon], [Adres], [Sehir], [Email] FROM [rehber]"
            UpdateCommand="UPDATE rehber SET Ad = @Ad, Soyad = @Soyad WHERE Id=@Id">
            <UpdateParameters>
                <asp:ControlParameter ControlID="DataList1" Name="newparameter" PropertyName="SelectedValue" />
            </UpdateParameters>
        </asp:SqlDataSource>
    
    </div>
    </form>
</body>
</html>

--- NEW FILE: Default.aspx.cs ---
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        OleDbConnection baglanti;
        OleDbCommand sorgu;
        baglanti = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/inetpub/wwwroot/ethem/telefonrehberi.mdb");
        baglanti.Open();
        sorgu = new OleDbCommand("select* from rehber", baglanti);
        OleDbDataReader veri=sorgu.ExecuteReader();
        DataList1.DataSource = veri;
        DataList1.DataBind();
        baglanti.Close();


    }
}

--- NEW FILE: repeater2.aspx ---
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="repeater2.aspx.cs" Inherits="repeater2" %>

<!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>Untitled Page</title>
</head>
<body>
    <asp:Label ID="Label1" runat="server"></asp:Label>
    <form id="form1" runat="server">
    <div>
    <table>
        <asp:Repeater OnItemCreated="item_olusturma" ID="Repeater1" runat="server">
        
             <HeaderTemplate>
        <tr>
        <th>Ad</th>
        <th>Soyad</th>
        </tr>
        </HeaderTemplate>
        <ItemTemplate>
        <tr>
        <td><%#DataBinder.Eval(Container.DataItem, "Ad" )%></td>
        <td><%#DataBinder.Eval(Container.DataItem, "Soyad" )%></td>
        </tr>
        </ItemTemplate>
        </asp:Repeater>
        </table>
    
  
    </div>
    </form>
</body>
</html>

--- NEW FILE: DataGridSortExpression.aspx ---
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Data" %>
<script runat=server>

void Page_Load(Object sender , EventArgs e) 
{
	if (! IsPostBack ) {
		BindDataGrid( "Ad" );
	}
}

void BindDataGrid( string  sirala ) {

    OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/inetpub/wwwroot/ethem/telefonrehberi.mdb");
    baglanti.Open();
    OleDbDataAdapter sorgu = new OleDbDataAdapter("SELECT * FROM rehber Order By "+sirala, baglanti);
    DataSet d =new DataSet();
    sorgu.Fill(d,"rehber");
    dgrdTitles.DataSource = d;
   dgrdTitles.DataBind();
    baglanti.Close();
  }

void dgrdTitles_SortCommand( object s, DataGridSortCommandEventArgs e ) {
	BindDataGrid( e.SortExpression );
    
}

</Script>

<html>
<head><title>DataGridSortExpression.aspx</title></head>
<body>
<form Runat="Server">

<asp:DataGrid
  ID="dgrdTitles"
  AllowSorting="True"
  OnSortCommand="dgrdTitles_SortCommand"
  AutoGenerateColumns="True"
  CellPadding="10"
  Runat="Server">

</asp:DataGrid>

</form>
</body>
</html>

--- NEW FILE: musteriler.mdb ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: default.aspx ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: DataListEditsql.aspx ---
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<script runat=server>

void Page_Load(Object sender , EventArgs e) 
{
	if (! IsPostBack ) {
		BindDataList();
	}
}
void BindDataList() {
    SqlConnection baglanti;
    SqlCommand sorgu;
    baglanti = new SqlConnection("SERVER=localhost;DATABASE=Egitim;UID=bote;PWD=gizli");
    baglanti.Open();
    sorgu = new SqlCommand("select* from ogrenci", baglanti);
   SqlDataReader veri;
    veri = sorgu.ExecuteReader();
    DataList1.DataSource = veri;
    DataList1.DataBind();
    baglanti.Close();
}

void dlstAuthors_EditCommand( object s, DataListCommandEventArgs e ) {
	DataList1.EditItemIndex = e.Item.ItemIndex;
	BindDataList();
}

void dlstAuthors_CancelCommand( object s, DataListCommandEventArgs e ) {
    DataList1.EditItemIndex = -1;
	BindDataList();
}

void dlstAuthors_DeleteCommand( object s, DataListCommandEventArgs e ) {
   SqlConnection baglanti;
  SqlCommand silerr;
    Label iddd = ((Label)e.Item.FindControl("idnumarasi"));
    baglanti = new SqlConnection("SERVER=localhost;DATABASE=Egitim;UID=bote;PWD=gizli");
    baglanti.Open();
    silerr = new SqlCommand("delete from ogrenci Where oid=" + iddd.Text + "", baglanti);

    silerr.ExecuteNonQuery();
	baglanti.Close();
	DataList1.EditItemIndex = -1;
	BindDataList();
    }

void dlstAuthors_UpdateCommand( object s, DataListCommandEventArgs e ) {
    SqlConnection baglanti;
    SqlCommand guncelle;
    Label iddd = ((Label)e.Item.FindControl("idnumarasi"));
   TextBox yeniad = ((TextBox)e.Item.FindControl("add"));
    TextBox yenisoyad = ((TextBox)e.Item.FindControl("soyadd"));
    baglanti = new SqlConnection("SERVER=localhost;DATABASE=Egitim;UID=bote;PWD=gizli");
    baglanti.Open();
    guncelle = new SqlCommand("UPDATE ogrenci SET oad='"+yeniad.Text+"', osoyadi='"+yenisoyad.Text+"' Where oid=" + iddd.Text + "", baglanti);
    guncelle.ExecuteNonQuery();
    baglanti.Close();
    DataList1.EditItemIndex = -1;
    BindDataList();
}

    protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
</Script>

<html>
<head><title>DataListEdit.aspx</title></head>
<body>
<form Runat="Server">

<asp:DataList
  ID="DataList1"
  DataKeyField="oid"
  OnEditCommand="dlstAuthors_EditCommand"
  OnCancelCommand="dlstAuthors_CancelCommand"
  OnDeleteCommand="dlstAuthors_DeleteCommand"
  OnUpdateCommand="dlstAuthors_UpdateCommand"
  RepeatColumns="4"
  GridLines="Both"
  CellPadding="10"
  EditItemStyle-BackColor="lightgrey"
  Runat="Server" OnSelectedIndexChanged="DataList1_SelectedIndexChanged">

<ItemTemplate>
  <%#DataBinder.Eval(Container.DataItem, "oad" )%>
  - <%#DataBinder.Eval(Container.DataItem, "osoyadi" )%>
  <br>
  <asp:LinkButton
    Text="Duzenle!"
    CommandName="edit"
    Runat="Server" />
</ItemTemplate>

<EditItemTemplate>
<b>Id:</b>
  <br>
  <asp:Label
    ID="idnumarasi"
    Text='<%#DataBinder.Eval(Container.DataItem, "oid" )%>'
    Runat="Server" />
  <p>
  <b>Ad:</b>
  <br>
  <asp:TextBox
    ID="add"
    Text='<%#DataBinder.Eval(Container.DataItem, "oad" )%>'
    Runat="Server" />
  <p>
  <b>Soyad</b>
  <br>
  <asp:TextBox
    ID="soyadd"
    Text='<%#DataBinder.Eval(Container.DataItem, "osoyadi" )%>'
    Runat="Server" />
  <p>
  <asp:LinkButton
  Id="guncellle"
    Text="Guncelle!"
    CommandName="update"
    Runat="Server" />
  <asp:LinkButton
    Text="Sil!"
    CommandName="delete"
    Runat="Server" />
  <asp:LinkButton
    Text="Iptal!"
    CommandName="cancel"
    Runat="Server" />

</EditItemTemplate>

</asp:DataList>

</form>
</body>
</html>

--- NEW FILE: DataGridButtonColumn.aspx ---
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat=server>
void Page_Load(Object sender , EventArgs e) 
{
	if (! IsPostBack ) {
        OleDbConnection baglanti;
        OleDbCommand sorgu;

        baglanti = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/inetpub/wwwroot/ethem/telefonrehberi.mdb");
        baglanti.Open();

        sorgu = new OleDbCommand("SELECT * FROM rehber", baglanti);
        OleDbDataReader veri;
        veri = sorgu.ExecuteReader();
        datagrid.DataSource = veri;
        datagrid.DataBind();
        baglanti.Close();
	}
}

void dgrdTitles_ItemCommand( object s, DataGridCommandEventArgs e ) {
	if ( e.CommandName == "select" ) {
		e.Item.BackColor = System.Drawing.Color.LightGreen;
		e.Item.Font.Bold = true;
	} else {
		e.Item.BackColor = System.Drawing.Color.White;
		e.Item.Font.Bold = false;
	}
}

</Script>

<html>
<head><title>DataGridButtonColumn.aspx</title></head>
<body>
<form Runat="Server">

<asp:DataGrid
  ID="datagrid"
  OnItemCommand="dgrdTitles_ItemCommand"
  AutoGenerateColumns="False"
  CellPadding="10"
  Runat="Server">
<Columns>
  <asp:BoundColumn
    HeaderText="Ad"
    DataField="Ad" />

  <asp:ButtonColumn 
  
    CommandName="select"
    Text="Sec" />

  <asp:ButtonColumn
    CommandName="unselect"
    Text="Secilmemis" />

</Columns>
</asp:DataGrid>

</form>
</body>
</html>

--- NEW FILE: datagridsiralama.aspx.cs ---
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class datagridsiralama : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
}

--- NEW FILE: repeater.aspx.cs ---
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class repeater : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        OleDbConnection baglanti;
        OleDbCommand sorgu;
        baglanti = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/inetpub/wwwroot/ethem/musteriler.mdb");
        baglanti.Open();
        sorgu = new OleDbCommand("select* from musteriler", baglanti);
        OleDbDataReader veri;
        veri = sorgu.ExecuteReader();
        Repeater1.DataSource = veri;
        Repeater1.DataBind();
        baglanti.Close();
    }
}

--- NEW FILE: Web.Config ---
<?xml version="1.0"?>
<!-- 
    Note: As an alternative to hand editing this file you can use the 
    web admin tool to configure settings for your application. Use
    the Website->Asp.Net Configuration option in Visual Studio.
    A full list of settings and comments can be found in 
    machine.config.comments usually located in 
    \Windows\Microsoft.Net\Framework\v2.x\Config 
-->
<configuration>
	<appSettings/>
	<connectionStrings>
  <add name="TelefonrehberiConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\datalist1\Telefonrehberi.mdb"
   providerName="System.Data.OleDb" />
  <add name="TelefonrehberiConnectionString2" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\ethem\Telefonrehberi.mdb"
   providerName="System.Data.OleDb" />
  <add name="tamerConnectionString" connectionString="Data Source=.;Initial Catalog=tamer;User ID=tamer;Password=sifre"
   providerName="System.Data.SqlClient" />
  <add name="TelefonrehberiConnectionString3" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\ethem\Telefonrehberi.mdb"
   providerName="System.Data.OleDb" />
 </connectionStrings>
	<system.web>
		<!-- 
            Set compilation debug="true" to insert debugging 
            symbols into the compiled page. Because this 
            affects performance, set this value to true only 
            during development.
        -->
		<compilation debug="true"/>
		<!--
            The <authentication> section enables configuration 
            of the security authentication mode used by 
            ASP.NET to identify an incoming user. 
        -->
		<authentication mode="Windows"/>
		<!--
            The <customErrors> section enables configuration 
            of what to do if/when an unhandled error occurs 
            during the execution of a request. Specifically, 
            it enables developers to configure html error pages 
            to be displayed in place of a error stack trace.

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
	</system.web>
</configuration>

--- NEW FILE: DataListSelected.aspx ---
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat=server>

void Page_Load(Object sender , EventArgs e) 
{
	if (! IsPostBack)
	{
		BindDataList();
	}
}

void BindDataList() {
	 OleDbConnection baglanti;
        OleDbCommand sorgu;

        baglanti = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/inetpub/wwwroot/ethem/telefonrehberi.mdb");
        baglanti.Open();
        sorgu = new OleDbCommand("select* from rehber", baglanti);
        OleDbDataReader veri;
        veri = sorgu.ExecuteReader();
        DataList1.DataSource = veri;
        DataList1.DataBind();
        baglanti.Close();
}

void DataList_ItemCommand( object s, DataListCommandEventArgs e ) {
	DataList1.SelectedIndex = e.Item.ItemIndex;
	BindDataList();
}

</Script>

<html>
<head><title>DataListSelected.aspx</title></head>
<body id="bugra">
<form Runat="Server">

<asp:DataList
  ID="DataList1"
  OnItemCommand="DataList_ItemCommand"
  Runat="Server">

<ItemTemplate>
  <asp:LinkButton ID="adi" 
    Text='<%# DataBinder.Eval(Container.DataItem, "Ad" ) %>'
    Runat="Server" />
</ItemTemplate>

<SelectedItemTemplate>
  <b><i><%#DataBinder.Eval(Container.DataItem, "Soyad" )%></i></b>
</SelectedItemTemplate>

</asp:DataList>

</form>
</body>
</html>

--- NEW FILE: Default3.aspx.cs ---
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
}

--- NEW FILE: Default2.aspx ---
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!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>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
    </form>
</body>
</html>

--- NEW FILE: repeater2.aspx.cs ---
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class repeater2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        OleDbConnection baglanti;
        OleDbCommand sorgu;
        baglanti = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/inetpub/wwwroot/ethem/musteriler.mdb");
        baglanti.Open();
        sorgu = new OleDbCommand("select* from musteriler", baglanti);
        OleDbDataReader veri;
        veri = sorgu.ExecuteReader();
        Repeater1.DataSource = veri;
        Repeater1.DataBind();


    }

    static int say = 0;
    protected void item_olusturma(object sender, RepeaterItemEventArgs e)
    {
         string tip_metni = "bugra";
        switch (e.Item.ItemType)
        {
            case ListItemType.AlternatingItem:
                tip_metni = "AlternatingItem";
                break;
            case ListItemType.EditItem:
                break;
            case ListItemType.Footer:
                tip_metni = "Footer";
                break;
            case ListItemType.Header:
                tip_metni = "Header";

                break;
            case ListItemType.Item:
                tip_metni = "Item";
                break;

            case ListItemType.Separator:
                tip_metni = "Separator";
                break;
        }
        
        say++;

        Label1.Text += say.ToString() + " " + tip_metni + "<br>";

    }


}


--- NEW FILE: datagridsiralama.aspx ---
<%@ Page Language="C#"%>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Data" %>

<script runat=server>


void Page_Load(Object sender , EventArgs e) 
{

	
}


</Script>

<html>
<head><title>DataGridCustomPaging.aspx</title></head>
<body>
<form id="Form1" Runat="Server">
    &nbsp;

&nbsp;<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
        AutoGenerateColumns="False" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
        AutoGenerateSelectButton="True" DataKeyNames="Id" DataSourceID="SqlDataSource1" PageSize="5">
        <Columns>
            <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True"
                SortExpression="Id" />
            <asp:BoundField DataField="Ad" HeaderText="Ad" SortExpression="Ad" />
            <asp:BoundField DataField="Soyad" HeaderText="Soyad" SortExpression="Soyad" />
            <asp:BoundField DataField="Telefon" HeaderText="Telefon" SortExpression="Telefon" />
            <asp:BoundField DataField="Adres" HeaderText="Adres" SortExpression="Adres" />
            <asp:BoundField DataField="Sehir" HeaderText="Sehir" SortExpression="Sehir" />
            <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\ethem\Telefonrehberi.mdb"
        ProviderName="<%$ ConnectionStrings:TelefonrehberiConnectionString.ProviderName %>"
        SelectCommand="SELECT [Id], [Ad], [Soyad], [Telefon], [Adres], [Sehir], [Email] FROM [rehber]">
    </asp:SqlDataSource>

</form>
</body>
</html>

--- NEW FILE: Telefonrehberi.mdb ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: DataGridHyperLink.aspx ---
<%@ Page Language="C#"%>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat=server>
void Page_Load(Object sender, EventArgs e)
{
    OleDbConnection baglanti;
    OleDbCommand sorgu;

    baglanti = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/inetpub/wwwroot/datalist/telefonrehberi.mdb");
    baglanti.Open();

    sorgu = new OleDbCommand("SELECT * FROM rehber", baglanti);
    OleDbDataReader veri;
    veri = sorgu.ExecuteReader();
    datagrid.DataSource = veri;
    datagrid.DataBind();
    baglanti.Close();
}

</Script>

<html>
<head><title>DataGridHyperLink.aspx</title></head>
<body>
<form Runat="Server">

<asp:DataGrid
  ID="datagrid"
  AutoGenerateColumns="False"
  EnableViewState="False"
  CellPadding="10"
  Runat="Server">

<Columns>
  <asp:BoundColumn
    HeaderText="Ad"
    DataField="Ad" />
  <asp:HyperLinkColumn
    HeaderText="Ozellikler"
     
    DataNavigateUrlField="Id"
    DataNavigateUrlFormatString="ozellikler.aspx?id={0}"
    Text="Goruntule" />
</Columns>

</asp:DataGrid>

</form>
</body>
</html>

--- NEW FILE: DataListEvents.aspx ---
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat=server>

void Page_Load(Object sender , EventArgs e) 
{
	
        OleDbConnection baglanti;
        OleDbCommand sorgu;

        baglanti = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/inetpub/wwwroot/ethem/telefonrehberi.mdb");
        baglanti.Open();
        sorgu = new OleDbCommand("select* from rehber", baglanti);
        OleDbDataReader veri;
        veri = sorgu.ExecuteReader();
        DataList1.DataSource = veri;
        DataList1.DataBind();
        baglanti.Close();
	
}

void DataList_ItemCommand( object s, DataListCommandEventArgs e ) {
	lblMessage.Text = "<li>Item Command!";
}

void DataList_EditCommand( object s, DataListCommandEventArgs e ) {
	lblMessage.Text += "<li>Düzelt!";
}

void DataList_DeleteCommand( object s, DataListCommandEventArgs e ) {
	lblMessage.Text = "<li>Silindi";
}

void DataList_UpdateCommand( object s, DataListCommandEventArgs e ) {
	lblMessage.Text = "<li>Guncelle!";
}

</Script>

<html>
<head><title>DataListEvents.aspx</title></head>
<body>

<form Runat="Server">

<asp:Label
  ID="lblMessage"
  BackColor="White"
  Runat="Server" />
<p>
<asp:DataList
  ID="DataList1"
  OnItemCommand="DataList_ItemCommand"
  OnEditCommand="DataList_EditCommand"
  OnDeleteCommand="DataList_DeleteCommand"
  OnUpdateCommand="DataList_UpdateCommand"
  GridLines="Both"
  CellPadding="4"
  Runat="Server">

<ItemTemplate>
  <%#DataBinder.Eval(Container.DataItem, "Ad" )%>
  <br>
  <asp:LinkButton
    Text="Duzelt!"
    CommandName="edit"
    Runat="Server"/>
  <asp:LinkButton
    Text="Sil!"
    CommandName="delete"
    Runat="Server"/>
  <asp:LinkButton
    Text="Guncellestir!"
    CommandName="update"
    Runat="Server"/>
</ItemTemplate>

</asp:DataList>

</form>
</body>
</html>

--- NEW FILE: DataGridEditProducts.aspx ---
<%@ Page Language="C#" debug="true"%>
<%@ Import Namespace="System.Data.SqlClient" %>

<script runat=server>
void Page_Load(Object sender , EventArgs e)
{
	if (! IsPostBack )
		BindDataGrid();
}

void BindDataGrid()
{
    SqlConnection baglanti;
    SqlCommand sorgu;
    baglanti = new SqlConnection("SERVER=localhost;DATABASE=Egitim;UID=bote;PWD=gizli");
    baglanti.Open();
    sorgu = new SqlCommand("select* from ogrenci", baglanti);
    SqlDataReader veri;
    veri = sorgu.ExecuteReader();
    dgrdProducts.DataSource = veri;
    dgrdProducts.DataBind();
    baglanti.Close();
}

void dgrdProducts_EditCommand( Object sender, DataGridCommandEventArgs e )
{
	dgrdProducts.EditItemIndex = e.Item.ItemIndex;
	BindDataGrid();
}

void dgrdProducts_UpdateCommand( Object sender, DataGridCommandEventArgs e )
{
	int id;
	SqlConnection baglanti;
    SqlCommand sorgu;
    baglanti = new SqlConnection("SERVER=localhost;DATABASE=Egitim;UID=bote;PWD=gizli");
    baglanti.Open();
	id = (int)dgrdProducts.DataKeys[e.Item.ItemIndex];
	TextBox yeniad= (TextBox)e.Item.Cells[1].Controls[0];
	TextBox yenisoyad = (TextBox)e.Item.Cells[2].Controls[0];
    SqlCommand guncelle = new SqlCommand("Update ogrenci Set oad='" + yeniad.Text + "',osoyadi='" + yenisoyad.Text + "' where  oid=" + id + "", baglanti);
	guncelle.ExecuteNonQuery();
	baglanti.Close();
	dgrdProducts.EditItemIndex = -1;
	BindDataGrid();
}

void dgrdProducts_CancelCommand(Object sender, DataGridCommandEventArgs e )
{
	dgrdProducts.EditItemIndex = -1;
	BindDataGrid();
}

    protected void dgrdProducts_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
</Script>

<html>
<head><title>DataGridEditProducts.aspx</title></head>
<body>
<form Runat="Server">

<asp:DataGrid
  ID="dgrdProducts"
  OnEditCommand="dgrdProducts_EditCommand"
  OnUpdateCommand="dgrdProducts_UpdateCommand"
  OnCancelCommand="dgrdProducts_CancelCommand"
  DataKeyField="ProductID"
  AutoGenerateColumns="False"
  CellPadding="10"
  HeaderStyle-BackColor="Salmon"
  Runat="Server" OnSelectedIndexChanged="dgrdProducts_SelectedIndexChanged">
<Columns>
  <asp:BoundColumn
    HeaderText="Ogrenci Id"
    DataField="Id"
    ReadOnly="True" />
  <asp:BoundColumn
    HeaderText="Ad"
    DataField="Ad" />
  <asp:BoundColumn
    HeaderText="Soyad"
    DataField="Soyad"
    />
  <asp:EditCommandColumn
    EditText="duzenle!"
    UpdateText="Guncelle!"
    CancelText="Ýptal!" />
</Columns>
</asp:DataGrid>

</form>
</body>
</html>

--- NEW FILE: DataListStyles.aspx ---
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat=server>

void Page_Load(Object sender , EventArgs e) 
{
    OleDbConnection baglanti;
    OleDbCommand sorgu;

    baglanti = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/inetpub/wwwroot/ethem/telefonrehberi.mdb");
    baglanti.Open();
    sorgu = new OleDbCommand("select* from rehber", baglanti);
    OleDbDataReader veri;
    veri = sorgu.ExecuteReader();
    DataList1.DataSource = veri;
    DataList1.DataBind();
    baglanti.Close();
}

</Script>

<html>
<head><title>DataListStyles.aspx</title></head>
<body>
<form Runat="Server">

<asp:DataList
  id="DataList1"
  CellSpacing="20"
  CellPadding="10"
  ItemStyle-BorderStyle="Dashed"
  AlternatingItemStyle-BackColor="pink"
  Runat="Server">

<ItemTemplate>
  <%#DataBinder.Eval(Container.DataItem, "Ad" )%>
</ItemTemplate>

</asp:DataList>

</form>
</body>
</html>

--- NEW FILE: Telefonrehberi.ldb ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: Default2.aspx.cs ---
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
}

--- NEW FILE: repeater.aspx ---
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="repeater.aspx.cs" Inherits="repeater" %>

<!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>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <table>
        <asp:Repeater ID="Repeater1" runat="server">
        <HeaderTemplate>
        <tr>
        <th>Ad</th>
        <th>Soyad</th>
        </tr>
        </HeaderTemplate>
        <ItemTemplate>
        <tr>
        <td><%#DataBinder.Eval(Container.DataItem, "Ad" )%></td>
        <td><%#DataBinder.Eval(Container.DataItem, "Soyad" )%></td>
        </tr>
        </ItemTemplate>
        <AlternatingItemTemplate>
        <tr>
        <td bgcolor="#33ffff" ><%#DataBinder.Eval(Container.DataItem, "Ad" )%></td>
          <td bgcolor="#ffff00"><%#DataBinder.Eval(Container.DataItem, "Soyad" )%></td>
        </tr>
        
        </AlternatingItemTemplate>
        <SeparatorTemplate>
        <tr>
        <td><hr /></td>
        <td><hr /></td>
        </tr>
        
        </SeparatorTemplate>
        <FooterTemplate>
        <tr>
         <td>---------</td>
        
        </tr></FooterTemplate>
        </asp:Repeater>
        </table>
    
    </div>
    </form>
</body>
</html>

--- NEW FILE: DataGrid.aspx ---
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat=server>
void Page_Load(Object sender , EventArgs e) 
{
OleDbConnection baglanti;
OleDbCommand sorgu;

baglanti = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=/inetpub/wwwroot/ethem/telefonrehberi.mdb");
baglanti.Open();

sorgu= new OleDbCommand("SELECT * FROM rehber", baglanti);
OleDbDataReader veri;
veri = sorgu.ExecuteReader();
datagrid.DataSource = veri;
	datagrid.DataBind();
	baglanti.Close();
}

</Script>

<html>
<head><title>DataGrid.aspx</title></head>
<body>

<asp:DataGrid
  ID="datagrid"
  AutoGenerateColumns="false"
  EnableViewState="False"
  Runat="Server" >
    <EditItemStyle BackColor="#FFFFC0" />
    <ItemStyle BackColor="Yellow" />
    <Columns>
    <asp:BoundColumn DataField="Ad" HeaderText="Ad"/>
    <asp:BoundColumn DataField="Soyad" HeaderText="Soyad"/>
    </Columns>
</asp:DataGrid>

</body>
</html>