INSERT,VIEW,UPDATE,DELETE in Windows Form Using ADO.NET

Bineesh Viswanath

Sir, I am Now doing a program that passes value from a windows textBox to a Database.

I did the query for Insert statement.

But I can't execute the other functions VIEW ,UPDATE and DELETE in this form.

I will send the FORM,DB If You ready to solve my Problem.

If you ready, reply me and I will send you the FORM and DB

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sunny Sharma13y ago
Accepted answer
Hi Bineesh,

find attached the modified Project.
Sunny Sharma13y ago
Nothing to worry about, you just copy the codes from frmFlight.cs and add it to your existing one. The error is because I had to convert the application in Visual Studio 2010 as I don't use 2008 version anymore. Alternatively I'm attaching the the codes inside the pages in text files here, copy them into your project and get it working.

Yes, one more thing. change the data type of "flightId" column to int in your DB file.
Bineesh Viswanath13y ago
Sir, First of all thank you for Re-sending the file.

The program is showing me message "Cannot open because it is version 655. this server

supports version 611 and earlier. A DownGrade Path is not supported.could not open new database

please solve this problem and send again the Form
Sunny Sharma13y ago
Hi Bineesh,

Did you find it useful? Let me know.
Pankaj Pandey13y ago
did you created SP for delete,update and view?
Bineesh Viswanath13y ago
Sir, Thank you for having a helping mind on me!

My Program is about to find the details of flights

I have a database named tbl_Flight

It have Four columns:-flightId(PK,IDENTITY),flightName,Model,Nation

I attached the database, Windows Form with this.

so send back the file as same as I attached
Sunny Sharma13y ago
Hi Bineesh,

Send me ur form, I'll help you with that.

Thanks.