İl’e göre İlçe , İlçeye göre Mahalle Listele — Asp Net — C#
İl’e göre İlçe , İlçeye göre Mahalle Listele — Asp Net — C#
<%@ 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>
<style type="text/css">
.auto-style1 {
width: 100%;
}
.auto-style2 {
width: 142px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table class="auto-style1">
<tr>
<td class="auto-style2">
İl ----------------></td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="IlAdi" DataValueField="IlID" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>" ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" SelectCommand="SELECT [IlID], [IlAdi] FROM [Iller]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<td class="auto-style2">
İlçe --------------></td>
<td>
<asp:DropDownList ID="DropDownList2" runat="server" OnSelectedIndexChanged="DropDownList2_SelectedIndexChanged" AutoPostBack="True">
</asp:DropDownList>
</td>
</tr>
<tr>
<td class="auto-style2">
Mahalle ----------></td>
<td>
<asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True">
</asp:DropDownList>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;//www.gorselprogramlama.com
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
public partial class _Default : System.Web.UI.Page
{
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DropDownList2.Items.Clear();//www.gorselprogramlama.com
Session["ilID"] = Convert.ToInt32(DropDownList1.SelectedValue);
OleDbConnection bag = new OleDbConnection("provider=microsoft.ace.oledb.12.0;data source=" + Server.MapPath("data.accdb"));
OleDbCommand kmt = new OleDbCommand();
kmt.Connection = bag;
kmt.CommandText = "select * from Ilceler where IlID=@IlID";
kmt.Parameters.AddWithValue("@IlID", Session["ilID"]);
OleDbDataReader oku;
bag.Open();
oku = kmt.ExecuteReader();
DropDownList2.DataSource = oku;
DropDownList2.DataValueField = "IlceID";
DropDownList2.DataTextField = "IlceAdi";
DropDownList2.DataBind();
bag.Close();
}
catch (Exception)
{
}
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DropDownList3.Items.Clear();
Session["ilceID"] = Convert.ToInt32(DropDownList2.SelectedValue);
OleDbConnection bag = new OleDbConnection("provider=microsoft.ace.oledb.12.0;data source=" + Server.MapPath("data.accdb"));
OleDbCommand kmt = new OleDbCommand();
kmt.Connection = bag;
kmt.CommandText = "select * from Mahalleler where IlID=@IlID and IlceID=@IlceID";
kmt.Parameters.AddWithValue("@IlID", Session["ilID"]);
kmt.Parameters.AddWithValue("@IlceID", Session["ilceID"]);
OleDbDataReader oku;
bag.Open();
oku = kmt.ExecuteReader();
DropDownList3.DataSource = oku;
DropDownList3.DataValueField = "MahID";
DropDownList3.DataTextField = "MahAdi";
DropDownList3.DataBind();//www.gorselprogramlama.com
bag.Close();
}
catch (Exception)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
}
}<a href="http://www.gorselprogramlama.com/wp-content/uploads/2017/11/il_ilce_mahalle.jpg">
</a>
