Bound datagridview not updating is carbon dating a theory or fact
Could you please explain how to do this from the start.
Now i just have a doubt,i used part of ur code to do just a delete opr in i update the database,it keeps on giving the same error that,”Object reference not set to instance of an object. Am getting mad trying alternatives for this error for 2 help resolve. 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. hih saw your post, it really great, but if i have web service, how am i going to call the web service web method to the datagridview and do the update, insert and delete??? but in button click event for update, its showing an error. Thanks bhaia, I have created one column ‘cust_ID’ primary key in DB. But i tried to use a textbox in the form where i will give a customer_ID and also a button. :-) Hello Rahim .., I’m new to windows application n my coding here is C# ..,, I want to perform Edit , Delete n Update in data Grid View n data should b saved in DB ,, Used Ur code bt the update so far don in GRIDVIEW only and its nt saved in DB .., It is very easy to perform Update Delete in WEB Application ..,, Bt here it is hectic ..,, Want to complete the task ..,, Help m out of it ..,, Hoping for a reply soon !! Here is the following code that i did n nt effective !! App Settings[“connection String”]; underlined “Configuration Manager” this word please tell me its solution? i used your code in my application for insert,delete and update from datagridview to sql but it giving an error “The name ‘Configuration Manager’ does not exist in the current context” so please give a solution hello…. TX :) When i click on Add\update button, a dialog box showing syntax error INSERT INTO and when i click on Delete button it also shows a dialog “Dynamic SQL generation for the Delete Command is not supported against a Select Command that does not return any key column information” why it is happening like please give me reply…. please i need code of update and delete from gridview but as u given above code that is not understanding to me.. but how to restore mdf and ldf files in sql server HI rahim i am having doubt regarding sqldata Adapter. you don’t have to worry about auto number or identity column. // if you want to hide Identity column data Grid View Trial. Visible = false; Or you can make it read only column. salam rahem i write your code in my project but i have a single error in this line connection String = Configuration Manager. Open(); (The Connection String property has not been initialized.) Please help me to solve this … 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.