，MyConnection ）;
// MyCommand.TableMappings.Add（Name，Path） ;
// DtSet = new System.Data.DataSet（）;
// MyCommand.Fill（DtSet）;
// dataGridView1.DataSource = DtSet.Tables [0];
// MyConnection.Close（）;
// dataGridView1.Columns [0] .Width = 300;
// dataGridView1.Columns [1] .Width = 45 0;
}

private void dataGridView1_CellMouseClick （ object sender，DataGridViewCellMouseEventArgs e）
{

foreach （ DataGridViewRow行 in dataGridView1.SelectedRows）
{
sName = row.Cells [ 0 ] Value.ToString（）;
sPath = row.Cells [ 1 ]。Value.ToString（）;


}
}

private void BtnBrowse_Click（ object sender，EventArgs e）
{
fbd.ShowDialog（）;
TxtBrowsepath.Text = fbd.SelectedPath;
}

private void BtnCreate_Click（ object sender，EventArgs e）
{
richTextBox1.Text = 跨度>;
StreamWriter file = new StreamWriter（ Export .BAT跨度>）;
file.WriteLine（ c：）;
file.WriteLine（ cd \\）;
file.WriteLine（ cd Program Files）;
file.WriteLine（ cd VMware）;
file.WriteLine（ cd VMware OVF Tool）;

foreach （DataGridViewRow row in dataGridView1.SelectedRows）
{
sName = row.Cells [ 0 ]。Value.ToString（）;
sPath = row.Cells [ 1 ]。Value.ToString（）;

// richTextBox1.Text = richTextBox1.Text + Environment.NewLine + sName;
file.WriteLine（ start ovftool.exe --powerOffSource vi：// + TxtUsername.Text + ： + TxtPassword.Text + @ + TxtIP.Text + sPath + + \ + TxtBrowsepath.Text + \\ + sName + \\ + sName + 。ovf + \ + Environment.NewLine）;


}
file.WriteLine（ pause跨度>）;
file.Close（）;
}

private void BtnClose_Click（ object sender，EventArgs e）
{
this .Close（）;
}

}

}

", MyConnection); // MyCommand.TableMappings.Add("Name", "Path"); //DtSet = new System.Data.DataSet(); //MyCommand.Fill(DtSet); //dataGridView1.DataSource = DtSet.Tables[0]; //MyConnection.Close(); //dataGridView1.Columns[0].Width = 300; //dataGridView1.Columns[1].Width = 450; } private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e) { foreach (DataGridViewRow row in dataGridView1.SelectedRows) { sName = row.Cells[0].Value.ToString(); sPath = row.Cells[1].Value.ToString(); } } private void BtnBrowse_Click(object sender, EventArgs e) { fbd.ShowDialog(); TxtBrowsepath.Text = fbd.SelectedPath; } private void BtnCreate_Click(object sender, EventArgs e) { richTextBox1.Text = ""; StreamWriter file = new StreamWriter("Export.bat"); file.WriteLine("c: "); file.WriteLine("cd \\"); file.WriteLine("cd Program Files " ); file.WriteLine("cd VMware" ); file.WriteLine("cd VMware OVF Tool" ); foreach (DataGridViewRow row in dataGridView1.SelectedRows) { sName = row.Cells[0].Value.ToString(); sPath = row.Cells[1].Value.ToString(); //richTextBox1.Text = richTextBox1.Text + Environment.NewLine + sName; file.WriteLine("start ovftool.exe --powerOffSource vi://"+TxtUsername.Text + ":" + TxtPassword.Text + "@"+ TxtIP.Text + sPath + " " + "\"" + TxtBrowsepath.Text + "\\" + sName + "\\"+ sName + ".ovf" + "\"" + Environment.NewLine); } file.WriteLine("pause"); file.Close(); } private void BtnClose_Click(object sender, EventArgs e) { this.Close(); } } }

我使用过这样的解决方案，我希望这对您有用。

将文本和CSV文件中的数据导入DataGridView

第1步：首先我将代码放在按钮点击事件中，这将在您的计算机中浏览.csv，您可以更改为加载功能。

I have used solution like this, i hope this will work for you.
Import Data from Text and CSV file to DataGridView
STEP 1 : First i put the code in Button click event this will Browse your .csv in your computer, you can change to load function.

OpenFileDialog fdlg = new OpenFileDialog();
    fdlg.Title = "Select file";
    fdlg.InitialDirectory = @"c:\";
    fdlg.FileName = txtFileName.Text;
    fdlg.Filter = "Text and CSV Files(*.txt, *.csv)|*.txt;*.csv|Text Files(*.txt)|*.txt|CSV Files(*.csv)|*.csv|All Files(*.*)|*.*";
    fdlg.FilterIndex = 1;
    fdlg.RestoreDirectory = true;
    if (fdlg.ShowDialog() == DialogResult.OK)
    {
        txtFileName.Text = fdlg.FileName;
        Import();
        Application.DoEvents();
    }

第2步：创建导入功能（），用于第1步

STEP 2 : Create Import function(), this used in STEP 1

if (txtFileName.Text.Trim() != string.Empty)
{
    try
    {
        DataTable dt = GetDataTable(txtFileName.Text);
        dataGridView1.DataSource = dt.DefaultView;
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message.ToString());
    }
}

第3步：创建像从数据集中的文件数据返回值。

STEP 3 : Create something like return value from file data in a dataset.

public static DataTable GetDataTable(string strFileName)
{
    ADODB.Connection oConn = new ADODB.Connection();
    oConn.Open("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + System.IO.Path.GetDirectoryName(strFileName) + "; Extended Properties = \"Text;HDR=YES;FMT=Delimited\";", "", "", 0);
    string strQuery = "SELECT * FROM [" + System.IO.Path.GetFileName(strFileName) + "]";
    ADODB.Recordset rs = new ADODB.Recordset();
    System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter();
    DataTable dt = new DataTable();
    rs.Open(strQuery, "Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + System.IO.Path.GetDirectoryName(strFileName) + "; Extended Properties = \"Text;HDR=YES;FMT=Delimited\";",
        ADODB.CursorTypeEnum.adOpenForwardOnly, ADODB.LockTypeEnum.adLockReadOnly, 1);
    adapter.Fill(dt, rs);
    return dt;
}

注意：如果您有任何错误请尝试将目标平台设置为X86 您的申请