prob in column index

arkadeep...

SOLVED CLOSED ACTIVE ANSWERED
User: arkadeepde
Posted: on Jun 13, 2014 12:00 AM
Forum: ASP.Net Web Forms
Replies: 1
Views: 2154

Id name

1 xyz

2 pqr

5 mnp

3 iuy

4 lkj

in a sql table like this how to get the coloumn index of a perticular name....

like out put will be for "mnp" index is 3....(not according to id)

what will be the sql query

or if it is a datatable then what will be the code to find the column index...

Download FREE API for Word, Excel and PDF in ASP.Net

Azim

0 1

Reply
User: Azim
Replied: on Jun 13, 2014 12:30 AM
Report

This is for SQL

WITH MyTable AS
(
SELECT EmployeeId,FirstName,  ROW_NUMBER() OVER(ORDER BY EmployeeId) AS Row    
FROM Employees 
)
SELECT Row
		,EmployeeId
		,FirstName     
FROM MyTable 
WHERE FirstName    ='Robert'

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

prob in column index

Company

Explore

Follow us

Contact Us