So in my project, I will let the user add the book that he wants, so I have created a new table for BooksAdded to users. so the user will choose the book and add it to the table, It will Insert the Book ID and the book name and the remaining quantity of the book from our main Books BookTbl and it will take the values for IssuedBy = loginscreen.username
and IssuedTIme = DateTime.now
How do I give these values any idea
I know that I am not using parameters i will use it later
sorry for the bad English
I wish you understand what I mean
What I have tried:
string mySQL = string.Empty;
mySQL += "INSERT INTO IssuedBooksTbl (Book_ID, Book_Name, RemainingQuantity, IssuedBy, IssuedTime)";
mySQL += "SELECT Book_ID, Book_Name, Quantitiy FROM BookTbl WHERE Book_ID='" + IDTxt.Text +"'";
Connection.LibraryBooksServer.executeSQL(mySQL);
............................................
SO IssuedBy = loginscreen.username
and IssuedTIme = DateTime.now
how do i give the values for them any idea