join multiple tables as datasource for datagrid - DataForm.NET Samples

1. Open DataForm.NET Manager. In DataForm.NET List page, choose Order Details by clicking the link.
2. In the DataForm.NET Designer on the right hand side, switch to GridForm tab.
3. ProductName field is from Products tables. Such field can be added by the form at the bottom of table. There are five attributes needed to specified(Column Name, Field Title,  Column Type and Order). After you click "Add Field" button, this field will show up in the table above.
4. Click "ProductName" link to open up GridForm Fields Designer window.
5. Switch to "Database" tab. The Datasource Name may be already specified. And by default, the Display Column is the same as the Column Name. But you can change it if you want to display different column.
6. The SQL join statement can be written inside the big textbox. Or you can pick corresponding tables and fields and click "Get Join Statement" link to help you generate the join statement. Make sure Join statement is corrent, then save and preview GridForm.

Aspx:

<%@ Register TagPrefix="EasyDotNet"Namespace="EasyDotNet.Web.UI.WebControls" Assembly="EasyDotNet.Web" %>

---

<form id="Form1" method="post" runat="server">

<script language="vb" runat="server">

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)

    'Put user code to initialize the page here

    If Not IsPostBack Then

        EGridForm1.DataBind()

    End If

End Sub

</script>

<EasyDotNet:eGridForm id=EGridForm1 runat="server" DataFormID="Order Details"></EasyDotNet:eGridForm>

</form>

Codebehind/Codefile:

None. No code needed.