public List <BringStudentData> GetallStudentTextBox(string regno)
{
List <BringStudentData> allStudent = new List <BringStudentData>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM tbl_Student WHERE RegestretionNumber = @RegestretionNumber";
cmd.Parameters.AddWithValue("@RegestretionNumber", regno);
cmd.Connection = connection;
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BringStudentData aStudentData = new BringStudentData();
aStudentData.GetValue(reader["StudentID"].ToString(), reader["StudentName"].ToString(), reader["MobileNumber"].ToString(),
reader["EmailAddress"].ToString(), reader["DepartmentID"].ToString(), reader["RegestretionNumber"].ToString());
allStudent.Add(aStudentData);
}
reader.Close();
connection.Close();
return(allStudent);
}
}
protected void ddlupdateDelete_SelectedIndexChanged(object sender, EventArgs e)
{
GetClear();
saveButton.Enabled = false;
BringStudentData bringStudent = new BringStudentData();
bringStudent = (aBringStudentData.AStudentData(ddlupdateDelete.SelectedValue));
studentNameTextBox.Text = bringStudent.StudentName;
mobileNumberTextBox.Text = bringStudent.MobileNumber;
emailAddressTextBox.Text = bringStudent.Email;
registrationNumberTextBox.Text = bringStudent.RegNO;
ddlDepartment.SelectedValue = bringStudent.DepartmentId;
}
