一个字符串如下,人名用半角逗号分开: 张三,李四,王五,赵六 一个GridView控件绑定一个表,表中有三列Title,Dates,Name张三,李四,牛七,王五,马八
现在想要的结果:要是参加了符合Title的,则姓名列,下面就有相应的姓名比如张三,李四,下面是我的代码:
public void gdvOutsideBind()这是gridview的绑定方法
{
string sql = "select Title,Dates,Name from OutsideInfo group by Title,Dates,Name order by Dates";
db.GridViewBind(gdvOutside,sql,"Title");
}
public string ShowName(string Name)这是显示名字的
{
SqlConnection con = db.GetConnection();
con.Open();
string sql = "select distinct Name from OutsideInfo";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader read = cmd.ExecuteReader();
{
while (read.Read())
{
Name =Name+" , "+read["Name"].ToString();
}
}
return Name;
con.Close();
}但是我不知道怎么把 titles与name 联系起来来查询数据,请大家帮忙看看
现在想要的结果:要是参加了符合Title的,则姓名列,下面就有相应的姓名比如张三,李四,下面是我的代码:
public void gdvOutsideBind()这是gridview的绑定方法
{
string sql = "select Title,Dates,Name from OutsideInfo group by Title,Dates,Name order by Dates";
db.GridViewBind(gdvOutside,sql,"Title");
}
public string ShowName(string Name)这是显示名字的
{
SqlConnection con = db.GetConnection();
con.Open();
string sql = "select distinct Name from OutsideInfo";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader read = cmd.ExecuteReader();
{
while (read.Read())
{
Name =Name+" , "+read["Name"].ToString();
}
}
return Name;
con.Close();
}但是我不知道怎么把 titles与name 联系起来来查询数据,请大家帮忙看看
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货