|
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
RAH
|
|
|
|
|
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.
Nathan
'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?
|
|
|
|
|
What have you tried? 
There are quite some walktroughs on MSDN, also on the DataGridView - Google knows where.
Bastard Programmer from Hell 
|
|
|
|
|
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:
textbox4.text=cmd.ToString.
The above line din't give any error and it din't show anything in textbox4 also.
So ,how to display it?
|
|
|
|
|
It looks like you have not executed the SQL cmd.
Something like this ...
Dim SQLrdr As SqlDataReader
SQLrdr = SQLcmd.ExecuteReader()
While SQLrdr.Read
debug.print (SQLrdr("ida"))
End While
SQLrdr.Close()
SQLrdr = Nothing
Check on other ways to execute SQL.
Look at DataAdapters and ExecuteScalar
|
|
|
|
|
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.
I'm a newbie in vb.net
tnx in advance 
|
|
|
|
|
Please do not post the same question at two locations. This question was already posted under Quick Answers section.
|
|
|
|
|
I would like to automatically include the latest compile date and time in my .exe. I am using Visual Studio 2010. Is that possible?
|
|
|
|
|
Not directly, but it's already there. Look at the LastModified time on the resulting .EXE file in your BIN folder.
|
|
|
|
|
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.
|
|
|
|
|
Hello,
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?
Please share your opinion.
|
|
|
|
|
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.
Thanks before,
VK 
|
|
|
|
|
"Peer to peer"
Bastard Programmer from Hell 
|
|
|
|
|
you're good, i learned it in only 1 hour.
i created a server and client program.
the server keep listening and any single text send from client, i write it in textbox.
and the client mark the server IP and can only send text.
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 to client?
btw, thank you very much. 
|
|
|
|
|
vkstarry wrote: i learned it in only 1 hour.
Whehe, that means that you are good at it - not me.
vkstarry wrote: 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
to client?
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.
Bastard Programmer from Hell
|
|
|
|
|
anybody can help me..how to control motor use visual basic at avr?
|
|
|
|
|
You can start by NOT hyjacking someone elses thread.
I think you may have missed the "Ask a question" button above the forum posts.
|
|
|
|
|
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.
Bastard Programmer from Hell
|
|
|
|
|
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.
|
|
|
|
|
How did you determine that it's a "new" file?
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.
Bastard Programmer from Hell
|
|
|
|
|
how to create a menu items on a form you had?... hmmm...
hermaine...",)
|
|
|
|
|
Do you wish to create a menu on your form?
In the toolbox, in the menus & Toolbars section, drag and drop a MenuStrip onto your form then start filling in your various menu options.
Double clicking the finished menu will create a a Private Sub menu item click event where you place the code to call the various menu item request calls.
Hope this helps
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
