Datagrid oneditcommand postback issue.

nambati · February 4th, 2005, 12:53 PM

Hi,
I have a problem with datagrid oneditcommand. When I click on edit link on the datagrid the datagrid disappers. It just displays the blank screen. What could be the problem. I appreciate your help.

Regards..

Private Sub Page_Load(sender as Object, e as EventArgs)handles mybase.load
    If Not Page.IsPostBack then
      BindData()
    End If
  End Sub

Sub dDatagrid_Edit(sender As Object, e As DataGridCommandEventArgs)handles dDatagrid.editcommand
    dDatagrid.EditItemIndex = e.Item.ItemIndex
    BindData()

    dDatagrid.ShowFooter = False
  End Sub

  Sub dDatagrid_Cancel(sender As Object, e As DataGridCommandEventArgs)handles dDatagrid.cancelcommand

    dDatagrid.EditItemIndex = -1
    BindData()

   dDatagrid.ShowFooter = True
  End Sub

jbenson001 · February 4th, 2005, 02:26 PM

Please show your BindData() code.

nambati · February 4th, 2005, 02:39 PM

Thanks for your reply.
Here is the BindData() code.

Regards..

Sub BindData()
      Dim SQL as String = "SELECT ID, Category_Name, descirption WHERE ID <= 25"
    Dim resultsDataSet as New DataSet()
    Dim myDataAdapter as SqlDataAdapter = New SqlDataAdapter(strSQL, myConnection)
    myDataAdapter.Fill(resultsDataSet)
    dDatagrid.DataSource = resultsDataSet
    dDatagrid.DataBind()
End Sub

nambati · February 4th, 2005, 02:42 PM

Sorry, There was a typo error.Here is the right one.
Regards..

Sub BindData()
      Dim strSQL as String = "SELECT ID, Category_Name, descirption WHERE ID <= 25"
    Dim resultsDataSet as New DataSet()
    Dim myDataAdapter as SqlDataAdapter = New SqlDataAdapter(strSQL, myConnection)
    myDataAdapter.Fill(resultsDataSet)
    dDatagrid.DataSource = resultsDataSet
    dDatagrid.DataBind()
End Sub

jbenson001 · February 4th, 2005, 02:50 PM

From what I can see this should work. Have you tried tracing the code in the degugger? Make sure your BindGrid() sub is being called once you click on the edit link. Let me know how you do.

stu9820 · February 4th, 2005, 03:14 PM

Can you post your HTML code?

nambati · February 4th, 2005, 03:31 PM

Thanks for your help.I tried to debug and trace the code. It seems to be BindData() function not been called when I click on the 'Edit' link. If I take out the Page.IsPostBack condition it's displaying the records, but the function called twice. I don't think this is correct.

Regards..

nambati · February 4th, 2005, 04:09 PM

<@page language="vb" autoeventwireup="false" codebehind="test.aspx.vb" inherits="project1.test"%>
<html>
<body>
<form runat="server">
    <asp:datagrid id="dDataGrid" runat="server"
        AutoGenerateColumns="False"

        OnEditCommand="dDatagrid_Edit"
        OnCancelCommand="dDatagrid_Cancel"
        OnUpdateCommand="dDatagrid_Update"
        OnItemCommand="dDatagrid_Insert"

        ShowFooter="True">

      <Columns>
        <asp:EditCommandColumn EditText="Edit" CancelText="Cancel" UpdateText="OK" />
        <asp:TemplateColumn ItemStyle-Width="10%"
            ItemStyle-HorizontalAlign="Center" HeaderText="ID">
          <ItemTemplate>
            <%# Container.DataItem("ID") %>
          </ItemTemplate>

          <FooterTemplate>
            <asp:Button Text="Add" CommandName="Insert" runat="server" />
          </FooterTemplate>
        </asp:TemplateColumn>

        <asp:TemplateColumn HeaderText="Category">
          <ItemTemplate>
            <%# DataBinder.Eval(Container.DataItem, "CategoryName") %>
          </ItemTemplate>

          <EditItemTemplate>
            <asp:DropDownList runat="server" id="lstCategories"
                  DataValueField="ID" DataTextField="CategoryName"
                  DataSource='<%# GetCategories() %>'
                  SelectedIndex='<%# GetSelectedIndex(Container.DataItem("ID")) %>' />
          </EditItemTemplate>

             <FooterTemplate>
            <asp:DropDownList runat="server" id="lstCategoriesInsert"
                  DataValueField="ID" DataTextField="CategoryName"
                  DataSource='<%# GetCategories() %>'
                  AutoPostBack="True"
                  OnSelectedIndexChanged="LoadSecondList" />
          </FooterTemplate>

        </asp:TemplateColumn>

        <asp:TemplateColumn HeaderText="Description">
          <ItemTemplate>
            <%# Container.DataItem("Description") %>
          </ItemTemplate>

          <EditItemTemplate>
            <asp:TextBox runat="server" Text='<%# Container.DataItem("Description") %>'
                   Columns="80" />
          </EditItemTemplate>

          <FooterTemplate>
            <asp:DropDownList runat="server" id="lstFAQsByCategory"
                  DataValueField="ID" DataTextField="Description"
                  DataSource='<%# GetFAQsByCategory(-1) %>' />
          </FooterTemplate>
        </asp:TemplateColumn>
      </Columns>
    </asp:datagrid>
  </form>
</body>
</html>