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.
abhilala 0 Newbie Poster
dspnhn 10 Junior Poster in Training
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 0 Light Poster
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.