易截截图软件、单文件、免安装、纯绿色、仅160KB

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


相关文档:

用 Sql添加删除字段,判断字段是否存在的方法

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数据库备份和还原

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 基本操作 删除 修改 刷新

SQL常用命令使用方法:    
   
  (1)   数据记录筛选:    
   
  sql="select   *   from   数据表   where   字段名=字段值   order   by   字段名   [desc]"    
   
  sq ......

C# asp.net macaddr

<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 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号