I wnt to display Admision no with checked box’s and checked means Present,unchecked means to do These values are will be directly insert aswell as update . for eg: user enter name in textbox and corresponding to dis textbox value related rows are selected and data is fetch in grid view.. Update(data Table); this will require update command text .. Now how should i write the insert command to insert into one table from the Data grid values. can we add a column in sqlserver database at run time using datagridview. I could not figure the Parameters for that Insert commnad Can you please let me know the syntax for the Insert and Update commands when we use multiple tables in the select to show the data in the Datagrid. like if we add a col in data gridview at runtime it must reflect the changes in sql server database’ table. code that i used to add col in datagrid at run time..
Now when you close the add form call that function. I want to know how to insert/update/delete in a Multiple tables in a single datagridview. thanks thendral HI Rahim, My Name is Raman ,as per the above comments , I understand you are very good at I am new to win app, but good SQL server, Can you tell me , I Can Solve the below querdy. 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. For this, i used where condition in the query and left the rest of the code as before(similar to urs). But now i want to take a data Grid View where i will add 3 column(name,address, Phone) manualy. Delete is also not working properly ..,, There also throws an exception .. Update(Data Table); it has gave an error please help me on this. Data Grid View control are used very frequently in C#. Insert Delete Update in Data Grid View with Data Table in C Hello there, I have a lot of errors with the same announce for the following (some of them!! cause i am only am be to retrieve the data to the datagridview for delete, i want to delete in the datagridview, meaning each row got it own delete button please provide me with the code….. which is: ” Dynamic SQL generation for the Update Command is not supported against a Select Command that does not return any key column information. So, if i click the button then it will show the result in Data Grid, against the customer_ID which will be given in the textbox. namespace Database private void button3_Click(object sender, Event Args e) private void Form6_Load(object sender, Event Args e) private void data Grid View1_Cell Content Click(object sender, Data Grid View Cell Event Args e) private void button1_Click(object sender, Event Args e) private void button4_Click(object sender, Event Args e) public void clear() } } Thanq so much for ur reply ..,, Here throws another exception if i use Ur code given .., Dynamic SQL Generation for the update command is not supported against a select command that doesn’t return any key column information ..,, Bhaia, I have done Insert, Update, Delete in data Grid View in the same way as urs. Update for the entire row is happening ..,, But for a single column it throws an exception ..,, Can U sort out this problem .. Update(datatable) Actually am using Oracle for the same thing i wrote like follwoing Oledb Data Adapter.