datagridview data populated multiple times in a same row
<p>i have this below code</p>

<pre><code> private void tbnFillgrid_Click(object sender, EventArgs e)
    {
        try
        {

            string sql = "select ID,MessageID,Type,Sender,Received,Transformed from tbltraceMessages";
            SqlConnection connection = new SqlConnection(CONNECTION_STRING);
            dataadapter = new SqlDataAdapter(sql, connection);
            ds = new DataSet();
            connection.Open();
            dataadapter.Fill(ds, "tbltraceMessages");
            connection.Close();
            dgMessages.DataSource = ds;
            dgMessages.DataMember = "tbltraceMessages";
            dgMessages.Columns["clmSender"].DataPropertyName = "Sender";
            dgMessages.Columns["clmType"].DataPropertyName = "Type";
            dgMessages.Columns["clmNo"].DataPropertyName = "ID";
            dgMessages.Columns["clmCreated"].DataPropertyName = "Received";
            dgMessages.Columns["clmSaved"].DataPropertyName = "Transformed";
            dgMessages.Columns["clmMessageId"].DataPropertyName = "MessageID";
</code></pre>

<p>It suppose to fill the row one time but if fills twice in a same row<img src="http://i.stack.imgur.com/eBAUr.png" alt="Multiple times">,am not sure what am missing in my code or design, Any help please</p>

<p>I suppose to see in my grid is </p>

<p>ID MessageID TYPE SENDER Created Saved (those extra columns ID,MessageID etc,shouldn''t be there)</p>
