How to get last code from column in table

To get the last code from table in mysql , example we want to show last id from idcustomer to textbox , the code is below

Private void Form1_load(Object sender, EventArgs e){

string connection = “Server=servername;user=username;database=dbsales”;
string kode;
int iNumber,iHasil;
MysqlConnection conn = New MysqlConnection();
MysqlReader reader ;
MysqlCommand comm = New MysqlCommand();
conn = New MysqlConnection(connection);
conn.Open();
comm = con.CreateCommand();
comm.CommandText = “Select id from idcustomer;”;
reader.ExecuteReader();
while (Reader.read()){
kode = Reader.GetString(“idcustomer”);
iNumber = Convert.ToInt32(kode);
iHasil = iNumber + 1;
Textbox1.Text = iHasil.ToString;
}
conn.Close();
}

Leave a Reply