data type converting in database

then Use it

Create PROCEDURE sp_Get_CustInfoInRecPay

(@ColumnName VARCHAR(50)=null,

@Value VARCHAR(50)=null)

AS

BEGIN

DECLARE @cmd AS NVARCHAR(max)

SET @Value = ''''+@Value+ ''''

SET @cmd = N'SELECT

C_Register.UserId, C_Register.Name, C_Register.UserName, C_Register.MobNo,

Area.AreaName, C_Register.Address, C_Register.CreatedDate, C_Register.Status

FROM C_Register join Area on C_Register.AreaId = Area.AreaId WHERE ' + @ColumnName + ' = ' + SELECT CAST(@Value As Int)

EXEC(@cmd)

END

from codebehind we passing string value its true, but in table our column is 'int' so how to convert that parameter to int on condition base?


same error throwing.like below 


Conversion failed when converting the varchar value '101' to data type int.

Create something like this no need of any conversion 
Create PROCEDURE sp_Get_CustInfoInRecPay
(@Condition VARCHAR(50)=null)
AS
BEGIN
DECLARE @cmd AS NVARCHAR(max)
SET @Value = ''''+@Value+ ''''
SET @cmd = N'SELECT
C_Register.UserId, C_Register.Name, C_Register.UserName, C_Register.MobNo,
Area.AreaName, C_Register.Address, C_Register.CreatedDate, C_Register.Status
FROM C_Register join Area on C_Register.AreaId = Area.AreaId WHERE  ' + @Condition'
EXEC(@cmd)
END




SqlConnection con = new SqlConnection("yourconnectionstring")
 { 
SqlCommand cmd = new SqlCommand("sp_Get_CustInfoInRecPay", con)
{
string con= txtName.Text+"="+ txtvalue.Text;
 cmd.CommandType = CommandType.StoredProcedure; 
cmd.Parameters.Add("@Condition", SqlDbType.VarChar).Value = con; 
 con.Open();
 cmd.ExecuteNonQuery();
con.close()
 }

 
Post an error if any.

use it

CAST(MyVarcharCol AS INT) FROM Table

 CONVERT(INT, MyVarcharCol) FROM Table

But in table 'UserId' is 'int' type
so how to convert here in sql?

your parameters are varchar so use like
sp_Get_CustInfoInRecPay 'UserId', '101'

and pass from code behing by convert into string()

Use following code

String strConnString =  ConfigurationManager.ConnectionStrings["conString"].ConnectionString;

SqlConnection con =  new SqlConnection(strConnString);

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = " sp_Get_CustInfoInRecPay";

cmd.Parameters.Add("@ColumnName", SqlDbType. VARCHAR,50).Value = LastName.Text;

cmd.Parameters.Add("@Value", SqlDbType.VARCHAR,50).Value = FirstName.Text;

LastName.Text;

 

cmd.Connection = con;

try

{

    con.Open();

    GridView1.EmptyDataText = "No Records Found";

    GridView1.DataSource = cmd.ExecuteReader() ;

    GridView1.DataBind(); 

}

catch (Exception ex)

{

    throw ex;

}

finally

{

    con.Close();

    con.Dispose();

}

just use like as below

SqlConnection con = new SqlConnection("yourconnectionstring")
 {
SqlCommand cmd = new SqlCommand("sp_Get_CustInfoInRecPay", con)
{
 cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ColumnName", SqlDbType.VarChar).Value = txtName.Text;
cmd.Parameters.Add("@Value", SqlDbType.VarChar).Value = txtvalue.Text;
 con.Open();
 cmd.ExecuteNonQuery();
con.close()
 }