private void button2_Click(object sender, EventArgs e)
{
Role[] role;
SqlConnection con = new SqlConnection("Data Source=SLY//SQLEXPRESS;Initial Catalog=ManagerRoles;User ID=sa");
SqlCommand cmd = new SqlCommand("select * from Roles",con);
SqlDataReader dr;
con.Open();
dr = cmd.ExecuteReader();
DataDAL dataDal = new DataDAL();
role = dataDal.GetRoles(dr);
con.Close();
textBox2.Text = role[0].RoleID.ToString();
textBox3.Text = role[0].Names.ToString();
textBox4.Text = role[0].Description.ToString();
}
类:DataDAL
public Role[] GetRoles(IDataReader reader)
{
System.Collections.ArrayList al = new System.Collections.ArrayList();
try
{
while (reader.Read())
{
R