Click here to Skip to main content
15,925,206 members
Home / Discussions / C#
   

C#

 
Generalfingerprint recognition using C# Pin
ashwinikm4-Apr-05 22:03
ashwinikm4-Apr-05 22:03 
GeneralRe: fingerprint recognition using C# Pin
Colin Angus Mackay5-Apr-05 0:09
Colin Angus Mackay5-Apr-05 0:09 
GeneralRe: fingerprint recognition using C# Pin
leppie5-Apr-05 0:34
leppie5-Apr-05 0:34 
Generaltransposing Pin
vinay284-Apr-05 21:30
vinay284-Apr-05 21:30 
GeneralGraph data structure Pin
WDI4-Apr-05 21:07
WDI4-Apr-05 21:07 
GeneralRe: Graph data structure Pin
Ryan Roberts5-Apr-05 0:00
Ryan Roberts5-Apr-05 0:00 
QuestionMS Word busy flag ? Pin
fracalifa4-Apr-05 20:18
fracalifa4-Apr-05 20:18 
GeneralDropdownlist problems Pin
brian554-Apr-05 18:45
brian554-Apr-05 18:45 
The problem is weird. I make a call to the method that does the binding. The method executes once, but it terminates after the databinding statement (not the close statements) then returns back to the Page_load method. This causes a problem because the connection is still open from the first time through. The html page with the dropdown list never appears.

If you can help great!
public class SA_ArptSelNav : System.Web.UI.Page<br />
	{<br />
		protected System.Web.UI.WebControls.ImageButton ZoomInButton1;<br />
		protected System.Web.UI.WebControls.ImageButton ZoomOutButton1;<br />
		protected System.Web.UI.WebControls.ImageButton ZoomPrevButton1;<br />
		protected System.Web.UI.WebControls.ImageButton ZoomExtButton1;<br />
		protected System.Web.UI.WebControls.ImageButton PanButton1;<br />
		protected System.Web.UI.WebControls.ImageButton PrintButton1;<br />
		protected System.Web.UI.WebControls.DropDownList DropDownList1;<br />
		protected System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;<br />
		protected System.Data.OleDb.OleDbCommand oleDbSelectCommand1;<br />
		protected System.Data.OleDb.OleDbCommand oleDbInsertCommand1;<br />
		protected System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;<br />
		protected System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;<br />
		protected System.Data.OleDb.OleDbConnection oleDbConnection1;<br />
		protected dbListOfAirports dbListOfAirports1;<br />
		protected System.Web.UI.WebControls.ImageButton CopyButton1;<br />
		//<br />
		//protected DataView dvAirportList;<br />
		//protected DataTable AirportList; <br />
<br />
		private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			if (!Page.IsPostBack) <br />
			{<br />
				BindListToDropDown();<br />
			}<br />
		}<br />
<br />
		#region Web Form Designer generated code<br />
		override protected void OnInit(EventArgs e)<br />
		{<br />
			//<br />
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.<br />
			//<br />
			InitializeComponent();<br />
			base.OnInit(e);<br />
		}<br />
		<br />
		/// <summary><br />
		/// Required method for Designer support - do not modify<br />
		/// the contents of this method with the code editor.<br />
		/// </summary><br />
		private void InitializeComponent()<br />
		{    <br />
			this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();<br />
			this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();<br />
			this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();<br />
			this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();<br />
			this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();<br />
			this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();<br />
			this.dbListOfAirports1 = new dbListOfAirports();<br />
			((System.ComponentModel.ISupportInitialize)(this.dbListOfAirports1)).BeginInit();<br />
			this.DropDownList1.DataBinding += new System.EventHandler(this.Page_Load);<br />
			// <br />
			// oleDbDataAdapter1<br />
			// <br />
			this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;<br />
			this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;<br />
			this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;<br />
			this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {<br />
																										new System.Data.Common.DataTableMapping("Table", "tblAirport", new System.Data.Common.DataColumnMapping[] {<br />
																																																					  new System.Data.Common.DataColumnMapping("AirportCode", "AirportCode"),<br />
																																																					  new System.Data.Common.DataColumnMapping("AirportID", "AirportID"),<br />
																																																					  new System.Data.Common.DataColumnMapping("AirportName", "AirportName"),<br />
																																																					  new System.Data.Common.DataColumnMapping("City", "City"),<br />
																																																					  new System.Data.Common.DataColumnMapping("Latitude", "Latitude"),<br />
																																																					  new System.Data.Common.DataColumnMapping("Longitude", "Longitude"),<br />
																																																					  new System.Data.Common.DataColumnMapping("State", "State")})});<br />
			this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;<br />
			// <br />
			// oleDbDeleteCommand1<br />
			// <br />
			this.oleDbDeleteCommand1.CommandText = "DELETE FROM tblAirport WHERE (AirportID = ?)";<br />
			this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;<br />
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AirportID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AirportID", System.Data.DataRowVersion.Original, null));<br />
			// <br />
			// oleDbConnection1<br />
			// <br />
			this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=0;Data Source=""D:\MGDevelopment\SIMDAC Viewer\DB\simdac_be.mdb"";Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";<br />
			// <br />
			// oleDbInsertCommand1<br />
			// <br />
			this.oleDbInsertCommand1.CommandText = "INSERT INTO tblAirport(AirportCode, AirportName, City, Latitude, Longitude, State" +<br />
				") VALUES (?, ?, ?, ?, ?, ?)";<br />
			this.oleDbInsertCommand1.Connection = this.oleDbConnection1;<br />
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AirportCode", System.Data.OleDb.OleDbType.VarWChar, 4, "AirportCode"));<br />
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AirportName", System.Data.OleDb.OleDbType.VarWChar, 50, "AirportName"));<br />
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("City", System.Data.OleDb.OleDbType.VarWChar, 20, "City"));<br />
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Latitude", System.Data.OleDb.OleDbType.VarWChar, 50, "Latitude"));<br />
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Longitude", System.Data.OleDb.OleDbType.VarWChar, 50, "Longitude"));<br />
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("State", System.Data.OleDb.OleDbType.VarWChar, 2, "State"));<br />
			// <br />
			// oleDbSelectCommand1<br />
			// <br />
			this.oleDbSelectCommand1.CommandText = "SELECT AirportCode, AirportID, AirportName, City, Latitude, Longitude, State FROM" +<br />
				" tblAirport";<br />
			this.oleDbSelectCommand1.Connection = this.oleDbConnection1;<br />
			// <br />
			// oleDbUpdateCommand1<br />
			// <br />
			this.oleDbUpdateCommand1.CommandText = "UPDATE tblAirport SET AirportCode = ?, AirportName = ?, City = ?, Latitude = ?, L" +<br />
				"ongitude = ?, State = ? WHERE (AirportID = ?)";<br />
			this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;<br />
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AirportCode", System.Data.OleDb.OleDbType.VarWChar, 4, "AirportCode"));<br />
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("AirportName", System.Data.OleDb.OleDbType.VarWChar, 50, "AirportName"));<br />
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("City", System.Data.OleDb.OleDbType.VarWChar, 20, "City"));<br />
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Latitude", System.Data.OleDb.OleDbType.VarWChar, 50, "Latitude"));<br />
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Longitude", System.Data.OleDb.OleDbType.VarWChar, 50, "Longitude"));<br />
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("State", System.Data.OleDb.OleDbType.VarWChar, 2, "State"));<br />
			this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_AirportID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AirportID", System.Data.DataRowVersion.Original, null));<br />
			// <br />
			// dbListOfAirports1<br />
			// <br />
			this.dbListOfAirports1.DataSetName = "dbListOfAirports";<br />
			this.dbListOfAirports1.Locale = new System.Globalization.CultureInfo("en-US");<br />
			((System.ComponentModel.ISupportInitialize)(this.dbListOfAirports1)).EndInit();<br />
<br />
		}<br />
		#endregion<br />
<br />
		private void BindListToDropDown()<br />
		{<br />
			oleDbConnection1.Open();<br />
			OleDbDataReader OleDbReader = this.oleDbSelectCommand1.ExecuteReader(CommandBehavior.CloseConnection);<br />
			DropDownList1.SelectedIndex=0;<br />
			DropDownList1.DataSource=OleDbReader;<br />
			//DropDownList1.DataTextField = "AirportName";<br />
			//DropDownList1.DataValueField="AirportID";<br />
			DropDownList1.DataBind();<br />
			<br />
			OleDbReader.Close();<br />
			oleDbConnection1.Close();<br />
		}<br />
	}

QuestionSome problem with my web form ? Pin
tutananthanh4-Apr-05 18:38
tutananthanh4-Apr-05 18:38 
Generaldataset+xml schema Pin
Dpriya4-Apr-05 18:07
Dpriya4-Apr-05 18:07 
GeneralRe: dataset+xml schema Pin
Kodanda Pani6-Apr-05 1:37
Kodanda Pani6-Apr-05 1:37 
GeneralPersisting properties Pin
chettu4-Apr-05 18:06
chettu4-Apr-05 18:06 
GeneralRe: Persisting properties Pin
Ashok Dhamija4-Apr-05 18:52
Ashok Dhamija4-Apr-05 18:52 
GeneralRe: Persisting properties Pin
chettu4-Apr-05 19:29
chettu4-Apr-05 19:29 
GeneralRe: Persisting properties Pin
spif20014-Apr-05 19:53
spif20014-Apr-05 19:53 
GeneralRe: Persisting properties Pin
Ashok Dhamija4-Apr-05 20:39
Ashok Dhamija4-Apr-05 20:39 
GeneralAdding a delay in a loop Pin
jctk4-Apr-05 14:00
jctk4-Apr-05 14:00 
GeneralRe: Adding a delay in a loop Pin
Luis Alonso Ramos4-Apr-05 14:53
Luis Alonso Ramos4-Apr-05 14:53 
GeneralRe: Adding a delay in a loop Pin
cishi_us5-Apr-05 8:19
cishi_us5-Apr-05 8:19 
GeneralRe: Adding a delay in a loop Pin
Luis Alonso Ramos5-Apr-05 8:33
Luis Alonso Ramos5-Apr-05 8:33 
GeneralRe: Adding a delay in a loop Pin
S. Senthil Kumar4-Apr-05 18:15
S. Senthil Kumar4-Apr-05 18:15 
GeneralRe: Adding a delay in a loop Pin
Colin Angus Mackay5-Apr-05 0:15
Colin Angus Mackay5-Apr-05 0:15 
GeneralRe: Adding a delay in a loop Pin
S. Senthil Kumar5-Apr-05 1:19
S. Senthil Kumar5-Apr-05 1:19 
GeneralEvent tab of the PropertyGrid in desing time Pin
rakat334-Apr-05 13:12
rakat334-Apr-05 13:12 
GeneralActive X Pin
webhay4-Apr-05 11:21
webhay4-Apr-05 11:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.