Converting MS SQL Database to MySQL

                         If you want to Convert your sql server database tables, stroed procs, functions etc 

to Mysql ,you can use this tool . Here is the URL

http://www.ispirer.com/products/sql-server-to-mysql-migration

You can either use free evaluation or can purchase. You need to register before downloading the tool.

Alpha Numeric Auto Increment in .net

Alpha Numeric Increment in .net

       private void button1_Click(object sender, System.EventArgs e)

              {

                     label1.Text = NxtKeyCode( textBox1.Text );

                     textBox1.Text =label1.Text;

              }

              public string NxtKeyCode(string KeyCode)

              {

                     byte[] ASCIIValues = ASCIIEncoding.ASCII.GetBytes(KeyCode) ;

                     int StringLength = ASCIIValues.Length ;

                     bool isAllZed = true;

                     bool isAllNine = true;

                     //Check if all has ZZZ.... then do nothing just return empty string.

                     for(int i =0; i < StringLength-1; i++)

                     {

                           if(ASCIIValues[i] != 90)

                           {

                                  isAllZed  = false;  

                                  break;

                           }

                     }

                     if(isAllZed && ASCIIValues[StringLength-1] == 57)

                     {

                     ASCIIValues[StringLength-1] = 64;

                     }

                    

                     // Check if all has 999... then make it A0

                     for(int i =0; i < StringLength; i++)

                     {

                           if(ASCIIValues[i] != 57)

                           {

                                  isAllNine = false;  

                                  break;

                           }

                     }

                     if(isAllNine)

                     {

                     ASCIIValues[StringLength-1] = 47;

                     ASCIIValues[0] = 65;

                     for(int i =1; i < StringLength-1; i++)

                     {

                     ASCIIValues[i] = 48;

                     }

                     }

                    

                     for(int i = StringLength; i>0; i--)

                     {

                           if(i-StringLength == 0)

                           {

                                  ASCIIValues[i-1] +=1;

                           }

                           if(ASCIIValues[i-1] == 58)

                           {

                                  ASCIIValues[i-1] = 48;

                                  if(i-2 ==-1)

                                  {

                                         break;

                                  }

                                  ASCIIValues[i-2] += 1;

                           }

                           else if(ASCIIValues[i-1] == 91)

                           {

                                  ASCIIValues[i-1] = 65;

                                  if(i-2 ==-1)

                                  {

                                         break;

                                  }

                                  ASCIIValues[i-2] += 1;

                    

                           }

                           else

                           {

                                  break;

                           }

                    

                     }     

                     KeyCode = ASCIIEncoding.ASCII.GetString(ASCIIValues);

                     return KeyCode;

              }

              public string NxtKeyCod(string KeyCode)

              {

                     //int startint = KeyCode.IndexOf("0123456789",0,1);

                     StringBuilder sb = new StringBuilder();

                     //Regex digitregex = new Regex("^[A-Z])");

                     //KeyCode = digitregex.Replace(KeyCode, "");

             

                     return KeyCode;

              }

DESIGN

OUTPUT

Click Here TO Download Alpha Numeric Auto Increment in .net exe