private void FormBalance_Load(object sender, EventArgs e)
{
//var x = from a in udc.Balances
// where a.BalanceId == br1.Id
// select a;
RemoteBankDataContext udc1 = new RemoteBankDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\C#\Remote Banking System\Remote Banking System\MainServer.mdf;Integrated Security=True;Connect Timeout=30");
var x = from b in udc1.Balances
join u in udc1.Users
on b.BalanceId equals u.Id
where b.BalanceId == br1.Id
select new { u.Id, u.name, u.password, u.phoneno, u.address, b.Accno, b.Account_Balance, b.Loan };
//User userReferenceForBalance = x.FirstOrDefault();
////MessageBox.Show(x.First().Account_Balance.ToString());
//labelBalance.Text = x.First().Account_Balance.ToString();
dataGridUserDetails.DataSource = x.ToList();
}
void GridViewUpdate()
{
RemoteBankDataContext udc = new RemoteBankDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\C#\Remote Banking System\Remote Banking System\MainServer.mdf;Integrated Security=True;Connect Timeout=30");
}
