Customizing code for insert ,update,select ,delete

Question

Hello friends,
              
          I am doing a project that is depend with many many tables with insert update,select ,delete.I dont want to write code for each and every insertion seprately. There is a one insertion,updation,deletion  statement   for all tables . please help me  is there any example articles available for this task. and i am doing with 3 tier architechture.so i want to minimize the coding concept and increase logical concepts   

Answer 1

Use this code in selected index changed event of combobox

 

for(int i=0; i<dataGridView1.Rows.Count;i++)

{

   dataGridView1.Rows[i].Cells[6].Value=comboBox1.SelectedValue;

}

 

 

Answer 2

Hii Ranjit,

thank you for your reply. there is just one little change I have to do that is instead of 'combobox1.SelectedValue' I added 'SelectedItem'. it is because when I used SelectedValue, and changed the value from combobox, all the values went blank...

 

'combobox1.text' also works.

 

anyway, my problem is solved.

thank you once again.

 

Mayank Jani