How Do I Save And Retrieve The Location Of A Control From Sql Table?

Question

0.00/5 (No votes)

See more:

This is the code that i use to move my control, how do i save and retrieve the current location of this control from a sql database table?

VB

If _mouseDown = True And RadioButton1.Checked = True Then
            Button1.Width = e.X
        Else
            If e.X >= Button1.Width - 3 And RadioButton1.Checked = True Then
                Button1.Cursor = Cursors.VSplit
            Else
                Button1.Cursor = Me.Cursor
            End If
        End If
        If _mouseDown = True And RadioButton1.Checked = True Then
            Button1.Height = e.Y
        Else

            If e.Y >= Button1.Height - 3 And RadioButton1.Checked = True Then
                Button1.Cursor = Cursors.HSplit
            Else
                Button1.Cursor = Me.Cursor
            End If
        End If

Posted 15-Jun-15 18:24pm

Member 11644196

Add a Solution

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)

David A. Gray · Accepted Answer · 2015-06-15T19:07:00

Create a SQL table containing a set of Integer columns for the X and Y coordinates of each control. Then, write a stored procedure that takes the coordinates as arguments, and execute it whenever you want to save them.

Retrieving them is even easier; write a Select query that returns them into a recordset. Whenever you need to retrieve them, execute the query, and read the values from the returned row.