Questions

trouble in uploading MS ACCESS db with ASP pages ?

+
0 Votes
Locked

trouble in uploading MS ACCESS db with ASP pages ?

zeeeshan
trouble in Access database link at web hosting


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>