3
Answers

Book are not sold out by using join

Seshadri M

Seshadri M

7y
228
1

which book are not sold out in Book table and given Book name


Book
BID Bookname pricecode
1 Harry potter AB01
2 Sheldon AB01
3 Dan brown AB01
4 Cindrella AB01
 
Sold
ID BID sold date
1 1 9/13/2017
2 2 9/12/2017
3 4 9/15/2017
4 8 9/19/2017
 
select Bookname from Book Join sold  on Book.BID=Sold.BID where sold date IS null 
--i am not getting expected output 
 
Answers (3)
1
Puneet Kankar

Puneet Kankar

NA 2.8k 72k 7y
please check this link
 
http://blog.stevensanderson.com/2010/01/28/editing-a-variable-length-list-aspnet-mvc-2-style/  
0
Gajendra Singh

Gajendra Singh

NA 41 993 7y
Thank you very much Sir for your sugeestion.
0
Gajendra Singh

Gajendra Singh

NA 41 993 7y
sir there is one problem in this code i want to create multiple rows with single control not with multiple control multiple control means adding by jquery i dont want this type of code so please help me
 
for example i want to add product list one by one and store them on one click in database in mvc 
 
this is for  multiple request  
0
Harminder Singh

Harminder Singh

NA 617 516k 7y
Yes you can use State Management techniques to acheive this requirement.
0
Manas Mohapatra

Manas Mohapatra

NA 29.3k 3.3m 7y
You can use client side Session storage to keep your entered value. Next when you need just fetch from session storage object.
 
https://www.w3schools.com/html/html5_webstorage.asp 
 
https://www.tutorialrepublic.com/html-tutorial/html5-web-storage.php