110,538
社区成员
发帖
与我相关
我的任务
分享
public bool u_ds_searchSQL_FromField_ret_Tbl(DataTable dt, string filedX, string searchStr, out DataTable resultTbl)
{
bool result = false;
resultTbl = dt.Clone();
//SQLで、フィルドを検索
string strFormat = filedX + @"= '{0}'";
string sqlStr = String.Format(strFormat, searchStr);
System.Data.DataRow[] DRReply = dt.Select(sqlStr);
for (int i = 0; i < DRReply.Length; i++)
{
DataRow myDatarow = resultTbl.NewRow();
myDatarow.ItemArray = DRReply[i].ItemArray;
resultTbl.Rows.Add(myDatarow);
myDatarow = null;
}
result = (DRReply.Length == 0) ? false : true;
return result;
}