private void AutoComplete()
{
studentSearchTB.AutoCompleteMode = AutoCompleteMode.Suggest;
studentSearchTB.AutoCompleteSource = AutoCompleteSource.CustomSource;
AutoCompleteStringCollection coll = new AutoCompleteStringCollection();
DatabaseConnectionClass dcc;
dcc = new DatabaseConnectionClass();
string query = "SELECT Id from Student";
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
firstName = sdr["Id"].ToString();
coll.Add(firstName);
}
dcc.CloseConnection();
studentSearchTB.AutoCompleteCustomSource = coll;
}
private void button8_Click(object sender, EventArgs e)
{
string query = "SELECT * from Accounts";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Account acc = new Account();
acc.AccountNo = sdr["AccountNo"].ToString();
acc.CustId = sdr["CustId"].ToString();
acc.AccountType = sdr["AccountType"].ToString();
acc.Description = sdr["Description"].ToString();
acc.Balance = Convert.ToInt32(sdr["Balance"]);
accList.Add(acc);
}
dcc.CloseConnection();
accTable.DataSource = accList;
}
private void button8_Click(object sender, EventArgs e)
{
string query = "SELECT * from Transfers ";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Transfer tccc = new Transfer();
tccc.Tf_ID = Convert.ToInt32(sdr["Tf_Id"]);
tccc.F_Acc = sdr["F_Acc"].ToString();
tccc.To_Acc = sdr["To_Acc"].ToString();
tccc.Date = sdr["Date"].ToString();
tccc.Amount = Convert.ToDouble(sdr["Amount"]);
tcccList.Add(tccc);
}
dcc.CloseConnection();
tcccTable.DataSource = tcccList;
}
private void button8_Click(object sender, EventArgs e)
{
string query = "SELECT * from Transactions";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Transaction tcc = new Transaction();
tcc.Tx_ID = Convert.ToInt32(sdr["Tx_Id"]);
tcc.AccountNo = sdr["AccountNo"].ToString();
tcc.Date = sdr["Date"].ToString();
tcc.Balance = Convert.ToDouble(sdr["Balance"]);
tcc.Deposit = Convert.ToDouble(sdr["Deposit"]);
tccList.Add(tcc);
}
dcc.CloseConnection();
tccTable.DataSource = tccList;
}
