Sql query for adding data to table

See more:

C#

SQL

WPF

Hi Developers, I am having a problem I am working on a Library Management System using C#(WPF) and SQL. i am having am Admin Panel and Student Panel So from the Admin panel i will add books to the book database (BooksTbl) and in Student panel it will be listed by using datagrid so the question is how are the student gonna add the book to their student database(StudentsTbl) i have created a database that insert all books that have been added by students and will be visible in admin panel by who and the time that been added

IssuedBooks = Table for books that will be added from students
BookTbl = Main Books Table

What I have tried:

string mySQL = string.Empty;
           mySQL += "INSERT INTO IssuedBooksTbl (Book_ID, Book_Name, RemainingQuantity,)";
           mySQL += "SELECT Book_ID, Book_Name, Quantitiy FROM BookTbl WHERE Book_ID='" + IDTxt.Text +"'";
           mySQL += "INSERT INTO IsuuedBooksTbl (IssuedBy = '" + Loginscreen.recBy + "', IssuedTime = '" + DateTime.Now + "')";
           Connection.LibraryBooksServer.executeSQL(mySQL);

           System.Windows.MessageBox.Show("Book Added");