Insert, update, delete in a windows form

Question

Hello,

I am a beginner in working with C# windows applications. I have a form with text boxes and a combobox and I want to insert, update and delete values from all the boxes on the form.

Can anybody recommend me a web site with an example please? The textboxes and datetime picker should be connected with one table and the combobox is filled with data from another and I chose one value to enter in the first table.

Thank you very much in advance.

Answer 1

this is the provider settings or sqlconnection settings for ms excel once we complete this every this is common like sqlcommand,dataset,dataadapter

sqlconnection con= new sqlconnectio(provider=Microsoft.Jet.OLEDB.4.0;Data Source='Your Filename';Extended Properties=Excel 8.0;)

,but select statement is sytanx is some differ like this way

ample Select sql

sqlcommand cmd  = new sqlcommand("select * from [Sheet1$] where condition",con);

if it satisfies you accept this answer by clicking thumb up symbol

 

Answer 2

Hi chiranjeevi,

This is a simple application i did of your requirements.Run the attachments.


Thanks


If it helps you plz mark the answer as Accepted answer

Answer 3

Also look at the articles in this web site about Excel.