I just want to add new row, but do not update the old records. I have created one page in in which i have taken 1 grid view which shows notification about person who will donate amount on particular day/date.

updating datagridview-73updating datagridview-1updating datagridview-54

Updating datagridview video

This is one of the most useful piece of code that I have come across on the net in a long long time. Just wanted to know how to validate data while saving, can we get individual values and validate them eg do not allow negative values or values above a cut-off level etc Hi rahim ,your multiple update code is ultimate…. its the first time i m working with the datagridview… actually its being inserted in the datagridview on the screen but my database mdb file is still empty… and is their any way to freeze particular row from updating and deleting ?

Im doing one application that is Attendance Entry form. even if i dont enter the records and fire a select query it is not even reacting to it.. Mr.rahim i want to apply query on datagrid view acc to user need.. hello sir, i want to now when we give command as sql Data Adapter. ” and for id i got value as e.current Row Index, so its updating only 1 row .. Hi Rahim, I am getting “Dynamic SQL generation is not supported under multiple Base Tables”, the reason of the error is I am Joining multiple tables to get the data in the Data grid. Add(cls Col1); pls send me the code for adding col into database. HI sir, i’m filtering the data’s from the sql table and dislplaying in datagridview , now i want to save the filtered content displayed in the datagridveiw in another new sql table. pl send the code to [email protected] sir, i want to insert grid view data to another delete from current table in Sql Database.is my code…its always insert row no to table not the column value..please help me..current table is jobmain i want to job main row data to delete from jobmain.

Regards, Arpan To add a reference in Visual C# # In Solution Explorer, right-click the project node and click Add Reference. https://khanrahim.wordpress.com/2010/07/08/delete-confirmation-in-asp-net-gridview/ However, for Button Click (on client click) write client confirmation javascript code.

Thanks Dear Sir, how can i add the reference of system.configuration, i m unable to ignore this error if u have time to solve my problem then reply step by step i have download code but no success to remove the errror. Open(); error message:”Expected class, delegate, enum, interface, or struct” hi i want a code to add details in my database using c#windows form apllication in these from it contains add button when i entered data in textboxes than click add button it will added to the data base plzz rply me here my code is using System; using System.

Data Grid View Text Box Column cls Col1 = new Data Grid View Text Box Column(); cls Col1.

i used your whole code….still i found run time error on updating and deleting…….. Hi Anshu, before using above code make ensure that 1) one primary must be exist in ur data base. Method below it’s update all records, maybe slow down the system? Sql Client; namespace Windows Forms Application2 hey…..i want to ask that for the value “11.40” i have used decimal(18,2) but whenever i try to update the data at that time it’s give me the error like conversion faild when converting the nvarchar value “11.40” to data type int. Now if person donate some amount monthly and if he paid amount then i want to remove his notification and also the notification should get display in next month. I have created one page in in which i have taken 1 grid view which shows notification about person who will donate amount on particular day/date.There is extensive support for this task in Visual Studio.Also see How to: Bind Data to the Windows Forms Data Grid View Control Using the Designer.Im writing code like this connection String = “Data Source=;database=Northwind; User ID=sa; Password=sa”; but Sql server2005 error shows like : SQL Server doesn’t allow remote connections. but i want to learn that how we doing this through DLL. I have single button “SAVE” which save the data in the database. how can i set , update or insert or delete operation on one “SAVE” button. One more better way to do this is using Data Grid View1[“Column Name”,Index). Benift of this is if the sequence of Columns changes, the o/p will not effect. Update(dt); still if u r getting problem , then leave a comment here. I wrote above code but its giving exception for connection string On this below line sql Connection. please reply I have created one page in in which i have taken 1 grid view which shows notification about person who will donate amount on particular day/date.