lets say for example i have a mysql query in vb
ex.

db.open(select * from student,con)

I want to display all the data that are in database and count the number of data rows that are there...

is there any way to count rows using only vb.net codes?

Thanks...jimbluberg,jdavi134,JackOfAllTrades and #define...for your contribution...

I get it ...not using replace method...
but this...

int b,flag=0;
for(b=0;b<5;b++)
{

if(empidno[b]==empid)
{
for(d=0;d<empname[b].size();d++)
{
if(empname[b][d]=='_')
{
empname[b][d]=' ';
}
}
cout<<"Name: "<<empname[b]<<endl;
cout<<"Salary Grade: "<<empsalgrade[b]<<endl;
flag=1;
}
else if(flag!=1)
{
cout<<"Employee does not exist"<<endl;
}


}

Sorry its an typographical error....yeah your right...

is this correct??

while(int c=empname[a].find("_"))
{
empname[a].replace(c,1,"_");
}