|
hello all
i'm using report viewer and i need to show data. the report viewer uses some object to get data. i declared the fields i need to use in the report, editing them by hand. if i use textboxes imbedded in list or tables then everything looks ok. but if i try to put a texbox in a rectangle then i cannot choose any field from any dataset. if a copy a textbox with an expression in it and put it in a rectangle then the textbox shows "#error".
what must i do to be able to use datasets for the controls in a rectangle? what is the purpose of rectangle if i cannot link it to data?
|
|
|
|
|
What error it shows?
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
i already told you. it shows "#error", no other details. i observed one thing. i noted that i could not see any field to use with controls embedded in a rectangle. that might be because the rectangle cannot have any dataset. if for example you add a rectangle and then add a list in it, set a dataset for the list then the controls in the list cand select fields. it's a bit strange but at least it works this way.
it can be easily seen that the reportviewer is version 1 and there can be done a lot to improve it, but hey it's better than nothing!
|
|
|
|
|
on the form closing event , i am invoking the cofirmation button , which is having two buttons named ok and cancel.now my question is , the moment i click the cancel button is happens nothing , and while i click the ok button , at that time , can i delete a particular record from the database
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Sonia Gupta wrote: can i delete a particular record from the database
Yes.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
if u can please provide the code.
thanks .
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
I cannot do your work Tell your problem in your code so that we can correct it and help you to solve your problem.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
The basic problem is , i am not being able to place , how i should delete the particular record from the database , when i click ok on the confirmation button.if u please provide the code?
Thank You
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
if you call javascript on button click event then put code on button event.
|
|
|
|
|
it is the window closing button, not the button control.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Sonia Gupta wrote: if u can please provide the code.
thanks .
Hey it's Satips. it have some limitations. He would be glad to provide link than code
|
|
|
|
|
Cool Navaneeth.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Navaneeth please provide any code or link .It is very urgent.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
We cannot provide code for this it is very simple.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
then give the code and prove it......Come on sir(Satips)SSK
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Sonia Gupta wrote: and while i click the ok button , at that time , can i delete a particular record from the database
By confirmation button, do you mean a javascript confirm ? You can do this using a AJAX call. See the code below
if(confirm("Are you sure to close"))
{
return true;
}
|
|
|
|
|
ajax call ? how to do that ?Please help ....If u can please arranege code.Thank You
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Sonia Gupta wrote: ajax call ?
Don't you heard that ? It's just javascript, calling server side methods. http://www.w3schools.com/ajax/default.asp[^] check this to get started.
Alternatively try redirecting to someother page and do the deletion over there. See the below code
if(confirm("are you sure"))
{
window.location.href="YourDeletePage.aspx";
return false;
}
On page_load of this delete page, do the deletion and close the window. But I am not sure on this method, just try your luck. But AJAX method will work as you expected.
|
|
|
|
|
N a v a n e e t h wrote: if(confirm("are you sure"))
{
window.location.href="YourDeletePage.aspx";
return false;
}
Why are you return false here?
|
|
|
|
|
Just to keep window active. else it will be closed.
|
|
|
|
|
|
When you click Ok then it return true.so you can run your code in code behind file and after that the form will be close.
if you have one button to close the window then you can write your code on that button event.it will run on Ok event of message.
Note: if you want to close the parent page then browser also fires one confirm message
bEst rEgard
pAthan
|
|
|
|
|
hi this is RK iam working with webservics in asp.net in that iam trying to use databaseconnectivity iam passing this query in dataadopter " select dtlastupdated,dblvalue from dbo.tblPerodicTickerData where dtDateTime = between 2007-03-28 11:35:09.000 a.m And 2007-04-09 11:40:05.000 a.m"
while using this websrvice in asp.net page iam getting the error like this
"System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'between'."
whAT DO I DO TO RECTIFY THIS ERROR COULD U PLEASE KINDLY HELP ME
OK BYE
|
|
|
|
|
Change your select to:
select dtlastupdated,dblvalue from dbo.tblPerodicTickerData where dtDateTime between '2007-03-28 11:35:09.000' And '2007-04-09 11:40:05.000'
And I think it will work.
There is no = between and I removed the a.m and put quotes around the datetime values.
Hope that helps.
Ben
|
|
|
|
|
yes it is working thak u very much rightfrom morning onwards iam suffering with this problem once thank u very much
|
|
|
|