C#与SQL Server 2000实现无限级菜单
//tree.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Threading;
public partial class MenuTree : System.Web.UI.Page
{
SqlDataAdapter da = null;
SqlConnection con = new SqlConnection("server=test;database=DQYPSite_oa;uid=sa;pwd=mfeilgm");
int i = 0;
int count = 0;
int proID = 0;
int column = 0;
string nextClassParentID;
string nextnode;
ArrayList columD = new ArrayList();
DataSet TreeTable = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string cmdStr = "select * from YP_FileClass order by ClassID";
da = new SqlDataAdapter(cmdStr, con);
da.Fill(TreeTable,"ClassForlder");
this.count = TreeTable.Tables["ClassForlder"].Rows.Count;
if (this.count > 0)
{
CreatNode(i);
}
els
相关文档:
http://www.cnblogs.com/dwjaissk/archive/2006/07/25/459476.aspx
增加字段
alter table docdsp add dspcode char(200)
删除字段
ALTER TABLE
table_NAME DROP COLUMN column_NAME
修改字段类型
ALTER TABLE table_name
ALTER COLUMN column_name new_data_type
改名
sp_rename
更改当前数据库中 ......
asp.net(C#)实现SQL2000数据库备份和还原
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.Htm ......
SQL常用命令使用方法:
(1) 数据记录筛选:
sql="select * from 数据表 where 字段名=字段值 order by 字段名 [desc]"
sq ......
<HTML><HEAD><TITLE>WMI Scripting HTML</TITLE>
<META http-equiv=Content-Type c>
<SCRIPT language=JScript event="OnCompleted(hResult,pErrorObject, pAsyncContext)" for=foo>
var MACaddress=unescape(MACAddr);
alert(MACaddress);
document.forms[0].txtMACAddr.value=u ......