继续贴代码

最新推荐文章于 2025-05-14 14:39:27 发布

猴子酋长

最新推荐文章于 2025-05-14 14:39:27 发布

阅读量299

点赞数

CC 4.0 BY-SA版权

分类专栏：随便写写文章标签： textbox object null button class sql

本文链接：https://blog.youkuaiyun.com/sp_chenjie/article/details/4087589

随便写写专栏收录该内容

10 篇文章

订阅专栏

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

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text.Equals(""))
            {
                return;
            }
            int paramcount = 0;
            StringBuilder sbparam = new StringBuilder();
            for (int i = 0; i < dataGridView1.RowCount; i++)
            {
                if (dataGridView1.Rows[i] == null)
                {
                    continue;
                }

                if (dataGridView1.Rows[i].Cells[0] == null)
                {
                    continue;
                }

                if (dataGridView1.Rows[i].Cells[0].Value == null)
                {
                    continue;
                }

                if (dataGridView1.Rows[i].Cells[0].Value.Equals(""))
                {
                    continue;
                }
                paramcount++;
                sbparam.Append("<PARAMENT ID=/"");
                sbparam.Append(dataGridView1.Rows[i].Cells[0].Value);
                sbparam.Append("/" TYPE=/"");
                sbparam.Append(dataGridView1.Rows[i].Cells[1].Value);
                sbparam.Append("/" />");
            }

            StringBuilder sb = new StringBuilder();
            sb.Append("<SQL ID=/"");
            sb.Append(textBox3.Text);
            sb.Append("/" PARAMCOUNT=/"");
            sb.Append(paramcount);
            sb.Append("/" >");

            sb.Append("<STATMENT>");
            sb.Append(textBox1.Text);
            sb.Append("</STATMENT>");

sb.Append(sbparam);

sb.Append("</SQL>");

textBox2.Text = sb.ToString();
}

        private void Form1_Load(object sender, EventArgs e)
        {
            DataGridViewComboBoxColumn column = (DataGridViewComboBoxColumn)dataGridView1.Columns[1];
            column.Items.AddRange(Enum.GetNames(typeof(MySql.Data.MySqlClient.MySqlDbType)));
        }
    }
}