Complete Editable Datagrid
-
Hi, Using Visual Studio 2012 Ultimate on Windows 8 64 bit Virtual Machine Using Oracle Database 11.2.0.1 Enterprise Edition I want to develop a web page with a gridview on it which will be populated with Oracle database's 4 tables having all features like add, delete and edit the rows without pressing update/cancle link buttons which I found on my google links. Gridview must have radio button, dropdownlist, textboxes, checkboxes and datatime control with it. The control's values are to be populated from different tables join on a common column customer_id number(5). When I google for it, I found many good links like : Editable Gridview with Textbox, CheckBox, Radio Button and DropDown List[^] and Editable GridView in ASP.NET 2.0[^] and many more. I am not going to request you to provide me the complete code (like spoon feed), but if anyone can share with me link(s) for it, I shall be thankful to you, in which different controls are being populated from different tables and that grid view should be available for update without any click on further link/button etc. How it should function : Suppose below is Grid view looks: Customer_Id (TextBox) Registered On (DateandTime Control) Status (Radio Button) Country (DropDownList) Phone (TextBox) Services (CheckBoxes) Customer_Id from all 4 tables. Registered On from Reg_Master table Active from Customer_Active table (customer_id, status number(1)); If status = 1 then it is active, else inactive) Country from country_master table (customer_id,country_name) Phone from cust_phone table (customer_id,phone_no) Services from service_list table (customer_id,service_code) [Dynamic, i.e. 1 to 20 services are there] and parent table service_master table (service_code, service_name) Now, if user changes status as inactive to active or vice versa, so its effect should only be in customer_active table. If user changes country from country1 to country4 and check/uncheck on its existing service, then its impact should be on country_master and service_list table only. I am not s
-
Hi, Using Visual Studio 2012 Ultimate on Windows 8 64 bit Virtual Machine Using Oracle Database 11.2.0.1 Enterprise Edition I want to develop a web page with a gridview on it which will be populated with Oracle database's 4 tables having all features like add, delete and edit the rows without pressing update/cancle link buttons which I found on my google links. Gridview must have radio button, dropdownlist, textboxes, checkboxes and datatime control with it. The control's values are to be populated from different tables join on a common column customer_id number(5). When I google for it, I found many good links like : Editable Gridview with Textbox, CheckBox, Radio Button and DropDown List[^] and Editable GridView in ASP.NET 2.0[^] and many more. I am not going to request you to provide me the complete code (like spoon feed), but if anyone can share with me link(s) for it, I shall be thankful to you, in which different controls are being populated from different tables and that grid view should be available for update without any click on further link/button etc. How it should function : Suppose below is Grid view looks: Customer_Id (TextBox) Registered On (DateandTime Control) Status (Radio Button) Country (DropDownList) Phone (TextBox) Services (CheckBoxes) Customer_Id from all 4 tables. Registered On from Reg_Master table Active from Customer_Active table (customer_id, status number(1)); If status = 1 then it is active, else inactive) Country from country_master table (customer_id,country_name) Phone from cust_phone table (customer_id,phone_no) Services from service_list table (customer_id,service_code) [Dynamic, i.e. 1 to 20 services are there] and parent table service_master table (service_code, service_name) Now, if user changes status as inactive to active or vice versa, so its effect should only be in customer_active table. If user changes country from country1 to country4 and check/uncheck on its existing service, then its impact should be on country_master and service_list table only. I am not s
Hi Girish - thank you for your email, but I don't have the capacity to implement this for you. However, if you change the dbconnection string and the dbprovider in the ConnectionString section of the web.config, you should be able to get the existing code working for you. If not, there are plenty of samples on CodeProject. Good luck! Chris