e ({1} = {2});", "shop_ex", "ID", textBox22. Text); = new MySqlDataAdapter (sql, conn); = new MySqlCommandBuilder (da);. Fill (data); = new DataTable (); = String. Format ("select * from {0};", "v_shop_ex"); = new MySqlDataAdapter (sql, connStr); = new MySqlCommandBuilder (da);. Fill (data);. DataSource = data;. Sort (dataGridView12. Columns [0], ListSortDirection. Ascending);
} void button15_Click (object sender, EventArgs e)
{sql = String. Format ("insert into {0} (shop_id, production_id) values ​​('{1}', '{2}')", "shop_ex", textBox23. Text, textBox24. Text);
{= new MySqlCommand (sql, conn);. ExecuteNonQuery ();
} (Exception ex)
{. Show ("Exception:" + ex. Message);
} = new DataTable (); = String. Format ("select * from {0};", "v_shop_ex"); = new MySqlDataAdapter (sql, connStr); = new MySqlCommandBuilder (da);. Fill (data);. DataSource = data;. Sort (dataGridView12. Columns [0], ListSortDirection. Ascending);
} void button16_Click (object sender, EventArgs e)
{s_test = ("call Stored_pr ();"); = new MySqlDataAdapter (s_test, connStr); = new MySqlCommandBuilder (da);. Fill (data); = new DataTable (); sql_d = "select * from kurs. test; "; = new MySqlDataAdapter (sql_d, connStr); = new MySqlCommandBuilder (da);. Fill (data);. DataSource = data;
}
}
}
