Cheat Engine Forum Index Cheat Engine
The Official Site of Cheat Engine
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


MS Access + VB coding (Need help setup)
Goto page Previous  1, 2
 
Post new topic   Reply to topic    Cheat Engine Forum Index -> General programming
View previous topic :: View next topic  
Author Message
asianking
Expert Cheater
Reputation: 0

Joined: 25 Jun 2008
Posts: 109

PostPosted: Thu Mar 10, 2011 5:04 pm    Post subject: Reply with quote

is there a code to hide checkbox inside the database, but show the checkbox on graphical interface?

for example:


If you ask why didn't I just create a plain checkbox without adding in database; I tried it and if I move on to the next record; the checkbox will kept highlighted which it doesn't save it.

_________________
Back to top
View user's profile Send private message MSN Messenger
AhMunRa
Grandmaster Cheater Supreme
Reputation: 27

Joined: 06 Aug 2010
Posts: 1117

PostPosted: Thu Mar 10, 2011 6:55 pm    Post subject: Reply with quote

Add an event that checks when the form is refreshed or the form moves on and have it clear out the check boxes. Also why is there a checkbox physically in your db? I would have had a column sex then pop with m or f have your checkbox check the value if checkbox == "m") checkbox_male.checked.value = true
_________________
<Wiccaan> Bah that was supposed to say 'not saying its dead' lol. Fixing >.>
Back to top
View user's profile Send private message
asianking
Expert Cheater
Reputation: 0

Joined: 25 Jun 2008
Posts: 109

PostPosted: Fri Mar 11, 2011 8:26 am    Post subject: Reply with quote

so i'm assuming you don't know the code to hide from data. I kind of like the data view to display on FirstName, LastName, Telephone, Email, and Address. For All checkbox, to hide. I still want them there, but just hide so it doesn't display it in data view. For graphical view, I want to show the checkbox though.
_________________
Back to top
View user's profile Send private message MSN Messenger
AhMunRa
Grandmaster Cheater Supreme
Reputation: 27

Joined: 06 Aug 2010
Posts: 1117

PostPosted: Fri Mar 11, 2011 3:16 pm    Post subject: Reply with quote

If not mistaken in DataView you would have to hide the whole column.

SELECT(FirstName, LastName, Telephone, Email, Address) FROM dbUsers;

In your query just leave it out.

What's the code look like for your DataView?

This is a snippet of code I wrote to fill a datatable with results parsed from a text file. If I wanted to hide something on the table, I just wouldn't have added it when creating the datatable to begin with. I am not sure if this is relevant to your question or not.

Code:

        public static int fillDataTable(DataTable tblName, string[] colHead, string[] dataRow)
        {
            DataRow dr;
            dr = tblName.NewRow();
            for (int n = 0; n < colHead.Length; n++)
            {
                dr[colHead[n]] = dataRow[n].ToString();
            }
            tblName.Rows.Add(dr);

            return 1;
        }




EDIT simpler solution. If you used the DataGridView then when you select your table you should be able to select what in the table is shown. This may affect your query though, unless you are building that seperately to popular the actual form.

_________________
<Wiccaan> Bah that was supposed to say 'not saying its dead' lol. Fixing >.>
Back to top
View user's profile Send private message
asianking
Expert Cheater
Reputation: 0

Joined: 25 Jun 2008
Posts: 109

PostPosted: Fri Mar 11, 2011 4:31 pm    Post subject: Reply with quote

code error; static is not a declearation.

by the way; I think you kind of got the right idea by hiding others that you do not enter in the codes. Anyway, my co-worker says that I can do two seperate tables and make sure both of them includes ID that will match. So if I update one table; it applies both. I would know how to do this with access, but not vb.

_________________
Back to top
View user's profile Send private message MSN Messenger
atom0s
Moderator
Reputation: 205

Joined: 25 Jan 2006
Posts: 8588
Location: 127.0.0.1

PostPosted: Fri Mar 11, 2011 5:35 pm    Post subject: Reply with quote

asianking wrote:
code error; static is not a declearation.

by the way; I think you kind of got the right idea by hiding others that you do not enter in the codes. Anyway, my co-worker says that I can do two seperate tables and make sure both of them includes ID that will match. So if I update one table; it applies both. I would know how to do this with access, but not vb.


You can use Linq to do joins to ensure matching.

If you need help learning Linq:
http://msdn.microsoft.com/en-us/vcsharp/aa336746

_________________
- Retired.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Cheat Engine Forum Index -> General programming All times are GMT - 6 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group

CE Wiki   IRC (#CEF)   Twitter
Third party websites