Im writing code like this connection String = “Data Source=10.1.2.16.1433;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. 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 can use this control in Windows Form using Wizard or programmatically. Select the components you want to reference, and then click OK. But unfortunately when i debugging this code an error is coming ” System. Data Table’ is a ‘type’ but is used like a ‘variable’ ” can you please suggest that how can i improve that……. here it is: Hi, I was designed a windows application form named as this form my issue the name of companyname combobox is there if i choose any companyname name from combobox(cmb_companyname)has to display the remaining textboxes.i will display my tables here. Tbl_report1 columns: Invoiceno,particulars,quantity,perprice,amount,invoicedate,ondate,invoiceid,orderno Tbl_report2 columns: Compname,compaddress,invoiceno(primarykey),orderno,ondate,invoicedate,amountstatus,netamount,netvat,tamount Tbl_customer columns: Custid,custname,custaddress,custcity,custstate,custstdcode,custphoneno,custmobileno in my form I am having these fields like I mentioned above two issue is if I select the compname it should display the remaining loading only companynames I wrote the code is below. In case you are adding row by row, then clear the rows of datagridview first in the function How we can access the entry’s in another system using LAN while running software in both systems. i want to add, delete, update in my C# forms through DLL… I have 5 tables and one datagridview , which display the information from 5 different tables, now user is allowed add/update/delete opration in the grid with new information. How to write the connection string to that in windows application(C#). adding , deleting , updating textboxes is very simple if we write codes on buttons. user can add or update or delete the datagridview row. Add a Data Grid View control and two Buttons on a Form. This will be something like…(please check out code syntax) Integer i = Data Grid View1. Dynamic SQL generation for the Update Command is not supported against a Select Command that does not return any key column information………. my first form is datagridview …side buttons is.,edit, delete,and close…now i want add some details then click add button then open another form….insert the data from add form…add form close after inserted data…..i want automatic refresh the form1…… When you click add button , close the datagrid form, open up the add data form.