internal void bindcompname() { cmd = new SqlCommand("select CompName from company",conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); DataRow dr = dt.NewRow(); comboscname.DisplayMember = "CompName"; comboscname.DataSource = dt; comboscname.DropDownStyle = ComboBoxStyle.DropDownList; } private void comboscname_SelectedIndexChanged_1(object sender, EventArgs e) { cmd = new SqlCommand("select model.ModNum from model inner join company on model.CompName=company.CompName where model.CompName=@cname",conn); cmd.Parameters.AddWithValue("@cname",comboscname.Text); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); DataRow dr = dt.NewRow(); combosmnumber.DisplayMember = "ModNum"; combosmnumber.DataSource = dt; combosmnumber.DropDownStyle = ComboBoxStyle.DropDownList; } private void combosmnumber_SelectedIndexChanged_1(object sender, EventArgs e) { cmd = new SqlCommand("select mobile.IMEINo from mobile inner join model on model.ModId=mobile.ModId inner join company c on c.CompName=mobile.CompName where model.ModNum=@mid and mobile.Status=@sts", conn); cmd.Parameters.AddWithValue("@mid", combosmnumber.Text); cmd.Parameters.AddWithValue("@sts", "NotSold"); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); DataRow dr = dt.NewRow(); combosimeinumber.DisplayMember = "IMEINo"; combosimeinumber.DataSource = dt; combosimeinumber.DropDownStyle = ComboBoxStyle.DropDownList; }
Quote:internal void bindcompname() { cmd = new SqlCommand("select CompName from company",conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); DataRow dr = dt.NewRow(); comboscname.DisplayMember = "CompName"; comboscname.DataSource = dt; comboscname.DropDownStyle = ComboBoxStyle.DropDownList; } private void comboscname_SelectedIndexChanged_1(object sender, EventArgs e) { cmd = new SqlCommand("select model.ModNum from model inner join company on model.CompName=company.CompName where model.CompName=@cname",conn); cmd.Parameters.AddWithValue("@cname",comboscname.Text); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); DataRow dr = dt.NewRow(); combosmnumber.DisplayMember = "ModNum"; combosmnumber.DataSource = dt; combosmnumber.DropDownStyle = ComboBoxStyle.DropDownList; } private void combosmnumber_SelectedIndexChanged_1(object sender, EventArgs e) { cmd = new SqlCommand("select mobile.IMEINo from mobile inner join model on model.ModId=mobile.ModId inner join company c on c.CompName=mobile.CompName where model.ModNum=@mid and mobile.Status=@sts", conn); cmd.Parameters.AddWithValue("@mid", combosmnumber.Text); cmd.Parameters.AddWithValue("@sts", "NotSold"); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); DataRow dr = dt.NewRow(); combosimeinumber.DisplayMember = "IMEINo"; combosimeinumber.DataSource = dt; combosimeinumber.DropDownStyle = ComboBoxStyle.DropDownList; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)