Wrox Programmer Forums
|
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 3rd, 2006, 08:47 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 363
Thanks: 0
Thanked 1 Time in 1 Post
Default Insert command

 Hello,

  I am new to asp.net and i want to insert a record into my table. For that i coded as...

dim connstr as string,conn as oledbconnection,dbcommand as oledbcommand
connstr="provider=Microsoft.Jet.Oledb.4.0;data source=c:\db.mdb"
conn=new oledbconnection(connstr)
insqry="insert into users(userid,username) values('" & txtUID.text & "','" & txtUName.text & "')"

conn.open()
dbcommand=new oledbcommand()
dbcommand.connection=conn
dbcommand.commandType=commandType.text
dbcommand.commandText=insqry
dbcommand.ExecuteNonQuery()
conn.close()
bindDatagrid()


but its not executing well. Displaying error, "Operation must be an updatable query"

I checked the database which readonly attribute unset.

What could be the problem? Otherwise, how can i execute queries like these?

thanx in advance






Similar Threads
Thread Thread Starter Forum Replies Last Post
insert command in grid view sumit_0 ASP.NET 2.0 Basics 1 April 26th, 2008 05:05 AM
Having Problems with my Insert Command - RESOLVED Andrew.Berry ASP.NET 2.0 Basics 1 October 2nd, 2007 09:59 AM
Insert Command using a querystring Andrew.Berry ASP.NET 2.0 Basics 1 September 27th, 2007 09:26 AM
Variable Usage in Insert Command tara0308 Access VBA 7 July 30th, 2007 12:50 PM
ASP Insert into command joshua_mccrea Classic ASP Databases 5 August 13th, 2003 10:35 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.