public int GetMidByMemberName(string name)
{
string sql = "select * from member where MemberName like '%" + name + "%'";
return ((Member)this.GetMembersBySql(sql)[0]).Mid;
}
就这段代码出的问题
具体是怎么回事啊
怎么解决啊???
高手来啊啊啊!1
{
string sql = "select * from member where MemberName like '%" + name + "%'";
return ((Member)this.GetMembersBySql(sql)[0]).Mid;
}
就这段代码出的问题
具体是怎么回事啊
怎么解决啊???
高手来啊啊啊!1
return ((Member)this.GetMembersBySql(sql)[0]).Mid;
你确定this.GetMembersBySql(sql)这个能查出数据吗? 打印出来看看里面是否有数据
Mid属性 的类型应该是int型吧
{
string sql = "select * from member where MemberName like '%" + name + "%'";
return ((Member)this.GetMembersBySql(sql)[0]).Mid;
}private IList<Member> GetMembersBySql(string safeSql)
{
DBHelper dbh = new DBHelper();
List<Member> list = new List<Member>(); try
{
DataTable table = dbh.GetDataSet(safeSql); foreach (DataRow row in table.Rows)
{
Member member = new Member(); member.Mid = (int)row["Mid"];
member.MemberName = row["MemberName"].ToString();
member.MemberLoginId = row["MemberLoginId"].ToString();
member.MemberPass = row["MemberPass"].ToString();
member.MemberMail = row["MemberMail"].ToString();
member.MemberSex = row["MemberSex"].ToString();
member.MemberCrodId = row["MemberCrodId"].ToString();
member.MemberPhone = row["MemberPhone"].ToString();
member.MemberQQ = (int)row["MemberQQ"];
member.MemberMsn = row["MemberMsn"].ToString();
member.MemberShuoMing = row["MemberShuoMing"].ToString();
member.MemberType = (int)row["MemberType"];
member.Memberphoto = row["MemberPhoto"].ToString();
member.Zhuchetime = Convert.ToDateTime(row["Zhuchetime"]);
member.Blog_KT = Convert.ToBoolean(row["Blog_KT"]); list.Add(member);
} return list;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
} }
Member对象是否 为 null
table没有数据吧
用sqlDataReader读取更好
} return list;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
------改成:
list.Add(member);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
finally
{
return list;
}断点调试,看看返回的list.Count为多少?return ((Member)this.GetMembersBySql(sql)[0]).Mid;
这个改成:
List<Member> list = this.GetMembersBySql(sql);
if(list.Count != 0)
return ((Member)list[0]).Mid;
else
return 0; //如果没有结果,返回的默认值