retriving data from SQL database to C#.Net

See more:

C#

Hi All,
I am using C# .net where I have to retrieve serial number from SQL database which is like A23 but I need only 23 below I am give code, here GenerateKey() is the function which hold the value

public string GenerateKey()
   {
       int data = 0;
       string id = "";
       string str = "select billno from tblEditBill"; //table name tblEditBill
       OdbcCommand cmd;
       cmd = new OdbcCommand(str, conn);
       OdbcDataReader dr;
       dr = cmd.ExecuteReader();
       while (dr.Read() != false)
       {
           data = Convert.ToInt32(dr.GetString(0));

       }
       try
       {

           int newid = Convert.ToInt32(data);
           //Int32.Parse(data);
           id = Convert.ToString(newid + 1);

       }
       catch (Exception ex)
       {
           MessageBox.Show(ex.Message + ex.Source);
       }

       return id.ToString();
   }

If it is possible please help.Thanks to All.

Thanks & Regards
Indrajit

---

Update
Hello Friend You Can also manually remove your character from your string like this and use the remaining character to convert it into integer to use them

protected string GetInteger(string s)
{
      string str = s;
      string newStr = "";// string newStr = string.Empty;
      for (int i = 0; i < str.Length; i++)
      {
         // here i will check for the ascii value to match with 0123456789 then it will add to new string
          if (Convert.ToInt32(str[i]) > 47 && Convert.ToInt32(str[i]) < 58)
          {
             newStr += str[i];
          }
      }
     // now new gentrated string will be returned
     return newStr;
}