public override IdhtmlxConnector CreateConnector(HttpContext context)
{
dhtmlxGridConnector connector = new dhtmlxGridConnector(
"SELECT ISO, PrintableName FROM Country",
"UID",
dhtmlxDatabaseAdapterType.SqlServer2005,
ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
);
connector.Request.CustomSQLs.Add(CustomSQLType.Delete, "UPDATE Country SET PrintableName = '-------------' WHERE UID={UID}");
return connector;
}
public override IdhtmlxConnector CreateConnector(HttpContext context)
{
dhtmlxGridConnector connector = new dhtmlxGridConnector(
"SELECT ISO, PrintableName FROM Country",
"UID",
dhtmlxDatabaseAdapterType.SqlServer2005,
ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
);
connector.BeforeInsert += new EventHandler<DataActionProcessingEventArgs>(connector_BeforeInsert);
return connector;
}
public override IdhtmlxConnector CreateConnector(HttpContext context)
{
dhtmlxGridConnector connector = new dhtmlxGridConnector(
"BookStore",
"sales, title, author, price, instore, shipping, bestseller, pub_date",
"book_id",
dhtmlxDatabaseAdapterType.SqlServer2005,
ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
);
connector.BeforeOutput += new EventHandler<RenderEventArgs>(connector_BeforeOutput);
return connector;
}
public override IdhtmlxConnector CreateConnector(HttpContext context)
{
dhtmlxGridConnector connector = new dhtmlxGridConnector(
"Country",
"ISO, PrintableName",
"UID",
dhtmlxDatabaseAdapterType.SqlServer2005,
ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
);
if (context.Request.QueryString["dynamic"] != null)
connector.SetDynamicLoading(Convert.ToInt32(context.Request.QueryString["dynamic"]));
return connector;
}
public override IdhtmlxConnector CreateConnector(HttpContext context)
{
dhtmlxGridConnector connector = new dhtmlxGridConnector(
"BookStore",
"sales, title, author, price, instore, shipping, bestseller, pub_date",
"book_id",
dhtmlxDatabaseAdapterType.SqlServer2005,
ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
);
connector.ExplicitOptions.Add((TableField)"shipping", "na", "1 Day", "3 Days", "5 Days");
connector.Request.TransactionMode = TransactionMode.PerRecord;
return connector;
}
public override IdhtmlxConnector CreateConnector(HttpContext context)
{
//configure grid connector
dhtmlxGridConnector connector = new dhtmlxGridConnector(
"Country",
"ISO, PrintableName",
"UID",
dhtmlxDatabaseAdapterType.SqlServer2005,
ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
);
connector.SetDynamicLoading(50);
//configure filter drop-down-list connector
dhtmlxOptionsConnector filterConnector = new dhtmlxOptionsConnector("Country", connector.Request.Adapter, "ISO");
//attach filter connector to first column of grid connector
connector.OptionsConnectors.Add(connector.Request.RequestedFields[0], filterConnector);
return connector;
}
