private void btnOpen_Click(object sender, EventArgs e) { con = new System.Data.SqlServerCe.SqlCeConnection(); con.ConnectionString = "Data Source=C:\\Users\\Lovette\\Documents\\MyFiles\\ETEEAP\\MODULE-1 C#\\Bankdatabase\\BankAccount.sdf"; comd = new SqlCeCommand("SELECT * From tbl_bankaccount WHERE AccountNumber='" + tbAccountNum.Text.Trim() + "'", con); con.Open(); reader = comd.ExecuteReader(); clientRecordForm clientRecords = new clientRecordForm(this); while (reader.Read()) { tbAccountNumPR.Text = reader.GetValue(0).ToString(); tbFirstName.Text = reader.GetValue(1).ToString(); tbMiddleName.Text = reader.GetValue(2).ToString(); tbLastName.Text = reader.GetValue(3).ToString(); tbEmployer.Text = reader.GetValue(4).ToString(); tbBusinessAdd.Text = reader.GetValue(5).ToString(); tbHomeAdd.Text = reader.GetValue(6).ToString(); tbContactNum.Text = reader.GetValue(7).ToString(); tbMoney.Text = reader.GetValue(8).ToString(); clientRecords.ShowDialog(); } con.Close();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)