SqlCommand query = new SqlCommand("SELECT lastname, firstname, middlename FROM tblStudent WHERE fldID='" + txtSearch.Text + "'", amicassaCon);
SqlDataReader dr = query.ExecuteReader();
while (dr.Read())
{
string a = dr[1].ToString();
string b = dr[2].ToString();
string c= dr[3].ToString();
txtName.Text = a + ',' + b + ' ' + c;
dr.Close();