i am newer to the developement industry..i created one html page for entering purchase details. i am using MS access as
database. but i don't know how to connect html page with access data base and how to insert data from html page..so i am asking all of your support in this problem..please give me a suitable solution..
Thanks
abhi
AccessDataSource INSERT problemAccess database query stringAccess Database - FileDSN in ASP.NET 2.0accessdatabaseMicrosoft Access Database DeleteInsert into Access Databaseaccess bvb.netaccess role provideraccess oledbAccess database bound DropDownList and RadioButtonList failureaccessc memo detailsdataset into access databaseAccess 2003Ms access databaseAccessDataSource Updateaccess memo field oledbdatareader 200 charsAccess 97 transactionsAccess dbaccess 2007 strings SQLAccessDataSource SelectCommand GridViewAccess 2003 Database Gridview Muliple Delete Response RedirectAccess C# VB databaseAccess 2003 with asp.net C#vb.net. AccessaccdbMS Access queryConnect to MS access database on serverms access database insert errorAmit Sharmaaccess update
There are many tutorials available for connecting to Ms Access DB, manipulating data etc etc. You should do google about it. You'll find many suitable ones for you..
I'have found one step-by-step article for you. Using this you can start on using Ms Access with your web app for connecting to it and all kind of data manipulation in it.
i need to know how to connect with access database from html page....its purely html..not using asp.net or any other tools to develope....
HTML is just a markup language that "runs" in a browser on client side. When you want to connect to a (Access) Database that is located at serverside, you need something that runs on serverside, retrieves the data from the database and then returns some
HTML that is visible in a browser. So you need to use some script code. If you want to start learning ASP.NET, which is a logical choice when you want to connect to an Access Database, you're very welcome here. It is very easy to connect to Access databases,
for simple taske you don't have to write any code, you can do it in HTML markup only. Go the the Get Started Menu, dowload and install Visual Web Developer (free) and you're set to go
If not, then you should ask your question somewhere else, because these forums are intended for ASP.NET related questions only. But like I said, you need some kind of script code, like ASP(.NET), Php or something like that
add namespace
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" + Server.MapPath("App_data\\tikkajack.mdb"));
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Open();
OleDbCommand comm = new OleDbCommand();
comm.CommandType = CommandType.Text;
comm.Connection = conn;
comm.CommandText = "insert into AdvertType (ObjectType) values (@Type)";
comm.Parameters.Add(new OleDbParameter("@Type", txtHead.Text.Trim()));
comm.ExecuteNonQuery();
comm.Cancel();
comm.Dispose();
In this example data is being inserted in table AdvertType , column name is ObjectType
and database name is tikkajack.mdb
so you can see this example and change to according to your requirement.
Did you read the question? Do you really think that someone who's not using Visual Web Developer or any other tool, does understand what you're trying to tell here?
Abhi
This is some example code what you could use, but you do not need togo that far. ASP.NET has also some easier ways to perform database actions, without the need of writing this kind of code. You can do most things in HTML markup, Visual Web Developer has
wizard, who help you to create this HTML markup without the need to learn the code whoch is presented here. But off course, if you want tp go more advanced, this is the code you'll need to learn....
add namespace
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" + Server.MapPath("App_data\\tikkajack.mdb"));
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Open();
OleDbCommand comm = new OleDbCommand();
comm.CommandType = CommandType.Text;
comm.Connection = conn;
comm.CommandText = "insert into AdvertType (ObjectType) values (@Type)";
comm.Parameters.Add(new OleDbParameter("@Type", txtHead.Text.Trim()));
comm.ExecuteNonQuery();
comm.Cancel();
comm.Dispose();
In this example data is being inserted in table AdvertType , column name is ObjectType
and database name is tikkajack.mdb
so you can see this example and change to according to your requirement.
abhilashkana...
Member
1 Points
30 Posts
How to insert data into access database from a html page
Mar 30, 2010 11:51 AM|LINK
Hi all..
i am newer to the developement industry..i created one html page for entering purchase details. i am using MS access as
database. but i don't know how to connect html page with access data base and how to insert data from html page..so i am asking all of your support in this problem..please give me a suitable solution..
Thanks
abhi
AccessDataSource INSERT problem Access database query string Access Database - FileDSN in ASP.NET 2.0 accessdatabase Microsoft Access Database Delete Insert into Access Database access bvb.net access role provider access oledb Access database bound DropDownList and RadioButtonList failure accessc memo details dataset into access database Access 2003 Ms access database AccessDataSource Update access memo field oledbdatareader 200 chars Access 97 transactions Access db access 2007 strings SQL AccessDataSource SelectCommand GridView Access 2003 Database Gridview Muliple Delete Response Redirect Access C# VB database Access 2003 with asp.net C# vb.net. Access accdb MS Access query Connect to MS access database on server ms access database insert error Amit Sharma access update
Abhi
cubangt
Contributor
3052 Points
2402 Posts
Re: How to insert data into access database from a html page
Mar 30, 2010 01:37 PM|LINK
Here is a link you can review.. http://support.microsoft.com/kb/175770
I've always used ASP and now working with ASP.Net and is pretty easy with the controls available.
---------------------
Mark as Answered if it helped
hassanmehmoo...
Star
8970 Points
1590 Posts
Re: How to insert data into access database from a html page
Mar 30, 2010 01:38 PM|LINK
Hi.
There are many tutorials available for connecting to Ms Access DB, manipulating data etc etc. You should do google about it. You'll find many suitable ones for you..
I'have found one step-by-step article for you. Using this you can start on using Ms Access with your web app for connecting to it and all kind of data manipulation in it.
Go through this link
http://www.codefixer.com/asp-net/tutorials/insert-records-access-database-1.asp
and feel free to ask anything more..
--
Mark as answer, if it answers you..
--
Mark as Answer, if it answers you..
--
abhilashkana...
Member
1 Points
30 Posts
Re: How to insert data into access database from a html page
Apr 03, 2010 12:09 PM|LINK
i need to know how to connect with access database from html page....its purely html..not using asp.net or any other tools to develope....
Abhi
hans_v
All-Star
35986 Points
6550 Posts
Re: How to insert data into access database from a html page
Apr 03, 2010 01:11 PM|LINK
HTML is just a markup language that "runs" in a browser on client side. When you want to connect to a (Access) Database that is located at serverside, you need something that runs on serverside, retrieves the data from the database and then returns some HTML that is visible in a browser. So you need to use some script code. If you want to start learning ASP.NET, which is a logical choice when you want to connect to an Access Database, you're very welcome here. It is very easy to connect to Access databases, for simple taske you don't have to write any code, you can do it in HTML markup only. Go the the Get Started Menu, dowload and install Visual Web Developer (free) and you're set to go
If not, then you should ask your question somewhere else, because these forums are intended for ASP.NET related questions only. But like I said, you need some kind of script code, like ASP(.NET), Php or something like that
vishwaraj1
Contributor
3687 Points
861 Posts
Re: How to insert data into access database from a html page
Apr 03, 2010 01:39 PM|LINK
add namespace using System.Data.OleDb; OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" + Server.MapPath("App_data\\tikkajack.mdb")); if (conn.State == ConnectionState.Open) conn.Close(); conn.Open(); OleDbCommand comm = new OleDbCommand(); comm.CommandType = CommandType.Text; comm.Connection = conn; comm.CommandText = "insert into AdvertType (ObjectType) values (@Type)"; comm.Parameters.Add(new OleDbParameter("@Type", txtHead.Text.Trim())); comm.ExecuteNonQuery(); comm.Cancel(); comm.Dispose(); In this example data is being inserted in table AdvertType , column name is ObjectType and database name is tikkajack.mdb so you can see this example and change to according to your requirement.Vishwaraj Malik
Skype ID: vishwaraj.malik
VB to C# Converter
Please: Don't forget to click "Mark as Answer" on the post that helped you. That way future readers will know which post solved your issue.
hans_v
All-Star
35986 Points
6550 Posts
Re: How to insert data into access database from a html page
Apr 03, 2010 01:47 PM|LINK
Vishwaraj
Did you read the question? Do you really think that someone who's not using Visual Web Developer or any other tool, does understand what you're trying to tell here?
Abhi
This is some example code what you could use, but you do not need togo that far. ASP.NET has also some easier ways to perform database actions, without the need of writing this kind of code. You can do most things in HTML markup, Visual Web Developer has wizard, who help you to create this HTML markup without the need to learn the code whoch is presented here. But off course, if you want tp go more advanced, this is the code you'll need to learn....
abhilashkana...
Member
1 Points
30 Posts
Re: How to insert data into access database from a html page
Apr 19, 2010 05:14 AM|LINK
Hi hans...
thank you very much for your valuable advice.
Abhi
JonathinRamo...
Member
2 Points
1 Post
Re: How to insert data into access database from a html page
Dec 12, 2012 03:50 PM|LINK
Is this in a <Script> tag?