I think you may be running into problems on this specific function cmd.ExecuteScalar(). I need to know what data its trying to pull. Try puting a breakpoint on the line and executing it. When it stops at that line open up the immediate window (down by your output for compilation) and type into it ?GetAllChangeControl It would be good if it said NULL or Nothing, which I am sure it will sense it dies at that point. Does Visual Studios give you the key dropdown after you type cmd.? If it doesn't that is where the problem would be. I'm just throwing out a list of ideas here, try the debugging with the immediate window and let me know what the output of it is. ~ Mike

I believe that I understand your problem. This is how you would go about doing it. I don't know what server you are trying to run off of (MS Sql server, oracle, an internal dataset application, whatever) but you would have to setup a dataconnection to call the information from the server, then you would have to setup a dataset off of that dataconnection to actually go in and retrieve the data, once you put the dataset control in your environment you have to bind the properties of it so that it uses the dataconnection. I believe the property is datasource (if you set the data source to your connection which could be named mydbcon or whatever you named it) the data source allows the dataset to connect through the dataconnection type which actually the dataconnection only connects to the server, logs in, then the dataset retrieves the information requested from the server. .Net has server control boud functions for this that login to a server and retrieve data from it based off of data connections and datasets. These controls should automatically be placed inside your toolbox in VStudios. The next step that I am about to arrive at is binding the button search to display the dataset on the next control. This is probably the easiest part. We will display Form2 with the dataset control on the form using the nice easy With New function that is supported in VB.Net. This is how you would call Form2 to load on the button click event to display with the dataset object: Private Sub btnsearch_Clicked(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsearch.Click With New Form2 .Show() End With End Sub Now I don't know how you have your environment setup but if you have the dataset object to display on the load of form2 then you have to set the search results to bind with the search query given. Again you can do this using the with New function. I apologize if this sounds confusing, I am at school and don't have Visual Studios on me so I am having to do this all off my head ;) If you have any further questions or problems MSDN libraries is a great resource on explaining how to connect datasets to dataconnections and dataconnections to servers (or any other programming problems you may arrive at). Thanks hope this helps! ~ Mike

Originally yes, the first reply is correct, although another alternative would be to set the textbox.text property value. Say for instance you have a text box named txtbxdate and a date & time picker named datetm. You would need to set the code of the text box to equal the date selected from the date & time drop down. It would look something like this txtbxdate.text = datetm.selecteddate or something like that I'm not actually running visual studios so I don't know exactly what the date & time picker property looks like but i know you can set the text of a text box to the date & time selected on the date & time box. ~ Mike

Hey everyone, my name is Mike and I host and run a group in the United States called AlienX Software (www.alienxsoftware.com) the site is anything close to being done but what I'm looking for is a group of dedicated devoted developers who love what they do to be a part of the AlienX Team. Wilson and I (the other guy working on this project with me) are working on a few programs so far, and are looking to work on a lot more in the future. Projects consist of Arctic Fox (a desktop app that is designed for students high school/college that is designed to help the student in the study of chemistry. It converts chemical formula's does citations in MLA format for reports and written projects, allows you to log into AlienX for online help, the list goes on...) Media Center (not yet in development) Cam Crawl (uses a proxy to get around firewall settings, etc...). There are many more projects that we would like to start down the line but seeing as how there is only two of us. We would like more people to help out and be a part of this project, those who help get 100% credit to the source and development they produce, get there own personal staff page on AlienX, and get to work with an awesome dedicated team. I have been looking for great developers out there and have found the best on the codeproject. I would like to state that I need more than just VB .Net developers, if your a web developer, flash developer, graphic designer, even C++ and C# developer, we need help everywhere, this site is so new google hasn't even crawled it yet. Wilson and I would really appreciate all the help we can get. Thank you everyone for taking your time to read this, sorry for the long note :) If you have any questions or would like to be a part of this project please email me mclark@alienxsoftware.com ~ Mike mclark@alienxsoftware.com

Linker Tools Error LNK2001 When your writing code you have to label the functions, variables, classes, etc... If you label something that it cannot find or is listed twice you will receive an LNK2001 process error. If that doesn't work try this on the main menu of Visual C++ go to project settings, and click on the C/C++ tab. remove _ATL_MIN_CRT from the preprocessor definitions, although depending on what version of Visual C you are running it may automatically be removed. Most likely however their is a function or variable that is listed twice in the Class tree, which again is causing compilation errors. Although if this doesn't work try looking at the error itself at msdn. Here is the link feel free to email me if you have any more questions or are still receiving problems -Mike