所以我正在尝试一些逻辑。进展不顺利。
目前,我的问题是在将本地XML文档读取到dataGridView中时。(LoadXmlButton_Click方法)
这是我的代码:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Xml;
namespace AddProducts_XMLForms
{
public partial class MainForm : Form
{
public MainForm()
{
InitializeComponent();
}
public DataTable dst = new DataTable();
Guid id = Guid.NewGuid();
private void Form1_Load(object sender, EventArgs e)
{
dst.Columns.Add("Artikelnummer", typeof(string));
dst.Columns.Add("Kategori", typeof(string));
dst.Columns.Add("Beskrivning", typeof(string));
dst.Columns.Add("Pris", typeof(decimal));
dst.Columns.Add("Bildadress", typeof(string));
}
private void loadXmlButton_Click(object sender, EventArgs e)
{
try
{
dst.ReadXml("products.xml");
productsDataGridView.DataSource = dst;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void exportXmlButton_Click(object sender, EventArgs e)
{
try
{
dst = (DataTable)productsDataGridView.DataSource;
dst.TableName = "Product";
dst.WriteXml("products.xml", true);
xmlExportedLabel.Text = "OK";
xmlExportedLabel.ForeColor = Color.Green;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void deleteButton_Click(object sender, EventArgs e)
{
try
{
dst.Rows.RemoveAt(productsDataGridView.CurrentCell.RowIndex);
productsDataGridView.DataSource = dst;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void addProductButton_Click_1(object sender, EventArgs e)
{
try
{
dst.Rows.Add(id.ToString(), categoryCheckListBox.SelectedItem, descriptionTextBox.Text, priceTextBox.Text, imageUrlTextBox.Text);
productsDataGridView.DataSource = dst;
foreach (int i in categoryCheckListBox.CheckedIndices)
{
categoryCheckListBox.SetItemCheckState(i, CheckState.Unchecked);
}
categoryCheckListBox.ClearSelected();
priceTextBox.Clear();
imageUrlTextBox.Clear();
descriptionTextBox.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
int i;
private void editButton_Click(object sender, EventArgs e)
{
try
{
DataGridViewRow row = productsDataGridView.Rows[i];
row.Cells[1].Value = categoryCheckListBox.SelectedItem;
row.Cells[2].Value = priceTextBox.Text;
row.Cells[3].Value = descriptionTextBox.Text;
row.Cells[4].Value = imageUrlTextBox.Text;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
它只是不会在XML中加载产品并将其放置在我想要的位置,而且我还不太擅长调试,但似乎如果在loadXmlButton_Click:中重写代码
private void loadXmlButton_Click(object sender, EventArgs e)
{
try
{
var dt = new DataSet();
dt.ReadXml("products.xml");
productsDataGridView.DataSource = dt.Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
它现在将正确加载到dataGridView中,但我的delete方法将无法工作。也许我的删除方法是主要问题?我很困惑!
private void deleteButton_Click(object sender, EventArgs e)
{
try
{
dst.Rows.RemoveAt(productsDataGridView.CurrentCell.RowIndex);
productsDataGridView.DataSource = dst;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
1)dst可能为空,从而导致异常。
2) 在触发删除事件之前,您需要选择一些单元格。错误可能是因为CurrentCell为null。
如果要将CurrentCell指定给某个对象,请使用这一行。
DataGridViewCell cell = productsDataGridView[1, 1];
productsDataGridView.CurrentCell = cell;
确保CurrentCell不为null。
if(dst.Rows.Count>0&&productsDataGridView.CurrentCell!=null)
{
try
{
dst.Rows.RemoveAt(productsDataGridView.CurrentCell.RowIndex);
productsDataGridView.DataSource = dst;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}