Browse by Tags

Home ›

All Tags » ASP.NET » Database » .aspx.vb (RSS)

Insert query being fired twice

hi every one i am having a strange problem - while trying to insert values in access database 2 rows are being inserted instead of 1. the code being used is pasted below. please help. Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click Dim sql As String...

Posted to Access Databases and AccessDataSource Control (Forum) by abhishekbrowne on 07-07-2008, 12:00 AM
Filed under: .ASPX, .aspx.vb, .Net 2.0, access, Access database query string, access oledb, asp.net, ASP.NET 2.0, Insert into Access Database, insert method, database
Inserting into two tables at the same time with the same ID

Hi, I am not sure if this is the right place to ask this but I have been searching the web and have yet to come across a suitable example. I am new to .NET but have had previous experience with ASP Anyway here goes, I have two tables in an Access database, named Colours and Horse, Horse (ID(AutoNumber...

Posted to Access Databases and AccessDataSource Control (Forum) by richardh09 on 05-30-2008, 12:00 AM
Filed under: database, access, Access database query string, vb.net, asp.net, Scope Identity, Primary Key, Access Database, data access, .aspx.vb, .Net 2.0, ASP.NET 2.0, record, SQL Query, Insert into Access Database, sql, insert method, access oledb, SELECT command
Re: Record(s) cannot be read; no read permission on 'MSysObjects'.

If you people are using AccessDataSource and having error " Record(s) cannot be read; no read permission on [table] ", first step is to open up the MDB file and assign full rights to Admin user for each & every table either its system or hidden table. if you want to see all system &...

Posted to Access Databases and AccessDataSource Control (Forum) by moizdhanji on 08-08-2007, 12:00 AM
Filed under: database, Odbc, access, c#, mdb, AccessDataSource INSERT problem, Access database query string, vb.net, asp.net, Access Database - FileDSN in ASP.NET 2.0, Access Database, data access, OLEDB - Relative Connection string, accessdatabase, Microsoft Access Database Delete, .aspx.vb, .Net 2.0, ASP.NET 2.0
PostBackUrl and "Insert"

When a user submits data in a form, I want to tell the user that the information has been saved to the database. But when I use the PostBackUrl="~/success.aspx", the data is not written. However, it works without the PostBackUrl. For example: <asp:Button ID="InsertButton1" runat...

Posted to Web Forms (Forum) by steldingc on 07-09-2007, 12:00 AM
Filed under: ASP.NET, form, postbackurl, ASP.NET 2.0, Database, PostBack, postback event handling, data entry insert auto, postback data expiration, 2.0, .aspx.vb, asp .net 2.0, postBackback postbackurl