Re: How I can update Child Table using Entity Framework (ugent) - C# Discussion Boards

First Prev Next

Re: C# Configuration Files

staticv2-Jun-09 4:59

staticv

2-Jun-09 4:59

Well, I configured it out myself after debugging for almost 5 hours, Damn!

The problem was when I used OpenFileDialog to get the file path, it changed the current directory to the one which is selected in the dialog, so the program couldn't find the config file. All I did was to set the RestoreDirectory property of OpenFileDialog to true and *poof* it worked

Top Web Hosting Providers[^]

Do, or do not. There is no 'try'.

How I can update Child Table using Entity Framework (ugent)

Qasim19842-Jun-09 1:57

Qasim1984

2-Jun-09 1:57

HI

I have three tables

1. Categorys (ID, Name)
2. Definitions (ID, Name, CategoryID)
3. Versions( ID, Name, DefinitionID)

I have generated three objects using EDM
1 Cagegorys
Navigation (Definition)
2. Definitions
Navigation (Category, Version)
3. Versions
Navigation (Definition)

I have following problems

1. I want to update the category of a version
2. I want to get all version against a specific Category

I need Code in C#.Net or VB.Net

Re: How I can update Child Table using Entity Framework (ugent)

Ennis Ray Lynch, Jr.2-Jun-09 2:00

Ennis Ray Lynch, Jr.

2-Jun-09 2:00

I need a Ferrari. It can be red or yellow.

Need custom software developed? I do C# development and consulting all over the United States.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane

Re: How I can update Child Table using Entity Framework (ugent)

musefan2-Jun-09 2:27

musefan

2-Jun-09 2:27

Unlucky, I have a blue one I'm trying to give away Laugh | :laugh:

Life goes very fast. Tomorrow, today is already yesterday.

Re: How I can update Child Table using Entity Framework (ugent)

Pete O'Hanlon2-Jun-09 2:29

Pete O'Hanlon

2-Jun-09 2:29

musefan wrote:
Unlucky, I have a blue one I'm trying to give away

I'm not so fussy. I'll take it.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: How I can update Child Table using Entity Framework (ugent)

musefan2-Jun-09 2:36

musefan

2-Jun-09 2:36

Sorry... just my dreams speaking out loud again

Life goes very fast. Tomorrow, today is already yesterday.

Re: How I can update Child Table using Entity Framework (ugent)

Pete O'Hanlon2-Jun-09 2:17

Pete O'Hanlon

2-Jun-09 2:17

Member 3374813 wrote:
I need Code in C#.Net or VB.Net

Two things:

1. There isn't such a thing as C#.NET - it's C# and it targets the .NET framework.
2. I don't work for you, so why should I write code for you?

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: How I can update Child Table using Entity Framework (ugent)

Qasim19842-Jun-09 2:21

Qasim1984

2-Jun-09 2:21

Please do not joke. I need it urgent

Re: How I can update Child Table using Entity Framework (ugent)

Colin Angus Mackay2-Jun-09 2:24

Colin Angus Mackay

2-Jun-09 2:24

Member 3374813 wrote:
Please do not joke. I need it urgent

He isn't joking. If you want something you need to be polite. The word "urgent" is a sure way not to get help because it is rude and this is a voluntary forum. No one gets paid to post here. If you need help urgently then you can get paid for support that will answer your questions in a timely manner set out by the terms of service.

Man who stand on hill with mouth open wait long time for roast duck to drop in

Re: How I can update Child Table using Entity Framework (ugent)

Rajesh R Subramanian2-Jun-09 2:26

Rajesh R Subramanian

2-Jun-09 2:26

Member 3374813 wrote:
Please do not joke. I need it urgent

This site is not good for urgent queries. I'll recommend you rentacoder[^] for that!

It is a crappy thing, but it's life -^ Carlo Pallini

Re: How I can update Child Table using Entity Framework (ugent)

Pete O'Hanlon2-Jun-09 2:29

Pete O'Hanlon

2-Jun-09 2:29

It's no joke. I don't work for you, and presumably you won't be paying me, so why should I write your code for you? If your need is that great, consider hiring a codemonkey off rentacoder, and as far as the urgency goes, this doesn't even make it into my top 500 things to care about today list. It's only urgent to you - not me.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: How I can update Child Table using Entity Framework (ugent)

0x3c02-Jun-09 2:30

0x3c0

2-Jun-09 2:30

After an extensive research period I would recommend using SQL queries somewhere

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

Re: How I can update Child Table using Entity Framework (ugent)

Qasim19842-Jun-09 4:57

Qasim1984

2-Jun-09 4:57

Yes I need esql Query. I am new to Entity framework. I need Entity SQL or LINQ Sql query for my problem

Smile | :)

Re: How I can update Child Table using Entity Framework (ugent)

musefan2-Jun-09 2:34

musefan

2-Jun-09 2:34

Member 3374813 wrote:
I have three tables

So do I...

1. Coffee Table
2. Dinner Table
3. Bed-side Table

Member 3374813 wrote:
I have following problems

My problem is singular...

1. You

Your problem is...

1. You are trying to do something you are incapable of doing (programming that is)

Life goes very fast. Tomorrow, today is already yesterday.

Re: How I can update Child Table using Entity Framework (ugent)

EliottA2-Jun-09 2:51

EliottA

2-Jun-09 2:51

musefan wrote:
3. Bed-side Table

Do you mean night table

Check out the CodeProject forum Guidelines[^]

Re: How I can update Child Table using Entity Framework (ugent)

musefan2-Jun-09 2:54

musefan

2-Jun-09 2:54

I mean a table you put at the side of your bed - Call it what you will Wink | ;)

Life goes very fast. Tomorrow, today is already yesterday.

Re: How I can update Child Table using Entity Framework (ugent)

Henry Minute2-Jun-09 3:48

Henry Minute

2-Jun-09 3:48

musefan wrote:
I mean a table you put at the side of your bed - Call it what you will

Well why didn't you say so.

A Call it what you will Table.

Using the correct names for Controls/Classes, can make the difference between getting an answer and getting the bird!!

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Filter BindingSource to show only datarows containing errors

MarkB1232-Jun-09 1:19

MarkB123

2-Jun-09 1:19

Can anyone give advice on how to do this?

I am using a DeveloperExpress Grid linked to a BindingSource.

I import data into the bindingsource from a flat file then perform various checks to ensure the data is valid. If not, I set a column error for the row - as follows...

if (view.GetRowCellValue(intRow, "intX") == null || Convert.ToDouble(view.GetRowCellValue(intRow, "intX")) == (double)0.00)
{
dr.SetColumnError("intX", String.Format("{0}: Missing value.", view.Columns["intX"].Caption));
}

I have a button on the form to allow the user to filter the grid so that the grid will hide all valid rows to allow them to concentrate on fixing the invalid rows.
Can someone tell me how to apply a filter to the binding source to only show those rows with one or more column errors?

Many Thanks

Re: Filter BindingSource to show only datarows containing errors

Henry Minute2-Jun-09 1:50

Henry Minute

2-Jun-09 1:50

Something like:

bindingSource1.Filter = "intX == null || intX == 0.00";

Re: Filter BindingSource to show only datarows containing errors

MarkB1232-Jun-09 2:17

MarkB123

2-Jun-09 2:17

Henry, Thanks for the reply.
I realise I can do that - the problem I have is that there is far more to the error checking than the small snippet I posted and it will not be feasible to do it this way. I could put in a dummy column and set the value to 1 within my error checking code on finding an error and filter on the dummy column = 1. However, I was hoping there was some way I could get a collection of the rows containing an error and use that to filter eg = extract all the ids of the rows with one or more errors into an array then convert that into a filter string... ID = id1 or ID = ID2...

Re: Filter BindingSource to show only datarows containing errors

Henry Minute2-Jun-09 3:52

Henry Minute

2-Jun-09 3:52

Well in a .NET DataGridView you could iterate over the DataGridRowCollection and do that. I would assume the DevExpress version has the same functionality. Whether that is practical depends on the number of rows involved, from a time point of view.

Re: Filter BindingSource to show only datarows containing errors

MarkB1232-Jun-09 4:18

MarkB123

2-Jun-09 4:18

Hi Henry - that's the approach I've now gone for...

string strFilterString = "";
sp00134BindingSource.Filter = ""; // Clear any Prior Filter //
foreach (DataRow dr in this.dataSet_AT.sp00134.Rows)
{
if (dr.HasErrors) strFilterString += " or ID = '" + dr["ID"].ToString() + "'" ?? String.Empty;
}
if (strFilterString.Length > 4) strFilterString = strFilterString.Remove(0, 4); // Remove initial " or " clause //
if (strFilterString == String.Empty) return;
try
{
sp00134BindingSource.Filter = strFilterString;
}
catch (Exception Ex)
{ .....

Thanks for the pointer. Smile | :)

DataGridView row side by side [modified]

mjelten2-Jun-09 1:06

mjelten

2-Jun-09 1:06

Hi!

i am adding rows to a datagridView with two columns, all my rows will be displayed as a long list, instead I want it to for example when ten rows has been added I want the next row to be inserted side by side to the first one.

Thanks,

Mjelten

Edit:
to make it clearer:

1---------------- 10---------------------
2---------------- 11---------------------
3---------------- 12---------------------

this is the structure..

modified on Tuesday, June 2, 2009 8:25 AM

Re: DataGridView row side by side

The NULL Developer2-Jun-09 1:45

The NULL Developer

2-Jun-09 1:45

Add a new column after adding every 10 rows.

"Do first things first, and second things not at all."
— Peter Drucker.

Re: DataGridView row side by side

mjelten2-Jun-09 2:01

mjelten

2-Jun-09 2:01

that doesent work, beacuse I have tagged every row, with a variable..

Last Visit: 31-Dec-99 18:00 Last Update: 24-Apr-24 19:03

Refresh

ᐊ Prev 1...4955 4956 4957 495849594960 4961 4962 4963 4964 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.