Help to convert Microsoft.VisualBasic.Right to C# code

Question

I have vb.net code, i try the code to C#. But microsoft.visualbasic.right not found in C# code. I don't know how to convert that. Can you help me to convert this code?   This is vb.net code Sub Autonumber()           'Koneksi()              Dim _Urutan As String           Dim _Hitung, _Cari As Long              CMD = New OdbcCommand( "Select * from data where kode in "  &                                             "(select max(kode) from data)" , CONN)           RD = CMD.ExecuteReader           RD.Read()           If Not RD.HasRows Then               _Urutan =  "K"  &  "001"            Else               _Cari = Microsoft.VisualBasic.Right(RD.GetString(0), 3)               If Microsoft.VisualBasic.Left(RD.GetString(0), 1) <>  "K"  Then                   _Urutan =  "K"  &  "001"                Else                   _Hitung = Microsoft.VisualBasic.Right(RD.GetString(0), 3) + 1                   _Urutan =  "K"  & Microsoft.VisualBasic.Right( "000"  & _Hitung, 3)               End If           End If           RD.Close()           txtCode.Text = _Urutan       End Sub   This in c# code  public   void  Autonumber()           {                string  _Urutan;                long  _Hitung, _Cari;               CMD =  new  OdbcCommand( "Select * from data where kode in "  +  "(select max(kode) from data)" , CONN);               RD = CMD.ExecuteReader();               RD.Read();                if  (!RD.HasRows)               {                   _Urutan =  "K"  +  "001" ;               }                else                {                   _Cari = Microsoft.VisualBasic.Right(RD.GetString(0), 3);                    if  (Microsoft.VisualBasic.Left(RD.GetString(0), 1) !=  "K" )                   {                       _Urutan =  "K"  +  "001" ;                   }                    else                    {                       _Hitung = Microsoft.VisualBasic.Right(RD.GetString(0), 3) + 1;                       _Urutan =  "K"  + Microsoft.VisualBasic.Right( "000"  + _Hitung, 3);                   }               }                  RD.Close();               txtCode.Text = _Urutan;           }

Nitin Sontakke · Answer

Right and Left are just wrapper functions on top of SubString. You can achieve the same result from SubString.   If you just have a look at the code and the developer is trying to achieve, so far as result is same, functions actually don't matter. Essentially if number is 1 expected result is 001, if number is 15, expected result is 015 and if number is 115 it should be 115.   You can achieve it just by:  Int32 intNumber = 15   String strNumber = intNumber.ToString( "000" );   Simple.   Also, in your code, what is the meaning of writing _Urutan = "K" + "001"; Instead of that can you not just _Urutan = "K001"; Why code look like complicated when it is not?

Laxmidhar Sahoo · Answer

Hi nitin
You are currect

Laxmidhar Sahoo · Answer

int Len = RD.Get string(0);
String s = RD.GetString(0).substring(Len-3);