1
Reply

Getting IErrorInfo.GetDescription failed with E_FAIL(0x80004005). public string generateInvoi...

rimmi anand

rimmi anand

Jun 20 2012 1:36 PM
2.1k
   I want to retrieve last digits from the invoice number. I want to get value why I am getting this error. which is the keyword. I have tried [] also but it's giiving error.
public string generateInvoiceNo(string PRODUCTNAME)         {      
      try             {              
  con.Open();              
  string number;              
  OleDbDataAdapter DA1 = new OleDbDataAdapter
("SELECT Max(INVOICE_NO.SUBSTRING(9,5)+1) AS MAXINVOICE FROM PRODUCT_DETAILS", con);                
DataTable DT1 = new DataTable();              
  DA1.Fill(DT1);              
  if (DT1.Rows.Count > 0)                
{                     number = DT1.Rows[0]["MAXINVOICE"].ToString();                
}                
else            
    {                     number = "00001";                 }            
    OleDbCommand cmd2 = new OleDbCommand
("SELECT [D_NO].SUBSTRING(0,2) AS [D_NO] FROM [PRODUCT_MASTER] WHERE [PRODUCT_NAME]='" + PRODUCTNAME + "'", con);                
OleDbDataAdapter DA2 = new OleDbDataAdapter(cmd2);              
  DataTable DT2 = new DataTable();              
  DA2.Fill(DT2);                
string dno = DT2.Rows[0]["D_NO"].ToString() + System.DateTime.Today.ToString();                 return dno;             }        
    catch (Exception ex)        
    {                
MessageBox.Show(ex.Message);                
return null;            
 }          
  finally      
 {          
      con.Close();          
  }        
}

Answers (1)