Stumped on Datagrid Edit enlightenment needed...

Question

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 HELP FAQS void Page_Load(Object sender  EventArgs e) { if (! IsPostBack) { BindDataList(); } } void BindDataList (){ SqlConnection conehelp_faq; SqlCommand cmdSelect; SqlDataReader dtrfaqcategories; conehelp_faq = new SqlConnection( @Server=myserver;uid=admin; pwd=aHelP; Database=ehelp_faq ); cmdSelect = new SqlCommand( Select id category From faqcategories1 order by category conehelp_faq ); conehelp_faq.Open(); dtrfaqcategories = cmdSelect.ExecuteReader(); dlstCategories.DataSource = dtrfaqcategories; dlstCategories.DataBind(); dtrfaqcategories.Close(); conehelp_faq.Close(); } void BindRepeater( int intCatID ) { SqlConnection conehelp_faq; string strSelect; SqlCommand cmdSelect; SqlDataReader dtrfaqs; conehelp_faq = new SqlConnection( @Server=myserver;uid=admin; pwd=aHelP; Database=ehelp_faq ); strSelect = Select * From faqs1 Where category_id=@catid; cmdSelect = new SqlCommand( strSelect conehelp_faq ); cmdSelect.Parameters.Add( @catid intCatID ); conehelp_faq.Open(); dtrfaqs = cmdSelect.ExecuteReader(); rptfaqs.DataSource = dtrfaqs; rptfaqs.DataBind(); dtrfaqs.Close(); conehelp_faq.Close(); } void dlstCategories_ItemCommand( object s DataListCommandEventArgs e ) { int intCatID; dlstCategories.SelectedIndex = e.Item.ItemIndex; BindDataList(); intCatID = (int)dlstCategories.DataKeys[(int)e.Item.ItemIndex]; BindRepeater( intCatID ); } function Go(){return} Your browser does not support script ' Runat=Server ID=Linkbutton1 NAME=Linkbutton1/> ') style=cursor:hand; cursor:pointer; color:steelblue>Q:  class=switchcontent style=WIDTH: 350; font-weight: normal; background: #f0f2ff; margin: 0; padding: 3px; font-size: 12pt; font-color:steelblue> Copyright 2004 Powered by

nick 0 · Answer

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();

Stumped on Datagrid Edit enlightenment needed...

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