...全文
请发表友善的回复…
发表回复
alphawin 2003-09-01
- 打赏
- 举报
在select 语句中设定:
select ltrim(str(a1))+ltrim(str(a2)) as Total from temp
select ltrim(str(a1))+ltrim(str(a2)) as Total from temp
cnhgj 2003-08-30
- 打赏
- 举报
用sql语句
select a+b as c from d
select a+b as c from d
batisituta 2003-08-30
- 打赏
- 举报
用SQL语句实现:
select convert(varchar(10),a1)+ ',' + convert(varhcar(10),a2) as aa from table
select convert(varchar(10),a1)+ ',' + convert(varhcar(10),a2) as aa from table
saucer 2003-08-30
- 打赏
- 举报
how are you displaying?
using BoundColumn? add a new column to your data table and bound it to the new column:
DataTable1.Columns.Add("NewColumn", typeof(string), "Convert(col1,'System.String') + ';' + Convert(col2,'System.String')");
otherwise, do
<%# DataBinder.Eval(Container.DataItem,"col1")%>:<%# DataBinder.Eval(Container.DataItem,"col2")%>
or
<%# DataBinder.Eval(Container.DataItem,"col1").ToString() + ":" + DataBinder.Eval(Container.DataItem,"col2").ToString()%>
using BoundColumn? add a new column to your data table and bound it to the new column:
DataTable1.Columns.Add("NewColumn", typeof(string), "Convert(col1,'System.String') + ';' + Convert(col2,'System.String')");
otherwise, do
<%# DataBinder.Eval(Container.DataItem,"col1")%>:<%# DataBinder.Eval(Container.DataItem,"col2")%>
or
<%# DataBinder.Eval(Container.DataItem,"col1").ToString() + ":" + DataBinder.Eval(Container.DataItem,"col2").ToString()%>
jiezhi 2003-08-30
- 打赏
- 举报
如何顯示在一起?
123 456 ?
最簡單的辦法就是使用sql語句了。
123 456 ?
最簡單的辦法就是使用sql語句了。
rouser 2003-08-30
- 打赏
- 举报
AS 成一個字段
雪狼1234567 2003-08-30
- 打赏
- 举报
在select 语句中设定:
select ltrim(str(a1))+ltrim(str(a2)) as Total from temp
select ltrim(str(a1))+ltrim(str(a2)) as Total from temp