Get table data for updating
unknown
plain_text
3 years ago
1.7 kB
12
Indexable
private async void GetStudentDetails()
{
await Conopen();
Strsql = "Select * from V_Students where lrn = '" + SelectedStudentId + "'";
Sqlcmd.CommandText = Strsql;
Sqlcmd.Connection = Cnn;
Sqladapter.SelectCommand = Sqlcmd;
Sqlreader = Sqlcmd.ExecuteReader();
//metroComboBox1.Items.Clear();
if (Sqlreader.Read())
{
txtLrn.Text = Sqlreader["LRN"].ToString();
txtfname.Text = Sqlreader["F_name"].ToString();
txtlname.Text = Sqlreader["L_name"].ToString();
pickerbdate.Text = Sqlreader["B_Date"].ToString();
txtaddress.Text = Sqlreader["Address"].ToString();
txtstudentmobile.Text = Sqlreader["S_mobile_number"].ToString();
cbogender.Text = Sqlreader["gender"].ToString();
guardianId = Sqlreader["guardian_id"].ToString();
studentimg.Source =
new BitmapImage(new Uri(
$"file:///{currentAssemblyParentPath}/net6.0-windows/StudentImages/{Sqlreader["img"]}"));
txtguardianname.Text = Sqlreader["guardian_name"].ToString();
txtrelationship.Text = Sqlreader["guardian_relationship"].ToString();
txtguardianaddress.Text = Sqlreader["guardian_address"].ToString();
txtguardianmobile.Text = Sqlreader["guardian_mobile"].ToString();
}
Sqlcmd.Dispose();
Sqlreader.Close();
Cnn.Close();
Strsql = "";
}Editor is loading...