ASP.NET

Sam Xavier13-Dec-07 22:33

Sam Xavier

13-Dec-07 22:33

Are you using the inbuild extender controls?
If not, have you created your own extender control?
Do let us know this info so that we can move forward..

Best Regards,
Sam Xavier
www.componentone.com

Agweet13-Dec-07 22:53

Agweet

13-Dec-07 22:53

Im using interior controls, its a filterTextBoxExtender.

living life on the flip side

Sam Xavier14-Dec-07 0:23

Sam Xavier

14-Dec-07 0:23

Are you rendering the controls? If yes, try to use Controls.Add method and see if it helps.
The follwoing link should resolve this issue:
http://weblogs.asp.net/scottgu/archive/2006/11/26/tip-trick-how-to-register-user-controls-and-custom-controls-in-web-config.aspx[^]

Best Regards,
Sam Xavier
www.componentone.com

Crystal Reports in asp.net 2005

Agweet14-Dec-07 0:56

Agweet

14-Dec-07 0:56

Thanks alot for all your help, i will check out that link now and give feed back.

Thanks a mil Big Grin | :-D

living life on the flip side

zareee13-Dec-07 0:46

zareee

13-Dec-07 0:46

Hi,

i have created a dataset named Dataset1.xsd
i have added a new crystalreport file to my apps named CrystalReport.rpt
i have configured the same with my dataset.
I get the tables n columns of my dataset in the FieldExplorer
I drag n drop the required columns in my rpt file

Then in my webform i drag n drop the crystalreportviewer
and map the CrystalReport.rpt source as the source for viewer.

When i execute i get this...

The report you requested requires further information
Dataset1
Server :Dataset
Database:
Username:
Password:
Integrated Security
and a logon button

can nebody help me???

zari

Re: Crystal Reports in asp.net 2005

zareee13-Dec-07 19:33

zareee

13-Dec-07 19:33

Does no body knows whats the pbm??

zari

Re: Crystal Reports in asp.net 2005

Elizma13-Dec-07 19:47

Elizma

13-Dec-07 19:47

Hi,

1. Tell me, when you created your report, did you use the dataset that you created, or did you connected directly to the database?

2. When creating the Dataset, dropping the tables from the database on the dataset, have you deleted the fill objects at the bottom of the table?

3. Have you created an instance of your dataset and fill the tables in the dataset with the code from the database?

4. Lastly you have to set the datasource for this report to the dataset instance that you created and filled.

Let me know if you need assistance. I struggled myself with this in the beginning.

Kind Regards,

Elizma

How to get it?

Imran Khan Pathan12-Dec-07 21:05

Imran Khan Pathan

12-Dec-07 21:05

Hi friends
I have one table called attributes
Fields like this

ID qty1 price1 qty2 price2 qty3 pirce3 qty4 price4 qty5 price5.....
1 1 20 10 15 50 10 100 8 200 6

If I enter qty 5 thens it returns prices 20 and 15 and if I enter qty 150 it returns prices 100 and 200.

Can any know sql quiry for this?
or
How to do it using code in asp.net if I get all records of each row?

thanks in advance

please don't forget to vote on the post that helped you.

Abhijit Jana12-Dec-07 21:45

Abhijit Jana

12-Dec-07 21:45

Hi Imran, can you cleary mention your table. I am not able to get it .

Best Regards
-----------------
Abhijit Jana
View My CodeProject Articles

"Success is Journey it's not a destination"

Imran Khan Pathan12-Dec-07 22:08

Imran Khan Pathan

12-Dec-07 22:08

Abhijit Jana wrote:
can you cleary mention your table. I am not able to get it .

Look at this

Table Name Attributes<br />
ID     1<br />
qty1   1<br />
price1 20<br />
<br />
qty2   10<br />
prices 15<br />
<br />
qty3   50<br />
prices 10<br />
<br />
qty4   100<br />
prices 8<br />
<br />
qty5   200<br />
prices 6<br />
<br />
qty6   500<br />
prices 4

Now, If I enter qty=5,return prices 20 and 15 (qty 1 to 10)
for qty=75,return prices 10 and 8 (qty 50 to 100)
for qty=250,return prices 6 and 4 (qty 200 to 500)
and so on.....

got it.

Thanks

please don't forget to vote on the post that helped you.

Paddy Boyd12-Dec-07 22:13

Paddy Boyd

12-Dec-07 22:13

Are qty1, qty2... qtyN and prices1, prices2... pricesN columns in your database?

Imran Khan Pathan12-Dec-07 22:15

Imran Khan Pathan

12-Dec-07 22:15

Paddy Boyd wrote:
Are qty1, qty2... qtyN and prices1, prices2... pricesN columns in your database?

No. thers are only 8 columns of qty and 8 columns of prices.

please don't forget to vote on the post that helped you.

Paddy Boyd12-Dec-07 22:21

Paddy Boyd

12-Dec-07 22:21

I think that you should look at your DB design, for two reasons:

1. You are making this very hard to query for yourself.

2. It's not extensible - what happens if your customer wants to add another quantity band - you add another column and update any sql??

I would suggest that you have a table with your ID (I'm guessing that it's a product table) and then another table like this:

ProductID Quantity Price

Where ProductId and Quantity are the combined PK.

So for product 1 you might then have entries in the above table like:

ID Qty Price
1 10 20
1 30 40
1 40 50

And you then want the price for a band, the select statement would be as follows:

SELECT TOP 1 PRICE
FROM ThisTable
WHERE ID = 1
AND Quantity < 15
ORDER BY Quantity DESC

Usharva12-Dec-07 22:16

Usharva

12-Dec-07 22:16

try something like this

select Price from Tablename
where qty =(select top 1 qty from TableName where qty<=5) or
qty =(select top 1 qty from TableName where qty>5)

harunbagwan13-Dec-07 19:16

harunbagwan

13-Dec-07 19:16

hi imran try this

select price from attributes where qty in (select Max(qty) as qty from attributes where qty < EnterValue) Or (select Min(qty) as qty from attributes where qty > EnterValue)

harun

Burning CD in Web Application

harunbagwan13-Dec-07 19:17

harunbagwan

13-Dec-07 19:17

just try this query

select price from attributes where qty in (select Max(qty) as qty from attributes where qty < EnterValue) Or qty in (select Min(qty) as qty from attributes where qty > EnterValue)

harun

arslanjatt12-Dec-07 20:53

arslanjatt

12-Dec-07 20:53

Hi,
I am doing work on a web application in asp.net 1.1. Client want me to place button on web form named as "Burn CD". In simple word he want to burn cd in web application. Let us suppose there is a file on web server. He want to burn that file on CD. Is it possible. Please do help me. If it is not possible then please give me any reference. Thanks in advance.

Arslan Ilyas
.Net Developer
Red Signal

Michael Sync12-Dec-07 20:59

Michael Sync

12-Dec-07 20:59

It's not possible to do for normal public website. (All web developers know that due to the security reason, it's not possible to access the client's system from website.)

But if your client added your website in trust websites and you are also using ActiveX or flash then it is possible.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

arslanjatt12-Dec-07 21:04

arslanjatt

12-Dec-07 21:04

I understand. But, if i want to burn cd on web server not on client then its possible or not. If you have any article or link to article then please let me know. Thanks again.

Michael Sync12-Dec-07 21:20

Michael Sync

12-Dec-07 21:20

arslanjatt wrote:
if i want to burn cd on web server not on client then its possible or not

The case doesn't make sense.

AND

It's not possible.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

N a v a n e e t h12-Dec-07 21:30

N a v a n e e t h

12-Dec-07 21:30

Michael Sync wrote:
It's not possible.

I haven't used, but I think XPBurn[^]can do that.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Paddy Boyd12-Dec-07 22:14

Paddy Boyd

12-Dec-07 22:14

Yeah indeed. But who's going to sit on the server and load all the CD's as required??

N a v a n e e t h12-Dec-07 22:18

N a v a n e e t h

12-Dec-07 22:18

Yes that's funny

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions