当前位置: 首页>>代码示例>>C#>>正文


C# DAO.GetDataTable方法代码示例

本文整理汇总了C#中DAO.GetDataTable方法的典型用法代码示例。如果您正苦于以下问题:C# DAO.GetDataTable方法的具体用法?C# DAO.GetDataTable怎么用?C# DAO.GetDataTable使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在DAO的用法示例。


在下文中一共展示了DAO.GetDataTable方法的9个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: Page_Load

 protected void Page_Load(object sender, EventArgs e)
 {
     if (this.Request.QueryString["docid"] != null)
     {
         string ls_docid = this.Request.QueryString["docid"].ToString();
         //根据文档ID得到记录
         DAO db = new DAO();
         string sql = "select * from hyp_flowmain where DOCID='" + ls_docid + "'";
         DataTable dt = db.GetDataTable(sql);
         string ls_flowid, ls_flowname, ls_mudelid, ls_curtacheid, ls_curtachename;
         if (dt.Rows.Count > 0)
         {
             ls_flowid = dt.Rows[0]["hy_flowid"].ToString();             //流程ID
             ls_flowname = dt.Rows[0]["hy_flowname"].ToString();         //流程名称
             ls_mudelid = dt.Rows[0]["hy_mudelid"].ToString();           //模块ID
             ls_curtacheid = dt.Rows[0]["hy_curtacheid"].ToString();     //当前环节ID
             ls_curtachename = dt.Rows[0]["hy_curtachename"].ToString(); //当前环节名称
             HyOperationlog HyOperationlog = new HyOperationlog();
             //制作表格式信息
             this.txtCurrnetDocFlow.Text = HyOperationlog.GetCurrnetDocFlow(ls_docid, ls_flowid, ls_flowname, ls_mudelid, ls_curtacheid, ls_curtachename);
         }
     }
 }
开发者ID:wjszxli,项目名称:Webapp,代码行数:23,代码来源:Hy_cklc.aspx.cs

示例2: getClass

    private string getClass(string strType)
    {
        if (this.ddl_tableid.SelectedValue == "")
        {
            Response.Write("<script>alert('对不起,请输入表名!!!');</script>");
            this.lb_showsql.Text = "&nbsp;";
            return "";
        }
        if (this.txt_con.Value != "")
        {
            strCon = this.txt_con.Value;
        }
        else
        {
            strCon = "server=(local);database=" + this.ddl_database.SelectedValue + ";uid=sa;[email protected]#$%^*(sa;";
        }
        DAO db = new DAO();
        //得到字段
        string sqlSelect = "  select a.name as [name],b.name as type from syscolumns a,systypes b where a.id=object_id('" + this.ddl_tableid.SelectedValue + "') and a.xtype=b.xtype";
        if (this.txt_sql.Value != "")
        {
            string[] arrySql = txt_sql.Value.Split('#');
            string sqlWhere = "";
            for (int i = 0; i < arrySql.Length; i++)
            {
                if (i == arrySql.Length - 1)
                {
                    sqlWhere += "'" + arrySql[i] + "'";
                }
                else
                {
                    sqlWhere += "'" + arrySql[i] + "',";
                }
            }
            sqlSelect += " and a.name not in(" + sqlWhere + ") ";
        }
        DataTable dt = new DataTable();
        try
        {
            dt = db.GetDataTable(sqlSelect);
        }
        catch (Exception ex)
        {
            throw ex;
            Response.Write("<script>alert('对不起,连接串输入有错误,系统将重置!');</script>");
            this.txt_con.Value = "";
            if (this.Session["constr"] != null)
            {
                this.Session["constr"] = null;
            }
            Response.Write("<script>window.location='" + this.Request.Url.ToString() + "';</script>");
        }
        string strInsert = " ";
        //构造类属性
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (strType == "1")
                {
                    strInsert += "public  " + getClassType(dt.Rows[i]["type"].ToString()) + " " + dt.Rows[i]["name"].ToString() + "; <br/>";
                }
                else
                {
                    strInsert += "public  " + getClassType(dt.Rows[i]["type"].ToString()) + " " + dt.Rows[i]["name"].ToString() + ";\r\n";
                }

            }
        }
        return strInsert;
    }
开发者ID:wjszxli,项目名称:Webapp,代码行数:71,代码来源:sqltest.aspx.cs

示例3: Page_Load

    protected void Page_Load(object sender, EventArgs e)
    {
        //对连接串赋值
        if (this.Session["constr"] != null)
        {
            this.txt_con.Value = this.Session["constr"].ToString();
        }
        if (!this.IsPostBack)
        {

            //连接数据库
            DAO db = new DAO();
            //找到库名
            string sqlSelect = " SELECT Name from Master..SysDatabases ORDER BY Name ";
            DataTable dt = new DataTable();
            try
            {
                dt = db.GetDataTable(sqlSelect);
            }
            catch (Exception ex)
            {
                Response.Write("<script>alert('对不起,连接串输入有错误,sql生成器急将重置!');</script>");
                this.txt_con.Value = "";
                if (this.Session["constr"] != null)
                {
                    this.Session["constr"] = null;
                }
                Response.Write("<script>window.location='" + this.Request.Url.ToString() + "';</script>");
            }
            this.ddl_database.DataSource = dt;
            this.ddl_database.DataTextField = "name";
            this.ddl_database.DataValueField = "name";
            this.ddl_database.DataBind();
            this.ddl_database.Items.Insert(0, new ListItem("--请选择--", ""));
            this.ddl_tableid.Items.Insert(0, new ListItem("--请选择--", ""));

        }
    }
开发者ID:wjszxli,项目名称:Webapp,代码行数:38,代码来源:sqltest.aspx.cs

示例4: ddl_database_SelectedIndexChanged

 protected void ddl_database_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (ddl_database.SelectedValue != "")
     {
         DAO db = new DAO();
         string sqlSelect = " SELECT Name FROM " + ddl_database.SelectedValue + "..SysObjects Where XType='U' ORDER BY Name ";
         DataTable dt = new DataTable();
         try
         {
             dt = db.GetDataTable(sqlSelect);
         }
         catch (Exception ex)
         {
             Response.Write("<script>alert('对不起,连接串输入有错误,系统将重置!');</script>");
             this.txt_con.Value = "";
             if (this.Session["constr"] != null)
             {
                 this.Session["constr"] = null;
             }
             Response.Write("<script>window.location='" + this.Request.Url.ToString() + "';</script>");
         }
         this.ddl_tableid.DataSource = dt;
         this.ddl_tableid.DataTextField = "name";
         this.ddl_tableid.DataValueField = "name";
         this.ddl_tableid.DataBind();
         this.ddl_tableid.Items.Insert(0, new ListItem("--请选择--", ""));
     }
     this.lb_showsql.Text = "&nbsp;";
 }
开发者ID:wjszxli,项目名称:Webapp,代码行数:29,代码来源:sqltest.aspx.cs

示例5: btn_update_Click

 //得到update语句
 protected void btn_update_Click(object sender, EventArgs e)
 {
     string sqlWhere = "";
     if (this.ddl_tableid.SelectedValue == "")
     {
         Response.Write("<script>alert('对不起,请输入表名!!!');</script>");
         this.lb_showsql.Text = "&nbsp;";
         return;
     }
     if (this.txt_con.Value != "")
     {
         strCon = this.txt_con.Value;
     }
     else
     {
         strCon = "server=(local);database=" + this.ddl_database.SelectedValue + ";uid=sa;[email protected]#$%^*(sa;";
     }
     DAO db = new DAO();
     //得到字段名
     string sqlSelect = " select name from syscolumns where id=object_id('" + this.ddl_tableid.SelectedValue + "') ";
     if (this.txt_sql.Value != "")
     {
         string[] arrySql = txt_sql.Value.Split('#');
         for (int i = 0; i < arrySql.Length; i++)
         {
             if (i == arrySql.Length - 1)
             {
                 sqlWhere += "'" + arrySql[i] + "'";
             }
             else
             {
                 sqlWhere += "'" + arrySql[i] + "',";
             }
         }
     }
     if (this.txt_where.Value != "")
     {
         string[] arrySql = txt_where.Value.Split('#');
         for (int i = 0; i < arrySql.Length; i++)
         {
             if (i == 0 && sqlWhere != "")
             {
                 sqlWhere += ",'" + arrySql[i] + "',";
             }
             else if (i == arrySql.Length - 1)
             {
                 sqlWhere += "'" + arrySql[i] + "'";
             }
             else
             {
                 sqlWhere += "'" + arrySql[i] + "',";
             }
         }
     }
     if (this.txt_sql.Value != "" || this.txt_where.Value != "")
     {
         sqlSelect += " and name not in(" + sqlWhere + ") ";
     }
     DataTable dt = new DataTable();
     try
     {
         dt = db.GetDataTable(sqlSelect);
     }
     catch (Exception ex)
     {
         Response.Write("<script>alert('对不起,连接串输入有错误,系统将重置!');</script>");
         this.txt_con.Value = "";
         if (this.Session["constr"] != null)
         {
             this.Session["constr"] = null;
         }
         Response.Write("<script>window.location='" + this.Request.Url.ToString() + "';</script>");
     }
     //开始构造update语句
     string strUpdate = "sqlUpdate=\"  update  " + this.ddl_tableid.SelectedValue + " set  ";
     if (dt.Rows.Count > 0)
     {
         int j = 1;
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             if (i == 0)
             {
                 strUpdate += dt.Rows[0]["name"].ToString() + "[email protected]" + dt.Rows[0]["name"].ToString();
             }
             else
             {
                 strUpdate += "," + dt.Rows[i]["name"].ToString() + "[email protected]" + dt.Rows[i]["name"].ToString();
             }
             if (strUpdate.Length > (100 * j))
             {
                 strUpdate += "\";</br>sqlUpdate+=\"";
                 j++;
             }
         }
     }
     if (this.txt_where.Value != "")
     {
         strUpdate += " where 1=1";
         string[] arryWhere = this.txt_where.Value.Split('#');
//.........这里部分代码省略.........
开发者ID:wjszxli,项目名称:Webapp,代码行数:101,代码来源:sqltest.aspx.cs

示例6: btn_sqlparam_Click

 //得到sqlparam
 protected void btn_sqlparam_Click(object sender, EventArgs e)
 {
     if (this.ddl_tableid.SelectedValue == "")
     {
         Response.Write("<script>alert('对不起,请输入表名!!!');</script>");
         this.lb_showsql.Text = "&nbsp;";
         return;
     }
     DAO db = new DAO();
     //得到字段和字段类型
     string sqlSelect = "  select a.name as [name],b.name as type from syscolumns a,systypes b where a.id=object_id('" + this.ddl_tableid.SelectedValue + "') and a.xtype=b.xtype";
     if (this.txt_sql.Value != "")
     {
         //过滤条件
         string[] arrySql = txt_sql.Value.Split('#');
         string sqlWhere = "";
         for (int i = 0; i < arrySql.Length; i++)
         {
             if (i == arrySql.Length - 1)
             {
                 sqlWhere += "'" + arrySql[i] + "'";
             }
             else
             {
                 sqlWhere += "'" + arrySql[i] + "',";
             }
         }
         sqlSelect += " and a.name not in(" + sqlWhere + ") ";
     }
     DataTable dt = new DataTable();
     try
     {
         dt = db.GetDataTable(sqlSelect);
     }
     catch (Exception ex)
     {
         Response.Write("<script>alert('对不起,连接串输入有错误,系统将重置!');</script>");
         this.txt_con.Value = "";
         if (this.Session["constr"] != null)
         {
             this.Session["constr"] = null;
         }
         Response.Write("<script>window.location='" + this.Request.Url.ToString() + "';</script>");
     }
     //开始构造
     string strInsert = " SqlParameter[] sqlparam = {";
     if (dt.Rows.Count > 0)
     {
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             if (i == dt.Rows.Count - 1)
             {
                 strInsert += " <br/>  db.MakeInParam(\"@" + dt.Rows[i]["name"].ToString() + "\",SqlDbType." + getDateType(dt.Rows[i]["type"].ToString()) + "," + dt.Rows[i]["name"].ToString() + ")";
             }
             else
             {
                 strInsert += "db.MakeInParam(\"@" + dt.Rows[i]["name"].ToString() + "\",SqlDbType." + getDateType(dt.Rows[i]["type"].ToString()) + "," + dt.Rows[i]["name"].ToString() + "),<br/>";
             }
         }
         strInsert += "};";
     }
     //前台显示出来
     this.lb_showsql.Text = strInsert;
 }
开发者ID:wjszxli,项目名称:Webapp,代码行数:65,代码来源:sqltest.aspx.cs

示例7: btn_speed_Click

 //得到sql的执行速度
 protected void btn_speed_Click(object sender, EventArgs e)
 {
     if (this.txt_sql.Value == "")
     {
         Response.Write("<script>alert('对不起,请输入sql语句!!!');</script>");
         return;
     }
     return;
     string sqlActive = " Declare @d Datetime Set @d=GetDate() " + this.txt_sql.Value + " Select [datetime]=DateDiff(ms,@d,GetDate()) ";
     if (this.txt_con.Value != "")
     {
         strCon = this.txt_con.Value;
     }
     else
     {
         strCon = "server=(local);database=" + this.ddl_database.SelectedValue + ";uid=sa;[email protected]#$%^*(sa;";
     }
     DAO db = new DAO();
     DataTable dt = db.GetDataTable(sqlActive);
     if (dt.Rows.Count > 0)
     {
         this.lb_showsql.Text = "SQL的执行速度为:" + dt.Rows[0]["datetime"].ToString();
     }
 }
开发者ID:wjszxli,项目名称:Webapp,代码行数:25,代码来源:sqltest.aspx.cs

示例8: btn_insert2_Click

 protected void btn_insert2_Click(object sender, EventArgs e)
 {
     if (this.ddl_tableid.SelectedValue == "")
     {
         Response.Write("<script>alert('对不起,请输入表名!!!');</script>");
         this.lb_showsql.Text = "&nbsp;";
         return;
     }
     if (this.txt_con.Value != "")
     {
         strCon = this.txt_con.Value;
     }
     else
     {
         strCon = "server=(local);database=" + this.ddl_database.SelectedValue + ";uid=sa;[email protected]#$%^*(sa;";
     }
     DAO db = new DAO();
     //得到字段
     string sqlSelect = " select name from syscolumns where id=object_id('" + this.ddl_tableid.SelectedValue + "') ";
     if (this.txt_sql.Value != "")
     {
         string[] arrySql = txt_sql.Value.Split('#');
         string sqlWhere = "";
         //构造where条件句
         for (int i = 0; i < arrySql.Length; i++)
         {
             if (i == arrySql.Length - 1)
             {
                 sqlWhere += "'" + arrySql[i] + "'";
             }
             else
             {
                 sqlWhere += "'" + arrySql[i] + "',";
             }
         }
         sqlSelect += " and name not in(" + sqlWhere + ") ";
     }
     DataTable dt = new DataTable();
     try
     {
         dt = db.GetDataTable(sqlSelect);
     }
     catch (Exception ex)
     {
         Response.Write("<script>alert('对不起,连接串输入有错误,系统将重置!');</script>");
         this.txt_con.Value = "";
         if (this.Session["constr"] != null)
         {
             this.Session["constr"] = null;
         }
         Response.Write("<script>window.location='" + this.Request.Url.ToString() + "';</script>");
     }
     //开始构造insert
     string strInsert = " insert into " + this.ddl_tableid.SelectedValue + "( ";
     int j = 1;
     if (dt.Rows.Count > 0)
     {
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             if (i == 0)
             {
                 strInsert += dt.Rows[0]["name"].ToString();
             }
             else
             {
                 strInsert += "," + dt.Rows[i]["name"].ToString();
             }
             //对sql进行格式化
             if (strInsert.Length > (100 * j))
             {
                 strInsert += "</br>";
                 j++;
             }
         }
         strInsert += ") values ( ";
         string flowid = "";
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             flowid = dt.Rows[i]["name"].ToString();
             if (flowid.IndexOf("hyc") != -1)
             {
                 flowid = flowid.Substring(4);
             }
             if (flowid.IndexOf("hy_") != -1)
             {
                 flowid = flowid.Substring(3);
             }
             if (i == 0)
             {
                 strInsert += "'\"+this." + flowid + ".Value+\"'";
             }
             else
             {
                 strInsert += ",'\"+this." + flowid + ".Value+\"'";
             }
             //对sql进行格式化
             if (strInsert.Length > (100 * j))
             {
                 strInsert += "</br>";
                 j++;
//.........这里部分代码省略.........
开发者ID:wjszxli,项目名称:Webapp,代码行数:101,代码来源:sqltest.aspx.cs

示例9: getInsert

    private string getInsert(string strType)
    {
        if (this.ddl_tableid.SelectedValue == "")
        {
            Response.Write("<script>alert('对不起,请输入表名!!!');</script>");
            this.lb_showsql.Text = "&nbsp;";
            return "";
        }
        if (this.txt_con.Value != "")
        {
            strCon = this.txt_con.Value;
        }
        else
        {
            strCon = "server=(local);database=" + this.ddl_database.SelectedValue + ";uid=sa;[email protected]#$%^*(sa;";
        }
        DAO db = new DAO();
        //得到字段
        string sqlSelect = " select name from syscolumns where id=object_id('" + this.ddl_tableid.SelectedValue + "') ";
        if (this.txt_sql.Value != "")
        {
            string[] arrySql = txt_sql.Value.Split('#');
            string sqlWhere = "";
            //构造where条件句
            for (int i = 0; i < arrySql.Length; i++)
            {
                if (i == arrySql.Length - 1)
                {
                    sqlWhere += "'" + arrySql[i] + "'";
                }
                else
                {
                    sqlWhere += "'" + arrySql[i] + "',";
                }
            }
            sqlSelect += " and name not in(" + sqlWhere + ") ";
        }
        DataTable dt = new DataTable();
        try
        {
            dt = db.GetDataTable(sqlSelect);
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('对不起,连接串输入有错误,系统将重置!');</script>");
            this.txt_con.Value = "";
            if (this.Session["constr"] != null)
            {
                this.Session["constr"] = null;
            }
            Response.Write("<script>window.location='" + this.Request.Url.ToString() + "';</script>");
        }
        //开始构造insert
        string strInsert = " sqlInsert =\" insert into " + this.ddl_tableid.SelectedValue + "( ";
        int j = 1;
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (i == 0)
                {
                    strInsert += dt.Rows[0]["name"].ToString();
                }
                else
                {
                    strInsert += "," + dt.Rows[i]["name"].ToString();
                }
                //对sql进行格式化
                if (strInsert.Length > (100 * j))
                {
                    if (strType == "1")
                    {
                        strInsert += "\";</br> sqlInsert +=\" ";
                    }
                    else
                    {
                        strInsert += "\";\r\nsqlInsert +=\" ";
                    }

                    j++;
                }
            }
            strInsert += ") values ( ";
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (i == 0)
                {
                    strInsert += "@" + dt.Rows[0]["name"].ToString();
                }
                else
                {
                    strInsert += ",@" + dt.Rows[i]["name"].ToString();
                }
                //对sql进行格式化
                if (strInsert.Length > (100 * j))
                {
                    if (strType == "1")
                    {
                        strInsert += "\";</br> sqlInsert +=\" ";
                    }
//.........这里部分代码省略.........
开发者ID:wjszxli,项目名称:Webapp,代码行数:101,代码来源:sqltest.aspx.cs


注:本文中的DAO.GetDataTable方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。