Re: User32 SetFocus not working - any ideas? - C# Discussion Boards

populating data into a listbox (SLOW)

30-Aug-06 13:07

Hello

monrobot13 wrote:
Is it possible to use .ico files for the Image property of ToolbarItems, Buttons, etc?

Yes. In the designtime click on image property => Click import => emove the images filter => Choose in .ico file Smile | :)

monrobot13 wrote:
a good program I could use to convert .ico's to a bmp, jpg, etc?

You don't need any extra program to convert icons to bitmaps. use MyIcon.ToBitmap() method

Also you can add icons to your resources files directly.

Regards

Saamir30-Aug-06 11:26

Saamir

30-Aug-06 11:26

Hi guys;
I have 2 listboxes in my form that I am loading data into on load of the form. Here is the code for one of them:

public void populatelbBranches()
{
SqlConnection cnn=null;
SqlCommand cmd=null;
SqlDataReader reader=null;
try
{
cnn=new SqlConnection(m_ADBCnn);
cnn.Open();

string query="SELECT BrnId,Name FROM tblBRANCHES";
cmd = new SqlCommand(query, cnn);
reader = cmd.ExecuteReader();
if (reader != null)
{
while (reader.Read())
{
lbBranches.Items.Add(reader["BrnId"]+ " - " + reader["Name"]);
}
}
}
catch (Exception ex)
{
MessageBox.Show(this,ex.Message)
}

finally
{
reader.Close();
cmd=null;
lbBranches.SelectedIndex = 0;
if(cnn!=null && cnn.State !=ConnectionState.Closed)
{
cnn.Close();
}
cnn=null;
}

Is there any way I can make the reading/loading faster? it takes almost 2 minutes to populate 3500 records. It takes 2 seconds if I run the query in SQL Query Analyzer. Please Help!!!!

sasa

Re: populating data into a listbox (SLOW)

Nader Elshehabi30-Aug-06 12:04

Re: populating data into a listbox (SLOW)

30-Aug-06 12:04

Hello

As a small demo of the time cose of a try block:

long TicksA, TicksB;
TicksA = DateTime.Now.Ticks;
try
{
    int A = 0;
    while (A < 1000000000)
        A++;
}
catch { }
TicksA = DateTime.Now.Ticks - TicksA;

TicksB = DateTime.Now.Ticks;
int B = 0;
while (B < 1000000000)
    B++;
TicksB = DateTime.Now.Ticks - TicksB;
MessageBox.Show(TicksA.ToString() + "\n" + TicksB.ToString());

1- Your code will never be as fast as the QueryAnalyzer
2- Try removing the try and if blocks -Bad but fast-
3- As a last solution you might want to make multiple threads reading at multiple areas of your datatable -like download accelerators-
4- Make a thread to read and give it high priority -dangerous-

Regards

gus_br30-Aug-06 16:23

gus_br

30-Aug-06 16:23

It's very strange, speacially in only 3500 rows. Your code are pretty good.
As a sugestion, try to use a dataset to retrieve these values using a Data Adaptor to fill it. And then, set the datasource property of you list box. But i think this will not solve your problem, cause it's indirect access, and you have made simple access, which is faster.

good luck!

User32 SetFocus not working - any ideas?

wbjohnson30-Aug-06 11:24

wbjohnson

30-Aug-06 11:24

hey guys, ive wrote a little app that takes a given a IntPtr handle to a random application.... it when gets all childwindows and looks for the first EDIT (CEdit) class and then tries to set focus to it.. i know it seems pointless, but its part of a large plan! hehe

anyway, its just not working! im calling SetFocus(IntPtr) to the Edit class and its just ignore me! (ive even tried bringing the parent application to te front - that works btw)

any ideas why SetFocus isnt putting the cursor in the Edit class ready for user input?

Nader Elshehabi30-Aug-06 11:34

30-Aug-06 11:34

Hello

Quoted from MSDN:
If the hWnd parameter is invalid or the window is not attached to the calling thread's message queue, the return value is NULL. To get extended error information, call GetLastError.

Try to see the returned value, and GetLastError().

Also I suggest to SendMessage(WM_SETFOCUS) yourself, instead of calling SetFocu(hWnd).

Regards

wbjohnson30-Aug-06 11:59

wbjohnson

30-Aug-06 11:59

hi there,

when i use SetFocus(), it doesnt work and i get this last error message:
1008 An attempt was made to reference a token that does not exist. ERROR_NO_TOKEN

(i looked up the message on google)

however - if i do what u suggested it works Big Grin | :-D

do you know why this way works and the other one doesnt?

Nader Elshehabi30-Aug-06 12:12

30-Aug-06 12:12

Hello

I'm glad that it works now. Smile | :)

If you revise the qoute I posted from MSDN, you'd notice that SetFocus() function, sends the message to the current message queue. You are sending WM_SETFOCUS message to another application with another message queue. That's why you need to explicitly send the message yourself.

Regards

Get the exact data types from a sql table

wbjohnson30-Aug-06 12:15

wbjohnson

30-Aug-06 12:15

ahhhhh thats excellent!!

i understand it now!

thanks ever so much for your help this evening, its much appriciated!

Regards,
Will

Ista30-Aug-06 11:11

Ista

30-Aug-06 11:11

Is there a way I can extract the extact data type strings but sql via ADO.NET.

I need to know the exact name of the data type from sql.

I tried creating a data table and filling it, then examining the columns. But, only gives me a .net data type. For instance, smalldatetime is converted to DateTime.

I need to know what it is before the conversion.

thanks
nick

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

1 line of code equals many bugs. So don't write any!!

My mad coder blog

Re: Get the exact data types from a sql table

mikone30-Aug-06 11:43

mikone

30-Aug-06 11:43

you could try to perform a query which shows you the tables structure
( MySQL: desc Tablename; - Firebird: show table Tablename; ) and parse the
result in your programm. That way you would get the name of the datatypes used by your database.

Toolstrip redraw problem

srev30-Aug-06 10:49

srev

30-Aug-06 10:49

Hi guys,

I have a ToolStrip control that is not redrawing properly. It seems to not be receiving a paint message when it should (ie if I bring any other window in front of it, it doesn't redraw). This is the structure it sits in:

- SplitContainer
- TabControl
- TabPage
- ToolStripContainer
- ToolStrip

It also doesn't redraw consistently when I switch between TabPages. Has anyone come across this before?

Many thanks,

Simon

PS This problem is occurring in a Windows Forms application for the desktop.

Nader Elshehabi30-Aug-06 11:30

30-Aug-06 11:30

Hello

Yes. ToolStip control isn't supposed to redraw itself without having the focus- AFAIK-. This is normal.

Regards

srev30-Aug-06 23:16

srev

30-Aug-06 23:16

Hi Nader,

Thanks for your reply. However, it does seem a bit odd because when I drag a window in front of Outlook the toolstrips there redraw perfectly well. Is there an obvious technique I should be aware of for forcing a redraw?

Many thanks,

Simon

Nader Elshehabi31-Aug-06 1:30

31-Aug-06 1:30

Hello

It looks like I got your question all wrong!! Roll eyes | :rolleyes:

Now I get what you mean.

Why doesn't your ToolStrip draw itself?? Doesn't it fire paint events?

To demonstrate that, I made the same cascade that you did, then I added a ListBox, and then the following code for each paint event in the cascade:

private void toolStripButton1_Paint(object sender, PaintEventArgs e)
{
   listBox2.Items.Add("Button Paint");
}

private void toolStrip1_Paint(object sender, PaintEventArgs e)
{
   listBox2.Items.Add("ToolStrip Paint");
}

private void toolStripContainer1_ContentPanel_Paint(object sender, PaintEventArgs e)
{
   listBox2.Items.Add("Container Paint");
}

The listbox addes the item in the same order as the paint events should be fired. Al the Paint events are fired appropriately.

Try this demo in your code to see if the paint events are fired or not.

Regards

Multipage - pageview : Tabstrip

srev31-Aug-06 3:34

srev

31-Aug-06 3:34

Thanks for your time on this Nader. I was hoping someone would say "Oh, that's a common problem and you just need to set property x". I was trying to avoid a full on investigation as I'm on a schedule with this thing. However, I will use your code and start digging into the problem to find out what's going on.

Many thanks again,

Simon

shivarishxxxx30-Aug-06 10:16

shivarishxxxx

30-Aug-06 10:16

Am trying to dynamically build a tab, multipage and pageview

protected Microsoft.Web.UI.WebControls.TabStrip tc;
protected Microsoft.Web.UI.WebControls.MultiPage mp;
protected System.Web.UI.WebControls.Label txt;

Microsoft.Web.UI.WebControls.Tab tab=new Microsoft.Web.UI.WebControls.Tab();

Microsoft.Web.UI.WebControls.PageView pv= new Microsoft.Web.UI.WebControls.PageView();
//Am building a control here and adding it to pv

System.Web.UI.WebControls.TextBox txt= new TextBox();
txt.Text = "Microsoft";
pv.Controls.Add(txt);
pv.ID = id.ToString();
tab.TargetID = pv.ID;

Error: TargetID does not point to a valid PageView

the tab.TargetID has to be set to pv.(something).
can somebody help me on this?

rmr

rmr

Re: Multipage - pageview : Tabstrip

Nader Elshehabi30-Aug-06 11:26

Re: Multipage - pageview : Tabstrip

30-Aug-06 11:26

Hello

First do not repost your question in the same forum even if you didn't get any answer. It's very rude. Delete the previous thread.

Second, to get an answer to your question you need to post this in the ASP forum not here.

Regards

shivarishxxxx30-Aug-06 17:58

shivarishxxxx

30-Aug-06 17:58

Hello,

Its not that I dont know the basics of posting on forums, I needed to change the subject so that someone can help me out, I posted it again. Thanks for your advice and if you had helped me out, I would have told you double thanks.

rmr

Re: Multipage - pageview : Tabstrip

Nader Elshehabi31-Aug-06 1:55

How to wait for multiple STA threads to finish?

31-Aug-06 1:55

Hello

I'd have happily helped you if I were an expert in ASP. There is a difference between C# and ASP. All I were capable of doing is pointing you to the right direction. Smile | :)

Regards

SandeepN30-Aug-06 10:14

SandeepN

30-Aug-06 10:14

I create multiple STA threads and start them. Once I have started all the threads in my main thread I need to wait till all of them are done.
To wait I tried
WaitHandle.WaitAll() ----- returns exception

Tried
waitEvent.waitOne()
and thread.Join()
In above case some times my main thread slips through Join\waitOne(). (i.e. main thread does not wait till all other threads are done)

Please advice how to implement this?

My sample code is as below

Main()
{
...
...
ArrayList myThreadClass = new ArrayList(3);
ArrayList threads = new ArrayList(3);

for(int i = 0 ; i< 3;i++)
{
ThreadClass thClass = new ThreadClass();
myThreadClass.Add(thClass);
Thread myThread = new Thread( new ThreadStart(thClass.threadMethod));
myThread.ApartmentState = ApartmentState.STA;
threads.Add(myThread);

((Thread)threads[i]).Start();

}

for(int k = 0;k<3;k++)
{
((Thread)threads[k]).Join();
}

.....
.....
} //Main Ends

Some more info
In my thread method I do some COM calls and make some callls Writeline to StreamWriter

Sandeep Naik

Re: How to wait for multiple STA threads to finish?

Nader Elshehabi30-Aug-06 11:17