问题描述
数据集 ds = 新 数据集 ();
DataSet ds = new DataSet();
DataTable dt = 新 数据表 ( "tblContact" );
ds =
DataTable dt = new DataTable("tblContact");
ds =
SunbrightDB . DataAccess .ExecuteDataset((( 字符串 ) Application.Get( " ConnectionString" ));
SunbrightDB.DataAccess.ExecuteDataset((string)Application.Get("ConnectionString"));
字符串 str = " ;
String str = "";
foreach ( DataRow 行 在 tblContact.row)
{
foreach (DataRow row in tblContact.row)
{
str = str +((row [
str = str + ((row[
" FullName" ] == DBNull .Value)? " :行[ 全名" ].ToString()+ ," );
}
"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;
this is the code which i am trying,but data not displayed in textbox
推荐答案
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();
}
这篇关于在以逗号分隔的文本框中使用数据集显示记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!