Gridview edit and delete the records from databse

Posted by Mohan9382 under Regular Expressions on 11/23/2010 | Points: 10 | Views : 3769 | Status : [Member] | Replies : 4
i am creating website using asp.net C# and sql server 2005. in my website i have search page in this page i have two dropdownlist box and one text box and one search button two radio buttons. i have product table and city table . in product table i have conatact_person comanyname,and so on. in city table city ,area . when user select first dropdownlist corresponding value will be added in second dropdownlist for example user select chennai from ddl1 the corresponding values like tambaram guindy,vadapalani, all are added automatically in ddl2. now user enter search keyword in textbox and then user click the search button. it will display search result in gridview .the grid view must have the edit and delete option when the user want to edit or delete it must refelect in database. give clear idea and coding step by step explanation.
thanks alot




Responses

Posted by: Raja on: 11/23/2010 [Member] Starter | Points: 25

Up
0
Down
Hi Mohan9382,

Giving coding steps may be difficult for anyone to give you as your scenario may differ from others, however I am sure this article will help you in understanding how to update and delete records from database with the help of GridView.

http://www.dotnetfunda.com/articles/article29.aspx
http://www.dotnetfunda.com/articles/article924-add-edit-delete-paging-records-in-gridview-using-jquery-.aspx

Thanks

Regards,
Raja, USA

Mohan9382, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sachin19 on: 11/23/2010 [Member] Starter | Points: 25

Up
0
Down
please send on my mail gow to update,del,and insert in database with gridview and seraching process
tell me all the steps.send me the code

Mohan9382, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Madhuk on: 11/23/2010 [Member] Starter | Points: 25

Up
0
Down
To make it simple initially populate the two dropdown lists or use cascading dropdown.
On SelectedINdexchanged event of 1st dropdown populate the second drop down list.
Search Button click event based on the drop down lists selected values and text box text check the db and get the result then bind the gridview.
Check the articles posted by raja to update edit gridview.
Hope this helps.

Mohan9382, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Chvrsri on: 11/24/2010 [Member] [Moderator] [MVP] Silver | Points: 25

Up
0
Down
Hi Mohan,

How could you expect others to do your work step by step? Any hw use these links this might help your cause.

http://www.codeproject.com/KB/aspnet/GridviewItemDropdown.aspx

http://www.dotnetspider.com/resources/26761-How-edit-Delete-records-gridview-using-datakeys.aspx



Thanks,
Radha Srikanth

Mohan9382, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response