more help please!?!?!?
That helps... but i still dont fully understand it :(... I like the datagridview way better... but seeing as how many users will be using it i dont think that my boss will like it so much... unfortunately... I am going to do it both ways and see which he likes better... however, what i dont understand is: (i am only going to be asking questions from the insert into the database from textbox b/c i am pretty sure thats how he wants it)
A) how does the OLEdbCommand work... (sorry i am just a student trying to do a proffessional's job :( )
B) all the code is done on the submit button right? we dont need to establish the connection on the form load?
C) what is an nvarchar? :(
I think i am going to leave it at that for now... and there is a 99% chance i will be asking more questions from your reply and i will come up with more questions as i am trying to code this.
There is a major discontinuity in the thread so I can't evaluate the first two questions.
But a nvarchar is an SQL datatype, with a defined maximum length and it's behavior is very much like the String datatype in VS2005.
A. The OLECommand is simple a way of executing a SQL command. The following link provides details on using the command along with a couple of examples.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataOleDbOleDbCommandClassTopic.asp
B. All the code is done on a submit button. This depends upon the way you wish to implement your solution and from a description of the submit button is this a ASP.Net solution ? It could potentially be implemented in either but its probably best to keep it in button click event.
C. Nvarchar is simply a specific datatype. It is a data type used specifically for databases.
http://msdn2.microsoft.com/en-us/library/ms186939.aspx
For Question A and B a simple check of the help system or even a web search will reveal literally hundreds of links to useful information with good examples which demonstate the use of either. Keep asking questions which your having problems with but also a little independent searching on the help system included with the product and the internet using a standard search engine like live.com or google will get you a wealth of answers instantly rather than necessarily waiting for a response from the forum,
