Create gridview for data in atm database to display customers names, customers accountNumber, customers Amount, customers Account Type
private void button2_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(@"Data Source=(localdb)\ProjectsV13;Initial Catalog=ATM;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); conn.Open(); string query = "SELECT [Customer].CustomerName, [Account].AccountNumber, [Account].Amount, [Account].AccountType FROM [Customer] JOIN [Account] ON [Customer].CustomerID = [Account].CustomerID"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; } }