Hello friends,
i have following tables
1) querytbl ( qid(pk) , query, date, time)
2) solutiontbl ( sid(pk) , solution,date, time,qid)
3) repeatquerytbl( reid(pk),date,time,qid)
using which i have created storded procdure which check
1) if query in the 1st table ie querytbl is not solved within 6 hours that query should be insertd into repeatquerytbl
2) if query in the querytbl is solved within 6 hour that
query should be insert into solution table with solution
so how i call stored procedure from Asp.net (C#)
i hope i will get solution from you
thank you.