Data Environment plus SQL Parameter in VB

[abhilala]

how to pass two parameters using a dataenvironment.
I have a table salary record in which there are two coloumns date and unit, i want to pass these parameters at run time.

[dspnhn]

for date format the value to mm-dd-yyyy or mm/dd/yyyy and put it in a variable named through dataenv. similarly put a variable for unit through dataenv and simple use the var in sql when executing ur query.

This will give u a fair idea what i m talking bout

article 244779 at microsoft - HOWTO: Refresh a Parameterized DataReport.

[Bashir ahmad]

sir

U have two parameters and while preparing the dataebvironment, U have to use a statement like " select * from salary where date=? and unit=? and thenin the click event of a button u enter the code as follows:
<code>
dataenvironment.rssalary mydate,myunit
</code>
where mydate and myunit are the values of parameters obtained through a textbox.

thx