日期:2014-05-18 浏览次数:21262 次
SqlConnection conn = new SqlConnection("Data Source=110.136.48.24;Initial Catalog=hope_loan;Integrated Security=True");
conn.Open();
string sql;
if (Request.QueryString["emp_id"]== "")
{
sql = "select * from [hope_empinfo] where hope_emp_name='" + Session["hope_user_name"] + "'";
}
else
{
sql = "select * from [hope_empinfo] where hope_emp_id=" + Request.QueryString["emp_id"];
}
// string sql = "select * from [hope_empinfo] where hope_emp_name='admin'";
SqlDataAdapter ada = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
ada.Fill(ds);
DetailsView1.DataSource = ds;
DetailsView1.DataBind();