I would guess that your composite primary key is incorrect. Ask this question, can a user have multiple types of authorisations. If yes then you need a many to many link
User - UserID
Authorisation - AuthID
Link - LinkID - unique constraint (userid/authid)
I hate composite primary keys - personal bias only!
Never underestimate the power of human stupidity
Thank you for your reply. Yes, a person can have 1-N authorizations.
I guess i'm still confused with 1 to many in this context. From the user record, I wanted to include the auths table to get at the auths relating to that person. In order to have a 1 to many, the 2nd table must have an additional field(s) defined as the primary key for uniqeness. But EF seems to want a matching of 1-1 of primary keys. Not sure how that's can be. Unless there's something about the mapping I completely am overlooking.
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
How to retrieve the particular row from the database table to the datagridview.
I will be comparing text box with one of the column name and if that matches then only that row should get display in the datagridview/
how to do this?
How to retrieve the particular column row to the text box?
I mean how to display it in textbox?
The column has got different rows.
The code I wrote in vb net is :
cmd = New SqlCommand("select ida from Issue where aname='" + TextBox3.Text + "'", con)
In the above line I compare the textbox3 data in the table.
And if the data matches then it should display the ida column record that matches with aname row record to textbox4.
I am doing something wrong for sure as I wrote it in this way:
The above line din't give any error and it din't show anything in textbox4 also.
I have an update button and a datagridview that bind one of my table. when I click on update button it successfully update but my problem is my datagridview doesn't update automatically.Can you give me some idea or code to resolve my problem.
There is no equivalent for the C preprocessor capabilities for including the compilation date/time, however you could look at the creation or modification datetime of the EXE file. I suggest you read up on Application.ExecutablePath and FileInfo.
I have an urgent task that requires to write an application in VB .NET with features like IVR and DTMF. I am running out of time so I found and SDK called Ozeki SIP SDK in order to get ready with the task. I am doing the things provided by the following page: http://www.voip-sip-sdk.com/p_331-vb-net-dtmf-ivr-voip.html[^]
What do you think will this tool be relevant for my task?
without testing it myself it would appear that it could do what you require of the SDK, the only thing left to do is test it!
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
it's like Warcraft Local Area Network games.
everyone can create their chat room, everyone saw all available rooms, and everyone can join the room freely.
i searched at google and keep finding chatting application with single server (even DOS server)
i really don't know what keyword to search at google.
can somebody tell me the keyword? i will try to learn by myself first.
Whehe, that means that you are good at it - not me.
nah i got question, chatroom is something that everyone sees every word. so
if server receive text from 1 client, server should loop and send it one by one
Yup, or store it all in a central location (but than you'd have a server again).
You could "promote" one of your peers to "act" as a server for the duration of the chat. All the clients would have to agree on who gets promoted, but it should generate less traffic than having each client update each client.
I am facing a certain problem. I am trying to delete a certain file programmatically that resides in the system32 folder (malicious file). When i try to delete it using the kill statement an error message shows that says Access Denied as the file is being used by another process. When i searched i found out the that winlogon.exe uses this executable. How can i remove this handle programmatically. Any ideas and suggestions would be very helpful.
WinLogon cannot be unloaded, and you cannot unload anything that's being referenced by it. You could have Windows remove the file "after" a reboot (it does this before it starts the shell, meaning that WinLogon will not yet be in use)
That's not recommendable though; the infected file will have replaced the original, and deleting it will corrupt your system. Unless you can put back a file that's not infected, best idea is to not touch it.
No, just a new malicious file has been created in the windows/system32 folder.When i try to delete that file it shows file in use . and this file is being used by the winlogon.exe process. how can i delete this file programmatically.
Files can only be deleted when they're not in use, and you can only remove it after a reboot and before logon, as described before. (Simple explanation, I cannot throw away your mug if you're still drinking from it, since it's in use)
WinLogon does not load random files. If the file is in use, it counts as a dependency. If WinLogon is started without the dependency, it will simply fail.
"Old" file's would be "corrected" by putting back a copy from a previous restore-point, or by copying back the original file from the setup.