Bind duplicate rows in Dataset once
<p>I am merging two datasets and I wish that duplicate rows are only bind once ,how can I achieve this ?</p>

<pre><code> protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
    showRelatedcat();
    DataSet ds = new DataSet();
    DataSet ds_frd = new DataSet();
    String frdQuery = my query
    String newquery = my other query 
    String queryString = another one 
    try
    {
        // Connect to the database and run the query.
        SqlConnection connection = new SqlConnection(connectionString);
        SqlDataAdapter adapter = new SqlDataAdapter(newquery, connection);
        SqlDataAdapter adapter1 = new SqlDataAdapter(frdQuery, connection);
        // Fill the DataSet.
        adapter1.Fill(ds_frd);
        adapter.Fill(ds);
        ds.Merge(ds_frd, true);
        connection.Close();
    }
    catch (Exception ex)
    {

        // The connection failed. Display an error message.
        //Message.Text = "Unable to connect to the database.";

    }



    RadGrid1.DataSource = ds.Tables[0].;


}
</code></pre>

<p>both queries have some rows as common .</p>
