在以逗号分隔的文本框中使用数据集显示记录 [英] using dataset display records in text box separated by coma
问题描述
数据集 ds = 数据集 DataSet ds = new DataSet();
DataTable dt = 数据表 "tblContact" );
ds = DataTable dt = new DataTable("tblContact");
ds = SunbrightDB . .ExecuteDataset((( 字符串 " ConnectionString" ));
SunbrightDB.DataAccess.ExecuteDataset((string)Application.Get("ConnectionString"));
字符串 str = String str = "";
foreach ( 行 在 foreach (DataRow row in tblContact.row)
{ str = str +((row [ str = str + ((row[ " FullName" ] == .Value)? " :行[ ," );
} "FullName"] == DBNull.Value) ? "" : row["FullName"].ToString() + ",");
} 如果 (str.Length> 0)
str = str.Remove(str.Length-1,1); if (str.Length > 0)
str = str.Remove(str.Length - 1, 1); Textbox1.Text = str; Textbox1.Text = str; 这篇关于在以逗号分隔的文本框中使用数据集显示记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
这是我正在尝试的代码,但数据未显示在文本框中
this is the code which i am trying,but data not displayed in textbox推荐答案
您好,
希望对您有所帮助
Hi,
I hope it will help you
DataSet ds = new DataSet();
DataTable dt = new DataTable("tblContact");
ds =SunbrightDB.DataAccess.ExecuteDataset((string)Application.Get("ConnectionString"));
String str = "";
StringBuilder blder = new StringBuilder();
if (tblContact.row.Count > 0)
{
foreach (DataRow row in tblContact.row)
{
str = str + ((row["FullName"] == DBNull.Value) ? "" : row["FullName"].ToString());
if (!String.IsNullOrEmpty(str))
{
blder.Append(str);
blder.Append(",");
}
}
Textbox1.Text = blder.ToString();
}