Clearify your question again.. give us the scenario. - Happy Coding - Vishal Vashishta

INNER JOIN Table2 t2 ON t1.Column = t2.Column and then take result from SP to a Dataset or Datatable and use .DataSource property of DropdownList - Happy Coding - Vishal Vashishta

Workout on SelectedIndexChanged Event of Gridview, and pick up the SelectedIndex in that Event. - Happy Coding - Vishal Vashishta

I want to generate Excel Worksheet through a SQL Query fired on the table directly export data to an Excel Sheet. - Happy Coding - Vishal Vashishta

I want to get data of a table in to an Excel direct from a SQL Query. Can anyone help? - Happy Coding - Vishal Vashishta

Ok ... but can you make me clear little bit more about the NOLOCK concept,any article you want to refer.? - Happy Coding - Vishal Vashishta

if i apply a NOLOCK on one table in a Stored Procedure then will it be applicable to all other tables consumed in that Stored Procedure too automatically - Happy Coding - Vishal Vashishta

I'm not sure if this is the same thing but in 'the old days' some web site owners would add lots of Anchor Text (links) including their keywords and hide them from humans (by using say white text on a white background) so search engine spiders could see them but they weren't viewable on the page. - Happy Coding - Vishal Vashishta

Make a Tag and then put tags in it... set align property of first three as Left, and rest as center.. Your Job Done - Happy Coding - Vishal Vashishta

DECLARE @TargetDate SMALLDATETIME DECLARE @InitialDate SMALLDATETIME SET @InitialDate = '06-19-2012' SET @TargetDate = '06-25-2012' WHILE @InitialDate <= @TargetDate BEGIN PRINT @InitialDate SELECT @InitialDate = DATEADD( D, 1, @InitialDate ) END - Happy Coding - Vishal Vashishta

You can use the Case Statement for this: Declare a variable @Client Varchar(100) = NULL, now put Select C.name as Client , @Client = C.name, B.Detail as Detail from tableA A left join tableB B on B.bID = A.bID Left join tableC C on C.clientID = B.clientID where aID= '100'; Now check in Case like this:: CASE WHEN @Client IS NULL THEN ... Put Your Another Select Query Here ... END - Happy Coding - Vishal Vashishta

You can create a Window Service for same. - Happy Coding - Vishal Vashishta

CREATE FUNCTION 'functionname' AS -- -- -- - Happy Coding - Vishal Vashishta

Put it like, CONVERT( VARCHAR, @To AS DATETIME, 103 ) ) - Happy Coding - Vishal Vashishta

SELECT * FROM Applicant WHERE Date_Of_Death > CONVERT(VARCHAR,'30-05-2012',106) - Happy Coding - Vishal Vashishta

Follow: http://www.c-sharpcorner.com/uploadfile/santhi.m/globalizationusingasp.net11262005072116am/globalizationusingasp.net.aspx[^] - Happy Coding - Vishal Vashishta

The function or the Procedure is having some Parameters that are not been provided by your code while making call to that procedure. Note: Signature of Fucntion/Procedure while Defining and While Declaring the fucntion donot matches.

- Happy Coding - Vishal Vashishta

For this you can make Role 1 as Admin or Priorty Role.. which has command over Role 2.

- Happy Coding - Vishal Vashishta

Ok.. you first have to plan out the features you wanna put in your application and then will fix the database structure and start coding modularized way. Rest you can seek assistance any time here at Code Project for any type of stuck outs.

- Happy Coding - Vishal Vashishta

What kind of report you are asking for.. Crystal Report or any other Report Tool.

- Happy Coding - Vishal Vashishta