Luo Cao's Q&A profile

• Visual Studio 2008 (Pre-release) Dynamic Queries accross joined objects. Lambda

  Hi all, I am attempting to construct a dynamic query across a join (Contact belongs to one company). I have achieved this using hard coded Lambda expressions: var FilteredContacts = DB.Contacts.Where(c => c.ReadOnly == false ).Select(c => c); FilteredContacts = FilteredContacts.Where(c => c.Company.Name.Contains( "Compan X" )); This works fine but I am looking for a way to construct this on the fly, this is what I have so far but I can not get it to work IQueryable q = DB.Contacts.ToQueryable().Including(c => c.Company); ParameterExpression p = Expression .Parameter( typeof ( Contact ), "c" ); ParameterExpression pCom = Expression .Parameter( typeof ( Company ), "Compa ...Show All

• Visual Basic Comprate Input text with a Data Table

  I have a school project, hope that you can help with my extra credit. I have to design a Database, which I have done but now I need to add a username and password. I have added the login form that visual studio has but now I need to validate. Which would e very easy if professor will only want 1 user and password. But he wants a separate table with user names and password which the application has to check. I beleive that what I have to do is comprare text imput by user and if username and password matches send it to next window. If this was only one value I would belike this: Dim Num1 As String String Num1 = LabelTextBox.Text If LabelText1Box.Text = "2323" _ And LabelText2Box.Text = "4444" THEN D ...Show All

• Visual Studio Tools for Office VSTO 2005 and Outlook 2007?

  Hi, I'd like some informations...I've started to use VSTO 2005 to build my plugin for Outlook 2003 some months ago...but a few weeks ago an user told me he has successfully installed my plugin into Outlook 2007! However, he's the only case... Do you have any clue Should they change the PIA, something else I still don't understand how this guy have been able to install (he neither...he just double-clicked the installer, and voila! :)) Please help me ;) Bye LastHope Installed a new PC for Office 2007.. same problem here... you can't install the PIAs for Office 2003 on a PC with just Office 2007.. can't belive that nobody on MS thought about that.. sigh... ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Setting vertices in graphics device

  Hi I'm wondering what it's best Having one big (not too big) vertexbuffer ore use many little vertexbuffers. I think that one vertexbuffer reduce setup time each frame, but I'm don't know why I think that. What do you think This thread may be helpful to you: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1242843&SiteID=1 ...Show All

• Visual Studio Where can i get VS2005 for free?

  Hello, Where can i get VS2005 for free I am student of High school and i am looking for some studying program where would i can get VS2005. I found http://theSpoke.Net but that's not longer available. I was also looking for MSDN AA, but that's for University or College, but i am studying High school. Any another chance how can i get copy of VS2005 for free I was using VS Express, but that's not support addins and i haven't chance develop for Windows Mobile and these two things are what i want. Sorry for my poor english, i am still learing. Thanks for help.   ahmedilyas wrote: you can't get the full VS For free, you must purchase it either from your retailer store or the internet, ...Show All

• SQL Server Converting milliseconds in hours

  Hi! I have the difference between two dates in milliseconds. I want to convert this difference to the format hh:mm:ss.mmm, without the date. So, if the difference is bigger then one day, I would like to show it like this, for example: 36:25:14.047 How can I do this Thank you! AnaC: Below is another alternative. Dave declare @1stDt datetime set @1stDt = '10/15/6' --declare @2ndDt datetime set @2ndDt = '10/15/6 01:02:03.006' declare @2ndDt datetime set @2ndDt = '10/16/6 12:25:14.047' declare @diff integer set @diff = datediff (ms, @1stDt, @2ndDt) select convert (varchar (13), @diff/3600000) + ':' + + right ( '0' + convert (varchar (2), (@diff % 36000 ...Show All

• Windows Forms Why aren't my shortcut keys firing on submenus?

  I created a contextmenu with a submenu with items off a submenu that I assigned shortcut keys but the shortcut keys don't fire unless I activate the context menu but they fire if they are a part of the main level of the context menu. Is there away to get items in a submenu to fire without activating the context menu the same way items on the first level behave ...Show All

• SQL Server Using OLE object within a procedure

  Can anyone help me address pros and cons of calling OLE object within a stored procedure. As we know system stored procedures such as sp_OACreate, sp_OAMethod are used to create and call OLE objects. I have to decide between whether it is advisable to use sp_ in my procedures or to do something outside the database. I need to use an external component to transfer files between FTP servers. This can be done using a procedure and job to schedule the calls. Thank you, Yogesh Generally speaking, it is a given that accessing external resources from within the database server has lot of implications - security, reliability, scalability, manageability etc. And one of the things we did in SQL Server 2 ...Show All

• .NET Development Intersection

  Hi All, Any one know how could I write the following query in MS Access in MS Access, there is no INTERSECT keyword select rd.rep_artittle as [title], rd.ar_ser as [code], rd.rep_code as [rdf] from report_definition rd, report_words rw, key_words kw where kw.id = rw.kw_id and rd.id = rw.rd_id and kw.aword = 'KEWYORD' INTERSECT select rd.rep_artittle as [title], rd.ar_ser as [code], rd.rep_code as [rdf] from report_definition rd, report_words rw, key_words kw where kw.id = rw.kw_id and rd.id = rw.rd_id and kw.aword = ' KEWYORD ' Hi pal, I dont know wht ur upto coz ur applying the "intersect" keyword between same queries so the result set would be the same as ...Show All

• SQL Server Migrated from SQL 2k5 Express to SQL Server - Profile doesn't work

  I recently created an application that stores 3 variables in the web.config in the "Profile"configuration: < profile > < properties > < add name = " Department " defaultValue = "" /> < add name = " UserName " defaultValue = " Anonymous " allowAnonymous = " true " /> < add name = " AL " defaultValue = "" /> </ properties > </ profile > By doing this my web.config automatically configured itself to create a database in my app_data folder and also filled in all the table rows as necessary. Then I moved the code to my sql server running SQL Server 2005 Standard and found out that it won't generate th ...Show All

• SQL Server Execute Function

  hi all, say for eg i have a function and proc named as fun_sample and proc_sample respectivley. why do we specify "dbo.fun_sample" for executing the function, whereas only "proc_sample" is enought for executing the proc For scalar function: select dbo.fun_sample() or declare @v int set @v = dbo.fun_sample() For table-value function: select * from dbo.fun_sample() ...Show All

• SQL Server Image .BMP only shows on first page, place holder on the rest

  I am printing a batch of Explanation of Benefits and the image only shows on the first page for each person. If they have additional pages all I get is the little red X. Thanks, Phil I wasn't clear on that from the initial post. It really depends on the report layout. From what you say I'm assuming that you have a list control that's grouped by person with page break option checked. In addition to that some users data spans multiple pages. What's confusing is that you mention that you get a red X (image place holder) but no image. Where is the image placed In the header, the body, a list control To my knowledge there are 2 things you can have repeated when paging: The overall report header The ...Show All

• Visual C++ Importing excel sheet data into spreadsheet

  Any one plz help me in "importing data from excel sheet into a spreadsheet" programatically in vc++. The C++ Language Forum is restricted to questions regarding the C++ Language, as implemented by the VC2005 compiler. It also includes the STL and other standard libraries, but as such not any Microsoft- or third party APIs or SDKs. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=789657&SiteID=1 . Please direct this question to one of the automation or office development newsgroups at http://msdn.microsoft.com/newsgroups . Thanks! ...Show All

• .NET Development Strange behaviour of JET Database Engine

  Hi, JET says, that my INSERT INTO-command, which has been generated by a CommandBuilder, has a syntax error. Is it possible to find out the SQL-command, which is sent to JET from a DataAdapter Thanks! Have you tried using OleDbCommandBuilder.GetInsertCommand() This will give you an OleDbCommand object, and you can look at the CommandText. Jet itself doesn't have much tracing, but we do have tracing in .NET in 2.0 that should show you the actual value being used at runtime. I think using GetInsertCommand is the easiest first step. For more on the new tracing, see: Tracing Data Access http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnadonet/html/tracingdataaccess.asp If you want ...Show All

• Visual Studio 2008 (Pre-release) 3d shape inside 3d shape

  hi, it's amazing... can i (with the WPF) create a outer shape and inside it an inner shape that "move" inside the 3D space in the outer shap thanks, omri You can set the Transform property on any Model3DGroup to move any part of the scene you wish, whether it's the entire scene or just a small part. If you're using a Visual3D tree for your scene structure (which enables hit testing with more granularity, extensibility, etc), you can set Transform on ModelVisual3D. -Adam Smith [MS] ...Show All