DataGrid添加一条纪录

最新推荐文章于 2021-03-23 18:03:20 发布

holmes_sun5

最新推荐文章于 2021-03-23 18:03:20 发布

阅读量252

点赞数

本文链接：https://blog.csdn.net/holmes_sun5/article/details/86500414

版权

MainWindow.xaml:

MainWindow.xaml.cs:

using HelloSolution.ViewModels;
using System.Windows;

namespace HelloSolution
{
/// <summary>
/// MainWindow.xaml 的交互逻辑
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
this.DataContext = new MainWindowViewModel();
}
}
}

MainWindowViewModel.cs

using Microsoft.Practices.Prism.ViewModel;
using Microsoft.Practices.Prism.Commands;
using System;
using System.Data;
namespace HelloSolution.ViewModels
{
class MainWindowViewModel:NotificationObject
{
public DelegateCommand AddCommand { get; set; }
private DataTable yTTable;
public DataTable YTTable
{
get { return yTTable; }
set
{
yTTable = value;
this.RaisePropertyChanged("YTTable");
}
}
public MainWindowViewModel()
{
YTTable = new System.Data.DataTable();
YTTable.Columns.Add(new DataColumn("PtypId", typeof(string)));
YTTable.Columns.Add(new DataColumn("UserCode", typeof(string)));
YTTable.Columns.Add(new DataColumn("FullName", typeof(string)));
this.AddCommand = new DelegateCommand(new Action(this.Add));
}

private void Add()
{
DataRow ytRow = YTTable.NewRow();
ytRow["PtypId"] = "dddd";
ytRow["UserCode"] = "eeee";
ytRow["FullName"] = "qqqqqqqq";
YTTable.Rows.Add(ytRow);
}
}
}

using System;

using System.Collections.Generic;

using System.Data;

using System.IO;

using System.Linq;

using System.Text;

using System.Text.RegularExpressions;

using System.Threading.Tasks;

using System.Windows;

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

https://blog.csdn.net/qq_37246121/article/details/79652062

namespace BtsMaster

{

public class CSVhelper

{

/// <summary>

/// 将Csv读入DataTable

/// </summary>

/// <param name="filePath">csv文件路径</param>

/// <param name="n">表示第n行是字段title,第n+1行是记录开始</param>

/// <param name="k">可选参数表示最后K行不算记录默认0</param>

public DataTable csv2dt(string filePath, int n,DataTable dt) //这个dt 是个空白的没有任何行列的DataTable

{

String csvSplitBy = "(?<=^|,)(\"(?:[^\"]|\"\")*\"|[^,]*)";

StreamReader reader = new StreamReader(filePath, System.Text.Encoding.Default, false);

int i = 0, m = 0;

reader.Peek();

while (reader.Peek() > 0)

{

m = m + 1;

string str = reader.ReadLine();

if (m >= n + 1)

{

if (m == n + 1) //如果是字段行，则自动加入字段。

{

MatchCollection mcs = Regex.Matches(str, csvSplitBy);

foreach (Match mc in mcs)

{

dt.Columns.Add(mc.Value); //增加列标题

}

else

{

MatchCollection mcs = Regex.Matches(str, "(?<=^|,)(\"(?:[^\"]|\"\")*\"|[^,]*)");

i = 0;

System.Data.DataRow dr = dt.NewRow();

foreach (Match mc in mcs)

{

dr[i] = mc.Value;

i++;

}

dt.Rows.Add(dr); //DataTable 增加一行

}

return dt;

}

}
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

https://blog.csdn.net/xinyalong/article/details/90031816
public class MainViewModel : ViewModelBase

{

public MainViewModel()

{

Messenger.Default.Register<string>(this, "MasterCommand", ExecuteMasterCmd);

MasterCmd = new RelayCommand<string>(ExecuteMasterCmd);

}

public RelayCommand<string> MasterCmd

{

get;

private set;

}