http://www.tutorialspoint.com/mysql/mysql- using-sequences.htm [ ^ 一>

Dear Frnds,

I have generate autogen id using mysql.. but not accept the charindex function.. please tell other method for autogen. following code..

<pre lang="xml">//MySqlCommand com = new MySqlCommand("SELECT  isnull(Max(cast(substring(Reg_No,charindex('-',Reg_No)+1,len(Reg_No)) as int)),0)+1 FROM In_Patients", conn);
MySqlCommand com = new MySqlCommand(&quot;SELECT  Max(Reg_No) FROM In_Patients&quot;, conn);
conn.Open();
Int32 no = Int32.Parse(com.ExecuteScalar().ToString()) + 1;
conn.Close();
string RNo = &quot;REG&quot; + DateTime.Now.Year + DateTime.Now.ToString(&quot;MM&quot;) + DateTime.Now.ToString(&quot;dd&quot;) + &quot;-&quot; + String.Format(&quot;{0:000}&quot;, no);
txtRegNo.Text = RNo;</pre>

With Regards,
Vino

http://www.tutorialspoint.com/mysql/mysql-using-sequences.htm[^]