I used the below code
private void form_Load(object sender, EventArgs e)
strSql=”update tbl set fldName=’AAA’”;
cmd=new sqlCommand(strSql, conn);
So I changed my code and used button_Click instead of form_load and I was able to insert many rows. But when I close the application and open it again the previous data disappeared like that if I am using blank database.
What I understand that the application creates a copy of the .mdf file while it is running and after closing the application it overwrite the original .mdf file
how to overcome this because I need to use it as database with historical data
Thanks for your time