Database problem - C# Discussion Boards

cignox117-Sep-07 21:12

17-Sep-07 21:12

Hi all, I am having problems adding controls to invisible panels. Making the long story short, if the panel has its property Visible set to false when I add the controls, they inherit that value. The problem is that when I set the panel to visible, those children are not shown and their property is still set to false.
Is this the correct behaviour, or am I doing something wrong? I will provide more details if needed.
Thank you,
Alessandro

Re: adding controls to an invisible control

Luc Pattyn17-Sep-07 23:03

Luc Pattyn

17-Sep-07 23:03

cignox1 wrote:
I will provide more details if needed

yes

Luc Pattyn [Forum Guidelines] [My Articles]

this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google

Re: adding controls to an invisible control

cignox117-Sep-07 23:36

cignox1

17-Sep-07 23:36

Well, which kind of informations dou you need?
Something more:
I have a usercontrol that contains two panels. One of them is a tablelayoutpanel that contains dozens othe customcontrols. If I add these controls to the usercontrol when this is invisible, then they are also invisible. My problem is that when I put the usercontrol back to visible again, the two panels are displayed, but those controls are not. The only way I've found to make them visible is with the usercontrol visible, wich is not always desiderable in our project (it sould switch from visible to invisible on demand, without affecting the creation of the contained items).

I hope that this makes my problem easier to solve.
Thank you

Re: adding controls to an invisible control

Luc Pattyn17-Sep-07 23:50

Luc Pattyn

17-Sep-07 23:50

Hi,

AFAIK Controls added to a Container don't inherit its Visible state, but the invisible
Container just does not invoke their Paint handlers.
If your UserControl behaves differently, then something in its code must do that;
Controls added to it should not copy its Visible property. I would call it a bug in the
UserControl, so that is where it must be fixed.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Re: adding controls to an invisible control

Big Daddy Farang18-Sep-07 7:37

Big Daddy Farang

18-Sep-07 7:37

Hello,

When you change the control to visible, maybe also get it to repaint itself.

control1.Visible = true;    // show it
control1.Invalidate();      // repaint it

Probably you've already tried that. Oh well, just a thought.

BDF

Re: adding controls to an invisible control

cignox118-Sep-07 20:37

cignox1

18-Sep-07 20:37

Thank you, but I've already tried that. My problem is that when I add the controls to my panel when this is not visible, all the controls (wich are complex and thus formed by many controls) are created with Visible = false. This prevents them to be shown when I put the parent panel to visible.

Re: adding controls to an invisible control

Big Daddy Farang19-Sep-07 7:28

Big Daddy Farang

19-Sep-07 7:28

cignox1 wrote:
created with Visible = false

Aha! That's interesting. Not what I (nor Luc) would have expected. Since you are a few time zone ahead of me, you may have tried this already, too, but here goes.

My assumptions:
System.Windows.Forms.Panel tablelayoutpanel;
Your custom controls derive from System.Windows.Forms.UserControl
Either you or the designer do something like
tablelayoutpanel.Controls.Add(this.customControl2);

You could iterate the custom controls making them visible:

tablelayoutpanel.Visible = true;
foreach (Control c in tablelayoutpanel.Controls)
{
  c.Visible = true;
}

BDF

Database problem

Nishad8517-Sep-07 20:45

Nishad85

17-Sep-07 20:45

Hi I have 3 columns in my table. They are Yes\No filelds. If the row is Yes i want to take the header name of the column.in the below example if morning is yes i want to take Morning in datagrid

eg: if
Morning Evening Afternoon
Yes No YES
Yes Yes No
No Yes Yes

in the above example in first row Morning and Afternoon is True.
I want to retieve this to a Datagrid column Named Session.. i want to retrieve the above data to Session column
. in the case of first row i want to show like this in datagrid column
Session
Morning, Evening

Please help me to write Query and code

Re: Database problem

Paul Conrad23-Sep-07 6:44

Paul Conrad

23-Sep-07 6:44

You might want to rephrase what you are trying to accomplish.

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

RichTextBox

mihksoft17-Sep-07 20:22

mihksoft

17-Sep-07 20:22

Hy
I have a RichTextBox and I typing words separated with SPACE. I want to set different color for each word typed. Can anybody tell me how can I do that or give me an short example.

Thanks

Re: RichTextBox

wienzzz17-Sep-07 22:27

wienzzz

17-Sep-07 22:27

Hai mihk, I'm working on similar application also.

In my opinion, you can do that on 2 ways.
1. scan through the first char loop until end, when you find "SPACE" / "32" in ASCII, you just put a little code of RTF Formatting. well, let's just say like this.

<br />
StringResult = "";<br />
//this is the header for RTF-format<br />
StringResult = {\rtf\ansi {\colortbl; \red0\green0\blue255;\red255\green0\blue0;}; <br />
//2 color, Blue and Red<br />
bool toggle = false;<br />
for(int i=0; i < YourString.GetLength(0); i++)<br />
{<br />
    if(toggle)<br />
    {<br />
        StringResult = StringResult + @"\cf1";<br />
    }<br />
    else<br />
        StringResult = StringResult + @"\cf2";<br />
<br />
    StringResult = StringResult + YourString[i];<br />
<br />
    if(YourString[i] == (char)32)<br />
    {<br />
    //toggle the boolean <br />
       if(toggle) toggle = false;<br />
       else toggle = true;<br />
    }<br />
}<br />

you may search more about RTF formatting on microsoft web site.

2. you can just use the method RTB.Selection to change the font, forecolor, backcolor, etc. find more info about this on MSDN help.

CMIIW

How Yahoo messenger photo sharing works

Lilupa17-Sep-07 20:20

Lilupa

17-Sep-07 20:20

I want to know how Yahoo messenger photo sharing works. Is it using byte streaming by using a web service? I want to develop that kind of application using C# or C++. So please help me to find some articles or sample source codes.

Regards,
Lilupa Karunarathne.

Getting a variant containing safe array of Double Values from MFC ActiveX in C#?

ss43117-Sep-07 20:11

ss431

17-Sep-07 20:11

Hi All,

I have a MFC ActiveX control which has a method which returns a variant which
contains a safe array of double values .

void Calculate(double value,VARIANT *Result);

"Result" variable is of "Out" type.
When i'm trying to access this function from C# i'm by passing variable of type "Object" i'm getting RunTime Exception as follows

"An unhandled exception of ype 'System.Runtime.InteropServices.COMException' occurred in mscorlib.dll
Additional information: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))"

Please Anyone help me to solve this problem
I can access this from VB 6 without any issues.

Thanks in Advance

Re: Getting a variant containing safe array of Double Values from MFC ActiveX in C#?

Nissim Salomon18-Sep-07 1:40

Nissim Salomon

18-Sep-07 1:40

Hi
Can you supply the IDL of the Interface that contain the method you are trying to invoke ???

Re: Getting a variant containing safe array of Double Values from MFC ActiveX in C#?

ss43118-Sep-07 19:30

ss431

18-Sep-07 19:30

Hi nissims

Thanks for your reply,
Below is the IDL for my MFC ActiveX Control

library MyActiveXLib
{
importlib(STDOLE_TLB);

// Primary dispatch interface for CMyActiveXCtrl

[ uuid(9117C567-1EAD-48B3-BA9E-C4D44852D181),
helpstring("Dispatch interface for MyActiveX Control")]
dispinterface _DMyActiveX
{
properties:

methods:

[id(1), helpstring("method AddDataPoint")] void AddDataPoint(LONG lngIdx, DOUBLE dblXVal, DOUBLE dblYVal);
[id(2), helpstring("method AddDataPoints")] void AddDataPoints( LONG lngNoOfPoints, VARIANT varXVals, VARIANT varYVals);

[id(3), helpstring("method GetData")] LONG Calculate( DOUBLE dblXVal, VARIANT* varResult);

};

// Event dispatch interface for CMyActiveXCtrl

[ uuid(07A82910-34BC-43C2-ADAE-A462286D4E10),
helpstring("Event interface for MyActiveX Control") ]

dispinterface _DMyActiveXEvents
{
properties:
// Event interface has no properties

methods:

};

// Class information for CMyActiveXCtrl

[ uuid(E98E4ED3-C038-4705-8EAB-43AD8A1B75AB),
helpstring("MyActiveX Control"), control ]

coclass MyActiveX
{
[default] dispinterface _DMyActiveX;
[default, source] dispinterface _DMyActiveXEvents;
};
};
"varResult" variable of "Calculate" method will return the SafeArray of Double values.
Please suggest me the solution to solve this problem

Thanks again

Re: Getting a variant containing safe array of Double Values from MFC ActiveX in C#?

Nissim Salomon20-Sep-07 13:54

Nissim Salomon

20-Sep-07 13:54

Hi Sorry about the delay, i just saw your answer now.
Are you passing an object argument that encapsulate a double array ???

For example: 
object result = new double[10];

Re: Getting a variant containing safe array of Double Values from MFC ActiveX in C#?

venkyhyd5-Oct-08 20:14

venkyhyd

5-Oct-08 20:14

any suggestions on the similar issue posted
http://www.codeproject.com/script/Forums/View.aspx?fid=1649&msg=2752382[^] Confused | :confused:

Where can call reports in layers "tier"

Rami Said Abd Alhalim17-Sep-07 19:57

Rami Said Abd Alhalim

17-Sep-07 19:57

i want add reports to my project, my project contain 3 layers (1- presentation layer 2-Business Logic layer 3-Data Access layer )

check to see if a specified file exist in a specified directory

pavya_Cool17-Sep-07 19:19

pavya_Cool

17-Sep-07 19:19

Hi to all,

I want to check the specified file exist in the specified directory or not....

how can i do this?

Pravin

Re: check to see if a specified file exist in a specified directory

Kuldeep Antil17-Sep-07 19:51

Kuldeep Antil

17-Sep-07 19:51

create the instance of FileInfo class

//FileInfo f;
initialze that in the following manner

//f = new FileInfo("something.txt");///mention the complete path

and then use this property to know whether this file exists or not

///if(f.Exists == false) /// means the file doesn't exist

ok

Re: check to see if a specified file exist in a specified directory

pavya_Cool17-Sep-07 19:54

pavya_Cool

17-Sep-07 19:54

Thanks Kuldeep

Pravin

Re: check to see if a specified file exist in a specified directory

Nissim Salomon17-Sep-07 20:18

Nissim Salomon

17-Sep-07 20:18

Hi
In order to check if a specific file exists
You can use the File.Exists static method , you can also use the
FileInfo.Exists property but for that you need to construct a FileInfo Object

Re: check to see if a specified file exist in a specified directory

pavya_Cool17-Sep-07 20:21

pavya_Cool

17-Sep-07 20:21

Thanks Nissims,

i have used here object.FileExists(filespec) method.

Pravin

Re: check to see if a specified file exist in a specified directory

ramdil20-Sep-07 1:10

ramdil

20-Sep-07 1:10

You can directly check the path using
if(System.IO.File.Exists(Path))

Regards
DilipRam

SQL Joins

iet200017-Sep-07 19:09

iet2000

17-Sep-07 19:09

Hi Everybody,
We have a problem in displaying the data combining two tables....

we have table1 where a primary key is set to field1 and another table table2 where a foreign key is set to field1 with the same name as it is in the table1.

we gave the query to the data adapter as
" SELECT field1,field2,field3 FROM table2,table1 WHERE table1.field1=table2.field1";

But all the table2 rows are displayed without satisfying the condition we gave in the sql query.

Please help us at the earliest.

Thanks and Regards,

Priya

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