C winform top and bottom pages, first and last pages

SQL pagination bar uses a variable to record the number of pages into the database to check,Define three variables,The first is the current number of pages,The second one shows how many pieces of data per page,The third one looks up a count to show how many pages in total,The front is OK to bind with datasource。

When querying the database statement, you can query according to the current number of pages transmitted from the page.

**You wrote your own ideas for you, and you can't be a programmer who completely depends on others**, so do it yourself! It's pretty simple, first write a case in the project.

Aren't there controls? If you want to write it by hand, use bingdingsource, which has these 4 functions.

Sorry, I read the wrong question, it is to pagination.

To write SQL to display the specified data based on the number of pages.

There's quite a lot, I'll give you a hint, you rely on yourself to find it** Use the pagination class pagedatasource

Do you want to handwrite pagination? If so, you can do it by manipulating the T-SQL statement. code:

select top pagesize *from table.

where condition and id not in(select top pagesize * currentpageindex -1) id from table where condition order by sort condition).

order by sort by.

Change the sql statement to query how many rows or which data you want, and get the data in the binding.

Hope it helps!

Just write a data query statement.

I'll write one for you.

id is the only representation of data in a table in the database.

listview comes with a business division function, please see the specific control properties, Chinese prompt, do not need to write**.

Database degree**, in fact, reads the location stored in the database, with varchar type.

It doesn't work to add a control to implement pagination, such as gridview.

tab control,Modify the attributes,Microsoft has updated the control,If you want to be more beautiful, download it

The built-in tab control can be used.,If you feel unsightly, you can use dotnetbar's tab to beautify it.。

Use GDI+ yourself

Let's draw. The toolbar or status bar is over, and you can draw it all by yourself.

Addendum: A lot of beautiful interfaces are used by third-party UI, I used to order one (not very beautiful, but after all, it's much better than doing it yourself, because most of the gorgeous effects must be achieved by hiring a professional UI designer, hehe, if you want, send me an email my email is, and then I'll send it to you, you can refer to it in your project).

Qianqian Jingting is done in C++.

In addition, fading C can be achieved by controlling the transparency of the form.

In fact, using lable is the easiest and most resource-saving way: put a panel, make an lable in it, write a timer, and control its top (vertical), or left (and horizontal) cyclic changes (you can also write both, diagonally change).

If you have to implement it in the status bar or toolbar, you'll need to draw (you can also customize the controls) gdi+

Don't draw the controls directly, they'll get stuck. You can change the word in a bitmap and then set the background image to the button in the status bar or toolbar. [This method is cumbersome].

This can be done with a timer control in conjunction with a multi-line text box or label.

For example, modify the value of every second.

The database reads the data and puts it in the datatable, and then takes rows m to n from the datatable.

For example, there are 15 data items in total, and 10 data are displayed on each page.

Page 1-10

Page 2 11-15 will do.

Thanks, even got it done by yourself.,1.Display the progress bar on the preparation page, use the timer to control the progress, and if the progress bar reaches the maximum, start from 0.

In opening a thread, the function is to back up the database, and in the method of backing up the database, if the backup is completed, open a thread to display the landing page.

OK, thank you rockeylau

First, start a modal form in the main method to display the progress bar, put the backup database operation on this form, remember to open a thread to back up, put a dynamic ** on this form, and you can start the main form after the backup is completed.

In your case, I've written a complete program, and I'm using a console program for ease of understanding, but the principle is exactly the same, just change the way it's displayed, and it's been tested.

using system;

using ;

using ;

using ;

using ;

using ;

namespace test

else"The main thread is running. ");

Displays a wait message.

private static void showwaitinginfo()

Back up the database.

public static void backupdatabase()}

It can be found on the login screen.

The other one is shown before.

A form that displays the progress of the program loading, and then displays the login screen after the loading is complete.

I have a little one here.

Sample program, lz can send me a message if needed.

Wouldn't it be nice to add a progress bar to the winform of the backup to show the backup progress?

Set the borderstyle property of the form to none, then place a menustrip control, and finally make three buttons by yourself in the same way as the close, minimize, and maximize buttons, and write the corresponding ** by yourself. In addition, you also need to write the ** of the menu bar dragging, specific**, please know it at a glance.