Dear in order to insert a new record you have to create a new id by fetching the max(ID) from the mysql table and adding one increment to it like for example:-
DAL.ExecuteNonQuery("insert into [table] (id,name,...) values (getMaxID(),'Vishnu',..))");
where DAL is the data access layer for SQL Server & .net and getMaxID() is the method which will return the max id for insertion of new record i.e.,
return int ID = DAL.ExecuteScalar("select max(id) from [table]");
I hope this example will help you out to understand how to insert new record.