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.

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.

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.