WinForm messageboxbuttons 和 三級聯動

標籤：

 MessageBoxButtons：

常用：點擊取消不執行任何操作，點擊確定，執行lable中的語句（是否刪除時，常用）

點擊按鈕中的代碼：

DialogResult dr= MessageBox.Show("是否繼續？", "警告！！！", MessageBoxButtons.OKCancel);
if(dr==DialogResult.OK)
{
label1.Text = "今天天氣不錯！";
}

：

三級聯動：

三個ComboBox，經典：省-市-區/縣

 

public class ChinaStates  //實體類
{
public string AreaCode { get; set; }
public string AreaName { get; set; }
public string ParentAreaCode { get; set; }

}

public class ChinaStatesData  //資料訪問類
{
SqlConnection conn = null;
SqlCommand cmd = null;

public ChinaData()
{
conn = new SqlConnection("server=.;database=mydb;user=sa;pwd=123;");
cmd = conn.CreateCommand();
}

public List<ChinaStates> Select(string pcode)
{
List<ChinaStates> list = new List<ChinaStates>();
cmd.CommandText = "select *from ChinaStates where ParentAreaCode = @a";
cmd.Parameters.Clear();
cmd.Parameters.Add("@a", pcode);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
ChinaStates c = new ChinaStates()
{
AreaCode = dr[0].ToString(),
AreaName = dr[1].ToString(),
ParentAreaCode = dr[2].ToString()
};
list.Add(c);
}
}
conn.Close();
return list;
}}

主函數中調用：

AreaDataBind(comboBox1, "0001");
AreaDataBind(comboBox2, comboBox1.SelectedValue.ToString());
AreaDataBind(comboBox3, comboBox2.SelectedValue.ToString());

方法：

public void AreaDataBind(ComboBox cb, string Pcode)
{
cb.DataSource = new ChinaData().Select(Pcode);
cb.DisplayMember = "AreaName";
cb.ValueMember = "AreaCode";
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
AreaDataBind(comboBox2, comboBox1.SelectedValue.ToString());
}

private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
AreaDataBind(comboBox3, comboBox2.SelectedValue.ToString());
}

WinForm messageboxbuttons 和 三級聯動