radgrid selected values

[Troika]

i'm binding a radgrid with custom dataset that i cal on need datasourece event

but then i need to fetch the username of select row on grid , but it gices always null:

string username = (string)RadGrid1.SelectedValues["UserName"];

i think its because i'm databing on code behind because with sql datasource directly associated with grid works fine

[Princy]

Hi Troika,

Please try the following code snippet ,I have tried to access the selected rows on a button click.

ASPX:

<rad:RadGrid runat="server" ID="RadGrid1" OnNeedDataSource="RadGrid1_NeedDataSource" AllowMultiRowSelection="true">
    <MasterTableView >
        <Columns>
            <rad:GridBoundColumn DataField="CustomerID" UniqueName="CustomerID">
            </rad:GridBoundColumn>
            <rad:GridBoundColumn DataField="CompanyName" UniqueName="CompanyName">
            </rad:GridBoundColumn>
        </Columns>
    </MasterTableView>
    <ClientSettings Selecting-AllowRowSelect="true" >
    </ClientSettings>
</rad:RadGrid>

C#:

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
    {
        String ConnString = ConfigurationManager.ConnectionStrings["Northwind_newConnectionString3"].ConnectionString;
        SqlConnection conn = new SqlConnection(ConnString);
        SqlDataAdapter adapter = new SqlDataAdapter();
        adapter.SelectCommand = new SqlCommand("SELECT CustomerID, CompanyName FROM Customers", conn);

        DataTable myDataTable = new DataTable();

        conn.Open();
        try
        {
            adapter.Fill(myDataTable);
        }
        finally
        {
            conn.Close();
        }

        RadGrid1.DataSource = myDataTable;
    }

 protected void Button1_Click(object sender, EventArgs e)
    {
        foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
        {
            if (item.Selected == true)
            {
                string mydata = item["CustomerID"].Text;
            }
        }
    }

Thanks,
Princy

[Troika]

that dont work because i dont select the row i just click on the row

[Troika]

i'm using 

<telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" Text="Apagar" UniqueName="DeleteColumn">

 

 

 

then on item command

if (e.CommandName == "Delete") but i cant get the username of the custom dataset bind on need datasource event

[Princy]

Hi Troika,

I have bind the radgrid in the NeedDataSource event as shown in the above code,In order to access the selected row on the button click,please try the following code snippet.

C#:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
 if (e.CommandName == "Delete")
 {
  GridDataItem data = (GridDataItem)e.Item;
  string mydata = data["CustomerID"].Text;
 }
}

Thanks,
Princy

[Troika]

this works.

Help me on this please i cant fix it