Loading

Select * from tablename where name like '%' + @name +'%' i can't get result.

Vipin Kumar

16y4.9k.NET

hello
i using like command

cmd = new SqlCommand("Select * from corporationtab where industryname like '%@name%'",con) ;
SqlParameter param = new SqlParameter();
param.ParameterName = "@name";
param.Value = a;
cmd.Parameters.Add(param);
rd = cmd.ExecuteReader();
if(rd.Read()
{
while (rd.Read())
{
}
}
here rd.Read() is not read data....
its not working...
this is urgent for me...
please help me.

if someone hav any result please help me.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

vipin saini16y ago
thanks dear..i will try
Sham T16y ago
check if rd ! = null before while loop

...
cmd = new SqlCommand("Select * from corporationtab where industryname like '%@name%'",con) ;
SqlParameter param = new SqlParameter();
param.ParameterName = "@name";
param.Value = a;
cmd.Parameters.Add(param);
rd = cmd.ExecuteReader();

if(rd != null)
{
while (rd.Read())
{
}
}

Check this one....