Windows Forms

Re: Scrollbar automatically reset when control get focus ?

6-Mar-09 2:34

That is an excellent reply! Thank you for your consideration.

Unfortunately, I cannot reproduce your problem. Let me tell you what I did and then you can tell me how we differ.

I created a Form. I put a Button on it and set its Dock property to DockStyle.Bottom. Then, I put a Panel on it and set its Dock property to DockStyle.Fill. I set AutoScroll to True. I added three TextBoxes, one at the top, another about two-thirds of the way down, and another beyond the clipping box causing the scrollbar to appear.

When I ran this project, I scrolled the Panel all the way to its bottom so that I could see the last added TextBox. Then, I clicked on the Button. Then, I clicked on the Panel. The Panel just sat there and mocked me. It did not, however, automatically reset to the default position.

Do you think that you could post some of your code so that we can look at it?

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

Pham Hoang Le6-Mar-09 6:33

Pham Hoang Le

6-Mar-09 6:33

Hi,

I did what you said and surprisingly, it did not cause the problem. Then i tried to point out what's the difference. After a while, i found out that my control which is inside the Panel, actually extends the UserControl, and that's the cause of the problem. If i change it so that it extends other Control, such as Panel, then no problem at all. I still dont know why.

In summary :

If a Panel with Scrollbar contains an UserControl, then when the Panel loose focus(user click on other Control outside the Panel) and then get back the focus(user click on the UserControl), then the Scrollbar will automatically reset to default position !

But if it's other kind of Control instead of UserControl, then everything is fine.

I'll try to find out why.

Re: Scrollbar automatically reset when control get focus ?

Curtis Schlak.6-Mar-09 7:36

Re: Scrollbar automatically reset when control get focus ?

6-Mar-09 7:36

Great detective work! I appreciate your hard work.

I created a simple class the inherits from UserControl. I put that on the form, too. Still no scrolling.

I wonder if your custom control is the culprit.

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

Pham Hoang Le8-Mar-09 21:38

Pham Hoang Le

8-Mar-09 21:38

Hi Curtis Schlak,

I have tried to put a dummy UserControl into a Panel, make the Scrollbar on the Panel appear, scroll the Scrollbar to some position, then make the Panel loose focus, and then make it get back the focus by clicking on the UserControl, the Scrollbar automatically reset.

But if i replace the UserControl with a Panel, then no reset at all.

Re: Scrollbar automatically reset when control get focus ?

Curtis Schlak.9-Mar-09 2:17

Convert SQL DataTable to Excel/CSV

9-Mar-09 2:17

Could you post your dummy code? I still can't reproduce this problem.

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

nt_virus5-Mar-09 3:05

nt_virus

5-Mar-09 3:05

Hello. I want to convert Tables of SQL Database to an Excel and CSV file through C#.NET Windows Application.. I tried reading few articles on internet.. and I m puzzled by seeing such codes and cant find a way to make it work..

Can anyone of you guys please help me in this.. I really need it ..

Waiting for your replies...

led mike5-Mar-09 6:27

led mike

5-Mar-09 6:27

nt_virus wrote:
Can anyone of you guys please help me in this

Help you with what? You didn't ask a question you just asked for help? Are you asking for someone to do the work for you? That's not really how this site works. There are some that do work that way like Rentacoder.com

Eddy Vluggen5-Mar-09 6:52

5-Mar-09 6:52

nt_virus wrote:
and I m puzzled by seeing such codes and cant find a way to make it work..

We can help if you get stuck, or provide a link to an article that sets you off in the right direction.

nt_virus wrote:
I really need it ..

Within what timespan? Writing it yourself is an option, but if you don't know the language then it will take some effort and time.

Start out with writing a small prototype that reads data from a SQL Server table. Exporting the data back to Excel goes somewhat along the same route. If you get stuck with a particular piece o' code, or want explanation about something that you're puzzled about, check back here. Copy & paste the code into a new post, without the "please" and "I need it", and you'll get some helpfull answers.

Could be done in a couple o' days Smile | :)

I are troll Smile | :)

nt_virus5-Mar-09 18:11

nt_virus

5-Mar-09 18:11

Hello. Thanks for the replies.

The below code works, it is made on Console Application.. but how to get the column names .. I m just getting only data..

namespace SqldataTable_to_Excel
{
    class Program
    {
        static void Main(string[] args)
        {
            string path = @"C:\db.xls";
            if (!File.Exists(path))
            {
                // Create a file to write to.
                using (StreamWriter sw = File.CreateText(path))
                {
                    //creating the file contents
                    SqlConnection cn = new SqlConnection("Data Source=NT_VIRUS;Initial Catalog=test;Integrated Security=True");
                    SqlCommand cmd = new SqlCommand("SELECT * FROM planets", cn);
                    try
                    {
                        cn.Open();
                        SqlDataReader dr = cmd.ExecuteReader();
                        while (dr.Read())
                        {
                            sw.WriteLine(dr["name"].ToString() + "\t" + dr["age"].ToString());
                        }

                        Console.WriteLine("Database has been exported.");
                    }
                    catch (Exception excpt)
                    {
                        Console.WriteLine(excpt.Message);
                    }
                }
            }
        }
    }

Eddy Vluggen5-Mar-09 23:55

5-Mar-09 23:55

Good job

There is more than one way to get the column-names. You could read the data into a DataTable, instead of using the dataReader. A DataTable also holds some information on the metadata of the table, such as columnnames.

You could also ask SQL Server to give you the same metadata. Execute the SQL-statement below (with the correct tablename) to get a list of columnnames, their types and length Smile | :)

SELECT sysobjects.name AS TableName,
       syscolumns.name AS ColumnName,
       datatype=systypes.name,
       length=syscolumns.length
  FROM sysobjects 
  JOIN syscolumns ON sysobjects.id = syscolumns.id
  JOIN systypes ON syscolumns.xtype=systypes.xtype
 WHERE sysobjects.name = 'AfvinkCode'

I are troll Smile | :)

nt_virus6-Mar-09 4:16

nt_virus

6-Mar-09 4:16

Thanks but I didn't understand .. how to apply this in my code.. could you please elaborate mate..

Curtis Schlak.6-Mar-09 4:24

6-Mar-09 4:24

Ok, you really don't seem to know what you're doing. While CodeProject will help you when you get stuck on a problem or want advice, I don't think that anyone will hold your hand to walk you through the creation of your application. That's what books, schools, online posts (though you're confused by them), and mentors are for.

Eddy gave you SQL! If you don't know how to invoke it, then you have a lot more learning to do than I (or anyone else, I think) would want to provide to you.

First, figure out what you want to do. Then, try to learn something about it. Then, come back here and ask a better question than what distills to "Thanks for the code snippet, can you please write the rest of the code for me, too?"

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

Eddy Vluggen6-Mar-09 6:12

Dropdown in combobox with sorting

6-Mar-09 6:12

I are troll Smile | :)

Any_India4-Mar-09 19:43

Any_India

4-Mar-09 19:43

i hav collection of items in combobox.when i press any key suppose to 'B' it should show all the collecton of items of B in drop list like in dropdownlist.

plz help me

Re: Dropdown in combobox with sorting

dan!sh 4-Mar-09 21:30

dan!sh

4-Mar-09 21:30

Combobox does have an autocomplete property. Set that and autocomplete source.

Time is the best teacher; unfortunately it kills all of its students.

जय हिंद

Re: Dropdown in combobox with sorting

jaypatel5128-Mar-09 20:59

jaypatel512

8-Mar-09 20:59

Ya he is right. Set the autocomplete property and have fun . .

RE: Windows Services

chandhuBTS4-Mar-09 0:49

chandhuBTS

4-Mar-09 0:49

different names for the Windows Service being installed.
different configuration and data files using the same .EXE
using presentation layers.

Chandhu

Ashfield4-Mar-09 1:20

Ashfield

4-Mar-09 1:20

and do you have a specific question?

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Eddy Vluggen4-Mar-09 2:18

4-Mar-09 2:18

Is it a haiku?

Different questions,
Different forums,
Same answers:

I are troll Smile | :)

Greg Chelstowski4-Mar-09 2:37

Greg Chelstowski

4-Mar-09 2:37

LOL! Funniest... post... ever!

var question = (_2b || !(_2b));

led mike4-Mar-09 4:47

led mike

4-Mar-09 4:47

Not funniest ever but damn funny stuff! here's a '5' for bringing the first laugh to my morning.

led mike4-Mar-09 4:50

led mike

4-Mar-09 4:50

Don't repost your question. You didn't even respond to the previous threads reply.

Get your act together before you post here again, or pray I don't see it.