namespace DataGridView
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public void button1_Click(object sender, EventArgs e)
{
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
checkedListBox1.SetItemChecked(0, false);
checkedListBox1.SetItemChecked(1, false);
checkedListBox1.SetItemChecked(2, false);
checkedListBox1.SetItemChecked(3, false);
checkedListBox1.SetItemChecked(4, false);
string strSql = string.Format("select * from STUDENT ");
SqlConnection myconn = new SqlConnection("Data Source=172.16.42.193;Initial Catalog=OTRS;Integrated Security=True");
myconn.Open();
DataSet dataset = new DataSet();
SqlDataAdapter myDataAdapter = new SqlDataAdapter(strSql, myconn);
myDataAdapter.Fill(dataset); //这句跟下面的顺序不能颠倒
dataGridView1.DataSource = dataset.Tables[0];//填充
myconn.Close();
}
}
}
namespace WindowsControlLibrary1
{
public partial class UserControl1 : UserControl
{
public delegate void GoDelegate(object sender, EventArgs e);
public UserControl1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
//using DataGridView .
//{
//GoDelegate goDelegate = new GoDelegate( button1_Click);
//goDelegate(null, null);
//return;
//} 这里先调用上一个命名空间的button1——click函数
}
}
大侠救我!!!