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

More Search Options

RSS Available

• Re: SQL Query

  I think in such case you can try count(distinct(projectid)) select count(distinct(projectid)) ,EmployeeID from employeeprojecttable where ProjectId in(101,102) group by EmployeeId Having count(distinct(projectid)) = 2 try this you will get the result

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

• Re: New Line in Datalist

  i thought you are binding the DataList using SQL Reader..i dont aware abt that you are using dataset.. so if you have status field in the Dataset then no need to use label.but at time of databinding you have to find the status of the CurrentStatus as well as of LastStatus..and just append the text of the check box with <br/> as specified condition.. still if any confution then let me know the structure of your datatable with which you are binding your datalist..so can help you more.

  Posted to Data Presentation Controls (Forum) by Shahnidhi_14 on 4/30/2008

• Re: New Line in Datalist

  I think you require the record in new line if status 1.that is you required checkbox in new line. You are not storing the status anywhere? so just place the invisible lable inside the DataList. < asp:Label ID= "lbl" Text= ' <%# Eval("status") %> ' runat= "server" visible="false" /> and in codebehind private void DataListR _ItemDataBound( object sender, System.Web.UI.WebControls.DataListItemEventArgs e) { if ((e.Item.ItemIndex != -1) &&

  Posted to Data Presentation Controls (Forum) by Shahnidhi_14 on 4/29/2008

• Re: Page.registerstartupscript

  Page.registerstartupscript("startup","<script>functionnameofjavascriptfunction();</script>"); or also write your javascript code in between the <script>

  Posted to Web Forms (Forum) by Shahnidhi_14 on 4/28/2008

• Re: how to use parametes in like statement

  Either pass '%Uday%' from your codebehind or Change your stored proc as follows create procedure searchUser ( @userName varchar(30), ) as begin select * from PhoneDirectory where userName like '%'+@userName+'%' end go

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Shahnidhi_14 on 4/25/2008

• Re: Select TOP

  Here you can declare one variable as NoOfRecordPerPage = 5 (as much records you want to show).and you have to maintaint the value for the current page. select top 5 * from mytable where pkid not in (select top " 5* (CurrentPage - 1) + " pkid from mytable) you can execute above query from you codebehind directly.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Shahnidhi_14 on 4/25/2008

• Re: Check boxes repeating

  In this Procedure if there is any of the table which have 1.n relation i mean to say 1 person have multiple entry in other table in such case this may happen..and if such case i think you cant return all the values from single procedure without repitation or it may happen you are missing to compare any condition..which is related to one other table.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Shahnidhi_14 on 4/25/2008

• Re: SQL Query

  You want emp who is working for 2 dif proj. but for query use have to use IN Bacause as per the table for the single row there cant be the mutiple value.. i mean to say is if you fire the Query select empid from emprj where projectid= 101 and projectid=102 then it will not return the single record. so i think select count(EmployeeId),EmployeeID from employeeprojcttable where ProjectId in(101,102) group by EmployeeId Having Count(EmployeeId) = 2 Here becuase you are doing group by as per you data

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Shahnidhi_14 on 4/25/2008

• Re: Removing duplicate rows

  I think the best way is to not fill the duplicate records in the Dataset. Or if you are using the existig DataSet then you can filter the records and then assign to the source.

  Posted to SQL Server Reporting Services (Forum) by Shahnidhi_14 on 4/25/2008

• Re: Hi Solve This Message box problem

  You can store the Javascript error mesage of client side validation in the Hiddenfield..and then return false..and after completion of your server side validation you can append the value of the hiddenfield with the serverside Message..

  Posted to Client Side Web Development (Forum) by Shahnidhi_14 on 4/25/2008