Reply to thread

Message

<blockquote data-quote="evad4682" data-source="post: 61278" data-attributes="member: 4642">Hello allI have a webform with three GridViews on it. The first GridView populates a summary of information at the Form_Load event. I have set this gridview to be selectable. When an item is selected off this gridview I need it to pass two different values - one to each of the subsequent gridviews (GridView2, GridView3). I have set two DataKeyNames in the properties of GridView1. From checking around I guess that I need to set up the Selecting event for GridView2 and GridView3 for this to work - which is where I am stuck.This is what I have so far[CODE]&nbsp; &nbsp; Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)Handles GridView1.SelectedIndexChanged&nbsp; &nbsp; &nbsp; &nbsp; m = Me.GridView1.DataKeys(0).ToString&nbsp; &nbsp; &nbsp; &nbsp; A = Me.GridView1.DataKeys(1).ToString&nbsp; &nbsp; &nbsp; &nbsp; Me.GridView2.DataBind()&nbsp; &nbsp; &nbsp; &nbsp; Me.GridView3.DataBind()&nbsp; &nbsp; End Sub&nbsp; &nbsp; Protected Sub SqlDataSource2_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource2.Selecting&nbsp; &nbsp; &nbsp; &nbsp; e.Command.Parameters(&quot;@messid&quot;).Value = m&nbsp; &nbsp; End Sub&nbsp; &nbsp; Protected Sub SqlDataSource3_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource3.Selecting&nbsp; &nbsp; &nbsp; &nbsp; e.Command.Parameters(&quot;@asset&quot;).Value = A&nbsp; &nbsp; End Sub[/CODE]When I debug this code [CODE]m = Me.GridView1.DataKeys(0).ToString[/CODE] it literally returns System.Web.UI.WebControls.Datakey as a string value. I get the same results for the next line. My code then bombs out when I try to databind - Cannot convert nvarchar to numeric. The two datakeys are numeric values. How do I get the &quot;actual&quot; values of the datakeys for the selected row?Any help is appreciated. Thanks</blockquote>

[QUOTE="evad4682, post: 61278, member: 4642"] Hello all I have a webform with three GridViews on it. The first GridView populates a summary of information at the Form_Load event. I have set this gridview to be selectable. When an item is selected off this gridview I need it to pass two different values - one to each of the subsequent gridviews (GridView2, GridView3). I have set two DataKeyNames in the properties of GridView1. From checking around I guess that I need to set up the Selecting event for GridView2 and GridView3 for this to work - which is where I am stuck. This is what I have so far [CODE] Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged m = Me.GridView1.DataKeys(0).ToString A = Me.GridView1.DataKeys(1).ToString Me.GridView2.DataBind() Me.GridView3.DataBind() End Sub Protected Sub SqlDataSource2_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource2.Selecting e.Command.Parameters("@messid").Value = m End Sub Protected Sub SqlDataSource3_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource3.Selecting e.Command.Parameters("@asset").Value = A End Sub [/CODE] When I debug this code [CODE]m = Me.GridView1.DataKeys(0).ToString[/CODE] it literally returns System.Web.UI.WebControls.Datakey as a string value. I get the same results for the next line. My code then bombs out when I try to databind - Cannot convert nvarchar to numeric. The two datakeys are numeric values. How do I get the "actual" values of the datakeys for the selected row? Any help is appreciated. Thanks [/QUOTE]

Verification