Net Core教程

C#-Winform-DataGridView-CSV

本文主要是介绍C#-Winform-DataGridView-CSV,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

C#-Winform-DataGridView-CSV

一、界面搭建

image

二、DataGridView基本属性

image

编辑列的选项中可以进行设计:

  • ColumnType:设计列的类型
    • DataGridViewTextBoxColumn:文本内容
    • DataGridViewCheckBoxColumn:勾选框内容
    • DataGridViewComboBoxColumn:下拉选框内容
    • DataGridViewImageColumn:图片格式内容
    • DataGridViewLinkColumn:链接
  • Name
  • HeaderText

基本属性:

image

  • 只读属性设定:datagridview.ReadOnly = True

  • 行自动追加:datagridview.AllowUserToAddRows = False

  • 删除行允许:datagridview.AllowUserToDeleteRows = False

  • 行幅设置:

    datagridview.AllowUserToResizeRows = False
    datagridview.ColumnHeadersHeightSizeMode =DataGridViewColumnHeadersHeightSizeMode.DisableResizing
    
  • 行表示:datagridview.RowHeadersVisible = False

  • 行选择模式:datagridview.SelectionMode = DataGridViewSelectionMode.FullRowSelect

  • 复数行选择:datagridview.MultiSelect = True

  • 选择状态解除:datagridview.ClearSelection()

  • 文字设置位置:datagridview.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter

  • 选择后行的颜色:datagridview.DefaultCellStyle.SelectionBackColor = Color.GreenYellow datagridview.DefaultCellStyle.SelectionForeColor = Color.Black

  • 行幅自动调整:datagridview.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill

三、DataGridView和CSV

3.1 初始化数据

//初始化数据
private void btnInitData_Click(object sender, EventArgs e)
{
    string[] strID = new string[] {"1", "2", "3", "4", "5"};
    string[] strName = new string[] {"赵一", "钱二", "孙三", "李四", "周五"};
    string[] strAddress = new string[] {"黑龙江", "江苏", "西藏", "新疆", "内蒙古"};
    string[] strPhone = new string[] { "86-451", "86-025	", "0891", "0995", "0477" };

    gridTestData.Rows.Add(5);
    for (int i = 0; i < gridTestData.Rows.Count; i++)
    {
        gridTestData.Rows[i].Cells[0].Value = strID[i];
        gridTestData.Rows[i].Cells[1].Value = strName[i];
        gridTestData.Rows[i].Cells[2].Value = strAddress[i];
        gridTestData.Rows[i].Cells[3].Value = strPhone[i];

    }
}

image

3.2 导出为CSV文件

//保存数据到csv文件
private void btnSaveToCSV_Click(object sender, EventArgs e)
{
    //实例化SaveFileDialog
    SaveFileDialog saveFileDialog = new SaveFileDialog();
    saveFileDialog.Filter = "Execl files (*.csv)|*.csv";
    saveFileDialog.FilterIndex = 0;
    saveFileDialog.RestoreDirectory = true;
    saveFileDialog.CreatePrompt = true;
    saveFileDialog.Title = "保存为csv文件";

    //打开SaveFileDialog控件
    if (saveFileDialog.ShowDialog() == DialogResult.OK)
    {
        //数据流变量
        Stream myStream;
        //返回SaveFileDialog控件,并将所选择的文件转化成流
        myStream = saveFileDialog.OpenFile();
        //将选择的文件流生成写入流
        StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
        string columnTitle = "";
        try
        {
            //写入列标题
            for (int i = 0; i < gridTestData.ColumnCount; i++)
            {
                if (i > 0)
                {
                    columnTitle += ",";
                }
                columnTitle += gridTestData.Columns[i].HeaderText;
            }
            //将内容写入文件流中
            sw.WriteLine(columnTitle);

            for (int j = 0; j < gridTestData.Rows.Count; j++)
            {
                string columnValue = "";
                for (int k = 0; k < gridTestData.Columns.Count; k++)
                {
                    if (k > 0)
                    {
                        columnValue += ",";
                    }
                    if (gridTestData.Rows[j].Cells[k].Value == null)
                    {
                        columnValue += "";
                    }
                    else if (gridTestData.Rows[j].Cells[k].Value.ToString().Contains(","))
                    {
                        //将单元个中的,转义成文本
                        columnValue += "\"" + gridTestData.Rows[j].Cells[k].Value.ToString().Trim() + "\"";
                    }
                    else
                    {
                        //横向跳格
                        columnValue += gridTestData.Rows[j].Cells[k].Value.ToString().Trim() + "\t";
                    }
                }
                //内容写入文件流中
                sw.WriteLine(columnValue);
            }
            sw.Close();
            myStream.Close();
            MessageBox.Show("导出表格成功!");
        }
        catch (Exception)
        {
            MessageBox.Show("导出表格失败!");
        }
        finally
        {
            sw.Close();
            myStream.Close();
        }
    }
    else
    {
        MessageBox.Show("取消导出表格操作!");
    }
}

image

3.3 导入CSV文件

  • 定义csv文件的实体类:
public class CSVExample
{
    public string id;
    public string name;
    public string address;
    public string phone;

    public static CSVExample FromCsv(string csvContent)
    {
        string[] values = csvContent.Split(',');
        CSVExample example = new CSVExample();
        example.id = values[0];
        example.name = values[1];
        example.address = values[2];
        example.phone = values[3];

        return example;
    }
}
  • 具体实现
//将csv文件转成list,并绑定到DataGridView组件上
private void btnCSVToGrid_Click(object sender, EventArgs e)
{
    //实例化SaveFileDialog
    OpenFileDialog openFileDialog = new OpenFileDialog();
    openFileDialog.Filter = "Execl files (*.csv)|*.csv";
    openFileDialog.FilterIndex = 0;
    openFileDialog.RestoreDirectory = true;
    openFileDialog.Title = "打开的文件";

    //打开SaveFileDialog控件
    if (openFileDialog.ShowDialog() == DialogResult.OK)
    {
        string path = Path.GetFullPath(openFileDialog.FileName);
        //MessageBox.Show(path);
        List<CSVExample> values = File.ReadAllLines(path, System.Text.Encoding.GetEncoding(-0))
            .Skip(1)
            .Select(v => CSVExample.FromCsv(v))
            .ToList();
        //MessageBox.Show(values.Count.ToString());
        gridTestWrite.Rows.Add(values.Count);
        for (int i = 0; i < values.Count; i++)
        {
            gridTestWrite.Rows[i].Cells[0].Value = values[i].id + ".csv";
            gridTestWrite.Rows[i].Cells[1].Value = values[i].name + ".csv";
            gridTestWrite.Rows[i].Cells[2].Value = values[i].address + ".csv";
            gridTestWrite.Rows[i].Cells[3].Value = values[i].phone + ".csv";



        }
    }
}

image

这篇关于C#-Winform-DataGridView-CSV的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!