1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67

<%@ Page Language="C#" AutoEventWireup="true" Inherits="demos_GridWebForm_GridWebForm1" 
	MasterPageFile="~/tpl/Demo.Master" 
	Title="GridWeb FormView - Aspose.Cells Grid Suite Demos" 
	 Codebehind="GridWebForm1.aspx.cs" %>
<%@ Register TagPrefix="agw" Namespace="Aspose.Cells.GridWeb" Assembly="Aspose.Cells.GridWeb" %>
<asp:Content runat="server" ContentPlaceHolderID="HeaderContent">
    <link href=../../style/site.css rel=Stylesheet type="text/css">    
</asp:Content>
<asp:Content runat="server" ContentPlaceHolderID="MainContent">
    <p class="componentDescriptionTxt">
    	You may see how demo enables you to edit form values by using a special <b>WebForm View</b> mode.
    	Just click <b>View</b> text in the first column to see the form where you can enter new values for grid columns.
	</p>
    <br />
    <div class="demoContentArea">
    <table>
				<TR>
					<TD></TD>
				</TR>
				<tr>
					<td>
						<agw:GridWeb id="GridWeb1" runat="server" XhtmlMode="false" ActiveCellBgColor="#DDDDFF" ViewTableStyle-LayoutFixed="Fixed" ViewTableStyle-BorderWidth="0px" ViewTableStyle-BorderCollapse="Collapse" BottomTableStyle-LayoutFixed="Fixed" BottomTableStyle-Height="20pt" BottomTableStyle-BorderWidth="0px" BottomTableStyle-BorderCollapse="Collapse" BottomTableStyle-TopBorderStyle-BorderStyle="Solid" BottomTableStyle-TopBorderStyle-BorderWidth="1px" BottomTableStyle-TopBorderStyle-BorderColor="Gray" BottomTableStyle-BackColor="#F0F0F0" HeaderBarStyle-LeftBorderStyle-BorderStyle="Solid" HeaderBarStyle-LeftBorderStyle-BorderWidth="1px" HeaderBarStyle-LeftBorderStyle-BorderColor="White" HeaderBarStyle-VerticalAlign="Middle" HeaderBarStyle-RightBorderStyle-BorderStyle="Solid" HeaderBarStyle-RightBorderStyle-BorderWidth="1px" HeaderBarStyle-RightBorderStyle-BorderColor="Gray" HeaderBarStyle-TopBorderStyle-BorderStyle="Solid" HeaderBarStyle-TopBorderStyle-BorderWidth="1px" HeaderBarStyle-TopBorderStyle-BorderColor="White" HeaderBarStyle-BorderWidth="1px" HeaderBarStyle-Font-Size="10pt" HeaderBarStyle-Font-Names="Arial" HeaderBarStyle-BorderColor="Gray" HeaderBarStyle-BorderStyle="Solid" HeaderBarStyle-HorizontalAlign="Center" HeaderBarStyle-ForeColor="Black" HeaderBarStyle-BackColor="#E0E0E0" HeaderBarStyle-BottomBorderStyle-BorderStyle="Solid" HeaderBarStyle-BottomBorderStyle-BorderWidth="1px" HeaderBarStyle-BottomBorderStyle-BorderColor="Gray" HeaderBarStyle-Wrap="False" HeaderBarTableStyle-LayoutFixed="Fixed" HeaderBarTableStyle-BorderWidth="0px" HeaderBarTableStyle-BorderCollapse="Separate" ActiveTabStyle-Height="15pt" ActiveTabStyle-BorderWidth="1px" ActiveTabStyle-Font-Size="10pt" ActiveTabStyle-Font-Names="Arial" ActiveTabStyle-BorderColor="Gray" ActiveTabStyle-BorderStyle="Solid" ActiveTabStyle-ForeColor="Black" ActiveTabStyle-BackColor="White" ActiveTabStyle-Wrap="False" SelectCellBgColor="#EEEEFF" FrameTableStyle-BorderStyle="Solid" FrameTableStyle-LayoutFixed="Fixed" FrameTableStyle-BorderWidth="1px" FrameTableStyle-BorderColor="Gray" FrameTableStyle-BorderCollapse="Collapse" FrameTableStyle-BackColor="White" TabStyle-Height="15pt" TabStyle-BorderWidth="1px" TabStyle-Font-Size="10pt" TabStyle-Font-Names="Arial" TabStyle-BorderColor="Gray" TabStyle-BorderStyle="Solid" TabStyle-ForeColor="Black" TabStyle-BackColor="#E0E0E0" TabStyle-Wrap="False" ActiveHeaderBgColor="#F2F2F2" OnCellCommand="GridWeb1_CellCommand">
							<WebWorksheets>
								<agw:Worksheet DataMember="Products" Name="Sheet1">
									<BindColumns>
										<agw:BindColumn CommandName="VIEWDETAIL" UseAlternativeStyle="False" EnableSort="False" Caption="View" CommandText="[VIEW]">
											<Style ForeColor="Blue">
											</Style>
										</agw:BindColumn>
										<agw:BindColumn IsAutoCreated="True" Caption="ProductID" DataField="ProductID">
											<Validation ValidationType="Integer" IsRequired="True"></Validation>
										</agw:BindColumn>
										<agw:BindColumn IsAutoCreated="True" Caption="CategoryID" DataField="CategoryID">
											<Validation ValidationType="Integer"></Validation>
										</agw:BindColumn>
										<agw:BindColumn IsAutoCreated="True" Caption="CreatedDate" DataField="CreatedDate">
											<Validation ValidationType="Date"></Validation>
										</agw:BindColumn>
										<agw:BindColumn IsAutoCreated="True" Caption="Discontinued" DataField="Discontinued">
											<Validation ValidationType="CheckBox"></Validation>
										</agw:BindColumn>
										<agw:BindColumn IsAutoCreated="True" Caption="ProductName" DataField="ProductName"></agw:BindColumn>
										<agw:BindColumn IsAutoCreated="True" Caption="QuantityPerUnit" DataField="QuantityPerUnit"></agw:BindColumn>
										<agw:BindColumn IsAutoCreated="True" Caption="ReorderLevel" DataField="ReorderLevel">
											<Validation ValidationType="Integer"></Validation>
										</agw:BindColumn>
										<agw:BindColumn IsAutoCreated="True" Caption="SupplierID" DataField="SupplierID">
											<Validation ValidationType="Integer"></Validation>
										</agw:BindColumn>
										<agw:BindColumn IsAutoCreated="True" Caption="UnitPrice" NumberType="Currency3" DataField="UnitPrice">
											<Validation ValidationType="Number"></Validation>
										</agw:BindColumn>
										<agw:BindColumn IsAutoCreated="True" Caption="UnitsInStock" DataField="UnitsInStock">
											<Validation ValidationType="Integer"></Validation>
										</agw:BindColumn>
										<agw:BindColumn IsAutoCreated="True" Caption="UnitsOnOrder" DataField="UnitsOnOrder">
											<Validation ValidationType="Integer"></Validation>
										</agw:BindColumn>
									</BindColumns>
								</agw:Worksheet>
							</WebWorksheets>
						</agw:GridWeb>
						<agw:GridWebForm id="GridWebForm2" runat="server" GridWebControl="GridWeb1"></agw:GridWebForm></td>
				</tr>
			</table>
    </div>
</asp:Content>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Aspose.Cells.GridWeb;
using Aspose.Cells.GridWeb.Data;
using Aspose.Cells.GridWeb.DemosCS.DataBind;
using Aspose.Cells.GridWeb.DemosCS;


public partial class demos_GridWebForm_GridWebForm1 : System.Web.UI.Page
{
    protected Aspose.Cells.GridWeb.DemosCS.DataBind.DataSet1 dataSet11;

    protected void Page_Load(object sender, EventArgs e)
    {
      // Put user code to initialize the page here
      if (!IsPostBack)
        BindWithoutInSheetHeaders();
    }

  private void BindWithoutInSheetHeaders()
  {
      this.dataSet11 = new Aspose.Cells.GridWeb.DemosCS.DataBind.DataSet1();
    DemoDatabase db = new DemoDatabase();
    string path = Server.MapPath("~");
    path = path.Substring(0, path.LastIndexOf("\\"));	
    db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Database\\demos.mdb";
    try
    {
      // Connects to database and fetches data.
      db.oleDbDataAdapter1.Fill(dataSet11);
      db.oleDbDataAdapter2.Fill(dataSet11);

      WebWorksheet sheet = GridWeb1.WebWorksheets[0];

      // Create the "CategoryID" field dropdownlist value list.
      sheet.BindColumns["CategoryID"].Validation.ValidationType = ValidationType.List;
      sheet.BindColumns["CategoryID"].Validation.LoadValueList(dataSet11.Categories.DefaultView, "CategoryID", "CategoryName", true);

      // Bind the sheet to the dataset.
      sheet.DataSource = dataSet11;
      sheet.DataBind();
    }
    finally
    {
      db.oleDbConnection1.Close();
    }
  }

  // Uses the cell command type bind column to create a link for each row to switch to the form view.
  protected void GridWeb1_CellCommand(object sender, Aspose.Cells.GridWeb.CellEventArgs e)
  {
    if (e.Argument.Equals("VIEWDETAIL"))
    {
      GridWebForm2.ShowForm();
      GridWebForm2.LineNumber = e.Cell.Row;
    }
  }

}