public Form_Index() { InitializeComponent(); System.IO.FileInfo fi = new System.IO.FileInfo("c:/SimpleWork79.sqlite"); if (fi.Exists) //파일존재 { flowLayoutPanel1.Controls.Clear(); SQLiteConnection conn = null; conn = new SQLiteConnection("Data Source=c:/SimpleWork79.sqlite;Version=3;"); conn.Open(); //업무 레이블들 생성 작업 필요 String sql = "select * from Work79"; SQLiteCommand command = new SQLiteCommand(sql, conn); SQLiteDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { UserControl1 us = new UserControl1(this); flowLayoutPanel1.Controls.Add(us); us.textBox1.Text = "" + rdr["wname"]; } rdr.Close(); } else //파일없음 { SQLiteConnection.CreateFile("c:/SimpleWork79.sqlite"); SQLiteConnection conn = null; conn = new SQLiteConnection("Data Source=c:/SimpleWork79.sqlite;Version=3;"); conn.Open(); MessageBox.Show("첫 실행을 환영합니다, 업무 세이브파일을 C드라이브에 생성했습니다"); string sql = "create table Work79 (wname varchar not null, wcon varchar, wsitu varchar, primary key(wname))"; SQLiteCommand command = new SQLiteCommand(sql, conn); int result = command.ExecuteNonQuery(); sql = "create table WorkAdd79 (wname varchar, wadd varchar, primary key(wname, wadd),foreign key(wname) references Work79 on delete cascade)"; command = new SQLiteCommand(sql, conn); result = command.ExecuteNonQuery(); Form_HINT formgo = new Form_HINT(); formgo.ShowDialog(); } }
private void button1_Click(object sender, EventArgs e) { Form_HINT formgo = new Form_HINT(); formgo.ShowDialog(); }