Mine

   public static DataSet TaxExemptNum_Get(int CompNo, string CustID)
            {
            m_objDs = new DataSet();
            DataTable dtCat = new DataTable();
            DataRow drCat;

            dtCat.Columns.Add( "CompanyID", typeof( string ) );    // 0 
            dtCat.Columns.Add( "CustomerID", typeof( string ) );    //1
            dtCat.Columns.Add( "TaxDetailID", typeof( string ) );    // 2 
            dtCat.Columns.Add( "TaxName", typeof( string ) );    // 3
            dtCat.Columns.Add( "TaxExemptNo", typeof( string ) );    // 4

            try
                {
                c_TLK.TableSelect( "CutomersTaxExempt",
                                                "CompanyID = " + "'" + CompNo + "'" + " ) AND ( " + "CustomerID = " + "'" + CustID + "'",
                                                "CompanyID, CustomerID, TaxDetailID ",
                                                " CompanyID, CustomerID, TaxDetailID, TaxName, TaxExemptNo"
                                                        );
                SqlDataReader oRdtg = c_TLK.TLSql.ExecuteReader( CommandBehavior.CloseConnection );
                if( oRdtg.HasRows )
                    {
                    while( oRdtg.Read() )
                        {
                        drCat = dtCat.NewRow();

                        drCat[ 0 ] = oRdtg[ 0 ].ToString();
                        drCat[ 1 ] = oRdtg[ 1 ].ToString();
                        drCat[ 2 ] = oRdtg[ 2 ].ToString();
                        drCat[ 3 ] = oRdtg[ 3 ].ToString();
                        drCat[ 4 ] = oRdtg[ 4 ].ToString();
                        dtCat.Rows.Add( drCat );
                        }
                    }
                oRdtg.Close();
                }
            catch( SqlException ex )
                {
                MessageBox.Show( "Database error has occurred: " + ex.ToString() );
                //System.Diagnostics.Debug.WriteLine( ex.ToString() );
                }
            m_objDs.Tables.Add( dtCat );

            return objDs;
            }