数据库的增

增

        private void btnSaveToDB_Click(object sender, EventArgs e)//保存到数据库
        {//按钮，保存
            dataGridView1.DataSource = null;
            List ls1 = new List();
            k课表 kb = new k课表()
            {
                k课名 = txtCourseName.Text,
                k课时 = txtClassHour.Text,
                k课类 = cbbCategory.Text,
                k课学分 = Convert.ToInt32(txtCredit.Text),
                k课概述 = txtCourseContent.Text,
            };
            dataGridView1.DataSource = null;
            j加课业务 jk = new j加课业务();
            jk.增(kb);
           
            ls1.Add(kb);
           
            dataGridView1.DataSource = ls1;
            dataGridView1.AutoGenerateColumns = true;
        }

        public k课表 增(k课表 jk)
        {
            sql业务 sql = new sql业务();
            string sqlstring = "insert into k课表(k课名,k课时,k课类,k课概述,k课学分,k课备用)";
            sqlstring += $"values(@k课名,@k课时,@k课类,@k课概述,@k课学分,@k课备用)";
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@k课名",jk.k课名),
                new SqlParameter("@k课时",jk.k课时),
                new SqlParameter("@k课类",jk.k课类),
                new SqlParameter("@k课概述",jk.k课概述),
                new SqlParameter("@k课学分",jk.k课学分),
                new SqlParameter("@k课备用",jk.k课备用),
            };

            sql.增(sqlstring, param);

            return jk;
        }

        public object 增(string str, SqlParameter[] param)
        {
            object obj = sql执行(str, param);
            return obj;
        }

    public class sql业务
    {
        SqlConnection conn;
        public object sql执行(string sqlcmd, SqlParameter[] param)//执行sql语句
        {
            object get = string.Empty;
            string link = $"Server={sql数据.sql服务器}"
                        + ";"
                        + $"Database={sql数据.sql库名}"
                        + ";"
                        + $"uid={sql数据.sql账号}"
                        + ";"
                        + $"pwd={sql数据.sql密码}"
                        + ";"
                        ;
            conn = new SqlConnection(link);//sql连接
            SqlCommand cmd = new SqlCommand(sqlcmd, conn);//命令，sql连接
            if (param != null)
            {
                cmd.Parameters.AddRange(param);
            }
            try
            {//关闭状态
                if (conn.State == System.Data.ConnectionState.Closed)
                {
                    conn.Open();
                    sql数据.sql状态 = conn.State.ToString();//"Open"
                }
                //select忽略大小写，没有为-1
                int indefof = sqlcmd.IndexOf("select", StringComparison.OrdinalIgnoreCase);
                if (indefof != -1)//包含  select  这个单词
                {//执行select语句
                    //object obj1 = cmd.ExecuteScalar();//返回第一行第一列
                    //sql数据.sql第1行1列 = obj1.ToString();
                    SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);//带关闭的读取

                    return reader;//退给 查询业务
                }
                else
                {//非查询语句
                    get = cmd.ExecuteNonQuery();//返回受影响的行数。
                }
            }
            catch (Exception e)
            {
                sql数据.sql状态 = e.ToString();
                conn.Close();
                //throw;
            }
            //finally
            //{//框架，关闭数据库连接
            //    //conn.Close();
            //}
            //返回对象
            return get;
        }