SQLServer Express Edition
-
I am using VS2005 with SQLServer Express Edition. Select SQL statement work fine but not Insert or update. Is there something am doing wrong? Sample insert code. DataSet.DatabaseDataSetTableAdapters.SaleTransactionTableTableAdapter SaleTransAdapter = new DataSet.DatabaseDataSetTableAdapters.SaleTransactionTableTableAdapter(); SaleTransAdapter.Insert(7, (decimal)NetTotal, DateTime.Now);
Nana
-
I am using VS2005 with SQLServer Express Edition. Select SQL statement work fine but not Insert or update. Is there something am doing wrong? Sample insert code. DataSet.DatabaseDataSetTableAdapters.SaleTransactionTableTableAdapter SaleTransAdapter = new DataSet.DatabaseDataSetTableAdapters.SaleTransactionTableTableAdapter(); SaleTransAdapter.Insert(7, (decimal)NetTotal, DateTime.Now);
Nana
i add the same problem with i think. the problem is when you create the DB, it make a copy of it in your bin/debug forder and every update are in this DB the one you create is the basic one and every time you run the debugger, he takes all the info in the basic one to overwrite the bin/debug one but the screen result show you the bin/debug DB. so, it look like the add you made are not working in your db explorer, create a new connection and link it to the bin/debug one then when you add something, check in this one hope it help you ! have a good one ;)
-
I am using VS2005 with SQLServer Express Edition. Select SQL statement work fine but not Insert or update. Is there something am doing wrong? Sample insert code. DataSet.DatabaseDataSetTableAdapters.SaleTransactionTableTableAdapter SaleTransAdapter = new DataSet.DatabaseDataSetTableAdapters.SaleTransactionTableTableAdapter(); SaleTransAdapter.Insert(7, (decimal)NetTotal, DateTime.Now);
Nana
You need to set insert and update commands
-
i add the same problem with i think. the problem is when you create the DB, it make a copy of it in your bin/debug forder and every update are in this DB the one you create is the basic one and every time you run the debugger, he takes all the info in the basic one to overwrite the bin/debug one but the screen result show you the bin/debug DB. so, it look like the add you made are not working in your db explorer, create a new connection and link it to the bin/debug one then when you add something, check in this one hope it help you ! have a good one ;)
Thank you for your help. I am afraid to say its still not working. Only select statements work after i have manually populated the database. Insert and updates still don't. i added a connection to the copy in the debug. It also has the same data as the one in the local folder. Insert still not working on that one too. I will appreciate anymore suggestions
Nana
-
i add the same problem with i think. the problem is when you create the DB, it make a copy of it in your bin/debug forder and every update are in this DB the one you create is the basic one and every time you run the debugger, he takes all the info in the basic one to overwrite the bin/debug one but the screen result show you the bin/debug DB. so, it look like the add you made are not working in your db explorer, create a new connection and link it to the bin/debug one then when you add something, check in this one hope it help you ! have a good one ;)
Well thanks for your suggestion. I tried it and its still not working. Insert and update statement do not work on the database cope in the debug directory too. The select statement works if i populate the database manually. I create insert and update commands to no success. I will appreciate anymore sugestions. Thanks
Nana
-
You need to set insert and update commands
Well thanks for your suggestion. I tried it and its still not working. Insert and update statement do not work on the database cope in the debug directory too. The select statement works if i populate the database manually. I create insert and update commands to no success. I will appreciate anymore sugestions. Thanks
Nana