how to retrieve data from sqlserver

Question

how to retrieve data from sqlserver . i store 5000 (its amount) i need to deduct the amount (if i give 5000-2000(textbox i give )3000 remaining should be shown in another textbox in asp.net using c#

MuthuMari M · Answer

Hi use like this select (no1 - no2) 'subtract' from subtract or using self join select a.Number1 coalesce(a.Number1- (select b.Number2 from tablename b ) a.Number1) as diff from tablename pls refer this url http://stackoverflow.com/questions/919136/subtracting-one-row-of-data-from-another-in-sql you have to modify conditions as per your need. thanks. If this post is useful then mark it as  Accepted Answer

selvi subramanian · Answer

i have to retrieve the value from sqlserver

MuthuMari M · Answer

Hi use the below code int a=Convert.ToInt32(Textbox1.Text); int b=Convert.ToInt32(Textbox2.Text); int c=a-b; TextBox3.Text=Convert.ToString(c); thanks. If this post is useful then mark it as  Accepted Answer