پیام حیاتی
دوشنبه 20 مهر 1394, 13:24 عصر
سلام
این جداول استان و شهر هستند :
135961
135962
این کدهای من :
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.IO;
public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=localhost; Initial Catalog=Drop; Integrated Security=TRUE ");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from Ostan", con);
DataSet ds = new DataSet();
da.Fill(ds, "Temp");
DropOstan.DataSource = ds;
DropOstan.Items.Clear();
DropOstan.Items.Add("-- انتخاب کنید --");
DropOstan.DataTextField = "o_name";
DropOstan.DataValueField = "o_id";
DropOstan.DataBind();
con.Close();
}
}
protected void DropCity_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void DropOstan_SelectedIndexChanged(object sender, EventArgs e)
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select c_name from City where c_o_id= '" + DropOstan.SelectedItem.Value + "' ", con);
DataSet ds = new DataSet();
da.Fill(ds, "Temp");
DropCity.DataSource = ds;
DropOstan.DataTextField = "c_name";
DropOstan.DataValueField = "c_id";
DropCity.DataBind();
con.Close();
}
}
نتیجه در خروجی :
135963
این جداول استان و شهر هستند :
135961
135962
این کدهای من :
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.IO;
public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=localhost; Initial Catalog=Drop; Integrated Security=TRUE ");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from Ostan", con);
DataSet ds = new DataSet();
da.Fill(ds, "Temp");
DropOstan.DataSource = ds;
DropOstan.Items.Clear();
DropOstan.Items.Add("-- انتخاب کنید --");
DropOstan.DataTextField = "o_name";
DropOstan.DataValueField = "o_id";
DropOstan.DataBind();
con.Close();
}
}
protected void DropCity_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void DropOstan_SelectedIndexChanged(object sender, EventArgs e)
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select c_name from City where c_o_id= '" + DropOstan.SelectedItem.Value + "' ", con);
DataSet ds = new DataSet();
da.Fill(ds, "Temp");
DropCity.DataSource = ds;
DropOstan.DataTextField = "c_name";
DropOstan.DataValueField = "c_id";
DropCity.DataBind();
con.Close();
}
}
نتیجه در خروجی :
135963