How to Get only Particular value from a grid panel on selected Row

  1. #1

    How to Get only Particular value from a grid panel on selected Row

    I have my grid panel as follows

    <ext:GridPanel ID="GridPanel1" runat="server" Height="300" Title="Title">
        <ColumnModel runat="server">
            <ext:Store ID="Store1" runat="server" EnableViewState="true">
            <ext:RowSelectionModel ID="RowSelectionModel1" SingleSelect="true" runat="server">
            <ext:Button ID="btnDelete" runat="server" Text="Delete">
                    <Click OnEvent="Delete">
                            <ext:Parameter Name="Values" Value="Ext.encode(#{GridPanel1}.getRowsValues({selectedOnly:true}))"
                                Mode="Raw" />
    This is my grid from my database

    Click image for larger version. 

Name:	Grid.png 
Views:	108 
Size:	3.3 KB 
ID:	3928

    This is my code to delete the selected row but this is looping for row value as i used dictionary

    protected void Delete(object sender, DirectEventArgs e)
           string json = e.ExtraParams["Values"];
           string value = string.Empty;
           Dictionary<string, string>[] companies = JSON.Deserialize<Dictionary<string, string>[]>(json);
           bool addHeader = true;
           foreach (Dictionary<string, string> row in companies)
               if (addHeader)
                   foreach (KeyValuePair<string, string> keyValuePair in row)
                       value = keyValuePair.Value.ToString();
                       SqlConnection con = new SqlConnection(connection);
                       SqlCommand cmd = new SqlCommand("Delete from Users where Name='" + value + "'", con);
                   addHeader = false;
    If I select first row and click on delete I would like to delete that row and Bind grid again. Can any one tell how to do this. Also I would like to alert a message box if the user didn't select any row using Java script
    Last edited by Dorababu; Mar 10, 2012 at 5:12 AM.
  2. #2
    Basically, to delete grid row:

    1) Delete using client script
    function onDelete() {
    	if (!GridPanel1.hasSelection()) {
    	else {
    		// Not select, 
    2) Submit to server:;
    3) Server code:
    AjaxStoreResult ajaxStoreResult = new AjaxStoreResult(StoreResponseFormat.Save);
            Models.BaotroEntities db = this.DBContext;
            StoreDataHandler dataHandler = new StoreDataHandler(HttpContext.Request["data"]);
            ChangeRecords<OBJ> data = dataHandler.ObjectData<OBJ>();
            foreach (OBJ c in data.Deleted)
            foreach (OBJ c in data.Created)
            foreach (OBJ c in data.Updated)
        catch (Exception e)
    		// ...
    4) To bind again, reload:
    Hope this help.

Similar Threads

  1. How to get values from grid panel selected row
    By mehmood in forum 1.x Help
    Replies: 9
    Last Post: Apr 11, 2012, 12:09 PM
  2. pass parameter by selected row in grid panel
    By in forum 1.x Help
    Replies: 0
    Last Post: Dec 19, 2011, 11:05 AM
  3. Filter Grid Panel by Selected Rows
    By JIGSAW in forum 1.x Help
    Replies: 2
    Last Post: Feb 25, 2011, 12:46 PM
  4. Replies: 0
    Last Post: Jan 28, 2010, 2:47 AM
  5. How to clear selected row in grid panel.
    By Satyanarayana murthy in forum 1.x Legacy Premium Help
    Replies: 1
    Last Post: Nov 25, 2009, 8:22 AM

Posting Permissions