Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
trouble in uploading MS ACCESS db with ASP pages ?
hello , i am uploading my ASP web on webhosting panel
the project name is test1 ,
MS access DB name is db.mdb
when i went to create the ms access database on my hosting it asked for these fields
DSN name temp -405
database useer id "text box"
database passwprd "textbox"
DBQ (Database Path) ftproot \db.mdb
it gave me this
ODBC Connection String for this DSN would be :
"DSN=temp-405;Uid=;Pwd=;"
now what should i do in next step ?
what should i have to in web.config?
what should i need to do in my grid view or page code?
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-???
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AutoGenerateColumns="False" DataKeyNames="jid" DataSourceID="temp-405">
<Columns>
<asp:BoundField DataField="jid" HeaderText="jid" ReadOnly="True"
SortExpression="jid" />
<asp:BoundField DataField="job_name" HeaderText="job_name"
SortExpression="job_name" />
<asp:BoundField DataField="short_description" HeaderText="short_description"
SortExpression="short_description" />
<asp:BoundField DataField="long_description" HeaderText="long_description"
SortExpression="long_description" />
<asp:BoundField DataField="quantity" HeaderText="quantity"
SortExpression="quantity" />
<asp:BoundField DataField="qualification" HeaderText="qualification"
SortExpression="qualification" />
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="temp-405" runat="server" DataFile="~/App_Data/db.mdb"
SelectCommand="SELECT * FROM [job]"></asp:AccessDataSource>
</div>