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