How to Stop DataGrid on Adding Rows?
<p>This is my Method:</p>

<p>Datatable data2 = new Datatable();
    int result = 0;
                using (SqlConnection conn = new SqlConnection(connStr))
                {
                    try
                    {
                        SqlCommand cmd = new SqlCommand();
                        cmd.Connection = conn;
                        conn.Open();
                        cmd.CommandText = "SELECT * from TableA";
                        SqlDataAdapter da = new SqlDataAdapter(cmd);
                        result = da.Fill(data2);</p>

<pre><code>                    if (result &gt; 0)
                    {
                        this.dgBatch.DataSource = data2;
                    }
                    else
                    {
                        MessageBox.Show("No Records!");
                    }

                }
                catch (Exception ee)
                {
                    MessageBox.Show(ee.Message);
                }
                finally
                {
                    if (conn.State == ConnectionState.Open) conn.Close();
                }


            }
</code></pre>

<p>If i call this Method consecutively it always Add Rows from the first Query.</p>

<pre><code>Ex:

Table Data: 5

First Call: 5

Second Call: 10 . it duplicate all Records  from first Call.
</code></pre>

<p>Thanks in Regards</p>
