Related value in Datagridviewcolumn - .NET (Core and Framework) Discussion Boards

Re: How would one go about doing this? (Code Coverage)

Jimmanuel23-Jul-09 17:43

23-Jul-09 17:43

Easier than tampering with the IL is tampering with the source code. I used to do formal unit testing and I don't know if it's a formal term or not but we called it "instrumenting a file" and it's a bit of tedium that automated processes are made for. The trick is to modify the source without actually changing the control flow of the code. Take the following function:

private void MyMethod()
{
    int x = SomeFunction();
    int y = SomeOtherFunction();

    if (x > y)
    {
        // do something
    }
    else
    {
        // do something else
    }
}

There are 5 bits of code you need to ensure are executed, so for each place insert a boolean:

static bool flag1 = false;
static bool flag2 = false;
static bool flag3 = false;
static bool flag4 = false;
static bool flag5 = false;

private void MyMethod()
{
    flag1 = true; // verify that the method even gets called

    int x = SomeFunction();

    flag2 = true; // if SomeFunction() throws an unhandled exception this won't be executed

    int y = SomeOtherFunction();

    flag3 = true; // same thing with SomeOtherFunction()

    if (x > y)
    {
        flag4 = true; // verify the true case
        // do something
    }
    else
    {
        flag5 = true; // verify the false case
        // do something else
    }
}

Then you can run your test cases and check the value of your bools to make sure that all of your code was executed. Note that the control flow of the code hasn't changed, we've just added stuff to verify that all bits are executed. The difficulty comes in when you start taking into account the endless variations of source code. For example:

private void MyMethod()
{
    int x = SomeFunction();
    int y = SomeOtherFunction();

    if (x > y)
    {
        // do something
    }
}

looks easier, but you still need to insert the else to the if when you instrument that method to prove that the if statement can be failed. If the if can't be failed then it's unnecessary (dead code) and shouldn't be there.

The biggest PITA to instrument (and test) is full MCDC coverage (google it). Take the following sample:

private void MyMethod(bool a, bool b)
{
    if (a || b)
    {
        // do something
    }
}

There's a multi-conditional if statement there, and you need to prove that both conditions are necessary. Why? Well, suppose hypothetically that a is always true. Then the statement will always evaluate to true and there's no point in checking either a or b. The same thing happens if b is always true, so you need to instrument that in such a way to prove that both a and b can be false independently of each other. To verify full coverage that one statement turns into something like this:

static bool flag1 = false;
static bool flag2 = false;
static bool flag3 = false;
static bool flag4 = false;

private void MyMethod(bool a, bool b)
{
    flag1 = true;

    if (a && !b)
    {
        flag2 = true;
        // do something
    }
    else
    {
        // a is definitely false 
        if (b)
        {
            flag3 = true;
            // do something
        }
        else
        {
            flag4 = true;
            // don't forget the implicit else
        }
    }
}

and that 's just a simple multi-conditioned statement! Try figuring out how to break this down:

if (a || ((b && c) || d) || (x > 2))
{
    // we're all guilty of this at least once :)
}

Hopefully you either don't care about such things or you can afford to buy a tool to do this for you. Trust me, it will drive you crazy.

Badger | [badger,badger,badger,badger...]

Re: How would one go about doing this? (Code Coverage)

Curtis Schlak.23-Jul-09 18:10

Curtis Schlak.

23-Jul-09 18:10

The .NET Framework has a profiling API available for just such a thing. Here's a nice introductory article.[^].

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Re: How would one go about doing this? (Code Coverage)

S. Senthil Kumar24-Jul-09 5:35

S. Senthil Kumar

24-Jul-09 5:35

The CLR profiler allows you to rewrite IL at JIT time. That would be one place to put instrumentation code to track what code is getting executed.

Regards
Senthil
_____________________________
My Home Page |My Blog | My Articles | My Flickr | WinMacro

OnDeserialized/OnDeserializing not firing

RichardM123-Jul-09 5:59

RichardM1

23-Jul-09 5:59

I have a set of objects that I want to do some processing on prior to serializing and after deserializing,using wcf for coms.
The code is included below. I understand that I should change OnDeserializing to OnDeserialized, and have, but neither get called.
If I put a break in the OnSerializing method, the debugger stops there. If I put a break in the OnDeserializing method, the debugger never stops there. It is also clear from the errors I am getting that the re-hydration has not happened.
I am following the same pattern for both the pre and post calls. The compiler is happy with them, and they look like they match the patterns in the online doc.
Any ideas? This is also posted on MSDN with no help forthcoming.
hury Plz snd code and dollars
TIA

[OnSerializing ()]
internal void OnSerializingMethod(StreamingContext context)
{
    long temp = 0;
    if (context.State != StreamingContextStates .Clone)
    {
        Dehydrate (null , ref temp);
    }
}

[OnDeserializing ()]
internal void OnDeserializingMethod(StreamingContext context)
{
    if (context.State != StreamingContextStates .Clone)
    {
        Rehydrate (0);
    }
}

Silver member by constant and unflinching longevity.

Re: OnDeserialized/OnDeserializing not firing

Vova Gaevoy15-Jul-10 4:33

Vova Gaevoy

15-Jul-10 4:33

Because of WCF generate proxy for DataContract with [System.Diagnostics.DebuggerStepThroughAttribute()].

SCSF Smart Client application takes time to load

Sakshi Smriti23-Jul-09 2:02

Sakshi Smriti

23-Jul-09 2:02

Hi,

I have developed a smart client desktop application using SCSF.

It has an MDI and MDI child forms opens over it(It is similar to windows menu based application using MDI) .

The problem is that the MDI child forms (i.e. the views) take a few seconds to open and load.

Is there any way of minimising the time it takes.

The forms are having simple text boxes and labels and grids(which has two columns and is not populated during load)

I call a webservice at form load and have tried to comment the service call; Even then it takes the same time so I have ruled out the possibility of service delay.

Nothing else is done at the form load except the form is rendered

All MDI child forms(views) are taking the same time.

The application is stand alone not run remotely or checks for any updates on any server.

I dont have knowledge of SCSF internals, and how SCSF does all the handling of smart parts etc.
May be it might be tuned up to load the views faster or there is some way to make the CAB work faster which I am unaware of.

Could not find the forum related to SCSF so posting it here, please suggest in case you have knowledge of SCSF message board in code project.

Thanks in advance.

Sakshi

Re: SCSF Smart Client application takes time to load

Ian McCaul23-Jul-09 8:23

Ian McCaul

23-Jul-09 8:23

SCSF uses reflection very heavily. Because of this reason performance is hit when trying to do what would seem the simplest of things. It is a very heavy framework and unless you really need it and are concerned about performance I would suggest an alternative.

Related value in Datagridviewcolumn

Sergiev23-Jul-09 1:37

Sergiev

23-Jul-09 1:37

Dear all, upon developing data entry project I've faced a problem and I still can't figure out the solution.

Simplifying the matter, lets say that the the user enters the ID value and should get the decription in another column (DataGridViewTextbox) in the same datagridview. The description column should get updated immediately after the value of the ID column is changed.

The scenario is very close to classical master/detail form except that the detail should be displayed into the same control.

I had particullar success when bound the datagridview control to dataset relation, but the form didn't work well when inserting new rows.

Can you provide me with brief advice or a link?

Kind regards,

Re: Related value in Datagridviewcolumn

amit k mistry23-Jul-09 6:53

amit k mistry

23-Jul-09 6:53

I don't get exatly what would you like to explain but as per my understanding this may be helpful to you if it didn't works for you. Let me know I can help you out with other way.

http://www.progtalk.com/ViewArticle.aspx?ArticleID=54[^]

Re: Related value in Datagridviewcolumn

Sergiev23-Jul-09 10:04

Sergiev

23-Jul-09 10:04

Thank you very much for your reply!

I will take a look.

Anyway I will try to clarify myself by pseudo-code.

Consider DB with two tables:

table "payments" with the following structure:

"p_id" int,
"price" int,
"empl_id" int

and "employees":
"empl_id" int,
"empl_name" varchar /* this I want to get later */

It is not difficult to bind the DataGridView control to the "payments" table.

In the form I define the following columns (binding them to corresponding columns in data source):
datagridview.Columns("pay_id").DataPropertyName = "payments"."p_id"
datagridview.Columns("price").DataPropertyName = "payments"."price"
datagridview.Columns("empl_id").DataPropertyName = "payments"."empl_id"

And here is it, I want to have a column which displays the employee's name taking it from table "employees". Something like:

datagridview.Columns("empl_name").DataPropertyName = "employees"."empl_name"

This column should refresh every time the user changes the value of datagridview.Columns("empl_id") providing him with the name of the employee.

But there is no way (at least I don't know how) to define another data source for DataGridViewTextBox column. May be I need to populate manually the cell with the employee's name fetching it from dataset relation.

Previously I hadn't used .NET for data entry forms which is my primary fields so I am not very certain about its classes and their properties.

Thanks and regards,

Re: Related value in Datagridviewcolumn

Infarkt25-Jul-09 15:29

Infarkt

25-Jul-09 15:29

you can use DataGridViewComboBox column instead of DataGridViewTextBoxColumn to show employee's name.
Example:
datagridview.Columns("empl_name").DisplayMember="empl_name"
datagridview.Columns("empl_name").ValueMember ="empl_id"
datagridview.Columns("empl_name").DataSource ="employees"
datagridview.Columns("empl_name").DataPropertyName="payments"."p_id"
datagridview.Columns("empl_name").DisplayStyle=Nothing

OleDbParameter and "IS NOT NULL"

:o:k:23-Jul-09 0:32

:o:k:

23-Jul-09 0:32

Hi,

how to pass a "IS NOT NULL" to an OleDbParameter?

I know how to do "IS NULL":
parameter = new OleDbParameter(myField, Convert.DBNull);

Any Help would be great...

Thank's
Blush | :O

:k:

Re: OleDbParameter and "IS NOT NULL"

:o:k:24-Jul-09 3:02

:o:k:

24-Jul-09 3:02

No idea for this issue?

Re: OleDbParameter and "IS NOT NULL"

Jack Vanderhorst25-Jul-09 4:20

Jack Vanderhorst

25-Jul-09 4:20

You can pass in an actual Null value for the parameter using your code, but this doesn't mean you're passing "IS NULL" or "IS NOT NULL". These aren't values, they're conditions, presumably your stored procedure or query would then use IS NULL or IS NOT NULL to check whether or not the value you passed in was or was not a Null.

about ajax

sapna sangole22-Jul-09 20:59

sapna sangole

22-Jul-09 20:59

How do .net framework relates to ajax technology.

Re: about ajax

Pete O'Hanlon22-Jul-09 22:03

Pete O'Hanlon

22-Jul-09 22:03

sapna sangole wrote:
How do .net framework relates to ajax technology.

They are both code.

Please clarify what you are asking - are you asking how do you implement AJAX in the .NET framework, or are you asking what AJAX is, and how it differs from the .NET framework?

"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: about ajax

Baran M22-Jul-09 22:47

Baran M

22-Jul-09 22:47

You can use AJAX with .Net framework in 2 ways

1. Use asynchronous Javascript method call to find server function and write everything by you only by you.
2. Or Install free Microsoft AJAX Framework and take advantage of AJAX Control Toolkit.

Education is not a way to escape poverty — it is a way of fighting it.

Registry Manipulation - Odd behaviour

Tristan Rhodes22-Jul-09 6:31

Tristan Rhodes

22-Jul-09 6:31

Hi Guys,

I've got a little wrapper class that exposes some registry properties in my code. This works and passes the unit test for writing and reading the value and comparing the result. However, when i look in the registry, there's no section for the values i am manipulating.

public static void SetGroupRegInfo(string group, string key, string value)
{
    RegistryKey rkApp = Registry.LocalMachine.CreateSubKey(
                REGISTRY_MICA_GROUPS + "\\" + group,
                RegistryKeyPermissionCheck.ReadWriteSubTree);

    try
    {
        rkApp.SetValue(key, value);
    }
    finally
    {
        rkApp.Close();
    }
}

public static string GetGroupRegInfo(string group, string key)
{
    RegistryKey rkApp = Registry.LocalMachine.OpenSubKey(
                            REGISTRY_MICA_GROUPS + "\\" + group,
                            RegistryKeyPermissionCheck.ReadSubTree,
                            RegistryRights.QueryValues);

    if (rkApp == null)
        return null;

    try
    {
        return (string)rkApp.GetValue(key);
    }
    finally
    {
        rkApp.Close();
    }
}

The base registry entries are created correctly by the application installer, but these values just don't seem to appear.

Any thoughts?

Regards

Tris

-------------------------------

Carrier Bags - 21st Century Tumbleweed.

Re: Registry Manipulation - Odd behaviour

led mike22-Jul-09 6:54

led mike

22-Jul-09 6:54

I find your post confusing. You say the Unit Tests pass but we have no idea what is being tested. You say "it works" but the value is not in the registry so I have no idea what "it works" means because to me if the value is not written to the registry then I would say it is NOT working.

Re: Registry Manipulation - Odd behaviour

Luc Pattyn22-Jul-09 7:11

Luc Pattyn

22-Jul-09 7:11

can't stay away for more than 8 minutes, can you? Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Registry Manipulation - Odd behaviour

led mike22-Jul-09 7:19

led mike

22-Jul-09 7:19

Luc Pattyn wrote:
can't stay away for more than 8 minutes, can you?

Hey Luc,

See here[^]

and here[^]

So long dude. Beer | [beer]

Re: Registry Manipulation - Odd behaviour

Luc Pattyn22-Jul-09 7:23

Luc Pattyn

22-Jul-09 7:23

Exactly, that[^] and your above message are 8 minutes apart.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Registry Manipulation - Odd behaviour

led mike22-Jul-09 7:26

led mike

22-Jul-09 7:26

Luc Pattyn wrote:
and your above message are 8 minutes apart.

That time is the original post, I modified it twice, see where I say "I just changed my mind". Wink | ;)

Re: Registry Manipulation - Odd behaviour

Luc Pattyn22-Jul-09 7:52

Luc Pattyn

22-Jul-09 7:52

I see. I never mind the "modified at..." message that gets added automatically, it uses Bujumbura local time or something similar, doesn't tell me much.

In the mean time, you're still here. Which is great.

BTW: if and when the new be-really-kind rules would really cripple you, you can always put a leaded answer in one of the soapboxes/back rooms, and just reply with a link to it. Big Grin | :-D

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Registry Manipulation - Odd behaviour

Tristan Rhodes22-Jul-09 23:04

Tristan Rhodes

22-Jul-09 23:04

Well, "it works" would mean that the unit test does the following:
* Write a value to the registry via the wrapper
* Read a value from the registry via the wrapper
* Assert that the value read is equal to the value written

So the fact that these values don't appear in the registry confuses me too and I'm inclined to agree that it appears to be not working, hence i posted here. :P

-------------------------------

Carrier Bags - 21st Century Tumbleweed.

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