Sharing the goodness…
Beth Massi is a Senior Program Manager on the Visual Studio team at Microsoft and a community champion for business application developers. Learn more about Beth.
More videos »
I just posted another Channel9 interview. This time I meet with the team that brings us the "experience" of coding in Visual Studio, also sometimes referred to as the VS IDE Team. I ask them how their design process works, what the top requested features are for the code editors, how they work with the language teams as well as what their favorite and hardest features are to build and test.
PingBack from http://hoursfunnywallpaper.cn/?p=5143
It's funny to see the developers of this project! Nice to see how they really enjoy their work :)
Sorry, I posted this on one of the other links also, but since that posting was a couple of weeks old, I decided to put it on one more recent.
I'm using Visual Basic Express Edition and am trying to set up the DataGridView like your video demonstrates except the query builder will not take the "@" symbol. Also, instead of using a textbox to type in the search parameter, I am trying to use the combox populated with a a collection list available on the FillBy Toolstrip, but I'm not having any luck getting the parameter passed in so I guess I have 2 questions. First, is the parser different on the Express edition (won't take the '@") and how can the value of the combobox on the toolstrip be passed into the query?
I assume you don't mean the video on this post. There is no code associated with this interview ;-).
For your reference next time, video discussions are listed on the main How Do I page for each series on MSDN. I think you are referring to this one: http://code.msdn.microsoft.com/vbvideosdata/Thread/List.aspx
So the @ symbol indicates a parameter when using the SqlClient provider and a SQL Server database like the free Express edition I showed in the video. When using the OleDbClient you need to supply a ? to indicate a parameter placeholder and these parameters are ordered instead of named. The SELECT statement must be written in the syntax your database understands so I'm assuming you aren't working against SQL Server. You'll need to look up the syntax for your database and enter that in correctly.
For more info on TableAdapters: http://msdn.microsoft.com/en-us/library/bz9tthwx(VS.80).aspx
Also if you are using a database that will not return identity keys automatically then you'll probably want to take a look at this forum thread on how to handle inserts: http://forums.microsoft.com/msdn/ShowPost.aspx?siteid=1&PostID=58862