Problem in set max value in scrollbar in C#

Question

0.00/5 (No votes)

See more:

I try to Set ScrollBar Max Value From DataBase Row Count but its not Working So Please Help me in this Problem

And in need scrollBar Show Default in Right Side not in Left Side

What I have tried:

C#

private void DataEntry_Load(object sender, EventArgs e)
{
    AutoDate1();
    fillCombo();
    ScrollBar();
}

private void ScrollBar()
{
    String connstring = ConfigurationManager.ConnectionStrings["Data"].ConnectionString;
    OleDbConnection con = new OleDbConnection(connstring);
    string Query = "select Count(SrNumber) from customer";
    OleDbCommand cd = new OleDbCommand(Query, con);
            
    {
        con.Open();
        int c = Convert.ToInt16(cd.ExecuteScalar());
        hScrollBar1.Maximum = c;
    }
}

Posted 14-May-20 2:01am

Amar chand123

Updated 14-May-20 3:40am

Richard Deeming

v2

Add a Solution

Comments

Richard Deeming 14-May-20 8:25am

Is this Windows Forms? WPF? Something else?

And you haven't explained what "not working" means.

Amar chand123 14-May-20 8:42am

In winform and i want my scrollbar bar maximum value show as par my database rows Count i mean for example my database table have 10 Rows then i want if i click right side button in scrollbar then in 10 click my scrollbar position show in last and if i click left button 10 time then scroll position go back in first position but when i use this code scrollbar not work scrollbar never go left or right

Richard MacCutchan 14-May-20 8:44am

Is your data large enough to exceed the Window size? Scrollbars only appear when all the data is not able to fit the Window. And it is unlikely that your Window is too small for 10 rows.

Amar chand123 14-May-20 8:48am

i want use my ScrollBar work like Next Perv Button and i Use this Code
private void hScrollBar1_Scroll(object sender, ScrollEventArgs e)
{

if (e.OldValue < e.NewValue)
btnNext.PerformClick();

if (e.OldValue > e.NewValue)
btnPrev.PerformClick();
}

Richard MacCutchan 14-May-20 9:02am

So what is the problem?

Amar chand123 14-May-20 9:11am

problem is when i use my ScroolBar(); Code, then ScrollBar Show like This
https://pasteboard.co/J8kR3tu.jpg

but in my database i have 10 Rows
i want scroll Position go left to right after 10 click but as a you see scroll position show fill already in scrollBar

Richard MacCutchan 14-May-20 9:27am

Yes because you are not using it correctly. Take a look at ScrollBar.Maximum Property (System.Windows.Forms) | Microsoft Docs[^]. The scrollbar will only need to move when the amount of data to be displayed is greater than the width or height of the control it is attached to. So you need to set other values to make it act the way you want. A better idea would be to use buttons.

Amar chand123 14-May-20 9:47am

i use replace Maximum to this work but only a small Problem if row count is divide 100 in decimal value
hScrollBar1.SmallChange=100/c;

Richard MacCutchan 14-May-20 10:28am

Don't use absolute values, they will never work. You need to calculate the values based on the number of items to be displayed, and the size of the Window. But if the window is already large enough to display all of the data then, as I already mentioned, the scrollbar will not be created correctly. So you need to do some extra calculation to make the scrollbar think that only some of the data can be shown in the window.

Richard MacCutchan 14-May-20 8:42am

You do not need the Convert function, Select Count returns the number. But the reason it is not working is most likely because your SELECT command did not return anything.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2020-05-14T03:40:00

Quote:
need scrollBar Show Default in Right Side not in Left Side

So, set this property:
Control.RightToLeft Property (System.Windows.Forms) | Microsoft Docs[^]

Other properties of HScrollBar[^] to set are listed here:
- SmallChange,
- LargeChange,
- Minimum,
- Maximum,
- Value.

As per to me, you're trying to use HScrollBar as ProgressBar[^]. Maybe, you should replace them?