110,571
社区成员
发帖
与我相关
我的任务
分享
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 DevComponents.DotNetBar.Controls;
namespace StarCoder
{
public partial class CreateWeb : Form
{
MainForm MF;
DataTable dtUserTable;
public CreateWeb(MainForm M)
{
this.Text = Program.Name;
MF = M;
InitializeComponent();
}
private void CreateWeb_Load(object sender, EventArgs e)
{
this.Name = Program.Name;
this.dataGridViewX1.AutoGenerateColumns = false;
this.dataGridViewX1.AllowUserToAddRows = false;
dtUserTable = MF.GetUserTables();
this.cbxUserTable.DataSource = dtUserTable;
dtUserTable.Columns.Add(new DataColumn("nameAndComment"));
foreach (DataRow dr in dtUserTable.Rows)
{
dr["nameAndComment"] = dr["name"].ToString() + "(" + dr["comment"].ToString() + ")";
}
this.cbxUserTable.DisplayMember = "nameAndComment";
this.cbxUserTable.ValueMember = "name";
BindUserTable();
}
void BindUserTable()
{
this.dataGridViewX1.DataSource = null;
string tb = this.cbxUserTable.SelectedValue.ToString();
DataTable dt = MF.GetTableColumnsInfo(MF.DataBase, tb);
this.dataGridViewX1.DataSource = dt;
}
private void cbxUserTable_SelectedIndexChanged(object sender, EventArgs e)
{
BindUserTable();
}
private void dataGridViewX1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
DataGridViewComboBoxExColumn cbxCol = this.dataGridViewX1.Columns[5] as DataGridViewComboBoxExColumn;
cbxCol.DataSource = dtUserTable;
cbxCol.DisplayMember = "nameAndComment";
cbxCol.ValueMember = "name";
BindControlType();
}
private void pbox_Click(object sender, EventArgs e)
{
this.Hide();
MF.Show();
}
public void BindControlType()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("id"));
dt.Columns.Add(new DataColumn("name"));
DataRow dr = dt.NewRow();
dr[0] = "lbl";
dr[1] = "标签";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "rbx";
dr[1] = "单选框";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "cbx";
dr[1] = "复选框";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "ddl";
dr[1] = "下拉列表";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "txt";
dr[1] = "密码输入";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "txt";
dr[1] = "单行文本框";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "txt";
dr[1] = "多行文本框";
dt.Rows.Add(dr);
DataGridViewComboBoxExColumn cbxCol = this.dataGridViewX1.Columns[4] as DataGridViewComboBoxExColumn;
cbxCol.DataSource = dt;
cbxCol.DisplayMember = "name";
cbxCol.ValueMember = "id";
}
}
}