string str=DoNumberMethod();
sqlCommand cmd=insert into item values('"+txtItemNo.Text+"' , '"+txtQty.Text+"' , '"+txtDescription.Text+"' , '"+str+"' , '"+txtDoDate.Text+"')", sqlCon);
the return type for the method should be string :
public string DoNumberMethod()
{
}