Database

CREATE PROCEDURE [dbo].[SelectItemList] 
	@ColName string,
	@FieldName string,
        @FieldValue int
	
AS
BEGIN TRANSACTION
	SELECT @ColName FROM ItemList where @FieldName = @FieldValue 
 
COMMIT TRANSACTION

ID     Name     Price($)      
1      Bag      20
2      Fabrics  35
3      Tools    100

CREATE PROCEDURE [dbo].[SelectItemList] 
	@ColName string,
	@ID int
	
AS
BEGIN TRANSACTION
	SELECT @ColName FROM ItemList where ID = @ID
 
COMMIT TRANSACTION

Name
-----
Bag

Column1
--------
Name
Name

Dhyanga wrote:

I don't know whelther we can send fieldname as input parameter to get the value of that field.

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

string colname;
int ID;
string query;
.
.
.
query = "select " + colname + " from ItemList where ID = " + ID ;
SqlCommand cmd = new SqlCommand(query, sqlconn);
.
.
.
.

Dhyanga wrote:

I don't know whelther we can send fieldname as input parameter

Dhyanga wrote:

i can just execute it without using stored procedure

CREATE PROCEDURE [dbo].[SelectItemList]
    @ColName string,
    @ID int

AS
BEGIN TRANSACTION
    SELECT @ColName = ColumnName FROM ItemList where ID = @ID 

COMMIT TRANSACTION

CREATE PROCEDURE SelectItemList
(
     @ColName string,
     @ID int
)
AS

     DECLARE @sql NVARCHAR(4000)

     SET @sql = N'SELECT ' + @ColName + N' FROM ItemList where ID = ' + CAST(@ID AS VARCHAR(10))

     EXEC sp_executesql @sql

lalitN wrote:

How we make the .mdf file of a database ?

Bastard Programmer from Hell