Database

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