Telerik Grid Problem [Answered]RSS

• • Reply
  dLcreations

  Member

  260 Points

  221 Posts

  Telerik Grid Problem

  Apr 22, 2011 12:52 AM|dLcreations|LINK

  Hi Team,

  I am Using Telerik RAD Grid.

  I am using This Code To Bind GridView AS per Combobox Selected Item.

  protected void RadComboBox1_SelectedIndexChange(object o, RadComboBoxSelectedIndexChangedEventArgs e)
      {
  
          if (RadComboBox1.SelectedItem != null)
          {
              string Text = RadComboBox1.SelectedItem.Text.ToString();
              string qrySelect = "Select * from Category Where Categoryname = '" + Text + "'";
              ds = obj.SelectQuery(qrySelect);
              RadGrid2.DataSource = ds;
              RadGrid2.DataBind();
              mvMain.SetActiveView(vwSearchGrid);
          }
      }

  And Also using Rad Context Menu. But When Popelates Rad Context Menu and Press Edit it Will Give an Error." There Is No row at Position 0"

  protected void RadMenu1_ItemClick(object sender, RadMenuEventArgs e)
      {
          foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
          {
              if (item.Selected)
              {
  
                  strtxt = item["ID"].Text.ToString();
                  Session["EditID"] = strtxt;
              }
          }
  
          switch (e.Item.Text)
          {
              case "Edit":
                  string qrySelect = "Select * from Category Where ID = '" + strtxt + "'";
                  ds = obj.SelectQuery(qrySelect);
                  TextBox1.Text = ds.Tables[0].Rows[0][1].ToString();
                  Session["mode"] = "Edit";
                  mvMain.SetActiveView(vwSubmit);
                  RadGrid1.Rebind();
                  break;
              case "Delete":
                  string qryDelete = "Delete From Category Where ID = '" + Convert.ToInt16(strtxt) + "'";
                  int i = obj.FireQuery(qryDelete);
                  Response.Write("<script>alert('Are You Sure want to Delete.?')</script>");
                  RadGrid1.Rebind();
                  break;
          }
          disableControls();
      }
  
  

  How to Solve It...?

  PLease Help

  dLcreations'
• • Reply
  vinz

  All-Star

  102861 Points

  19464 Posts

  MVP

  Re: Telerik Grid Problem

  Apr 25, 2011 07:42 AM|vinz|LINK

  Have you checked if your query returns any rows? Before assigning value to your checkbox try to check for the row count like:

  if(ds.Tables[0].Rows[0].Count > 0){

  //Populate your TextBox

  }
  

  Vincent Maverick Durano
  Microsoft MVP, CodeProject MVP, C# Corner MVP
  Blog | Twitter | Linkedin
  
• • Reply
  dLcreations

  Member

  260 Points

  221 Posts

  Re: Telerik Grid Problem

  Apr 28, 2011 01:06 AM|dLcreations|LINK

  No It Will not Return Any Rows There.....!!!

  dLcreations'
• • Reply
  vinz

  All-Star

  102861 Points

  19464 Posts

  MVP

  Re: Telerik Grid Problem

  Apr 28, 2011 11:37 PM|vinz|LINK

  dLcreations

  No It Will not Return Any Rows There.....!!!

  Then that means your sql query doesn't return an data at all..  and that's why it throws an error because you referenced a row in the DataTable that dont have any data at all.

   

  Vincent Maverick Durano
  Microsoft MVP, CodeProject MVP, C# Corner MVP
  Blog | Twitter | Linkedin
  
• • Reply
  dLcreations

  Member

  260 Points

  221 Posts

  Re: Telerik Grid Problem

  May 06, 2011 08:04 AM|dLcreations|LINK

  THnx Got the Problem

   

  dLcreations'