i have marked in bold the query in question ..whch gives me the the runtime error mentioned at the below , i double checked everything all the table names and the field names are correct so whats the problem , please anyone??
im really stumped!
if (Radio_Btn_Book.Checked == true)
{
string book_query = "update Issue_Book_Reserve I set I.Issue_Book_Reserve_state = 1 where I.Book_Id = Books.Book_Id and Books.Book_Name = '" + Session["Book_name"].ToString()+"'";
SqlCommand Cmd_book = new SqlCommand(book_query, con);
con.Open();
Cmd_book.ExecuteNonQuery();
con.Close();
}
ERROR:
The column prefix 'Books' does not match with a table name or alias name used in the query.
The column prefix 'Books' does not match with a table name or alias name used in the query.
string book_query = "update Issue_Book_Reserve I set I.Issue_Book_Reserve_state = 1 where I.Book_Id =Books.Book_Id and Books.Book_Name = '" + Session["Book_name"].ToString()+"'";
whats this ? there is no reference of books table please check ... or change it to
whats is this Books ? is it a object in that case use query like this
string book_query = "update Issue_Book_Reserve I set I.Issue_Book_Reserve_state = 1 where I.Book_Id = " +Books.Book_Id + " and I.Book_Name = '" + Session["Book_name"].ToString()+"'";
not sure what this Books is ...
|||there are 2 tables in the query
Issue_Book_reference and Books
|||
1update Issue_Book_Reserve I2set I.Issue_Book_Reserve_state = 13from Books B4where I.Book_Id = B.Book_Idand B.Book_Name ='" + Session["Book_name"].ToString()+"'";
use this sql
