473,749 Members | 2,597 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Update SQLserver Database Table Column.

2 New Member
Dear Sir,

I'm maintaining a Table in SQLserver, the Table contains Transaction of Cash IN(Debit) and Cash OUT(Credit) as follows:
Table Name : "BankLedger "
Expand|Select|Wrap|Line Numbers
  1. DATE...DETAILS........DEBIT...CREDIT...BALANCE
  2. 1/1/11.Opening Balance.................5000
  3. 1/1/11.Rent payment...........2500.....
  4. 2/1/11.Mobile Bill.............500.....
  5. 3/1/11.Monthly Share...5000............
  6. 6/1/11.Emp Salary.............3000.....
Now my requirement is how to update the Balance column respectively same as "Running Total" method???
Expand|Select|Wrap|Line Numbers
  1. DATE....DETAILS........DEBIT...CREDIT..BALANCE
  2. 1/1/11..Opening Balance................5000
  3. 1/1/11..Rent payment...........2500....2500
  4. 2/1/11..Mobile Bill.............500....2000
  5. 3/1/11..Monthly Share...5000...........7000
  6. 6/1/11..Emp Salary.............3000....4000
  7.  
My application in Visual Basic 2010 and Database SQLserver 2008.

Expecting your answer with sample codes....

Thanks in advance.
Mar 26 '11 #1
3 2215
BlackLibrary
16 New Member
Hard to understand what you want...except that you are overdemanding in tone.
Mar 26 '11 #2
kadghar
1,295 Recognized Expert Top Contributor
I agreee with BlackLibrary.

Anyway, why don't you ask google about the SLQClient library?
You might be interested in:
Opening an SqlConnection,
Filling a DataSet using an SqlDataAdapter
Updating your info with an SqlCommandBuild er
Mar 27 '11 #3
VijaySofist
107 New Member
Hi,

Check this URL below. This may be helpful to you

http://www.sqldev.org/transactsql/sq...ng-95189.shtml

Regards
Vijay.R
Mar 30 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
17351
by: Martin Lucas-Smith | last post by:
Can anyone point me to a regular expression in PHP which could be used to check that a proposed (My)SQL database/table/column name is valid, i.e. shouldn't result in an SQL error when created? The user of my (hopefully to be opensourced) program has the ability to create database/table/column names on the fly. I'm aware of obvious characters such as ., , things like >, etc., which won't work, but haven't been able to source a...
0
1908
by: zhaoJian | last post by:
Here it is my code ,but it can't update the database.How to do it ? In _UpdateUnit event, I can not get the original value to @Original_UnitID,so I set a hidden column named LabelKey.But It don't update the database.My server is SqlServer 2000. using System; using System.Collections;
3
2761
by: Daniel M | last post by:
I'm building a medium-scale data-entry web application, which involves creating data entry forms, record listings and detail screens for lots of database tables. Rather than designing a series of similar web pages for each table I'm looking into recording metadata about tables / columns in the database and using this to determine presentation. Let's keep things simple for now and assume that I'm interested in adding more user friendly...
3
2994
by: nvx | last post by:
Hello everyone... Just for the record, I'm a newbie to this data binding thing... In my C# application I need to bind a cell of an Access database table to a multiline TextBox. How should I do it? I've tried to bind the TextBox using the VS IDE (which ended up in binding to a table column). This was perfect until I used the Update command. Then an exception was thrown, telling me, that to update a database it needs to have a DataRow...
1
3618
by: hazz | last post by:
What do I do to capture the checkbox values as listed below in order to update the database table. There will be an ID field also contained in the row to use in the update query. What would I put in the Button Click event? Thank you. -Greg <tr> <td>CO_NUMBER</td><td> <input id="ItemsGrid_ctl02_CheckBox1" type="checkbox" name="ItemsGrid$ctl02$CheckBox1" checked="checked" /> </td>
1
1997
tolkienarda
by: tolkienarda | last post by:
i need to update a database table using variables in unusual places here are the update statements mysql_query("UPDATE 'grades' SET '$class' = '$grade' WHERE student='$student'"); mysql_query("UPDATE 'assignments' SET '$class' = '$grade' WHERE student='$student'"); mysql_query("UPDATE 'comments' SET '$class' = '$grade' WHERE student='$student'"); now i was just showed by ron how to recive post stuff and that is where the variables come...
1
1349
by: srikarn | last post by:
how to retrieve randomly rows from a sqlserver database table
0
1459
by: =?Utf-8?B?dmlzaHJ1dGg=?= | last post by:
how to write data from data set in dotnet to paradox database in c# In this code from Archive Sql Server database, Table named:tmsarcdata I want all the details from tmsarcdata table to move to paradox database My paradox database path is: =@"D:\\ArchiveBase\\CDFilesa" This is the code I tried,but did not work: private void button1_Click(object sender, System.EventArgs e) {
0
1673
by: Andy B | last post by:
I need to take an existing GridView that connects to a database and gets rows from a table and force it to show x rows in the insert mode. This is what should happen: 1. There is a TextBox in the GridView header where I type the number of rows I want to show in insert mode. Say I type 12. 2. When I click Add, the GridView changes to insert mode showing the 12 rows ready to be filled in. I would use a custom template for insert mode. 3....
3
3827
by: techno | last post by:
in a text box and click on update button. once the button is click a function with parameter as the changed value. it is sent to a jsp file for updation. when i try to run this code, it shows number format exception-input string undefined.
0
8833
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9389
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9335
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9256
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6801
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6079
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4881
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3320
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2794
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.