That is one hell of a query. I see that you do use the parameter @curtrans_no in your query. Is that a typo when the "@" shouldn't been there? If not, then you need to supply a value for that parameter by adding a parameter to your MySqlDataAdapter.Parameters collection and assign a value for it.
My suggestion: rewrite your query so that it's easier to read. Use parameters instead of string concatenations.