初识ASP.NET

最新推荐文章于 2020-10-17 08:16:24 发布

litoupu

最新推荐文章于 2020-10-17 08:16:24 发布

阅读量726

点赞数

分类专栏： ASP.NET 文章标签： asp.net string sql textbox delete insert

本文链接：https://blog.csdn.net/litoupu/article/details/6882072

版权

ASP.NET 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

利用VS自带数据库连接：

引用命名空间using System.Data.SqlClient;

 public void DeleteDb()
        {
            SqlConnection sqlcon = new SqlConnection(@"Data Source=.\sqlexpress;Integrated Security=True");
            sqlcon.Open();
            string sql = "delete FROM Experiment_Content";
            SqlCommand sqlCmd = new SqlCommand(sql, sqlcon);
            SqlDataAdapter sda = new SqlDataAdapter(sqlCmd);
            DataTable table = new DataTable();
            sda.Fill(table);
            // this.dataGridView1.DataSource = table;
            sqlcon.Close();

        }
        public void Insert(string sql0)
        {
            SqlConnection sqlcon = new SqlConnection(@"Data Source=.\sqlexpress;Integrated Security=True");
            sqlcon.Open();
            //string sql = "insert into Experiment (Exp_Id,Tran_Range,Node_Num,Client_retio,Transtraction_Num,Npush) values(4,1,1,1,1,1)";
            string sql = sql0;
            SqlCommand sqlCmd = new SqlCommand(sql, sqlcon);
            SqlDataAdapter sda = new SqlDataAdapter(sqlCmd);
            DataTable table = new DataTable();
            sda.Fill(table);
            //this.dataGridView1.DataSource = table;
            sqlcon.Close();
        }

1、 数据库连接的2种方式：
（1）Data Source=;Initial Catalog=;Integrated Security=True 不需要通过sa和密码直接登录页面
（2）<add name="take_out_system" connectionString="Data Source=USER62-PC\SQLEXPRESS;Initial Catalog=_TakeOutSystem;User Id=sa;Password=123456;"></add>
2.明码变成隐码：在相应的textbox里面多加入一行属性 TextMode="Password"(其中Password为textbox的Id)

3.类里面的一些命名规则。变量一般为_id ,_userName (下划线+小写。。后面的英语单词

大写)
方法名：一般大写字母开头

4.学会使用数据库的增删改查4条基本的语句：

增： string sql = "insert into category([name]) values(@caName)";

public bool AddComment(Comment c)
       {
           string sql = "insert into comment(newsid,[content],userip) values(@newsID,@content,@userIP)";
           SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@newsID",c.NewsId),new SqlParameter("@content",c.Content),new SqlParameter("@userIP",c.UserIP)};
           if (sqlhelper.ExecuteNonQuery(sql, paras,CommandType.Text) > 0)
           {
               return true;
           }
           return false;
       }

insert into [table] ([字段]) values(@a)

删： string sql = "Delete from category whereid=@id";

public bool Delete(int id)
       {
           string sql = "delete comment where id=@id";
           SqlParameter[] paras = new SqlParameter[] {new SqlParameter("@id",id) };
           if (sqlhelper.ExecuteNonQuery(sql,paras,CommandType.Text)>0)
           {
               return true;
           }
           return false;
       }

改：string sql = "update category set [name]=@caName whereid=@caId";

public bool Update(Category ca)
        {
            bool flag = false;
            string sql = "update category set [name]=@caName where id=@caId";
            SqlParameter[] paras = new SqlParameter[]
            {
            new SqlParameter("@caName",ca.Name),new SqlParameter("@caId",ca.Id)
            };

            if (sqlhelper.ExecuteNonQuery(sql, paras,CommandType.Text) > 0)
            {
                flag = true;
            }
            return flag;
        }

查：string sql = "select * from category whereid=@caid";

   public DataTable SelectByNewsID(int newsId)
       {
           DataTable dt = new DataTable();
           string sql = "select * from comment where newsid=@newsId";
           SqlParameter[] paras=new SqlParameter[]{new SqlParameter("@newsId",newsId)};
           dt=sqlhelper.ExecuteQuery(sql, paras,CommandType.Text);
           return dt;
       }