How I can reload my dataGridView ?

[ANIRCK]

http://social.msdn.microsoft.com/Forums/windows/en-US/ff091d1a-c446-472f-b51e-37f2b9cd3b54/how-i-can-refresh-my-datagridview-from-another-form?referrer=http://social.msdn.microsoft.com/Forums/windows/en-US/ff091d1a-c446-472f-b51e-37f2b9cd3b54/how-i-can-refresh-my-datagridview-from-another-form?referrer=http://social.msdn.microsoft.com/Forums/windows/en-US/ff091d1a-c446-472f-b51e-37f2b9cd3b54/how-i-can-refresh-my-datagridview-from-another-form

In this link there is a code. It works fine when I use sql server.

But I used MS- access database. Then it will not working.


public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public static SqlConnection getc()
{
string sqlstr = "Data Source=.;Initial Catalog=pp1;Integrated Security=True";
SqlConnection conn = new SqlConnection(sqlstr);
return conn;
}
private DataTable GetData()
{
DataTable dt = new DataTable();
using (SqlConnection conn = getc())
{
SqlCommand cmd = new SqlCommand("select * from dgv", conn);
conn.Open();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
dt = ds.Tables[0];
return dt;
}

}

private void Form1_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = GetData();
}

private void button1_Click(object sender, EventArgs e)
{
Form2 fm = new Form2();
fm.RefreshDgv += new Form2.DoEvent(fm_RefreshDgv);
fm.Show();
}

void fm_RefreshDgv(string a, string b, string c)
{
using (SqlConnection conn = getc())
{
SqlCommand cmd = new SqlCommand("insert into dgv values(@a,@b,@c)", conn);
cmd.Parameters.AddWithValue("@a", a);
cmd.Parameters.AddWithValue("@b", b);
cmd.Parameters.AddWithValue("@c", c);
conn.Open();
cmd.ExecuteNonQuery();
dataGridView1.DataSource = GetData();
}

}
}

Continue reading...