How to protect particular table from viewing users

Question

Hi friends,

I want to protect particular table through password or by restrricting user from watching the sensitive data.

Is it possible to give password to table or sql database ? We can give pasword to Ms Access file. can  we done in sql database? 

Plz give me solution?....

Answer 1

it shows me this error : localhost.SqlParameter does not contain a constructor that takes 2 arguments

 

in

param[0] = new localhost.SqlParameter("KeyWord", b[1].ToString());

this line...

 

 

Answer 2

Hi u can try like this

 

localhost.SqlParameter[] param = new localhost.SqlParameter[2];

param[0] = new localhost.SqlParameter("KeyWord", "Testing");

param[1] = new localhost.SqlParameter("PageSize", 20);

var objGetDetail = Obj1.GetDetail("SP_Related", param).Tables[0];