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.SqlClient;
public partial class AddProductor : System.Web.UI.Page
{
DataAccess MarketBase = new DataAccess();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection conn = new SqlConnection(MarketBase.SqlBase);
conn.Open();
DataTable dt1 = new DataTable();
dt1 = MarketBase.DisPlayList_Ds("select * from GoodType", conn);
firstKind.DataTextField = "TypeName";
firstKind.DataValueField = "GoodTypeID";
firstKind.DataSource = dt1.DefaultView;
firstKind.DataBind();
DataTable dt = new DataTable();
int id = int.Parse(firstKind.Value);
dt = MarketBase.DisPlayList_Ds("select * from GoodType2 where GoodTypeID='" + id + "'", conn);
secondKind.DataTextField = "GoodType2Name";
secondKind.DataValueField = "GoodType2ID";
secondKind.DataSource = dt.DefaultView;
secondKind.DataBind();
}