hello.. thanks for your replies.. what i am trying to do is that i have a mysql table.. which have several fields in it. including a primary key named SERIES that auto increments. so what i did is that i create a datasource from the Data Menu -> Add New Data Source. after that, i directly drag the datasource into my form and it automatically generates a datagridview and a bindingnavigator wherein i could manipulate the records. the problem is when i add a record and didnt place a value in the series field then it creates an error. it says the series field doesnt accept a null value. i dont want to place a value on the series field since i want the mysql database to generate it for me.. i hope i explained it fully for all of you to understand. i am still a newbie at c# so i am trying the auto code generation prowess of c#. is this a good thing? or it is still best to create your own code and not rely on the auto code generation of c#? please help.. thanks.