private void btn_reg_Click(object sender, EventArgs e) { SQLiteConnection m_dbConnection; string con_str = @"Data Source=E4U_liteDB.db; Version = 3;"; //SqlConnection cn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\Локальный диск Е\Exampl pop up\Exampl pop up\E4U.mdf;Integrated Security=True"); //SqlDataAdapter cmd = new SqlDataAdapter(); if (txt_UserName.Text != "") { m_dbConnection = new SQLiteConnection(con_str); m_dbConnection.Open(); //cn.Open(); string login = txt_UserName.Text; name = txt_UserName.Text; string date = Convert.ToString(DateTime.Today); //string sql = "INSERT INTO [TABLE](Id, Login, Password) VALUES (NULL,'" + txt_UserName.Text + "','" + txt_Password.Text + "')"; string sql1 = "INSERT INTO profile_data(Login,Reg_date, Categories, TimeIn) VALUES ('" + txt_UserName.Text + "','" + date + "', '', '00:00:00')"; //SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); //command.ExecuteNonQuery(); SQLiteCommand command1 = new SQLiteCommand(sql1, m_dbConnection); command1.ExecuteNonQuery(); m_dbConnection.Close(); //SQLiteDataReader reader = command.ExecuteReader(); //cmd.InsertCommand = new SqlCommand("INSERT INTO [TABLE] VALUES ('" + txt_UserName.Text + "','" + txt_Password.Text + "')"); //cmd.InsertCommand.Connection = cn; //cmd.InsertCommand.ExecuteNonQuery(); //cn.Close(); Form0 frm0 = new Form0(frm_reg.name); frm0.Show(); this.Hide(); } }
private void btn_reg_Click(object sender, EventArgs e) { //this.Hide(); Form0 form0 = new Form0(frm_reg.name); form0.Show(); this.Hide(); }