document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. private void LoadingData()
  2.         {
  3.  
  4.             string mdfFilename = "ContohLocalDb.mdf";
  5.             string outputFolder = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
  6.             string attachDbFilename = Path.Combine(outputFolder, mdfFilename);
  7.  
  8.             string connString = @"Data Source=(LocalDB)\\v11.0;AttachDbFilename=" + attachDbFilename + ";Integrated Security=True";
  9.  
  10.             try
  11.             {
  12.  
  13.                 var connection = new SqlConnection(connString);//seperti ini bisa
  14.                 connection.Open();
  15.  
  16.                 Console.WriteLine("State: {0}", connection.State);
  17.                 Console.WriteLine("ConnectionString: {0}", connection.ConnectionString);
  18.                 MessageBox.Show("Sip, konek kang");
  19.  
  20.                 var command = new SqlCommand("SELECT * FROM TableLagu", connection); //bisa seperti ini juga
  21.                 var adapter = new SqlDataAdapter(command); //bisa seperti ini
  22.                 var table = new DataTable();//bisa seperti ini juga
  23.  
  24.                 adapter.Fill(table);
  25.  
  26.                 dataGridView1.DataSource = table;
  27.  
  28.             }
  29.             catch (Exception ex)
  30.             {
  31.                 Console.WriteLine("Failed to Connect::" + ex.Message);
  32.                 MessageBox.Show("Wah, erro bro");
  33.             }
  34.         }
');