SQL??????????
????????? ???????[ 2010/5/12 15:28:27 ] ????????
????????????????ó????У???????????????????????????????????????????DataTable?????????????????? TestDataTable??????????????????????????????????select??????????????SetInputParameter???????????????????????Table??????????DataTable???????????select???????????
????class TestDataTable
????{
????private readonly SqlCommand _command;
????public TestDataTable(String connstr?? String selectQuery?? CommandType commandType)
????{
????SqlConnection conn = new SqlConnection(connstr);
????_command = new SqlCommand(selectQuery?? conn);
????_command.CommandType = commandType;
????}
????public void SetInputParameter(string parameterName?? object parameterValue)
????{
????if (_command.Parameters.Contains(parameterName))
????_command.Parameters[parameterName] =
????new SqlParameter(parameterName?? parameterValue);
????else
????_command.Parameters.AddWithValue(parameterName?? parameterValue);
????}
????public DataTable Table
????{
????get
????{
????DataTable _dataTable = new DataTable();
????SqlDataAdapter da = new SqlDataAdapter(_command);
????da.Fill(_dataTable);
????da.Dispose();
????return _dataTable;
????}
????}
????}
????????????????????LINQ?????????DataTable???????????????????????д???????????logFilePath???????????С?ResultSetComparer?????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11