Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class Program
- {
- static void Main(string[] args)
- {
- try
- {
- MySqlConnection conn = new MySqlConnection();
- conn.ConnectionString = "Server=127.0.0.1;user=root;password=terli;database=netchar";
- conn.Open();
- MySqlDataAdapter adp = new MySqlDataAdapter("Select * from server_settings", conn);
- DataSet set = new DataSet();
- adp.Fill(set);
- foreach (DataTable table in set.Tables)
- {
- Console.WriteLine("--> " + table.TableName);
- DataColumn[] keys = new DataColumn[1];
- keys[0] = table.Columns[0];
- table.PrimaryKey = keys;
- object[] row1 = new object[2];
- row1[0] = (object)"Setting1";
- row1[1] = (object)2;
- table.Rows.Add(row1);
- table.Rows.Add(row1);
- }
- }
- catch (Exception e)
- {
- Console.WriteLine(e.Message);
- }
- Console.ReadKey();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement