How to Insert & Update a certain Fileds in Tbl c#

Question

Hi Guys Please Help full me I have Table designed for two WebForm  Form1 use to Insert and Select only and Form Designed to Update only . How to Put Good Analysis for this aproach  is this is corect or not ? Form1: Insert / Select Form2: Update Only Thank You

Dharmraj Thakur · Answer

No its not good way... Here only one Form is required.... Form1 which is created for insert it can also use for update... onclick edit button just get the record by its ID and set it to insert insert field.. and take 1 Mode variable everywhere which will indicate which method will call on Save button Insert Or Update... Thats it...

Dharmraj Thakur · Answer

Multiple table for one entity or module is not good... you have change it in single table and single form to avoid more complexity....

Abdalla Elawad · Answer

Hi Dharmarj If the designed in one Form there is no problem  but Now what is the solution Please Help me more

Dharmraj Thakur · Answer

Dear @Abdalla Elawad How it is possible that you are inserting record in table1 and updating and selecting from table2... and why you want to do this??? Its wrong...

Abdalla Elawad · Answer

I will Create 2 Tbl . Tbl_1 to Insert Only and Tbl_2 To Select & Update Is This is corect or not ?

Abdalla Elawad · Answer

Hi Dharmraj Thakur You are right  But very necessary to seprate forms and this is request to me Can you divide the table into 2 Tbls and copy all Pk Keys to New Tbl as FK key Thank you