Yes, SQL can store the data you describe quite well.
Here are a few terms you may want to research:
1) Primary key 2) Foreign key 3) Transaction
Basically what you describe is a classic Master-detail relationship where the Order is the master and the Items are the details. You would define a primary key on the Order table which uniquely defines the order, then that primary key is used in the Items table as a foreign key (relating all of the Items back to the single Order).
When you do updates to the Order/Items, you will use a transaction which ensures that all of the updates across all of the records are performed consistently or not at all.
I am saving the following html in a database the trying to display it to show the recent activities for my user. I am doing this because the recent activities might contain HREFs. The problem that my result is not showing properly. it's not aligned normal to left although I tried to add align='left' to the
what can i do?
here is the saved data in the text datatype field:
There are only 10 types of people in the world, those who understand binary and those who don't.
on Applicationdetails.aspx page i have a button control.on this button click event ,i want to change linkbutton's(this linkbutton is on webform1.aspx) text from "verify" to "verified".
Does not make any sense. You are on another page and want some text to be changed on a page which is not currently in view!
What it sounds is, after you click this button, whenever you visit the 'Webform1.aspx', you should see a new text. If so, on button click, set a flag (store it somewhere if needed as per workflow) that is accessible in webform1 page. When loading that page, use this flag and based on it's value set the text.
could u tell me how to set a flag pls i have written my code...when i visit webform1.aspx 2nd time ,that record is not shown .....ie verfied record...so i have to set linkbutton's text to "verifid"....pls help me...what is d syntax to get linkbutton's text...pls help me
hi in my table request i have columns as follows requestid,applicationid,statusid,usertypeid & the data is 1,xxxxx, 1,6 2,xxxxx,2,7 3,xxxxx,3,8 i vil pass requestid to a storedprocedure , and i want to increment statusid,usertype by 1. create procedure updateusertypeid_statusid @requestid int as begin update request set usertypeid += 1, statusid += 1 where requestid = @requestid.....this is not working pls help me to implement this requirement