//地点模糊查找议程信息
受累看看模糊查询在这里可以这么写么？
        public Agendum GetAgendumByIntangibleSitus(string Situs)
        {
            Agendum agendum = new Agendum();
            sql = "select * from Agendm where Situs Like%" + Convert.ToString(Situs) + "%";
            using (SqlDataReader reader = DBHelper.GetReader(sql))
            {
                if (reader.Read())
                {
                    agendum.CreateStaffID = Convert.ToInt32(reader["CreateStaffID"]);
                    agendum.AgendumTypeID = Convert.ToInt32(reader["AgendumTypeID"]);
                    agendum.Subject = Convert.ToString(reader["Subject"]);
                    agendum.Situs = Convert.ToString(reader["Situs"]);
                    agendum.StartingTime = Convert.ToDateTime(reader["StartinTime"]);
                    agendum.EndTime = Convert.ToDateTime(reader["EndTime"]);
                    agendum.Content = Convert.ToString(reader["Content"]);
                    agendum.CreateDate = Convert.ToDateTime(reader["CreateDate"]);
                    agendum.OpenAgendum = Convert.ToBoolean(reader["OpenAgendum"]);
                }
            }
            return agendum;
        }

"select * from Agendm where Situs Like '%" + Convert.ToString(Situs) + "%'";

1.最好在使用reader.Read()前，做个判断:reader.HasRows
2.你确定你查出来的只有一条数据吗？如果多条数据，你的代码只能取到第一条。
3.读取字段 reader[""]最好判断是否IsDBNull.
4.是否要异常处理？

[ 本帖最后由 dwwwing 于 2011-6-20 15:09 编辑 ]

1.  要有一个好习惯，查询语句里面最要些清楚要查询的字段，尽量不要用*号以求简便

2.  不知道你是否只想获得一行数据，如果是一张表的话，sqlDataAdept是不是好点？？

！！good