Need Help with Database Connection w/ ASP.NET!

[Sparky Arbuckle]

web.config

<?xml version="1.0" encoding="utf-8" ?>

<configuratio n>
<!-- application specific settings -->

<appSettings>
<add key="myConnecti on" value="Provider =Microsoft.Jet. OLEDB.4.0;Data
source=Customer s.mdb;" />
</appSettings>

<system.web>
<httpRuntime executionTimeou t="5" maxRequestLengt h="8192"/>
<customErrors mode="Off"/>
<compilation debug="true"/>
</system.web>

</configuration>
--------------------------------------------------------

DataGridEmail.a spx (Connection String)

<%@ Page Language="VB" %>
<%@ Import Namespace="Syst em.Data" %>
<%@ Import Namespace="Syst em.Data.OleDb" %>

<SCRIPT runat="SERVER">

'Modified from Payne Listings 10.10 & 10.11
'declare connection object with page-level scope (use in two
subroutines)

Dim myConnection as NEW
OLEDBConnection (ConfigurationS ettings.AppSett ings("Customers "))

Sub Page_Load(obj as Object, e as EventArgs)
IF NOT Page.IsPostBack then subFillDataGrid ()
END Sub

Sub subFillDataGrid (Optional EditIndex as integer=-1)
'If Datagrid is in edit mode then specify row to edit
IF NOT EditIndex.Equal s(Nothing) then dgData.EditItem Index = EditIndex

'Initialize command object
Dim objCommand as new OleDbCommand ("SELECT CustID, FirstName,
LastName, Email", myConnection)

TRY
myConnection.Op en()
dgData.DataSour ce =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)
dgData.DataBind ()
CATCH objError as Exception
lblMessage.text += "<br />FillDataGrid "
lblMessage.text += "<br />Error message - " & objError.Messag e
lblMessage.text += "<br />Error source - " & objError.Source
END TRY

END Sub
--------------------------------------------

My error is as follows:

Error message - The ConnectionStrin g property has not been initialized.
Error source - System.Data

Any help would be greatly appreciated!

[Bambi]

Hi, I think this should help :)

Dim myConnection as NEW
OLEDBConnection (ConfigurationS ettings.AppSett ings("myConnect ion"))

Your key for the connection string in <appSettings> is "myConnecti on" NOT
"Customers"

"Sparky Arbuckle" wrote:

web.config

<?xml version="1.0" encoding="utf-8" ?>

<configuratio n>
<!-- application specific settings -->

<appSettings>
<add key="myConnecti on" value="Provider =Microsoft.Jet. OLEDB.4.0;Data
source=Customer s.mdb;" />
</appSettings>

<system.web>
<httpRuntime executionTimeou t="5" maxRequestLengt h="8192"/>
<customErrors mode="Off"/>
<compilation debug="true"/>
</system.web>

</configuration>
--------------------------------------------------------

DataGridEmail.a spx (Connection String)

<%@ Page Language="VB" %>
<%@ Import Namespace="Syst em.Data" %>
<%@ Import Namespace="Syst em.Data.OleDb" %>

<SCRIPT runat="SERVER">

'Modified from Payne Listings 10.10 & 10.11
'declare connection object with page-level scope (use in two
subroutines)

Dim myConnection as NEW
OLEDBConnection (ConfigurationS ettings.AppSett ings("Customers "))

Sub Page_Load(obj as Object, e as EventArgs)
IF NOT Page.IsPostBack then subFillDataGrid ()
END Sub

Sub subFillDataGrid (Optional EditIndex as integer=-1)
'If Datagrid is in edit mode then specify row to edit
IF NOT EditIndex.Equal s(Nothing) then dgData.EditItem Index = EditIndex

'Initialize command object
Dim objCommand as new OleDbCommand ("SELECT CustID, FirstName,
LastName, Email", myConnection)

TRY
myConnection.Op en()
dgData.DataSour ce =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)
dgData.DataBind ()
CATCH objError as Exception
lblMessage.text += "<br />FillDataGrid "
lblMessage.text += "<br />Error message - " & objError.Messag e
lblMessage.text += "<br />Error source - " & objError.Source
END TRY

END Sub
--------------------------------------------

My error is as follows:

Error message - The ConnectionStrin g property has not been initialized.
Error source - System.Data

Any help would be greatly appreciated!

[Chris Botha]

From your example your setting in <appSettings> is called "myConnecti on" and
in the code you use "ConfigurationS ettings.AppSett ings("Customers ")".
It may be good to debug it in steps, put a break and ensure you get the
right value from AppSettings. After that stick it into the connection string
and debug further.
"Sparky Arbuckle" <tw*@secureroot .com> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...

web.config

<?xml version="1.0" encoding="utf-8" ?>

<configuratio n>
<!-- application specific settings -->

<appSettings>
<add key="myConnecti on" value="Provider =Microsoft.Jet. OLEDB.4.0;Data
source=Customer s.mdb;" />
</appSettings>

<system.web>
<httpRuntime executionTimeou t="5" maxRequestLengt h="8192"/>
<customErrors mode="Off"/>
<compilation debug="true"/>
</system.web>

</configuration>
--------------------------------------------------------

DataGridEmail.a spx (Connection String)

<%@ Page Language="VB" %>
<%@ Import Namespace="Syst em.Data" %>
<%@ Import Namespace="Syst em.Data.OleDb" %>

<SCRIPT runat="SERVER">

'Modified from Payne Listings 10.10 & 10.11
'declare connection object with page-level scope (use in two
subroutines)

Dim myConnection as NEW
OLEDBConnection (ConfigurationS ettings.AppSett ings("Customers "))

Sub Page_Load(obj as Object, e as EventArgs)
IF NOT Page.IsPostBack then subFillDataGrid ()
END Sub

Sub subFillDataGrid (Optional EditIndex as integer=-1)
'If Datagrid is in edit mode then specify row to edit
IF NOT EditIndex.Equal s(Nothing) then dgData.EditItem Index = EditIndex

'Initialize command object
Dim objCommand as new OleDbCommand ("SELECT CustID, FirstName,
LastName, Email", myConnection)

TRY
myConnection.Op en()
dgData.DataSour ce =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)
dgData.DataBind ()
CATCH objError as Exception
lblMessage.text += "<br />FillDataGrid "
lblMessage.text += "<br />Error message - " & objError.Messag e
lblMessage.text += "<br />Error source - " & objError.Source
END TRY

END Sub
--------------------------------------------

My error is as follows:

Error message - The ConnectionStrin g property has not been initialized.
Error source - System.Data

Any help would be greatly appreciated!

[Sparky Arbuckle]

Error message - No value given for one or more required parameters.
Error source - Microsoft JET Database Engine

I have no idea what is going on here. I can tell that something is
starting to work.

Thanks everyone for the prompt replies!

[Sparky Arbuckle]

LOFL!

I selected from the database originally:

Dim objCommand as NEW OLEDBCommand ("SELECT CustID, FirstName,
LastName, Email", myConnection)

I forgot to add FROM tblCustomers

Oh man, I love ASP.NET debugging. It was ready to SELECT but had no
idea where to SELECT FROM!

Thanks everyone. Since everyone is so helpful I will probably be back!

[Sparky Arbuckle]

Now I run into another problem when I go to add a customer to the
database.

Number of query values and destination fields are not the same. -->
Error message that I get.

My code is as follows:

Sub Insert_onclick( obj as object, e as eventargs)
'insert new data
Dim strText as string
Dim strSQL as string = "INSERT INTO tblCustomers " & _
"(CustID, FirstName, LastName, Email) VALUES (" & _
"'" & CleanData(tbFNa me.text) & "'," & _
"'" & CleanData(tbLNa me.text) & "')" & _
"'" & CleanData(tbEma il.text) & "')"

tbFName.text = ""
tbLName.text = ""
tbEmail.text = ""

ExecuteSQL(strS QL)
subFillDataGrid ()
END Sub
----------------------------------------------------

I don't understand how it is not updating. All the fields that need to
be updated are included in my Subroutine. Any suggestions.

[Sparky Arbuckle]

Nevermind. I got it. It seems that the Error Debugging script is
pretty worthless. I was missing a parentheses! Damn you ASP.NET!