protected void Button1_Click(object sender, EventArgs e) { int num = DropDownList1.SelectedIndex; //TextBox2.Text = num.ToString(); var path = Server.MapPath(@"db\qqq.mdf"); var loader = new Loader(); loader.LoadData(num, TextBox1.Text, path); }
protected void Button1_Click(object sender, EventArgs e) { var num = DropDownList1.SelectedIndex; var mod = DropDownList2.SelectedIndex; var f = DropDownList3.SelectedIndex; var y = DropDownList4.SelectedIndex; //TextBox1.Text = num.ToString()+mod+f+y.ToString(); string s1 = null; string s2 = null; string s3 = null; string s4 = null; if (f == 0) s3 = "*"; if (f == 1) s3 = "бензин"; if (f == 2) s3 = "дизель"; if (y == 0) s4 = "*"; if (y == 1) s4 = "2012"; if (y == 2) s4 = "2011"; if (y == 3) s4 = "2010"; if (y == 4) s4 = "2009"; if (y == 5) s4 = "2008"; if (y == 6) s4 = "2007"; if (y == 7) s4 = "2006"; if (y == 8) s4 = "2005"; string s5 = TextBox1.Text; string s6 = TextBox2.Text; int x5 = Convert.ToInt32(s5); //string xxx = "INSERT INTO "+s1+" (Model, Fuel, Year, Price, Owner) VALUES('"+ s2 + "', '" + s3 + "', " + s4 + ", " + s5 + ", '" + s6 + "')"; //TextBox3.Text = xxx; if (num == 1) { s1 = "Audi"; if (mod == 0) s2 = "*"; if (mod == 1) s2 = "A3"; if (mod == 2) s2 = "A4"; if (mod == 3) s2 = "A6"; var path = Server.MapPath(@"..\App_Data\Auto.mdf"); string sql = "INSERT INTO " + s1 + " (Model, Fuel, Year, Price, Owner) VALUES('" + s2 + "', '" + s3 + "', " + s4 + ", " + s5 + ", '" + s6 + "')"; var loader = new Loader(); loader.LoadData(sql, path); } if (num == 2) { s1 = "BMW"; if (mod == 0) s2 = "*"; if (mod == 1) s2 = "3-reihe (E46)"; if (mod == 2) s2 = "5-reihe (E60)"; if (mod == 3) s2 = "X5"; var path = Server.MapPath(@"..\App_Data\Auto.mdf"); string sql = "INSERT INTO " + s1 + " (Model, Fuel, Year, Price, Owner) VALUES('" + s2 + "', '" + s3 + "', " + s4 + ", " + s5 + ", '" + s6 + "')"; var loader = new Loader(); loader.LoadData(sql, path); } if (num == 3) { s1 = "Mercedes"; if (mod == 0) s2 = "*"; if (mod == 1) s2 = "C-klasse (W203)"; if (mod == 2) s2 = "E-klasse (W211)"; if (mod == 3) s2 = "S-klasse (W221)"; var path = Server.MapPath(@"..\App_Data\Auto.mdf"); string sql = "INSERT INTO " + s1 + " (Model, Fuel, Year, Price, Owner) VALUES('" + s2 + "', '" + s3 + "', " + s4 + ", " + s5 + ", '" + s6 + "')"; var loader = new Loader(); loader.LoadData(sql, path); } }