General discussion


Deploying ASP web with MS ACCESS db

By 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 :
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" "

<html xmlns="">
<head runat="server">
<form id="form1" runat="server">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AutoGenerateColumns="False" DataKeyNames="jid" DataSourceID="temp-405">
<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" />

<asp:AccessDataSource ID="temp-405" runat="server" DataFile="~/App_Data/db.mdb"
SelectCommand="SELECT * FROM [job]"></asp:AccessDataSource>


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums