110,549
社区成员
发帖
与我相关
我的任务
分享
select singer_id,singertype_name,singer_name,singer_gender,singer_description from singer_info,singer_type where singer_name='bobo' and singertype_name=(select singertype_name from singer_type where singertype_id='1')
public List<Singer_info> Select(string name, string id)
{
List<Singer_info> infoList = new List<Singer_info>();
StringBuilder sb = new StringBuilder("select singer_id,singertype_name,singer_name,singer_gender,singer_description ");
sb.AppendFormat(" from singer_info,singer_type where");
sb.AppendFormat(" singer_name='{0}' and singertype_name=(select singertype_name from singer_type where singertype_id='{1}') ",name,id);
DataSet ds = DataBase.GetDateSet(sb.ToString(), "singerinfo");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Singer_info info = new Singer_info();
info.singer_id = Convert.ToInt32(ds.Tables[0].Rows[i]["singer_id"]);
info.singer_name = ds.Tables[0].Rows[i]["singer_name"].ToString();
info.singer_gender = ds.Tables[0].Rows[i]["singer_gender"].ToString();
info.singer_description = ds.Tables[0].Rows[i]["singer_description"].ToString();
info.Singertype_name = ds.Tables[0].Rows[i]["singertype_name"].ToString();
infoList.Add(info);
}
return infoList;