System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Dear All,

(Guid)productFamily1[1] => return value {9dd28cc2-3243-e011-b0cc-005056875e43}

But i getting this error:
total.productfamily 'total.productfamily' threw an exception of type 'System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

When i try to assign (Guid)productFamily1[1] into total.ProductFamily as below:-

total.productfamily = (Guid)productFamily1[1];

Can anyone help me on this?

Thank you.

Regards,

Micheale

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

What is the type of productFamily1[1]? You can't just cast a string to a Guid, you create a new Guid using the string as a parameter to the constructor. So, if productFamily1 is of type string[] then you would need

total.productfamily = new Guid(productFamily1[1]);

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Hi Paul,

It's Guid.

Here the process flow:-

-------------------------- Bold section will call the function, and return Guid value --------------

int k = 1;

Guid[] productFamily1 = new Guid[10];

foreach (ToolStripMenuItem item in tsddbSegment.DropDown.Items) {

if (item.Checked)

{

productFamily1[k] = Helpers.getProduct(item.Text);

filterByProductFamily = (productFamily1[k] !=null && productFamily1[k] != Guid.Empty) ? true : false;

k = k + 1;

}

-------------------------------------- Function to retrieve Guid ----------------------------

public static Guid getProduct(string name) {

frmMain mainForm = (frmMain)Application.OpenForms["frmMain"];

DataSet1 dataset = mainForm.GetDataSet();

// Get distinct set of Families referenced in opportunity dataset

DataView tempView = new DataView(dataset.OpportunityElement, null, "productfamilyname", DataViewRowState.CurrentRows);

DataTable distinctAProductFamily = tempView.ToTable(true, new string[] { "productfamilyname", "productfamily" });

Guid aPro = Guid.Empty;

// Create list of region options

foreach (DataRow aPFRow in distinctAProductFamily.Rows)

{

if ((string)aPFRow["productfamilyname"] == name)

{

aPro=(Guid)aPFRow["productfamily"];

}

return (aPro);

}

total.productfamily = productFamily1[1];

I used watch to trace the value for productFamily1[1] return value {...........} as above mentiod. It's Guid.

But i try to assigned into total.productfamily, where the watch return above mentioned error. I get stuck. Logicall it's should work. But technically i am failed. :-(

Please help. Appreciate for your kind respond & help.

Thank you.

Regards,

Micheale

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

I can't see a problem, immediately. Can you put a breakpoint on the line

total.productfamily = productFamily1[1];

check that productFamily1[1] is correct at this point and then step once and see what the value of total.productFamily is? If you now continue is this line executed again? What line actually generates the exception?

The StrongTypingException is generated when you try to store a null in a dataset field that does not allow nulls.

By the way. In c# array indexes start at 0. When you declare an array to be new fred[10] then the elements are indexed from 0 to 9. So it would be more natural to set k = 0 and to use element zero of the array.

The logic around filterbyproductfamily doesn't look right either. It seems that it only reflects the validity of the last checked item as it is overwritten each time around the loop.

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Thanks Paul.

I will try to redo the code line by line breakpoint as you have suggested above. Maybe somewhere is wrong.

Thank you.

Regards,

Micheale

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Guid[] productFamily = new Guid[10];

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Thank you once again.

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Hi,

How can i make the bold section accept multi scalar parameter matching likes [Contains] or [ where fieldname IN('Parameter1','Parameter2','Parameter3...) ]?

eg: productFamily[2]

productFamily[0] = Guid {xxxxxxxxxxxxxxxxxxxxxxxxx}

productFamily[1] = Guid {yyyyyyyyyyyyyyyyyyyyyyyy}

Please advise.

Thank you.

for (int i = 1; i <= 10; i++)

{

// Revenues by month

DataSet1.TotalRevenueByMonthRow total = dataSet1.TotalRevenueByMonth.NewTotalRevenueByMonthRow();

total.totalcategory = i;

total.financialyear = year;

total.financialmonth = month;

for(int jj=0; jj<k; jj++)

{

total.productfamily = productFamily[jj];

}

dataSet1.TotalRevenueByMonth.AddTotalRevenueByMonthRow(total);

}

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Can you give some more explanation about what you want to achieve?

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Hi Paul,

My objective :

I have a dropdownbox with mutiselect. I want the dataset row total to sum up the productfamily that i have selected with others criteria expression. Now, i only successful to get 1 item selected total no matter how many item been selected. The problem is causing by Guid[].

Thank you.

Regards,

Micheale

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Hi,

I have below code for 1 productfamily. It's work fine.

DataSet1.TotalRevenueByMonthRow total = dataSet1.TotalRevenueByMonth.NewTotalRevenueByMonthRow();

total.productfamily = productFamily[0];

dataSet1.TotalRevenueByMonth.AddTotalRevenueByMonthRow(total);

But, I want total.productfamily (type: System.Guid) having two value. The idea is like:-

total.productfamily = productFamily[0] or total.productfamily = productFamily[1];

How can i put it in the correct coding ways?

Please advise.

Thank you.

Regards,

Micheale

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

total.productfamily will need to be a data type which con contain multiple values. A List would be my choice.

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Hi Paul,

Could you please give me a sample of code?

Appreciate for your kind help.

Thank you.

Regards,

Micheale

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Hi,

I have change syste.Guid to be Guid[] for the function, but i having issue on bold section. I can't perform using equal sign.

Please advise.

Thank you.

[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

public System.Guid[] productfamily {

get {

try {

return ((global::System.Guid[])(this[this.tableTotalRevenueByMonth.productfamilyColumn]));

}

catch (global::System.InvalidCastException e) {

throw new global::System.Data.StrongTypingException("The value for column \'productfamily\' in table \'TotalRevenueByMonth\' is DBNull.", e); }

}

set {

this[this.tableTotalRevenueByMonth.productfamilyColumn] = value;

}

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Hi,

This will be useful.

http://msdn.microsoft.com/en-us/library/system.data.strongtypingexception.aspx

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Hi,

I am stuck in the bold section section as below:-

[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

public global::System.Data.DataColumn[] productfamilyColumn {

get {

return this.columnproductfamily; // show error: Cannot implicity convert type 'System.Data.DataColumn' to 'System.Data.DataColumn[]'

}

Please advise.

Thank you.

Regards,

Micheale

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Hi,

I manage to resolved the problem until this stage, but i got error for this line:-

Error: Cannot set Expression property due to circular reference in the expression.

dataSet1.TotalRevenueByMonth.productfamilyColumn.Expression = " productfamily in ('" + filterByProductFamily2.TrimStart(',') + "')";

Please Advise.

Thank you.

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Hi,

My current solution:-

total.productfamily is Guid []

productFamily is Guid[].

If productFamily having 1 Guid, then it's work fined. But if Guid>1, then the total all show nil.

What's wrong with my below code?

Please Advise.

Thank you.

for (int i = 1; i <= 10; i++)

{

DataSet1.TotalRevenueByMonthRow total = dataSet1.TotalRevenueByMonth.NewTotalRevenueByMonthRow();

total.totalcategory = i;

total.financialyear = year;

total.financialmonth = month;

total.accountmanagerid = (filterByAccountManager) ? accountManagerId : Guid.Empty;

total.aegionid = (filterByARegion) ? aRegionId : Guid.Empty;

total.abuid = (filterByABu) ? aBuId : Guid.Empty;
total.productfamily = productFamily;

dataSet1.TotalRevenueByMonth.AddTotalRevenueByMonthRow(total);

}

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Which piece of code is doing the wrong thing?

Is it AddTotalRevenueByMonthRow? Can you show the code that is giving an unexpected result?

Re: System.Data.StrongTypingException' System.Guid {System.Data.StrongTypingException}

Hi Paul,

Thank you very much for your kind reply & help again.

Here it go:-

http://forums.asp.net/t/1794451.aspx/1?DataSet+Relations+with+filter+using+productfamily+in+item+a+item+b+item+c+

Finally i figure out the problem is occur at the post above.

Please Advise.

For the function request above by you as below:-

[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

public void AddTotalRevenueByMonthRow(TotalRevenueByMonthRow row) {

this.Rows.Add(row);

}

[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

public TotalRevenueByMonthRow AddTotalRevenueByMonthRow(

int totalcategory, string name, int financialmonth,

int financialyear, System.Guid[] productfamily,

System.Guid accountmanagerid,

string accountmanager,

int countdownregion, System.Guid avbuid, System.Guid avregionid,

string currencycode_rc,

double initial_rcCoS,

double initial_rc,

double annual_rcCoS,

double annual_rc,

double rental_rcCoS,

double rental_rc,

double service_rcCoS,

double service_rc,

double training_rcCoS,

double training_rc,

double gross_rc,

double cos_rc,

double net_rc,

double ytd_initial_rcCoS,

double ytd_annual_rcCoS,

double ytd_rental_rcCoS,

double ytd_service_rcCoS,

double ytd_training_rcCoS,

double ytd_initial_rc,

double ytd_annual_rc,

double ytd_rental_rc,

double ytd_service_rc,

double ytd_training_rc,

double ytd_gross_rc,

double ytd_cos_rc,

double ytd_net_rc,

string opportunitytypename) {

TotalRevenueByMonthRow rowTotalRevenueByMonthRow = ((TotalRevenueByMonthRow)(this.NewRow()));

object[] columnValuesArray = new object[] {

totalcategory, name,financialmonth, financialyear,

productfamily, accountmanagerid, accountmanager,

countdownregion, avbuid, avregionid, currencycode_rc,

initial_rcCoS, initial_rc, annual_rcCoS, annual_rc,

rental_rcCoS, rental_rc, service_rcCoS, service_rc,

training_rcCoS, training_rc, gross_rc, cos_rc, net_rc, ytd_initial_rcCoS,

ytd_annual_rcCoS, ytd_rental_rcCoS, ytd_service_rcCoS, ytd_training_rcCoS,

ytd_initial_rc, ytd_annual_rc, ytd_rental_rc, ytd_service_rc, ytd_training_rc,

ytd_gross_rc, ytd_cos_rc, ytd_net_rc, opportunitytypename};

rowTotalRevenueByMonthRow.ItemArray = columnValuesArray;

this.Rows.Add(rowTotalRevenueByMonthRow);

return rowTotalRevenueByMonthRow;

}

[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

public TotalRevenueByMonthRow AddTotalRevenueByMonthRow(

int totalcategory, string name,

int financialmonth,

int financialyear, System.Guid[] productfamily, System.Guid accountmanagerid,

string accountmanager, int countdownregion, System.Guid avbuid, System.Guid avregionid,

string currencycode_rc, double initial_rcCoS, double initial_rc,

double annual_rcCoS, double annual_rc,

double rental_rcCoS, double rental_rc,

double service_rcCoS, double service_rc,

double training_rcCoS,

double training_rc,

double cos_rc,

double ytd_initial_rcCoS,

double ytd_annual_rcCoS,

double ytd_rental_rcCoS,

double ytd_service_rcCoS,

double ytd_training_rcCoS,

double ytd_initial_rc,

double ytd_annual_rc,

double ytd_rental_rc,

double ytd_service_rc,

double ytd_training_rc, double ytd_cos_rc,

string opportunitytypename) {

TotalRevenueByMonthRow rowTotalRevenueByMonthRow = ((TotalRevenueByMonthRow)(this.NewRow()));

object[] columnValuesArray = new object[] {

totalcategory, name, financialmonth, financialyear, productfamily, accountmanagerid, accountmanager, countdownregion, avbuid, avregionid, currencycode_rc, initial_rcCoS, initial_rc, annual_rcCoS, annual_rc, rental_rcCoS, rental_rc, service_rcCoS, service_rc, training_rcCoS, training_rc, null, cos_rc, null, ytd_initial_rcCoS, ytd_annual_rcCoS, ytd_rental_rcCoS, ytd_service_rcCoS, ytd_training_rcCoS, ytd_initial_rc, ytd_annual_rc, ytd_rental_rc, ytd_service_rc, ytd_training_rc,null, ytd_cos_rc, null, opportunitytypename};

rowTotalRevenueByMonthRow.ItemArray = columnValuesArray;

this.Rows.Add(rowTotalRevenueByMonthRow);

return rowTotalRevenueByMonthRow;

}

Thank You.