C# Discussion Boards - CodeProject

Office 2016-Like Help for .NET application

2-Aug-16 2:22

its done thank u all

Jassim Rahma1-Aug-16 11:18

Jassim Rahma

1-Aug-16 11:18

Hi,

How does the Office 2016-Like Help works? How can I add a similar to my C# application?

Thanks,
Jassim[^]

Technology News @ www.JassimRahma.com

How to Insert/update/delete records in multiple Databases tables in one transaction using C#

Tej_dev1-Aug-16 8:44

Tej_dev

1-Aug-16 8:44

Hi All,
I am designing one web based application to add user primary information. My objective is in one Submit button action , the entered information need to save to 35 databases at one time.
I am using IBM DB2 databases.

Every database having 2 tables those are going to affect for this insert , update and delete event from UI.

I am planning to iterate through database list and planning to insert record at one time to one database and then next database inline. Will it be good approach as per performance?

can anyone please have any suggestion on my approach?
please advice.

Thanks

modified 1-Aug-16 14:55pm.

Re: How to Insert/update/delete records in multiple Databases tables in one transaction using C#

Eddy Vluggen1-Aug-16 10:17

Eddy Vluggen

1-Aug-16 10:17

Tejendrasing wrote:
can anyone please have any suggestion on my approach?

..do you know the decorator-pattern?

Act as if you are programming against a single connection (program against the IDb-interface); inherit your own connection-object and IDbCommand, and implement the distribution there against the list of actual connections.

Should work, and could be executing the commands async for all sources, and report back any exceptions

If you can do it once, you can do it in a loop. No need for fancy stuff.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: How to Insert/update/delete records in multiple Databases tables in one transaction using C#

Mycroft Holmes1-Aug-16 12:50

Mycroft Holmes

1-Aug-16 12:50

Tejendrasing wrote:
the entered information need to save to 35 databases at one time

WTF sort of design is that. You are working with one weird data design if user details are replicated/scattered across 35 databases. I would seriously look into a redesign of your data structure.

You still need to make a connection to each database from your DAL unless you do some fancy work with linked databases and replication at the database level. Or possibly a single stored proc that updates the 35 (unbelievable) databases.

Never underestimate the power of human stupidity
RAH

Request for advice: 3D realistic scene interface

Jayme651-Aug-16 6:22

Jayme65

1-Aug-16 6:22

Hi,

I would like your enlightened advice on this matter:
For my next application I have to setup an interface in 3D.
The interface will be an office with a desktop and some usual items like pens, papers, telephone, lamp, etc...
There won't be complex animation, just slight rotation around the desktop BUT...the scene has to be rendered in a very realistic way, offering a 'global illumination' (like?) quality display! (realistic light effects and shadows)

How should I realize this? Will I have to use a 3D game engine? If so, which one would you advice me to use?

My question is not on the content of the scene (a 3D graphic artist will manage this) but on how to achieve a realtime high quality render of the scene!

Thank you very much!

Re: Request for advice: 3D realistic scene interface

Richard Deeming1-Aug-16 6:44

Richard Deeming

1-Aug-16 6:44

Jayme65 wrote:
The interface will be an office with a desktop and some usual items like pens, papers, telephone, lamp, etc...

Sounds like you're reinventing Microsoft Bob[^]. Laugh | :laugh:

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Request for advice: 3D realistic scene interface

Richard MacCutchan1-Aug-16 22:07

Richard MacCutchan

1-Aug-16 22:07

This is a question for Google: there are many papers, tutorials and samples to be found.

How to save combobox values in forms

Member 1265992631-Jul-16 20:46

31-Jul-16 20:46

I have two forms form1 and form2.in form1 I have a button that opens form2.in form2 I have a combobox and button.on clicking a button in form1,form2 will be displayed,then in form 2 I will add items to comboxbox by clicking a button present in form2.on closing the form2,the values added by clicking the button disappears,so help me to come out of it.i don't want to use databases.i just want that values be binded until the close of main form Form1.
Form1.cs

private button1_click(object o,EventArgs e)
{
Form2 F2 = new Form2;
F2.Show();
}

Form2.cs
int i=0;
private void button1_Click(object sender, EventArgs e)
{
i = i + 1;

comboBox1.SelectedIndex = comboBox1.Items.Add("Message" + i);

}
help me with proper examples
The scope of saving,means values on combox box must be remained until the close of Form1.

modified 1-Aug-16 3:12am.

Richard MacCutchan31-Jul-16 21:23

Richard MacCutchan

31-Jul-16 21:23

You need to save the values somewhere so that Form2 can read them every time it starts, and save any changes when it closes. This has already been explained in your recent QA post at How do I save the values entered on the text box, list boxes in the forms[^].

OriginalGriff31-Jul-16 21:27

OriginalGriff

31-Jul-16 21:27

Since you are using Show it's a little complicated.
What you need to do is get the selection back from Form2 to Form1 and then "re-use it" next time you need Form2. That's pretty simple in theory: just write a property in Form2 which gets and sets teh information:

public int SelectedIndex
    {
    get { return comboBox1.SelectedIndex; }
    set { comboBox1.SelectedIndex = value; }
    }

And if you use ShowDialog to display Form2, it's easy:

private int index = 0;
private void button1_click(object o,EventArgs e)
    {
    Form2 F2 = new Form2();
    F2.SelectedIndex = index;
    F2.ShowDialog();
    index = F2.SelectedIndex;
    }

Or better:

private int index = 0;
private void button1_click(object o,EventArgs e)
    {
    Form2 F2 = new Form2();
    F2.SelectedIndex = index;
    if (F2.ShowDialog() == DialogResult.OK)
        {
        index = F2.SelectedIndex;
        }
    }

But with Show it's more complicated. What you need to do then is handle the FormClosed event:

private int index = 0;
private Form2 F2;
private void button2_Click(object o, EventArgs e)
    {
    F2 = new Form2();
    F2.SelectedIndex = index;
    F2.FormClosed += F2_FormClosed;
    F2.Show();
    }
private void F2_FormClosed(object sender, FormClosedEventArgs e)
    {
    index = F2.SelectedIndex;
    }

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Member 126599261-Aug-16 19:00

1-Aug-16 19:00

sorry,it hasn't helped me.any other solutions

Pete O'Hanlon1-Aug-16 20:18

1-Aug-16 20:18

As we can't see any of your code, we can't see whether or not you implemented this properly. Given OG's experience as a developer, I would expect that the problem is you haven't implemented what he told you properly.

This space for rent

Member 126599261-Aug-16 20:31

1-Aug-16 20:31

hi Pete O'Hanlon,
can u provide me any working example

Pete O'Hanlon1-Aug-16 20:35

1-Aug-16 20:35

OG already has provided you with the solution. You just need to plug it into your forms. Anything I put would just be duplicating his answer.

This space for rent

Member 126599261-Aug-16 22:38

1-Aug-16 22:38

here is the code that I have tried
Form1 has a single button.
Form1.cs
private int index = 0;
private void button1_Click(object sender, EventArgs e)
{

Form2 F2 = new Form2();
F2.SelectedIndex = index;
F2.ShowDialog();
index = F2.SelectedIndex;
}

Form2 has a combobox and a button
Form2.cs

int i = 0;
private void button1_Click(object sender, EventArgs e)
{
i = i + 1;
comboBox1.Items.Add("Message" + i);
}

public int SelectedIndex
{
get { return comboBox1.SelectedIndex; }
set { comboBox1.SelectedIndex = value; }
}

aboveis the code.on running the above.i clicked the button on form1 it opens form2.in form2 on cliking the button I have added items to form1.then I close the form2 and reopen it from form1 button.then also no item will be present in combobox on form2.
please let me know where I did wrong.

Pete O'Hanlon1-Aug-16 23:36

1-Aug-16 23:36

You have missed out the code to re-add items into the combo box when you show the dialog again. I also don't see you returning these added items from Form2 back to Form1 to be re-added back in.

This space for rent

Member 126599261-Aug-16 23:39

1-Aug-16 23:39

how to do that,

Pete O'Hanlon1-Aug-16 23:53

1-Aug-16 23:53

In a similar way that you got the selected index. Put a couple of methods in Form2 - the first to retrieve the list of combo items and the second to set the list. In the second method, populate the combo box - call this before you call ShowDialog. It's not that hard, so I leave it to you to complete.

This space for rent

Member 126599262-Aug-16 1:13