string mysql1 = "SELECT * from table_1 where sx='man' ";
SqlCommand ccmd = new SqlCommand(mysql1, conn);
SqlDataReader dr1 = ccmd.ExecuteReader();
if (dr1.Read())
{ hf1.value=dr["phone"].tostring();}
dr1.Close();
我想把phone列读出来 每个中间加逗号 比如A,B,C,D,E,F。存在hf1里,这样怎么做呢
那就处理一下这个字符串,每取一个字符,然后加一个逗号,构造一个新字符串
using System.Text;
...
string mysql1 = "SELECT * from table_1 where sx='man' ";
SqlCommand ccmd = new SqlCommand(mysql1, conn);
SqlDataReader dr1 = ccmd.ExecuteReader();
StringBuilder sb = new StringBuilder();
while(dr1.Read())
{
sb.Append(dr1["phone"].ToString());
sb.Append(",");
}
hf1.value = sb.ToString().TrimEnd(',');
dr1.Close();
string [] ph=phone.Split(',');
3楼taomanman的应该可行
你如果是不想在代码中遍历,而是直接从sql查询出来一列就是用逗号隔开
可以搜索下Sql行转列,比较麻烦
你的语句中不是已经加了where sx='man' 吗,
那三楼的还有问题吗?
using System;
..... string mysql1 = "SELECT * from table_1 where sx='man' ";
SqlCommand ccmd = new SqlCommand(mysql1, conn);
SqlDataReader dr1 = ccmd.ExecuteReader();
string a=string.Empty;
while(dr1.Read())
{
a+=dr1["phone"].ToString();
}
dr1.Close();
set @id='{ hf1.value=dr["phone"].tostring();}'
select SUBSTRING (@id,charindex('["',@id)+2,charindex('"]',@id)-charindex('["',@id)-2)