AddArticle.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace BBS
{
    public partial class AddArticle : Form
    {
        public string title_text;
        public string abstract_text;
        public string content_text;
        public string category_name;
        public int category_id;

        public AddArticle()
        {
            InitializeComponent();
        }

        private void AddArticle_Load(object sender, EventArgs e)
        {
            // 窗口初始化设置
            // 焦点重设
            textBox_title.Focus();

            string sqlconf = "Server=127.0.0.1;User ID=root;Password=51aspx;Database=bbs_csharp;";
            MySqlConnection sqlConnection = new MySqlConnection(sqlconf);
            sqlConnection.Open();
            // 渲染文章分类
            string sql2 = "select name from category where user_id = '" + DataShare.LoginUserId + "';";
            MySqlCommand sqlCommand2 = new MySqlCommand(sql2, sqlConnection);
            MySqlDataAdapter mysqlDataAdapter = new MySqlDataAdapter(sqlCommand2);
            DataSet dataset = new DataSet();
            mysqlDataAdapter.Fill(dataset, "Category");
            int total = dataset.Tables["Category"].Rows.Count; // 总的数据行数
            for (int i = 0; i < total; i++)
            {
                comboBox_category.Items.Add(dataset.Tables["Category"].Rows[i]["name"].ToString());
            }
            // 渲染文章标签
            string sql_tag = "SELECT name FROM tag WHERE user_id= '" + DataShare.LoginUserId + "';";
            MySqlCommand sqlCommand3 = new MySqlCommand(sql_tag, sqlConnection);
            MySqlDataAdapter mysqlDataAdapter_tag = new MySqlDataAdapter(sqlCommand3);
            DataSet dataset_tag = new DataSet();
            mysqlDataAdapter_tag.Fill(dataset_tag, "Tags");
            int total_tag = dataset_tag.Tables["Tags"].Rows.Count;
            for (int j = 0; j < total_tag; j++)
            {
                comboBox_tag.Items.Add(dataset_tag.Tables["Tags"].Rows[j]["name"].ToString());
            }
            sqlConnection.Close();
        }