<div>
<div class="content wysiwyg-content">
Hi i do encounter is error &quot;Function sms_rpt.IDENT_CURRENT does not exit.&quot; 
 
 
private void LastRowNo() 
&nbsp; &nbsp; &nbsp; &nbsp; { 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; InitialRecord = LastRecord; 
 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string cmd = &quot;Select IDENT_CURRENT('mastersmsdb')&quot;; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myconint.Open(); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlCommand checkcmd = new MySqlCommand(cmd, myconint); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LastRecord = Convert.ToInt32(checkcmd.ExecuteScalar()); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;// &lt;--- error point over here. 
 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (myconint.State == ConnectionState.Open) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myconint.Close(); 
 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lblSSNewRecord.Text = &quot;New Incoming Record :&quot; + Convert.ToString(LastRecord - InitialRecord ); 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lblSSExistingRecord.Text = &quot;Existing Record : &quot;&nbsp;+ Convert.ToString(InitialRecord );
</div>
</div>

Hi i do encounter is error "Function sms_rpt.IDENT_CURRENT does not exit."


private void LastRowNo()
 {
 InitialRecord = LastRecord;

 string cmd = "Select IDENT_CURRENT('mastersmsdb')";
 myconint.Open();
 MySqlCommand checkcmd = new MySqlCommand(cmd, myconint);
 LastRecord = Convert.ToInt32(checkcmd.ExecuteScalar()); // <--- error point over here.

 if (myconint.State == ConnectionState.Open)
 myconint.Close();

 lblSSNewRecord.Text = "New Incoming Record :" + Convert.ToString(LastRecord - InitialRecord );
 lblSSExistingRecord.Text = "Existing Record : " + Convert.ToString(InitialRecord );

Function sms_rpt.IDENT_CURRENT does not exit.

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.