You searched for the word(s): userid:782761

More Search Options

RSS Available

• The query does not work. Help me!

  In the query: <Query> <Where> <Lt> <FieldRef Name="PublishedDate"> </FieldRef> <Value Type="DateTime"> <GetVar Scope="Request" Name="PDate" /> </Value> </Lt> </Where> </Query> PDate variable get from url: .../Lists/Posts/Post.aspx?ID=12&PDate=2008%2d09%2d06T09%3a47%3a10Z (PDate=2008-09-06T09:47:10Z) But my query did not work. If I replace <GetVar Scope="Request" Name="PDate"

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by nguyenvanbay1975 on 9/6/2008

• How to get variable between two views in the current page in SharePoint 3.0

  I have 2 views (View1, View2) in Schema.xml file and I assign them on the same page . <View1> <SetVar Name="CurrentPostDate"> <Field Name="PublishedDate" Scope="Request" /> </SetVar> </View1> <View2> <GetVar Name="CurrentPostDate" Scope="Request" /> </View2> I used SetVar in View1 with name is CurrentPostDate and I want to using it in View2 by GetVar. But I does not work. Can you help me? Thanks.

  Posted to Free For All (Forum) by nguyenvanbay1975 on 9/5/2008

• Share this issue with everyone beginner in C# and LINQ

  Please study this code, I think it can solve my issue: var TopMedalList = (from a in db.SportTeams select new { TeamID = a.TeamID, TeamName = a.TeamName, G = (from m in db.SportMedals where m.Medal == 'G' && m.SportAthlete.TeamID == a.TeamID group m by m.EventID into t select t).Count(), S = (from m in db.SportMedals where m.Medal == 'S' && m.SportAthlete.TeamID == a.TeamID group m by m.EventID into t select t).Count(), B = (from m in db.SportMedals where m.Medal

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by nguyenvanbay1975 on 8/16/2008

• Re: Help me! Convert SQL syntax to LINQ with multi join

  Thanks for your replies. But I want to learn LINQ syntax (in C#). Can you help me write my query into LINQ syntax. Thanks!

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by nguyenvanbay1975 on 5/6/2008

• Help me! Convert SQL syntax to LINQ with multi join

  Hi... I have 3 tables: SportTeams (TeamID, TeamName) SportAthletes (TeamID, AthleteID, AthleteName) SportMedals (AthleteID, Medal) I want to have a brief medal list (TeamID, G, S, B). I can write query in systax: Select a.TeamID, a.TeamName_en,g.G,s.S,b.B from SportTeams a Left Join (Select c.TeamID,Count(*) as G from SportMedals b Inner Join SportAthletes c On b.AthleteID = c.AthleteID Where Medal = 'G' Group By c.TeamID) g On a.TeamID = g.TeamID Left Join (Select c.TeamID,Count(*) as S

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by nguyenvanbay1975 on 5/5/2008

• Re: Left Outer Join with two conditions

  Please query your data like this: select I.ir_id, I.ir_title,I. ir_b_type, I.ir_label, I.ir_createdby, I.ir_createdon, B.mstatus, B.bstatus from BR_IR I left outer join (select * from BR_BS where Isnull(bstatus,'No') <> 'Yes') B on I.ir_id = B.bs_ir_id order by I.ir_id desc

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by nguyenvanbay1975 on 2/12/2008

• Searching AdventureWorks scenarios list

  Hi everybody! I have already read contents in "Appendix A: A Day in the Life of Team System" of "Working with Visual Studio 2005 Team System". But I can't find the scenarios list, quanlity of service requirments list and distribute them into tasks. I want to have them as a concrete sample. Can you help me? Thanks.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by nguyenvanbay1975 on 1/28/2008