hi everybody i had a problem with gridview. my grid view having 10 rows of data. if i change one value in one row then the remaining rows will be updated. how can i solve this. im explaining briefly here name | credit | debit | balance aaa | 1000 | 0 | 1000 aaa | 0 | 500 | 500 if i change 1000 value to 2000 then the balance vl be 1500 i m inserting those values from different forms by using triggers concept. hope u help me in this thnx in advance kumar

AIM: TO DISPLAY IN CRYSTAL REPORT typee ex1 ex2 ex3 ex4 date NAME Q V Q V Q V Q V RAVI 100 1000 200 2000 2 200 3 300 2/5/2009 PRAVEEN 0 0 0 0 0 0 1 1000 2/5/2009 IN SQL SERVER 2000 I HAVE TAKEN TABLE AS FOLLOWES EMPID EMPNAME START DATE TYPE Q v 1 RAVI 02/05/2009 ex1 100 1000 1 RAVI 02/05/2009 ex2 200 2000 1 RAVI 02/05/2009 ex3 2 200 1 RAVI 02/05/2009 ex4 3 300 3 PRAVEEN 02/05/2009 ex4 1 1000 .. .. .. .. .. …

would you don't mind , give me some example code for this application issue.

[Message Deleted]

hi everybody i m doing a small banking application i have three tables master,transactions,ledgers if i m entering the opening balance from master table it inserts in the ledger table and display that value properly. if i update that value in master it updates ledger value properly. i enter the values in grid view and save them they are saved in ledger table as well as corresponding tables.here i m using storedprocedures for saving values. ledger table is read only it displays only report in gridview **transaction table have 3 columns ------------------------------------------- date | deposit | withdrawl ------------------------------------------- **my ledger table have 4 columns ------------------------------------------- date | deposit | withdrawl | balance ------------------------------------------- now the task is if i enter amount in 'deposit'column of 'transaction table's gridview' ,it displays in deposit column of ledger gridview for suppose i enter amount in 'withdrawl 'column of 'transaction table's gridview' ,it displays in withdrawl column of ledger gridview now balance will be calculated and displays in balance column of ledger's gridview how can i calculate and displays in gridview of ledger ------------------------------------------------------------------- date ------ deposit---- withdrawl-----balance ------------------------------------------------------------------- 1/1/2000----1500-----------0----------1500 2/2/2000------0----------1000----------500 3/3/2000-----700-----------0----------1200 4/4/2000------0-----------200---------1000 ------------------------------------------------------------------ like this i need hope u help me n this issue with regards, nagendra kumar

hi everybody i m doing a small banking application i have three tables master,transactions,ledgers if i m entering the opening balance from master table it inserts in the ledger table and display that value properly. if i update that value in master it updates ledger value properly. i enter the values in grid view and save them they are saved in ledger table as well as corresponding tables.here i m using storedprocedures for saving values. ledger table is read only it displays only report in gridview **transaction table have 3 columns ------------------------------------------- date | deposit | withdrawl ------------------------------------------- **my ledger table have 4 columns ------------------------------------------- date | deposit | withdrawl | balance ------------------------------------------- now the task is if i enter amount in 'deposit'column of 'transaction table's gridview' ,it displays in deposit column of ledger gridview for suppose i enter amount in 'withdrawl 'column of 'transaction table's gridview' ,it displays in withdrawl column of ledger gridview now balance will be calculated and displays in balance column of ledger's gridview how can i calculate and displays in gridview of ledger ------------------------------------------------------------------- date ------ deposit---- withdrawl-----balance ------------------------------------------------------------------- 1/1/2000----1500-----------0----------1500 2/2/2000------0----------1000----------500 3/3/2000-----700-----------0----------1200 4/4/2000------0-----------200---------1000 ------------------------------------------------------------------ like this i need hope u help me n this issue with regards, nagendra kumar

hi everybody i m using C# Application i have a 'date' and 'days' columns in datagridview now i want to findout the no. of days between two dates how can i calculate pls help me date days -------------------------------------------- 1/11/2008 0 1/12/2008 30 3/12/2008 2 --------------------------------------------

modified on Monday, May 4, 2009 9:32 AM

hi everybody i have a database named 'example',which is created in sql server 2000 now i want to convert it into msaccess 2007 through C# coding hope you help me in this issue thnx in advance nagendra kumar

Inserting ------------------------------------------------------------ ms = new MemoryStream(); pbEmp.Image.Save(ms,System.Drawing.Imaging.ImageFormat.Jpeg); byte[] data = new byte[ms.Length]; ms.Position = 0; ms.Read(data, 0, Convert.ToInt32(ms.Length)); cmd.Parameters.AddWithValue("@Photo", data); Retrieving ------------------------------------------------------------ byte[] data = (byte[])ds.Tables["tablename"].Rows[0][0]; ms = new MemoryStream(data); picturebox.Image = Image.FromStream(ms);

thanx musefan but i got a prob with that one is there any other way to solve it?

hi i had a problem while using toolstrip, in C# application i have a form named 'master', which is mdi child form. i access it from menu click event of mdiparent form. i have another form 'example'. it contains toolstrip. one of the toolstrip buttons is 'master' in 'example' form. now i m clicking that master toolstrip button again n again,it opens the 'master' form multiple times. how can i avoid this problem( multiple forms opening)? hope u help me in this issue. thanx in advance, nagendra kumar.

hi everybody i want to retreiving the image which is stored in sql server database using asp.net. all images are stored in datagrid which i want to retreive. please help me in coding

hi everybody I want to take my database backup which is created in sql server 2000 in windows application using C# so i have no network its an independent system i want to display all sqlserver instances in combobox without internet(Lan etc..) how can i take backup my database using c# hope you help me thanks in advance nagendra...

hi everybody, I use toolstrip button in windows application using c#. i have toolstrip in mdi child form. when i click the toolstrip button it open the related form. The prob is here that i clicked that button again it open another form. the related form opened again & again when i clicked. i need only the form is opened once when i click it multiple times. please help me.

thnx Steven but i dnt have tht much of time its urgent so i m trying for conversion tool

hi can u suggest me that the tools for converting vb source code to vb.net.

hi everybody how to handle leave(back to front & vice versa) event for a textbox in windows form using c#

hi good evening frnds, I have three doubts here... 1) How can i refresh my windows form everytime,when i submit the values to the database using C#. 2) can u gimme autogenerate code for userid, its urgent pls help me 3) i need some clarification abt ths error : what is meant by, insert command confilcted with foreign key column hope u gimme as early as possible... thnx in advance, nagendra kumar

Hi every one...can u help me in disabling the border of the group box thnx in advance, nagendra kumar :)