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);
}
}