I made this C# program and sometimes the window freezes when i edit something in the dataGridView.
Can anybody see a mistake in my programm?
namespace WindowsFormsApp1
{
public partial class Form1 : Form
{
public ServiceReference1.Service1Client client = new ServiceReference1.Service1Client();
public int Rowindex = 0;
public int Columindex = 0;
public Form1()
{
InitializeComponent();
}
private void button4_Click(object sender, EventArgs e)
{
dataSetCD1.Clear();
sqlDataAdapter1.Fill(dataSetCD1, "CD");
dataSetCD21.Clear();
sqlDataAdapter2.Fill(dataSetCD21, "CD");
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
dataSetCD31.Clear();
sqlDataAdapter3.SelectCommand.Parameters["@YEAR"].Value = comboBox1.SelectedValue;
sqlDataAdapter3.Fill(dataSetCD31, "CD");
}
private void button2_Click(object sender, EventArgs e)
{
if(dataGridView1.SelectedRows != null)
{
foreach(DataGridViewRow dr in dataGridView1.SelectedRows)
{
dataGridView1.Rows.Remove(dr);
}
sqlDataAdapter1.Update(dataSetCD1, "CD");
}
}
private void button5_Click(object sender, EventArgs e)
{
dataSetCD1.WriteXml("Test.xml", XmlWriteMode.DiffGram);
}
public void clearDatabase()
{
sqlConnection1.Open();
SqlCommand cmd = new SqlCommand("DELETE FROM CD WHERE 1 = 1", sqlConnection1);
cmd.ExecuteNonQuery();
sqlConnection1.Close();
}
private void button3_Click(object sender, EventArgs e)
{
OpenFileDialog df = new OpenFileDialog();
if(df.ShowDialog() == DialogResult.OK)
{
dataSetCD1.Clear();
clearDatabase();
dataSetCD1.ReadXml(df.FileName);
sqlDataAdapter1.Update(dataSetCD1, "CD");
}
}
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
sqlDataAdapter1.Update(dataSetCD1, "CD");
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
Rowindex = e.RowIndex;
Columindex = e.ColumnIndex;
if(Columindex == 1)
{
axInkEdit1.Text = dataSetCD1.Tables[0].Rows[Rowindex].Field<String>("TITLE");
}else if(Columindex == 2)
{
axInkEdit1.Text = dataSetCD1.Tables[0].Rows[Rowindex].Field<String>("ARTIST");
}
else if (Columindex == 3)
{
axInkEdit1.Text = dataSetCD1.Tables[0].Rows[Rowindex].Field<String>("COUNTRY");
}
else if (Columindex == 4)
{
axInkEdit1.Text = dataSetCD1.Tables[0].Rows[Rowindex].Field<String>("COMPANY");
}
}
private void button1_Click(object sender, EventArgs e)
{
client.GetData(textBox3.Text, textBox1.Text, textBox4.Text, textBox2.Text, Convert.ToInt32(numericUpDown2.Value), Convert.ToInt32(numericUpDown1.Value));
}
private void axInkEdit1_Change(object sender, EventArgs e)
{
if (Columindex == 1)
{
dataSetCD1.Tables[0].Rows[Rowindex].SetField<String>("TITLE", axInkEdit1.Text);
}
else if (Columindex == 2)
{
dataSetCD1.Tables[0].Rows[Rowindex].SetField<String>("ARTIST", axInkEdit1.Text);
}
else if (Columindex == 3)
{
dataSetCD1.Tables[0].Rows[Rowindex].SetField<String>("COUNTRY", axInkEdit1.Text);
}
else if (Columindex == 4)
{
dataSetCD1.Tables[0].Rows[Rowindex].SetField<String>("COMPANY", axInkEdit1.Text);
}
sqlDataAdapter1.Update(dataSetCD1, "CD");
}
}
}