Advertisement
kshadow22

Connect Application To Database

Mar 11th, 2014
155
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.95 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using MySql.Data.MySqlClient;
  10.  
  11. namespace FirstLogInData
  12. {
  13.     public partial class Form1 : Form
  14.     {
  15.         public Form1()
  16.         {
  17.             InitializeComponent();
  18.         }
  19.  
  20.         private void button1_Click(object sender, EventArgs e)
  21.         {
  22.             try
  23. {
  24.  
  25. string myConnection = "datasource=localhost;port=3306;username=USERNAME;password=PASSWORD";
  26. MySqlConnection myConn = new MySqlConnection(myConnection);
  27. MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
  28. myDataAdapter.SelectCommand = new MySqlCommand(" select * database.DATABASE ;", myConn);
  29. myConn.Open();
  30. DataSet ds = new DataSet(); 'Do not need
  31. MessageBox.Show("Connected");
  32. myConn.Close();
  33. }
  34. catch(Exception ex)
  35. {
  36. MessageBox.Show(ex.Message);
  37. }
  38.        }
  39.    }
  40. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement