string sql = string.Format("select departmentname from alya_department where departmentid=1"); int x = Convert.ToInt32(Connection.SqlExecuteScalar(sql));查询departmentname 从 alya_department 条件是 departmentid 为1 的 查询完毕 查询到的传给 Strig ttb;不知道上面查询到的内容如何传给 ttb 通过上面两个类的方法
string sql = string.Format("select departmentname from alya_department where departmentid=1");DataTable dt = Connection.SqlDataAapter(sql);Strig ttb="";
ttb = dt.Rows[0][0].ToString();//只是查询到一个值//多个值
foreach (DataRow dr in dt.Rows)
{
ttb += dr["departmentname"].ToString();//把所有值拚一起了,你要使用分开就好
}试试