tabdb.cs

ASP C#代码实例 适合初学人士学习使用

using System;
using System.Data;
using System.Data.SqlClient;

namespace Example_9_1
{
	/// <summary>
	/// Summary description for TabDB.
	/// </summary>
	public class TabDetails
	{		
		public int          TabId;
		public String       TabName;
		public int          TabOrder;
	}

	public class TabDB
	{
		public SqlDataReader GetTabs()
		{
			///从数据库中Tabs表获取所有记录
			String cmdText = "SELECT * FROM Tabs ORDER BY TabOrder";
			SqlConnection myConnection = new SqlConnection(MySingelDataBind.SQLCONNECTIONSTRING);
			SqlCommand myCommand = new SqlCommand(cmdText,myConnection);

			///执行数据库查询
			myConnection.Open();
			SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
			
			///绑定TabList控件的数据
			return(dr);		
		}
	}
}