private void BringForthTheInterfaces()
{
this.StartPosition = FormStartPosition.CenterScreen;
ctrlTabs = new UserControl2();
ctrlEmp = new UserControl1();
ctrlMain = new UserControl3();
panelEmployee.Controls.Add(ctrlEmp);
panelTabs.AutoScroll = true;
panelTabs.Controls.Add(ctrlTabs);
panelMain.Controls.Add(ctrlMain);
}
//主窗体加载
private void FormMain_Load(object sender, EventArgs e)
{
panelTop.BackColor = ColorTranslator.FromHtml("#398dee");
panelNewFile.BackColor = ColorTranslator.FromHtml("#398dee");
uc1 = new UserControl1();
uc3 = new UserControl3();
//默认UC1控件显示
uc1.Show();
textBoxgroup.Controls.Clear();
textBoxgroup.Controls.Add(uc1);
//委托点击按钮新建笔记
this.uc1.button1.Click += userControl11_button1_Click;
string str = "delete from tbl_note";
string str1 = "delete from tbl_rabbish";
MyMeans.getsqlcom(str);
MyMeans.getsqlcom(str1);
//显示所有的文件夹
String SQLstr = "select * from tbl_folder";
SqlConnection My_con;
string M_str_sqlcon = "Integrated Security=SSPI;Database=notebook;Server=.";
My_con = new SqlConnection(M_str_sqlcon);
My_con.Open();
SqlCommand cmd = new SqlCommand(SQLstr, My_con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "tbl_folder");
//获取表中有多少条记录，循环显示文件夹
SqlConnection conn = new SqlConnection("Integrated Security=SSPI;Database=notebook;Server=.");
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandText = "select count(*) from tbl_folder";
comm.Connection = conn;
int count = (int)comm.ExecuteScalar();
for (int i = 0; i < count; i++)
{
string foldername = ds.Tables["tbl_folder"].Rows[i]["foldername"].ToString();
newnode = new TreeNode(foldername, 0, 0);
treeViewFolder.Nodes.Add(newnode);
}
}
