well i'm sorry to bring you the bad news, but the adodb.connection statement
isn't used anymore
when youre using SQL server, look into system.data.sqlclient
when your using Access, look into system.data.oledbclient
you can get rid of your old ado ideas, things have changed.
start reading stuff about the following classes of system.data.sqlclient
Sqlconnection
SqlCommand
SqlParameter
SqlDataAdapter
SqlDataReader
to connect to the server and Dataset, DataTable, DataRow, DataColumn for
processing the results.
(those classes are valid in Oledb, when you replace the Sql-, and there in
the system.data.oledbclient namespace)
it's a brave new world out there.
happy hunting.
(for examples, check the asp.net site, or any asp.net discussion list)
regards
Remie Bolte
----- Original Message -----
From: "Tiffany Blake" <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 6:39 PM
Subject: .net beginning
i messing around with my first c# web application developed in visual
studio.net.
the compile/build is successful, but i keep getting the same runtime error -
Operation is not allowed when the object is closed (see below). the error
points to the "finally" exception handling and occurs when i input search
criteria on the webform and click the search button, i receive a server
error. any ideas??
thanks,
[EMAIL PROTECTED]
-------------------------------------
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace SWPFirstTry
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class SWPFirstTryLookup : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label LabelTradeNameSearch;
protected System.Web.UI.WebControls.Label LabelTradeName;
protected System.Web.UI.WebControls.Label LabelIngredients;
protected System.Web.UI.WebControls.Label LabelDosageRoute;
protected System.Web.UI.WebControls.Label LabelStrength;
protected System.Web.UI.WebControls.Label LabelType;
protected System.Web.UI.WebControls.Label LabelQueryTime;
protected System.Web.UI.WebControls.Button ButtonSearch;
protected System.Web.UI.WebControls.DropDownList DropDownListTradeName;
protected System.Web.UI.WebControls.DropDownList DropDownListIngredients;
protected System.Web.UI.WebControls.DropDownList DropDownListDosageRoute;
protected System.Web.UI.WebControls.DropDownList DropDownListStrength;
protected System.Web.UI.WebControls.DropDownList DropDownListType;
protected System.Web.UI.WebControls.TextBox TextBoxTradeName;
protected System.Web.UI.WebControls.Label LabelError;
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.ButtonSearch.Click += new System.EventHandler(this.ButtonSearch_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void ButtonSearch_Click(object sender, System.EventArgs e)
{
if ((TextBoxTradeName.Text == null) || (TextBoxTradeName.Text.Length == 0))
{
LabelError.Text = "No item specified";
SWPTweakAllDropDownLists(false);
return;
}
LabelError.Text = "";
ADODB.Connection conn = null;
DateTime startTime = DateTime.Now;
try
{
conn = new ADODB.ConnectionClass();
conn.ConnectionString = "PROVIDER=sqloledb;" + "Database=SWPMedicalStuff";
conn.Open(null, null, null, (int)ADODB.ConnectModeEnum.adModeUnknown);
SWPFillItIn(conn);
}
catch(Exception ex)
{
SWPTweakAllDropDownLists(false);
LabelError.Text = ex.Message;
}
finally
{
if (null != conn)
{
conn.Close();
conn = null;
}
}
TimeSpan duration = DateTime.Now - startTime;
LabelQueryTime.Text = String.Format("Query time: {0:N} ms",
duration.TotalMilliseconds);
}
const string listData =
"SELECT Col001 As Ingredients, " +
"Col002 As DosageRoute, " +
"Col003 As TradeName, " +
"Col005 As Strength, " +
"Col011 As Type, " +
"FROM Approved " +
"WHERE Col003='{0}'";
private void SWPFillItIn(ADODB.Connection conn)
{
string commandText = String.Format(listData, TextBoxTradeName.Text);
//string commandText = String.Format(" ",TextBoxTradeName.Text);
//string commandText = TextBoxTradeName.Text;
Object recordsAffected;
ADODB.Recordset rs = null;
try
{
rs = conn.Execute(commandText, out recordsAffected,
(int)ADODB.ConnectModeEnum.adModeUnknown);
SWPClearAllDropDownLists();
while (!rs.EOF)
{
DropDownListIngredients.Items.Add(rs.Fields["Ingredients"].Value.ToString())
;
DropDownListDosageRoute.Items.Add(rs.Fields["DosageAndRoute"].Value.ToString
());
DropDownListTradeName.Items.Add(rs.Fields["TradeName"].Value.ToString());
DropDownListStrength.Items.Add(rs.Fields["Strength"].Value.ToString());
DropDownListType.Items.Add(rs.Fields["Type"].Value.ToString());
rs.MoveNext();
}
SWPTweakAllDropDownLists(true);
}
finally
{
if (null != rs)
{
rs.Close();
rs = null;
}
}
}
private void SWPClearAllDropDownLists()
{
DropDownListIngredients.Items.Clear();
DropDownListDosageRoute.Items.Clear();
DropDownListTradeName.Items.Clear();
DropDownListStrength.Items.Clear();
DropDownListType.Items.Clear();
}
private void SWPTweakAllDropDownLists(bool visible)
{
DropDownListIngredients.Visible = visible;
DropDownListDosageRoute.Visible = visible;
DropDownListTradeName.Visible = visible;
DropDownListStrength.Visible = visible;
DropDownListType.Visible = visible;
}
private void SWPChangeAllDropDownListsIndexes(int index)
{
DropDownListIngredients.SelectedIndex = index;
DropDownListDosageRoute.SelectedIndex = index;
DropDownListTradeName.SelectedIndex = index;
DropDownListStrength.SelectedIndex = index;
DropDownListType.SelectedIndex = index;
}
private void DropDownListGeneric_SelectedIndexChanged(object sender,
System.EventArgs e)
{
SWPChangeAllDropDownListsIndexes(((DropDownList)sender).SelectedIndex);
}
}
}
-------------------------------------
-----Original Message-----
From: deb [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 21, 2002 6:20 AM
To: ActiveServerPages
Subject: RE: Asp.net beginning
Paul
I highly recomed www.asp.net
I think that this site has much information that could help you as well as
a very informative forum for help in learning. Also there is a place
called Hiveminds.com you might want to give them a check out as well.
---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
