private void LoadingData()
{
string mdfFilename = "ContohLocalDb.mdf";
string outputFolder = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
string attachDbFilename = Path.Combine(outputFolder, mdfFilename);
string connString = @"Data Source=(LocalDB)\\v11.0;AttachDbFilename=" + attachDbFilename + ";Integrated Security=True";
try
{
var connection = new SqlConnection(connString);//seperti ini bisa
connection.Open();
Console.WriteLine("State: {0}", connection.State);
Console.WriteLine("ConnectionString: {0}", connection.ConnectionString);
MessageBox.Show("Sip, konek kang");
var command = new SqlCommand("SELECT * FROM TableLagu", connection); //bisa seperti ini juga
var adapter = new SqlDataAdapter(command); //bisa seperti ini
var table = new DataTable();//bisa seperti ini juga
adapter.Fill(table);
dataGridView1.DataSource = table;
}
catch (Exception ex)
{
Console.WriteLine("Failed to Connect::" + ex.Message);
MessageBox.Show("Wah, erro bro");
}
}