SqlConnection conn = new SqlConnection("user id=sa;password=sa;database=KMS; server=(local)");
conn.Open();
string Area = Request.QueryString["area"].ToString();
string strsql = "SELECT * FROM KMS_ROLES where delflag=0 and deptid='"+Area+"'";
SqlDataAdapter sd = new SqlDataAdapter(strsql, conn);
DataTable data = new DataTable();
sd.Fill(data);
string aa = "sdf/sdaf";
for (int i = 0; i < data.Rows.Count; i++)
{
if (aa == "")
{
aa = data.Rows[i]["rolesid"].ToString() + "/" + data.Rows[i]["rolesname"].ToString();
}
else
{
aa = data.Rows[i]["rolesid"].ToString() + "/" + data.Rows[i]["rolesname"].ToString()+","+aa;
}
}
Response.Write(aa);
}