I am new bee in vb 2005.
My probelm is i fail to merge the dataset and the error from the merging is catch in the try catch but the messagebos does not prompt out as coded.My coding is as follow:

[Code
Private mdsAdditionalPJS As New DataSet()
Private mdsPaperCode As New DataSet()


Try
If txtJobNo.Text <> "" And e.KeyChar = Chr(13) Then
cmd = New MySqlCommand("SELECT * FROM prodjof WHERE ProdJobNo=?ProdJobNo ", conn)
cmd.Parameters.Add("?ProdJobNo", MySqlDbType.VarChar) 'Access the id datafield
cmd.Parameters("?ProdJobNo").Value = txtJobNo.Text.Trim
da.SelectCommand = cmd
da.Fill(mdsAdditionalPJS)
a = mdsAdditionalPJS.Tables(0).Rows.Count
mdsPaperCode.merge(mdsAdditionalPJS)
End If

Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
[/Code]


Does anyone has idea on this?