Data Presentation Controls

Re: Gridview RowEdit and DataBinding without SqlDataSource

dotnetkode — Fri, 29 Aug 2008 18:38:08 GMT

Why don't you have class called Person with three properties.

then have something like this.

List<Person> coolPeople=new List<Person>();

then in your while loop

Person p=new Person();

//set the person properties

//add the person to the list

return the list

Re: Gridview RowEdit and DataBinding without SqlDataSource

adarwich — Fri, 29 Aug 2008 16:10:08 GMT

Hi Ed,

Thanks for reply, and you are right. I'm not overly familiar with the ObjectDataSource. I've changed my code to:

<asp:GridView ID="gvList" runat="server" DataSourceID="objList" AutoGenerateColumns="false" AutoGenerateEditButton="true" DataKeyNames="ID" AllowSorting="true" AllowPaging="false" OnRowEditing="gvList_RowEditing" OnRowUpdating="gvList_RowUpdating" ShowFooter="true">
<Columns>
<asp:BoundField HeaderText="Volume" DataField="StartVolume" SortExpression="StartVolume" />
</Columns>
</asp:GridView>
<asp:ObjectDataSource ID="objList" SelectMethod="GetData" runat="server" TypeName="CMSLibrary.JournalVolumesInfo"></asp:ObjectDataSource>

public CMSLibrary.JournalVolumesInfo[] GetData()
    {
        CMSLibrary.JournalVolumesDB jvDB = new CMSLibrary.JournalVolumesDB();
        CMSLibrary.JournalVolumesInfo[] jvAll = jvDB.JournalVolumes_GetAllByJournalIDIgnoreStatus(this.JournalInfo.ID);

        return jvAll;
    }

but receive the following error

ObjectDataSource 'objList' could not find a non-generic method 'GetData' that has no parameters.

What am I missing?

Thanks!

Re: Gridview RowEdit and DataBinding without SqlDataSource

ecbruck — Fri, 29 Aug 2008 15:31:20 GMT

It looks like you should be using an ObjectDataSource as opposed to a SqlDataSource.

Gridview RowEdit and DataBinding without SqlDataSource

adarwich — Fri, 29 Aug 2008 15:26:06 GMT

Hi there,

I have a gridview (gvList), that I would like to populate programatically from a class and then use the rowedit features. Is this possible, or do I need to create some type of custom control? Currently, I've used a SqlDataSource for testing purposes. For example:

<asp:GridView ID="gvList" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="false" AutoGenerateEditButton="true" DataKeyNames="ID" AllowSorting="true" AllowPaging="false" OnRowEditing="gvList_RowEditing" OnRowUpdating="gvList_RowUpdating" ShowFooter="true">
<Columns>
<asp:BoundField HeaderText="Volume" DataField="StartVolume" SortExpression="StartVolume" />
</Columns>
</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" UpdateCommand="UPDATE tbl_JournalVolumes SET StartVolume = @StartVolume WHERE ID = @ID" ConnectionString="<%$ ConnectionStrings:DB_1 %>" ></asp:SqlDataSource>

if (this.JournalInfo != null)
{

SqlDataSource1.SelectCommand = "SELECT ID, StartVolume FROM tbl_JournalVolumes WHERE tbl_JournalVolumes.JournalID = " + jItm.ID.ToString();

}

I would like to instead BindData using this, or similar:

CMSLibrary.JournalVolumesDB jvDB = new CMSLibrary.JournalVolumesDB();
CMSLibrary.JournalVolumesInfo[] jvAll = jvDB.JournalVolumes_GetAllByJournalIDIgnoreStatus(this.JournalInfo.ID);

gvList.DataSource = jvAll;
gvList.DataBind();

I guess I'm wondering if I can assume jvAll to the SqlDataSource? I also have a class built to update the necessary SQL tables (jvDB.JournalVolumes_EditJournalVolumeSettings). Can this be assigned somehow to the SqlDataSource? Or, can I throw out the SqlDataSource and use some other method to bind and edit data line by line?

Thanks!