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

Question

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

Sunny Sharma · Answer

Hi Bineesh, find attached the modified Project.

Sunny Sharma · Answer

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 Viswanath · Answer

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 Sharma · Answer

Hi Bineesh, Did you find it useful? Let me know.

Pankaj Pandey · Answer

did you created SP for delete,update and view?

Bineesh Viswanath · Answer

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 Sharma · Answer

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

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

Answers (7)