Blue Ink
Blue InkHomeBlue Ink SolutionsArticlesBlue Ink Net CommunityBlue Ink Demo ApplicationAbout Automated Architecture
My Profile
login/register
0

Connection Error

View Blue Ink Issues Forum | Post Response | New Topic

Author Message
tonis
Dec 5 2005
6:42 PM
Dear Support,

Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573; Blue Ink version is 1.4.1969.2084.

1) I created an application but the .CS file for all the strongly typed datasets in Common\Entities\BaseXsd\ folder were missing though the XSD files were created successfully.

2) In the following dataset, in <xs:element name="tbl_CustomerSegment"> there is only one element:

<?xml version="1.0" encoding="utf-8"?>

<xs:schema id="tbl_Customer_ViewFksDataSet_BaseXsd" targetNamespace="http://tempuri.org/tbl_Customer_ViewFksDataSet_BaseXsd.xsd" elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/tbl_Customer_ViewFksDataSet_BaseXsd.xsd" xmlns:mstns="http://tempuri.org/tbl_Customer_ViewFksDataSet_BaseXsd.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

<xs:element name="tbl_Customer_ViewFksDataSet_BaseXsd" msdata:IsDataSet="true">

<xs:complexType>

<xs:choice maxOccurs="unbounded">

<xs:element name="tbl_Customer">

<xs:complexType>

<xs:sequence>

<xs:element name="Address" type="xs:string" minOccurs="0" />

<xs:element name="CRN" type="xs:string" minOccurs="0" />

<xs:element name="CustomerCategoryId" type="xs:int" minOccurs="0" />

<xs:element name="CustomerSegmentId" type="xs:int" minOccurs="0" />

<xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" minOccurs="0" />

<xs:element name="Phone" type="xs:string" minOccurs="0" />

<xs:element name="PostCode" type="xs:string" minOccurs="0" />

<xs:element name="State" type="xs:string" minOccurs="0" />

<xs:element name="strName" type="xs:string" minOccurs="0" />

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="tbl_CustomerSegment">

<xs:complexType>

<xs:sequence>

<xs:element name="ID" type="xs:int" />

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="tbl_CustomerCategory">

<xs:complexType>

<xs:sequence>

<xs:element name="ID" type="xs:int" />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:choice>

</xs:complexType>

<xs:unique name="tbl_Customer_PK" msdata:PrimaryKey="true">

<xs:selector xpath=".//mstns:tbl_Customer" />

<xs:field xpath="mstns:ID" />

</xs:unique>

<xs:unique name="tbl_CustomerSegment_PK" msdata:PrimaryKey="true">

<xs:selector xpath=".//mstns:tbl_CustomerSegment" />

<xs:field xpath="mstns:ID" />

</xs:unique>

<xs:unique name="tbl_CustomerCategory_PK" msdata:PrimaryKey="true">

<xs:selector xpath=".//mstns:tbl_CustomerCategory" />

<xs:field xpath="mstns:ID" />

</xs:unique>

<xs:keyref name="tbl_CustomerSegmenttbl_CustomerCustomerSegmentId" refer="tbl_CustomerSegment_PK">

<xs:selector xpath=".//mstns:tbl_Customer" />

<xs:field xpath="mstns:CustomerSegmentId" />

</xs:keyref>

<xs:keyref name="tbl_CustomerCategorytbl_CustomerCustomerCategoryId" refer="tbl_CustomerCategory_PK">

<xs:selector xpath=".//mstns:tbl_Customer" />

<xs:field xpath="mstns:CustomerCategoryId" />

</xs:keyref>

</xs:element>

</xs:schema>

As a result the following error occurs:

Server Error in '/FGE' Application.
--------------------------------------------------------------------------------

DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with the name strName.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with the name strName.

Source Error:

Line 16: ddl.DataTextField = strDataTextField; Line 17: ddl.DataValueField = strDataValueField; Line 18: ddl.DataBind(); Line 19: ddl.Items.Insert(0, new ListItem("", "")); Line 20: }


Source File: d:\dev\blueinkfge\web\uicommon\uihelper.cs Line: 18

Stack Trace:

[HttpException (0x80004005): DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with the name strName.] System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName, String format) System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) System.Web.UI.Control.DataBind() Infosys.FGE2.UiCommon.UiHelper.FillDropDown(DropDownList ddl, DataTable tbl, String strDataTextField, String strDataValueField) in d:\dev\blueinkfge\web\uicommon\uihelper.cs:18 Infosys.FGE2.Base.tbl_Customer_Add_Base.BindPageControls(tbl_Customer_ViewFksDataSet tdsViewFks) in D:\Dev\BlueInkFGE\Web\Base\tbl_Customer_Add_Base.cs:93 Infosys.FGE2.Base.tbl_Customer_Add_Base.Page_Load_Base(Object sender, EventArgs e) in D:\Dev\BlueInkFGE\Web\Base\tbl_Customer_Add_Base.cs:117 System.EventHandler.Invoke(Object sender, EventArgs e) +0 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731
Lee Richardson
(Admin)

Dec 7 2005
1:00 AM
Toni,

Regarding issue #1 did you run CompileDataSets.bat or check out the generated instructions? One of the files generated should have been PostInstallationInstructions.html. This should have been put in the root solution directory along with the .sln file. The document should contain detailed instructions on how to install the generated application including how to compile all strongly typed datasets using the CompileDataSets.bat file.

Regarding issue #2. It is hard to diagnose without viewing your database schema, but I suspect the schema lacks many required fields. Required fields are how Blue Ink determines which fields are "important" (or more specifically which fields are "Identifying" in terms of the meta-data). This should not cause problems during installation or running of the application, but can be fixed: by preferably requiring at least a field in every table other than the primary key, or alternately selecting which fields are identifying in the meta-data.

If your schema actually is causing runtime or compile time errors, I am currently seeking database schemas that cause problems out of the box for Blue Ink. So if you are comfortable sharing I would very much like a copy of your database or a script to recreate it in order to help improve Blue Ink.

Thanks,
- Lee
tonis
Dec 8 2005
3:13 PM
Thanks Lee.
Yes, you are right with regards to issue #1. I did not run compiledataset.bat. :-(

As for issue 2, I am e-mailing the SQL script.

View Blue Ink Issues Forum | Post Response | New Topic






ARTICLES

What is Rapid Application Development?


QUESTIONS?

Call us toll free:
(877) 756-3595

Or Visit Forums

    

Copyright © 2017 Automated Architecture, Inc. All rights reserved.