ASP

本类阅读TOP10

·asp常用数据库连接方法和技巧
·无组件生成BMP验证码
·一些常用的辅助代码 (网络收藏)
·JavaScript实现的数据表格:冻结列、调整列宽和客户端排序
·VisualStudio.NET_2003及其 MSDN 下载地址
·ASP模拟MVC模式编程
·图片以二进制流输出到网页
·MD5加密算法 ASP版
·ASP.NET编程中的十大技巧
·改进 ASP 的字符串处理性能

分类导航
VC语言Delphi
VB语言ASP
PerlJava
Script数据库
其他语言游戏开发
文件格式网站制作
软件工程.NET开发
在DataGrid里添加DropDownLit控件【转贴】

作者:未知 来源:月光软件站 加入时间:2005-2-28 月光软件站

http://www.csharphelp.com/archives/archive212.html

?

Using DropDownList control in DataGrid
By Eric Zheng

When I was developing a web application couple days ago, I found some interesting things about the datagrid, I want to share them with other vs.net programmers, so I wrote this article. This article will demonstrate how to use DropDownList control in datagrid.

The essential part of the DropDown.aspx file is the following:


In second line, we set the datasource of the dropdownlist control to a function 'GetCategory()', this function fetches the Category records from database and returns a datatable. In the last line, we set the SelectedIndex to a funciton 'GetCategoryID', this function takes the current Categoryname as its argument, and returns the locaiton(an integer) of the Categoryname, this enables the DorpDownList control to display the correct Categoryname for the current record.

The following is the C# code:

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
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 Management
{
	
	public class DropDown : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid ProductGrid;
		protected DataTable _category;

		//new a database class to get records, ProductDb is a public class 
		//containing several functions
		protected ProductDb pdb=new ProductDb();
	
		public DropDown()
		{
			Page.Init += new System.EventHandler(Page_Init);
		}

		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!IsPostBack)
			{
				BindProduct();
				
			}
		}

		private void Page_Init(object sender, EventArgs e)
		{
			InitializeComponent();
		}

		void BindProduct()
		{
			//pdb.GetProduct() returns a datatable to Product's datagrid
			ProductGrid.DataSource=pdb.GetProduct();
			ProductGrid.DataBind();
		}

		protected void Product_Edit(object sender, DataGridCommandEventArgs e)
		{
			
			BindCategory();
			((DataGrid)sender).EditItemIndex=e.Item.ItemIndex;
			BindProduct();

		}

		protected void Product_Cancel(object sender, DataGridCommandEventArgs e)
		{
			ProductGrid.EditItemIndex=-1;
			BindProduct();

		}
		protected void Product_Update(object sender, DataGridCommandEventArgs e)
		{
			//get the currnet product name
			string pname=e.Item.Cell[1].Controls[0].Text;
			//get the current product price
			string price=e.Item.Cell[2].Controls[0].Text;
			//get the current categoryid
	DropDownList ddl=(DropDownList)e.Item.Cells[3].FindControl("DropDownList1");
			string categoryid=ddl.SelectedItem.Value;
			//get the current productid
			string pid=e.Item.Cell[4].Controls[0].Text;

			//call pdb's update function
			pdb.update(pid,pname,price,categoryid);
			
			ProductGrid.EditItemIndex=-1;
			BindProduct();

			
		}
		void BindCategory()
		{
			//pdb.FetchCategory() returns a datatable
			_category=pdb.FetchCategory();
					
		}

		protected DataTable GetCategory()
		{
			return _category;
		}

		protected int GetCategoryID(string cname)
		{
			for(int i=0;i<_category.DefaultView.Count;i++)
			{
			if (_category.DefaultView[i]["categoryname"].ToString()==cname)
				{
					return i;
				}
			}
			return 0;
				
		}



		#region Web Form Designer generated code
		/// 
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// 
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		
	}
}

The key points of this C# file are:

1.In Product_Edit() function, you have to call BindCategory() to set the _category datatable first, and then set the EditItemIndex for the datagrid, and at last, call BindProduct() function. The DropDownList control will not display anyting if you reverse this order. Because once you set the EditItemIndex, the datagrid begings rendering records, and at the same time, the DropDownList control access the function 'GetCategory()' to get the data source, if 'GetCategory()' returns nothing, you will not get anything of course. Just remember: before setting EditItemIndex of datagrid, set the data source of the control.

2.In Product_Update() function, You have no access to the DropDownList control directly which is embeded in the datagrid, the solution of getting the selected value of DropDownList control is the 'FindControl()' function. This function takes the DropDownList control's name as its argument, and return the DropDownList control it found, so that you can use the return control to get the selected value. Just remember: use FindControl() function to return any control you want to find in the datagrid, such as text box, text area, label, calendar.




相关文章

相关软件