Help on Displaying values from a Gridview to a textbox

Question

0.00/5 (No votes)

See more:

Please i a problem trying to get the primary key of a gridview control bounded by an entitydata source.I have a table called staff and this table has about 25 columns on it.The primary key of this table consist of a combination of two columns which is column [StaffID] and column [SchoolID].
I used the entitydatasource control to hook up to the table.I did not select all the columns i just selected four of the columns.Below is the markup of the entitydatasource control.

XML

<asp:EntityDataSource ID="EntityDataSource1" runat="server"

        ContextTypeName="DEMOWEBAPPLICATION.PriSecDbEntities" EnableFlattening="False"
        AutoGenerateOrderByClause="true"
        EntitySetName="Staffs" EntityTypeFilter="Staff"
        Select="it.[StaffID], it.[SchoolID], it.[Surname], it.[FirstName]">
        <OrderByParameters>
        <asp:Parameter
        DefaultValue="StaffID" />

        </OrderByParameters>
    </asp:EntityDataSource>

I bounded this to a gridview control.My question is i want a situation when i click on a row on the gridview i will be able to show the different columns from my staff table on different textbox control(for example i will be able to do something like this txtSurname.text=newStaff.name and so on) and i will be able to edit and updated it and it will updates on the database. I have been trying to create an object of staff and get the primary key column by doing this

VB

Dim newStaff As Staff = DirectCast(grdLoadStaffDetails.SelectedPersistedDataKey("StaffID"), Staff)

This is how i normally do it when using a datagrid with windows form application.

VB

Dim selectedUser = DirectCast(Me.grdLoadStaffDetails.CurrentRow.DataBoundItem, Staff)

I want the equivalent of this with a gridview control
in the gridview selectedindexchanged event handler but it throws up an invalid cast execption hour. I have been pulling out my hair out for the past five hours. Any help is highly appreciated. Thanks

Posted 28-Aug-13 21:46pm

jamiebones

Updated 28-Aug-13 23:29pm

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jameel VM · Answer 1 · 2013-08-28T22:28:00

Solution 1

Try this link
http://stackoverflow.com/questions/6095504/how-can-i-get-selected-row-cell-value-of-grid-view-on-page[^]
Hope this helps

Posted 28-Aug-13 22:28pm

Jameel VM

jamiebones · Answer 2 · 2013-08-30T08:29:00

Protected Sub grdLoadStaffDetails_SelectedIndexChanged(sender As Object, e As EventArgs) Handles grdLoadStaffDetails.SelectedIndexChanged
       Dim Demo As New PriSecDbEntities
       Dim ke As String = grdLoadStaffDetails.SelectedPersistedDataKey("StaffID")
       Dim newStaff As Staff = Demo.Staffs.Where(Function(c) c.StaffID = ke).First

       txtSurname.Text = newStaff.Surname
       txtDOB.Text = newStaff.Usergroup
       txtFirstName.Text = newStaff.Password


   End Sub