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

More Search Options

RSS Available

• Select Query + order By + union

  Hi, I am having a query like this select UserId , LoginName + '(' + Name + ')' as LoginName from dbo . UserProfile where UserId not in( 1 ) and Status = 'ACTIVE' union select UserId , LoginName + '(' + Name + ')' + '(Inactive)' as LoginName from dbo . UserProfile where UserId not in( 1 ) and status = 'INACTIVE' I need to oderby the result based on LoginName. Wut shud I do??

  Posted to Data Access and ObjectDataSource Control (Forum) by chanakya01 on 7/6/2009
  Filed under: Union, SELECT query, Order By

• Re: Select Query from another Query

  Select from (select UserId , LoginName + '(' + Name + ')' as LoginName from dbo . UserProfile where UserId not in( 1 ) and Status = 'ACTIVE' union s elect UserId , LoginName + '(' + Name + ')' + '(Inactive)' as LoginName from dbo . UserProfile where UserId not in( 1 ) and status = 'INACTIVE' ) order by LoginName

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by chanakya01 on 7/6/2009

• Re: Checkbox and Checkbox list values

  Replace your CheckBoxList code in aspx code as... <asp:CheckBoxList id= "cbProofreading_Editing" TextAlign= "Right" OnSelectedIndexChanged= "Check" runat= "server" > <asp:ListItem Value="True">Yes</asp:ListItem> <asp:ListItem Value="False">No</asp:ListItem> </asp:CheckBoxList>

  Posted to Web Forms (Forum) by chanakya01 on 7/2/2009

• Re: How to only allow certain rows of gridview to have Delete..

  Replace your gridview code in aspx as below. This will do. <asp:GridView ID= "gvInvolves" runat= "server" AllowSorting= "True" AutoGenerateColumns= "False" DataKeyNames= "InvolvesID" Width= "750px" OnRowDataBound="gvInvolves_RowDataBound" >

  Posted to Getting Started (Forum) by chanakya01 on 7/2/2009

• Re: session id issue

  In which part of your application you are facing this problem?? Where you are storing the session and retrieving back?? And where you are displaying the details based on the session value?? Give some code sample so that I can get a clear idea...

  Posted to State Management (Forum) by chanakya01 on 7/2/2009

• Re: How to structure this query?

  Select ItemName from Items where Date in ( Select MAX ( Date ) from Items group by ItemName ) This will solve your need. Try this.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by chanakya01 on 7/2/2009

• Re: Checkbox and Checkbox list values

  If it's a bit datatype then u can store only 0 or 1.. If you want to store as true or false then you can store as string in nvarchar datatype.. Note that the value store dwill be a string not a bool because there is no datatype like bool in SQl as in C#

  Posted to Web Forms (Forum) by chanakya01 on 7/2/2009

• Re: how can I check if number field is empty ?

  check if(book.price==0) { //Code for steps to be done if there is no value in book.price } Because Null is only for string datatype and for int,decimal etc its 0.

  Posted to ASP.NET MVC (Forum) by chanakya01 on 7/2/2009

• Re: Assigning validation group to autogenerated buttons

  In your code behind page give btnName.ValidationGroup="ValidationGroupName";

  Posted to Web Forms (Forum) by chanakya01 on 7/2/2009

• Re: how can I check if number field is empty ?

  Where you have declared book.price?? Have you changed its value anywhere?? Try initializing it to 0.

  Posted to ASP.NET MVC (Forum) by chanakya01 on 7/2/2009