Stumped on Datagrid Edit enlightenment needed...

Hi, Can anyone help me witht he below code to change it to an editable datagrid? my database is SQL it has two tables...... faqcategories1 faqs1 inside the first is columns id category inside the second is id category_id question answer if anyone can show me how to do this i would be most grateful. Stuart



<%@ Import Namespace="System.Data.SqlClient" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Drawing" %>

<%@ Page Language="c#" %>







	

		HELP FAQS

		

		

		

		

	

	

	

		





	

			

			

		

	

	

	

	

	   

	       

	       

    

        

        

        

        

    



    

    



            

        

        

        

	

	



				

					

						

							

							

							

							

						

										 <%#DataBinder.Eval(Container.DataItem, "category" )%>

									

							

							

							

							

							

							

							

							

						

						

					

					

					

					

						

						

							

								

							

							 ')" style="cursor:hand; cursor:pointer; color:steelblue">Q: <%#DataBinder.Eval(Container.DataItem, "question")%>

							

							 " class="switchcontent" style="WIDTH: 350; font-weight: normal; background: #f0f2ff;  margin: 0; padding: 3px; font-size: 12pt; font-color:steelblue">

				

			<%#DataBinder.Eval(Container.DataItem, "answer")%>	

							

							

							

													

							

								

							

							

						

					

				

			

			

	

   

			Copyright 2004  Powered by

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

nick 022y ago
If you are using the visual editor then you can use the Property Builder option for the DataGrid. Add an Edit, Update, Cancel button column. Then you need to link up to the EditCommand, UpdateCommand and CancelCommend on the events page. All this can be done by hand in code if necessary. When you respond to the edit command you set the datagrids EditItemIndex property like this mydatagrid.EditItemIndex = e.Item.ItemIndex; myDataBind();
0