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; }