Show dynamic sql result set in Report Viewer - ASP.NET Discussion Boards

welcome to code project Rose | [Rose]

Best Regards
-----------------
Abhijit Jana
"Success is Journey it's not a destination"

Hi,

I need to call a webservice through javascript, i am using scripmanager(http://www.semenoff.dk/en/Code-Corner/ASP.Net.AJAX/WebService-From-JavaScript.aspx[^]....it was succesfful when i use webservice in my project..now i need to use a webservice which is running from another machine....i tried to give path to the serviceReference trough code...the path is something like this(http://165.8.15.10/myServices/WebServiceone.asmx), but couldnt solve it...Javascript throws error that "WebServiceone" is undefined.....i have googled and found that we can use .HTC and solve it..is there any other way? or..can anyone help me to solve this??

I am assuming this code uses AJAX to make the call. I would import the web service using the usual mechanisms so that you end up with a helper class in your project and you just call that.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Hi...thanks for replying.... i have written "ScriptManagerMain.Services[0].Path = autoFillService.Url;" in the Page_load event. where autoFillService is the object of my webservice....but it couldnt help me out..when i debug it.....i am getting the correct path into the path....can u help me ?

thanks,
deep.

To be honest, I answered b/c the question was unanswered, I've not looked at this code. It doesn't use AJAX to make a web service call from code behind ? If it does, I am still all for adding a proper web reference and just calling it, then it's just plain AJAX.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Hi...please go through this URL and read my question...u will understand wat i am asking http://www.semenoff.dk/en/Code-Corner/ASP.Net.AJAX/WebService-From-JavaScript.aspx[
href="http://www.semenoff.dk/en/Code-Corner/ASP.Net.AJAX/WebService-From-JavaScript.aspx" target="_blank" title="New Window">^]....i hope u can suggest something....

Thanks,
deep.

Check this link

http://www.webtips.co.in/javascript/javascript-client-code-to-call-webservice.aspx[^]

Regards,
Webtips - Web Development tips

in aspx page, i have a reportviewer and ObjectDataSource as at below.

   <rsweb:ReportViewer ID="ReportViewer1" runat="server"  Width="100%" > </rsweb:ReportViewer><br />
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" <br />
       SelectMethod="SELECT" TypeName="DataSet1.Expenses"></asp:ObjectDataSource>

in code

 protected void Page_Load(object sender, EventArgs e)<br />
    {<br />
        DataSet ds=new DataSet();<br />
...<br />
adp.fill(ds)<br />
<br />
       <br />
        ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", ds.Tables[0]));<br />
<br />
    }

i'm sure dataset contains a table, but Reportviewer it doesnt show the result,why?

Dont you have to show your dataset in the aspx code?

Dataadapter.SelectCommand=GenerateDynamicSql();

i get SQL command from a function dynamically generated. so i cant add dataset.xsd

[Message Deleted]

This looks kind of trivial. Do you not know any ASP.NET ?

Looks like you can send an SMS by passing it on the URL to this site. So, the first part is just building a string, use a stringbuilder for that.

The second part, you just do a send and see if the response is <success> I think the classes are called HTTPRequest and HTTPResponse.

This is not ASP.NET code, it's just C# code that makes a HTTP request. Doing an ASP.NET page that takes the details to post, is more than can be done in a forum reply, and also trivial.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

thanks...

but i have problem with httprequest or httpresponse
its not working..

Error 8 'System.Web.HttpResponse' is a 'type' but is used like a 'variable'

I guess if you posted the code, I would be able to correct it.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

// the problem is her...
gv_reply = httpRequest(gv_url);

if (gv_reply == "<lt;succes&gt>")
{
' If the reply contains the tag <succes> the SMS has been sent.
Response.Write "The message has been sent. Server response: " & gv_reply
}
else
' If not, there has been an error.
Response.Write "The message has NOT been sent. Server response: " & gv_reply

//To here..

Burim Rama wrote:
gv_reply = httpRequest(gv_url);

What is httpRequest ? What made you think this would work ?

Try this:

http://en.csharp-online.net/HTTP_Post[^]

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

i need to se if my rquest from the page is succses like a posted the first topic in php .. thanks christian.

That's why you do the post of the data and grab the response.

Here is the code from my credit card class, which uses the methods you need to use.

string strPost = transaction.ToString();

StreamWriter myWriter = null;

HttpWebRequest objRequest = (HttpWebRequest)WebRequest.Create((transaction.TestRequest) ? testurl : url);
objRequest.AuthenticationLevel = System.Net.Security.AuthenticationLevel.MutualAuthRequired;
objRequest.Method = "POST";
objRequest.ContentLength = strPost.Length;
objRequest.ContentType = "application/x-www-form-urlencoded";

try
{
myWriter = new StreamWriter(objRequest.GetRequestStream());
myWriter.Write(strPost);
}
catch (Exception e)
{
return null;
}
finally
{
if (myWriter != null)
myWriter.Close();
}

string result = string.Empty;

HttpWebResponse objResponse = (HttpWebResponse)objRequest.GetResponse();
using (StreamReader sr =
new StreamReader(objResponse.GetResponseStream()))
{
result = sr.ReadToEnd();

// Close and clean up the StreamReader
sr.Close();
}

AuthorizeResponse response = new AuthorizeResponse(result);

return response;

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I took over a project and found usercontrols in
the App_Code-directory, now I was wondering, why
put them in App_Code and not just anywhere else.

The only reason I could find was if it was a base-class
and I want other controls to inherit from it.
But if it's just a control that let say shows a logo
with some text, why would I put that control in App_Code

http://johanmartensson.se - Home of MPEG4Watcher

If it's in app code, it must be a control entirely in code, no markup. That would then be where it belongs

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

So as soon as I'm creating a control that uses hyperlink, textbox and so on, It should not be in App_Code.

I found a UserControl with this method in it:

public override void RenderControl(System.Web.UI.HtmlTextWriter writer) <br />
{<br />
   writer.Write("<p><a href="\"/about.aspx\"">" + this.Language[0] + "</a>|<a href="\"/advertise.aspx\"">" + this.Language[1] + "</a>|<a href="\"/contact.aspx\"">" + this.Language[2] + "</a></p>");<br />
}

This feels wrong to me, I would have put it in a normal usercontrol outside App_code and used hyperlinks instead.

http://johanmartensson.se - Home of MPEG4Watcher

If it's code, not a control with an ascx, the App_Code is the only place for it unless you put it in a dll. Otherwise, it's not going to be compiled.

If the person who worked on it before made good choices in what to use, is a different question, that much is true.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

So I should only create a usercontrol in App_Code if I have a good reason for it?
I just can't figure out what that good reason is...

http://johanmartensson.se - Home of MPEG4Watcher

I would tend to put them in a dll for reuse, if I wrote any,

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Absolutely, I would do that to if I were to reuse them.
Could the be any benefits like loading-speed or something if I put the usercontrols in app_code rather than outside?

http://johanmartensson.se - Home of MPEG4Watcher