private void button1_Click(object sender, EventArgs e)
{
DB db = new rieltor.DB();
db.openConnection();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand("INSERT INTO `apartment` (`city`, `region`, `square`, `san`, `bed`, `center`, `metro`, `name`, `surname`, `phone`, `price`) VALUES (@city, @region, @square, @san, @bed, @center, @metro, @name, @surname, @phone, @price);", db.getConnection());
command.Parameters.Add("@city", MySqlDbType.VarChar).Value = city.Text;
command.Parameters.Add("@region", MySqlDbType.VarChar).Value = region.Text;
command.Parameters.Add("@square", MySqlDbType.Int32).Value = Int32.Parse(square.Text);
command.Parameters.Add("@san", MySqlDbType.Int32).Value = Int32.Parse(san.Text);
command.Parameters.Add("@bed", MySqlDbType.Int32).Value = Int32.Parse(bed.Text);
command.Parameters.Add("@center", MySqlDbType.Int32).Value = Int32.Parse(center.Text);
command.Parameters.Add("@metro", MySqlDbType.Int32).Value = Int32.Parse(metro.Text);
command.Parameters.Add("@name", MySqlDbType.VarChar).Value = name.Text;
command.Parameters.Add("@surname", MySqlDbType.VarChar).Value = surname.Text;
command.Parameters.Add("@phone", MySqlDbType.VarChar).Value = phone.Text;
command.Parameters.Add("@price", MySqlDbType.Int32).Value = Int32.Parse(price.Text);
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Добавлено в базу!");
}
}
public Form1()
{
InitializeComponent();
DB db = new rieltor.DB();
db.openConnection();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand("select distinct city from apartment", db.getConnection());
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
city_box.Items.Add(reader[0].ToString());
//region_box.Items.Add(reader[1]);
}
city_box.SelectedIndexChanged += new EventHandler(city_selectedindexchanged);
db.closeConnection();
san_box.Items.Add("1");
san_box.Items.Add("2");
san_box.Items.Add("3");
bed_box.Items.Add("1");
bed_box.Items.Add("2");
bed_box.Items.Add("3");
bed_box.Items.Add("4");
bed_box.Items.Add("5");
}
