[kstr]

I'm trying to get a Gridview/detailsview working but when using accessdatasource, i can specify a custom sql statement using the values in the gridview. With entitydatasource it seems inpossible...


How is it done with the entity framework?

[ramesh866]

i dont know about access db.. but with sql db , it can be done..

[kstr]

Maybe i wasn't clear enough (sorry about that)

It can be done with sql
It can be done with access

I want to know how to do it using entity framework.

[ramesh866]

check this
http://www.packtpub....ntity-framework

[kstr]

What i'm trying to to is select a record from the gridview, then edit/insert it in the detailsview

[ronaldjames]

kstr, on 30 Nov, 2009 - 12:02 AM, said:

What i'm trying to to is select a record from the gridview, then edit/insert it in the detailsview

so can you tell which datasource you are going to use

[ronaldjames]

So i will explain you how to select data using Gridview or Detailsview assuming that you are using the sql server database which comes with Microsoft Visual Studio 2008.

After creating the sql database and providing sufficient values to retrieve follow these steps.

1. Go to the Toolbar, drag and drop the Gridview.

2. Click on the Smart tag which is in the top right corner of the Gridview control.

3. Select <new data source> from the listbox shown there.

4. Now Select --> database ( for sql database) and specify an ID for datasource.

5. Now you specify which data connection you want to connect to using the listbox provided.

6. Now specify a name for the connection string.

7. Now select the database then the columns you want to show.

I think you are clear.

[kstr]

Thank you for your reply. What i want to do is use the ado.net entity framework. so the datasource is EntityDataSource.

As i said, i can make it work with sql and access, but not with entity

This post has been edited by kstr: 30 November 2009 - 03:22 AM

[gaotter]

Hi I hade the same problem looks like there are some new ways of doing stuff. Here is some code that that worked for me:

The code is in the second datasource where you what to do the selection.

<asp:EntityDataSource ID="EntityDataSource2" runat="server" 
			ConnectionString="name=AdventureWorksEntities" 
			DefaultContainerName="AdventureWorksEntities" EnableInsert="True" 
			EnableUpdate="True" EntitySetName="Employee" EntityTypeFilter="Employee"
			 Select="" Where="it.EmployeeID = @selEmpID">
			<WhereParameters>
			<asp:ControlParameter ControlID="GridView1" Name="selEmpID" Type="Int32" PropertyName="SelectedValue" />
			</WhereParameters>
		</asp:EntityDataSource> 

Here is my source:
http://msdn.microsof...y/cc488531.aspx