I can't update the data base
-
i beleive i am using the right code .. but nothing happens to the database when i am insert or update or delete only select statement running. ********CODE******* conn.open() sql="insert into table values("","")" dbcommand(sql, conn) dbcommand.ExecuteNonQuery() conn.close() *******************
-
i beleive i am using the right code .. but nothing happens to the database when i am insert or update or delete only select statement running. ********CODE******* conn.open() sql="insert into table values("","")" dbcommand(sql, conn) dbcommand.ExecuteNonQuery() conn.close() *******************
Hai, The following checks may help you to trace out the problem 1)Please check your connection(connectionstring),so that it is connecting to the database(Debug/ use try-catch). 2)Check you are having enough permission to execute the command. 3)Similarly use,
Dim myCommand as SqlCommand myCommand=New SqlCommand(sql,conn) myCommand.ExecuteNonQuery()4)Check your T-Sql queries are working fine(Execute in Query Analyzer) If every above cases are fine,It should work. More confidently, "It will work". Thank You, Rahul.P.Menon "Different Thinking makes people differ" -
i beleive i am using the right code .. but nothing happens to the database when i am insert or update or delete only select statement running. ********CODE******* conn.open() sql="insert into table values("","")" dbcommand(sql, conn) dbcommand.ExecuteNonQuery() conn.close() *******************
Are you using MS Access as DB? << >>
-
Are you using MS Access as DB? << >>
yes dear i am using MS Access !!
-
yes dear i am using MS Access !!
Hi there, So first you should make sure that ur coding is working. I mean that the problem is not from ur code, just simply run on another machine or run with SQL server. if the code is good, that means you might try to re-install the MS Access. Because, my friend had experinced this issue and we try to find out what the cause is, but nothing. And everything is working again until re-installing MS Access. we dont know why..... if you have a better solution, post it here as well.... << >>
-
Hi there, So first you should make sure that ur coding is working. I mean that the problem is not from ur code, just simply run on another machine or run with SQL server. if the code is good, that means you might try to re-install the MS Access. Because, my friend had experinced this issue and we try to find out what the cause is, but nothing. And everything is working again until re-installing MS Access. we dont know why..... if you have a better solution, post it here as well.... << >>
-
also i can't update my DB, i'm using access DB, have DBNULLchange to String not available show on the screen.
Hey there,
bryanball wrote:
have DBNULLchange to String not available show on the screen
what do you mean?? :doh: Not get your point... << >>