Btw. if you need to connect to a database, that isn't supported by Umbraco, you need to create a custom editor/view based on the Table*-classes, but it isn't difficult.

Sune - thanks, that works great!  I missed it in the docs, I should RTFM ;-)

Phil

Haha, no prob.

- Sune

Hi Sune,

So for editor/view do i need to edit your source code?

Hi Eshan,

No. To create a new editor/view/repository you can specifiy your own type on the tag in the xml-file, like this.
<dewd>   
  <repository name="Languages" icon="mediaFile.gif">
    <view name="All" type="yourowntype,yourownassembly">
    </view>
    <editor tableName="umbracoLanguage" type="yourowntype,yourownassembly">
      <field title="ISO code" sourceField="languageISOCode" umbracoDataType="Textstring" />
      <field title="Culture name" sourceField="languageCultureName" umbracoDataType="Textstring" />
    </editor>
  </repository>
</dewd>
And then you can just inherit from one of the build-in types.

Hope this makes sense.

Btw. you're welcome to start a new thread, if you have more specific questions regarding this.

sorry sune i didn't get what you say, will you please explain it more. below is the my xml code

<container name="External database" connection="data source=Test;database=Test;user id=test;password=test">
      <repository name="Reviews">
          <primaryKey name="reviewID" />

          <view name="Reviews entries" pageSize="50" >
              <columns>
                  <column field="DateAdded" title="Date Added" />
                  <column field="Rating" />
                  <column field="Title" />
                  <column field="Description" />
                  <column field="IsApproved" title="Is Approved"/>
              </columns>
              <sql>
                  <![CDATA[
                    SELECT reviewID, DateAdded, Rating, Title, Description, IsApproved
                    FROM tblReview
                  ]]>
              </sql>
              <editor tableName="tblReview">
                  <field title="ID" sourceField="reviewID" umbracoDataType="Textstring" readonly="true" />
                  <field title="Title" sourceField="Title" umbracoDataType="Textstring" />
              </editor>

          </view>
      </repository> 

  </container> 

All i need is to edit this record. :(

Btw what do you mean by yourowntype and yourownassembly. What are the built in types that I should inherit from?

how listControldatasouce will work for umbraco7.2.x

is working on a reply...