|
 |
aspx thread: Access Connection
Message #1 by "Leitner Christoph" <christoph@o...> on Wed, 4 Jul 2001 15:35:18 +0200
|
|
How must the ConnectString looklike when I want to connect to an access
DB !
What Connection must i use
System.Data.OleDd
or
System.Data.SqlClient
Christoph
Message #2 by "Roger M. Taylor" <rogertaylor@f...> on Wed, 04 Jul 2001 11:02:22 -0400
|
|
see:
http://www.aspng.com/learn/dbopen.aspx
for how to connect to Access database with Connection String!
At 03:35 PM 7/4/2001 +0200, you wrote:
>How must the ConnectString looklike when I want to connect to an access DB
!
>
>What Connection must i use
>System.Data.OleDd
>or
>System.Data.SqlClient
>
>Christoph
>
>
Message #3 by "Mel C Solomon" <melsolomon@e...> on Thu, 5 Jul 2001 01:58:52 -0800
|
|
Hmmmmh? I feel good today so I want to share my simple codes with
you.... Just delete the unneccesary codes or modify it to for your use.
====guessbook.aspx====
<%@ Register TagPrefix="mel" TagName="header" Src="header.ascx" %>
<%@ Register TagPrefix="mel" Tagname="leftmenu" Src="leftmenu.ascx" %>
<html>
<head>
<link rel="stylesheet" type="text/css" href="styleko.css"/>
<script language=C# runat=server>
void Page_Init(Object sender, EventArgs e)
{
footer.Controls.Add(Page.LoadControl("footer.ascx"));
}
void Page_Load(Object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
msg.Text=null;
visitorcomments.Text=null;
visitorname.Text="";
visitoremail.Text="";
}
}
void submit(Object sender, EventArgs e){
if (visitorcomments.Text!=""&&visitorname.Text!=""&&visitoremail.Text!="")
{
string req = "";
req+="&&visitorcomments="+visitorcomments.Text;
req+="&&visitoremail="+visitoremail.Text;
req+="&&visitorname="+visitorname.Text;
msg.Text="";
visitorcomments.Text="";
visitorname.Text="";
visitoremail.Text="";
Page.Response.Redirect("guess.aspx?" + req);
}
else
{
msg.Text="Please complete the field";
}
}
</script>
</head>
<body bgcolor=#336699>
<table border=0 cellpadding=0 cellspacing=0 bgcolor="white" height=100% width=100%>
<mel:header runat=server/>
<tr valign=top height=100%>
<td colspan=0 valign=top height=100%>
<table border=0 valign=top cellpadding=0 cellspacing=0 height=100% bgcolor=white>
<tr height=100% valign=top>
<td colspan=1 height=100% valign=top>
<mel:leftmenu runat=server/>
</td>
<td valign=top align=center width=100%><hr color=#36699><p>Please fill free to fill-up our public guess book.
</p>
<form runat=server id=form1>
<p align=center>
<asp:Label id=msg runat=server Text=""/><br>
<asp:TextBox id="visitorcomments" Rows=8 Columns=30 TextMode="MultiLine" runat=server Text=""/>
<br><br>
Name: <asp:TextBox id="visitorname" Text="" runat=server/>
<br>
Email: <asp:TextBox id="visitoremail" Text="" runat=server/>
<br><br>
<asp:Button Text="Submit Comments" onClick="submit" id=button1 runat=server/>
<input type="Reset" Text="Clear" runat=server/>
</p>
<br>
</form>
</td>
</tr>
</table>
</td>
</tr>
<asp:label id=footer runat=server/>
</table>
</body>
</html>
=====end guessbook====
======guess.aspx===
<%@ Register TagPrefix="mel" TagName="header" Src="header.ascx" %>
<%@ Register TagPrefix="mel" Tagname="leftmenu" Src="leftmenu.ascx" %>
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.OleDb" %>
<%@ Page Language="C#" Debug="true" %>
<html>
<head>
<link href="styleko.css" type="text/css" rel="stylesheet"/>
<script language=C# runat=server>
void Page_Init(Object sender, EventArgs e)
{
footer.Controls.Add(Page.LoadControl("footer.ascx"));
}
void Page_Load(Object sender, EventArgs e)
{
string visitor=Request.Params["visitorname"];
string email=Request.Params["visitoremail"];
string strcomments=Request.Params["visitorcomments"];
string strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(".\\db\\db1.mdb");
OleDbConnection conn = new OleDbConnection(strconn);
conn.Open();
string strcomm="Insert into
visitor(visitorname,visitoremail,visitorcomments)values('"+visitor.ToString()+"','"+email.ToString()+"','"+strcomments.ToString()+"'
)";
OleDbCommand comm = new OleDbCommand(strcomm,conn);
comm.ExecuteNonQuery();
conn.Close();
lblname.Text=visitor;
lblemail.Text=email;
lblcomments.Text=strcomments;
}
</script>
</head>
<body bgcolor=#336699>
<table border=0 cellpadding=0 cellspacing=0 bgcolor="white" height=100% width=100%>
<mel:header runat=server/>
<tr valign=top height=100%>
<td colspan=0 width=100%>
<table border=0 cellpadding=0 cellspacing=0 height=100% bgcolor=white width=100%>
<tr height=100%>
<td>
<mel:leftmenu runat=server/>
</td>
<td valign=top align=center width=100%><hr color=#336699>
<center>
<table border=0 bordercolor=#336699 width=50% rightmargin=0 leftmargin=0 >
<br>
<tr bgcolor=#336699 class=title>
<td colspan=2 align=center><B>Thank You</B>
</td>
</tr>
<tr>
<td>Name:</td>
<td><asp:Label id="lblname" Text="" runat=server/></td>
</tr>
<tr>
<td>Email:</td>
<td><asp:Label id="lblemail" Text="" runat=server/></td>
</tr>
<tr>
<td>Message:</td>
<td><asp:Label MultiLine=True Column=20 id="lblcomments" Text="" runat=server/></td>
</tr>
</table>
<h5>to go back to where you came...<a href="guessbook.aspx">CLICK </a> here.
<center>
<a href='viewcomments.aspx'>View Comments</a>
</td>
</tr>
</table>
</td>
</tr>
<asp:label id=footer runat=server/>
</table>
</body>
</html>
======end=====
"My the code be with you!"
mel :)
ASP+ wrote:
>How must the ConnectString looklike when I want to connect to an access
>DB !
>
>What Connection must i use
>System.Data.OleDd
>or
>System.Data.SqlClient
>
>Christoph
>
__________________________________
www.edsamail.com
Message #4 by "max.li" <max@a...> on Thu, 5 Jul 2001 03:00:03
|
|
Application Error
---------------------------------------------------------------------------
-----
Parser Error
Description: An error occurred during the parsing of a resource required
to service this request. Please review the specific parse error details
below and modify your source file appropriately.
Parser Error Message: Could not find file 'c:\inetpub\wwwroot\test2
\header.ascx'.
Source Error:
Line 1: <%@ Register TagPrefix="mel" TagName="header" Src="header.ascx" %>
Line 2: <%@ Register TagPrefix="mel" Tagname="leftmenu"
Src="leftmenu.ascx" %>
Line 3:
Source File: c:\inetpub\wwwroot\test2\WebForm1.aspx Line: 1
---------------------------------------------------------------------------
-----
Version Information: Runtime Build: 1.0.2204.21; ASP.NET Build:
1.0.2204.21
> Hmmmmh? I feel good today so I want to share my simple codes with
> you.... Just delete the unneccesary codes or modify it to for your use.
>
>
> ====guessbook.aspx====
>
> <%@ Register TagPrefix="mel" TagName="header" Src="header.ascx" %>
> <%@ Register TagPrefix="mel" Tagname="leftmenu" Src="leftmenu.ascx" %>
>
> <html>
> <head>
> <link rel="stylesheet" type="text/css" href="styleko.css"/>
> <script language=C# runat=server>
>
> void Page_Init(Object sender, EventArgs e)
> {
> footer.Controls.Add(Page.LoadControl("footer.ascx"));
>
> }
>
> void Page_Load(Object sender, EventArgs e)
> {
> if(!Page.IsPostBack)
> {
> msg.Text=null;
> visitorcomments.Text=null;
> visitorname.Text="";
> visitoremail.Text="";
> }
> }
> void submit(Object sender, EventArgs e){
>
> if (visitorcomments.Text!=""&&visitorname.Text!=""&&visitoremail.Text!
="")
> {
> string req = "";
> req+="&&visitorcomments="+visitorcomments.Text;
> req+="&&visitoremail="+visitoremail.Text;
> req+="&&visitorname="+visitorname.Text;
>
> msg.Text="";
> visitorcomments.Text="";
> visitorname.Text="";
> visitoremail.Text="";
> Page.Response.Redirect("guess.aspx?" + req);
>
> }
> else
> {
> msg.Text="Please complete the field";
> }
> }
> </script>
> </head>
> <body bgcolor=#336699>
> <table border=0 cellpadding=0 cellspacing=0 bgcolor="white" height=100%
width=100%>
>
> <mel:header runat=server/>
>
> <tr valign=top height=100%>
> <td colspan=0 valign=top height=100%>
> <table border=0 valign=top cellpadding=0 cellspacing=0
height=100% bgcolor=white>
> <tr height=100% valign=top>
> <td colspan=1 height=100% valign=top>
> <mel:leftmenu runat=server/>
> </td>
>
>
> <td valign=top align=center width=100%><hr
color=#36699><p>Please fill free to fill-up our public guess book. </p>
> <form runat=server id=form1>
>
> <p align=center>
> <asp:Label id=msg runat=server Text=""/><br>
> <asp:TextBox id="visitorcomments" Rows=8 Columns=30
TextMode="MultiLine" runat=server Text=""/>
> <br><br>
> Name: <asp:TextBox id="visitorname" Text="" runat=server/>
> <br>
> Email: <asp:TextBox id="visitoremail" Text="" runat=server/>
> <br><br>
> <asp:Button Text="Submit Comments" onClick="submit" id=button1
runat=server/>
> <input type="Reset" Text="Clear" runat=server/>
> </p>
> <br>
>
>
>
> </form>
> </td>
> </tr>
> </table>
> </td>
>
> </tr>
> <asp:label id=footer runat=server/>
> </table>
> </body>
> </html>
>
> =====end guessbook====
>
>
>
>
> ======guess.aspx===
>
> <%@ Register TagPrefix="mel" TagName="header" Src="header.ascx" %>
> <%@ Register TagPrefix="mel" Tagname="leftmenu" Src="leftmenu.ascx" %>
> <%@ Import NameSpace="System.Data" %>
> <%@ Import NameSpace="System.Data.OleDb" %>
> <%@ Page Language="C#" Debug="true" %>
>
> <html>
> <head>
> <link href="styleko.css" type="text/css" rel="stylesheet"/>
>
> <script language=C# runat=server>
>
> void Page_Init(Object sender, EventArgs e)
> {
> footer.Controls.Add(Page.LoadControl("footer.ascx"));
>
> }
>
> void Page_Load(Object sender, EventArgs e)
> {
>
> string visitor=Request.Params["visitorname"];
> string email=Request.Params["visitoremail"];
> string strcomments=Request.Params["visitorcomments"];
>
> string strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="+Server.MapPath(".\\db\\db1.mdb");
>
> OleDbConnection conn = new OleDbConnection(strconn);
>
> conn.Open();
>
> string strcomm="Insert into visitor
(visitorname,visitoremail,visitorcomments)values('"+visitor.ToString()
+"','"+email.ToString()+"','"+strcomments.ToString()+"')";
>
> OleDbCommand comm = new OleDbCommand(strcomm,conn);
> comm.ExecuteNonQuery();
> conn.Close();
>
>
> lblname.Text=visitor;
> lblemail.Text=email;
> lblcomments.Text=strcomments;
> }
> </script>
>
> </head>
> <body bgcolor=#336699>
> <table border=0 cellpadding=0 cellspacing=0 bgcolor="white" height=100%
width=100%>
>
> <mel:header runat=server/>
>
> <tr valign=top height=100%>
> <td colspan=0 width=100%>
> <table border=0 cellpadding=0 cellspacing=0 height=100%
bgcolor=white width=100%>
> <tr height=100%>
> <td>
> <mel:leftmenu runat=server/>
> </td>
>
>
> <td valign=top align=center width=100%><hr color=#336699>
> <center>
> <table border=0 bordercolor=#336699 width=50%
rightmargin=0 leftmargin=0 >
> <br>
> <tr bgcolor=#336699 class=title>
> <td colspan=2 align=center><B>Thank You</B>
> </td>
> </tr>
> <tr>
> <td>Name:</td>
> <td><asp:Label id="lblname" Text="" runat=server/></td>
> </tr>
> <tr>
> <td>Email:</td>
> <td><asp:Label id="lblemail" Text="" runat=server/></td>
> </tr>
> <tr>
> <td>Message:</td>
> <td><asp:Label MultiLine=True Column=20
id="lblcomments" Text="" runat=server/></td>
> </tr>
> </table>
> <h5>to go back to where you came...<a
href="guessbook.aspx">CLICK </a> here.
> <center>
> <a href='viewcomments.aspx'>View Comments</a>
> </td>
> </tr>
> </table>
> </td>
>
> </tr>
> <asp:label id=footer runat=server/>
> </table>
> </body>
> </html>
>
> ======end=====
>
>
>
> "My the code be with you!"
> mel :)
>
>
>
> ASP+ wrote:
>
> >How must the ConnectString looklike when I want to connect to an access
> >DB !
> >
> >What Connection must i use
> >System.Data.OleDd
> >or
> >System.Data.SqlClient
> >
> >Christoph
> >
>
>
> __________________________________
> www.edsamail.com
Message #5 by "Mel C Solomon" <melsolomon@e...> on Fri, 6 Jul 2001 16:17:00 -0800
|
|
max.li;
... I use User Controls in the page....i suggest you explore
the quickstart tutorials.... everyone who wants to learn asp.net
should read the tutorials...i'm sure you'll learn many things on
it just like me.:-)
...as a work aroud, you my delete all the <%@ Register--%> at the
top of the page as well as their component -->i.e.
<mel:leftmenu runat=server/> ....it should work.
Back to you original question:
>> >How must the ConnectString looklike when I want to connect
to an access
>
>> >DB !
>> >
>> >What Connection must i use
>> >System.Data.OleDd
>> >or
>> >System.Data.SqlClient
>> >
...Here it is complete connection example:
==========
string strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="+Server.MapPath(".\\db\\db1.mdb");
OleDbConnection conn = new OleDbConnection(strconn);
conn.Open();
//Some sql..I'm inserting new records here //
string strcomm="Insert into visitor
(visitorname,visitoremail,visitorcomments)values('"+visitor.ToString()
+"','"+email.ToString()+"','"+strcomments.ToString()+"')";
OleDbCommand comm = new OleDbCommand(strcomm,conn);
comm.ExecuteNonQuery();
conn.Close();
==========
Some Changes:
========Changes====
Beta 1 ==>> Beta 2
System.Data.SQL = System.Data.SqlClient
SQLConnection = SqlConnection
SQLCommand = SqlCommand
SQLDataSetCommand = SqlDataAdapter
SQLDataReader = SqlDataReader
System.Data.ADO = System.Data.OleDb
ADOConnection = OleDbConnection
ADOCommand = OleDbCommand
ADODataSetCommand = OleDbDataAdapter
ADODataReader = OleDbDataReader
SQLDataSetCommand.FillDataSet() = SqlDataAdapter.Fill()
ADODataSetCommand.FillDataSet() = OleDbDataAdapter.Fill()
___________________________________________
hth,
mel :)
__________________________________
www.edsamail.com
|
|
|
View Cart
