|
Hi all,
How I can convert this code to a WebMethod in WebService?
This code is here:
Protected Sub Submit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Submit.Click
Dim con As SqlConnection = New SqlConnection(WebConfigurationManager.ConnectionStrings("Articles").ConnectionString)
Dim cmd As SqlCommand = New SqlCommand("SELECT Title, Content FROM tblArticle", con)
con.Open()
Accordion1.DataSource = cmd.ExecuteReader
Accordion1.DataBind()
con.Close()
End Sub
I try to convert this code to webmethod But I couldn't convert it to a WebMethod for WebService and use it in Application.
How I can do this work?
Please help me,
Thank you
Hoda
|
|
|
|
|
Saba02 wrote: I try to convert this code to webmethod But I couldn't convert it to a WebMethod for WebService and use it in Application.
How ? Adding [Web Methods] Attributes with a method does not convert it into a web service.
You can create a separate web service for that, or you can add webservice in your current web application, which will add a webservice.cs file in your app code and do the rest thing by calling the WS.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Thank you,
i have a web service for my project that i connect to data base with it.
i don't have problem with creating web service,but i couldn't create a function for this code.
How i can return result and use it in my application?
when i use dataset i returned dataset:
<webmethode()>
Public Function getusers() as DataSet
dim da as new sqldataadapter
dim ds as new dataset
.
.
.
.
da.fill(ds,"Tbl")
return ds
end Function
and i use this code in my application:
protected sub btn1_click(....................)
dim ws as new localhost.service
gridview1.datasource=ws.getusers()
gridview1.databind()
end sub
now i have that code for submit button , only i don't know how i can write it in webservice instead of application?
<WebMethod()> _
Public Function FillAccordion() as ?????????
Dim cn As New SqlConnection
Dim cls As New ClsGeneral
cn.ConnectionString = cls.GetConnection
cls = Nothing
Dim cmd As SqlCommand = New SqlCommand("SELECT Title, Abstract FROM Articles", cn)
cn.Open()
cmd.ExecuteReader()
cn.Close()
return ????????
End Function
i couldn't write that code using function in web service and use function in submit button!
Hoda
modified on Tuesday, April 14, 2009 8:47 AM
|
|
|
|
|
Hi all,
Is there a way that i can use inline and attachment at the same time in content-disposition for Response Headers?
i have code like this
HttpContext.Current.Response.AddHeader("Content-disposition", "inline; filename=__aaa.pdf");
I want to open the file first in the browser and then open the dialog box for download as well.
How can i do that?
I tried to AddHeader again after that line of code and replaced the "inline" with "attachment", but that didn't work.
Please help me.
Thanks alot!
-ewin 
|
|
|
|
|
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("Content-Disposition", "attachment;filename=Report.xls")
Response.Write(l_objStrBuilder.ToString)
Response.Flush()
Response.End()
try this way is help ful or not 
|
|
|
|
|
Dear all,
I want to know how to send automatic email notification taking email address from database and send each one ema  il according to there status for eg :- Choose email from database of status 1 and send them birthday message and for status 2 membership end message etc and each message template can also be picked by database.
As this can be done on regular basis, I know it can be done by window service but how it can be used with c# and sql server 2005
If any one of you have code than Please Post it.
Thanks u all for your support
RAHUL TANDON
|
|
|
|
|
rahultandon1000 wrote: As this can be done on regular basis, I know it can be done by window service but how it can be used with c# and sql server 2005
So, what is you problem ? You want to create a Windows services which will regularly check your database and send the notification mail to the user ?
If yes, then what is the point to post this question in ASP.NET Forum.
You have to create a simple web service, which will call Some SP of of SQL server and retrieve the data from database.
By the way you can do all the thing only using SQL server 2005 also
|
|
|
|
|
hello,
i want to pass parameters in a POST mode from a .NET page to other page.
i heared about : Server.Transfer("xxx.asp",true);
can i have guidelines on how to use it ?
tnx in advance ,
avi
|
|
|
|
|
Server.Transfer("xxx.asp?paramname=paramvalue",true);
and your xxx.aspx page_load event read parameter value like
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dim str as string=Request.QueryString("paramname")
End Sub
i thing is helpful 
|
|
|
|
|
This is true and probably sufficient for many cases, but be aware you are changing from POST to GET and then have the limitations of the querystring, such as: maximum of 2083 characters in the URI(This is IE, not sure for FF/Opera/other), and of course there are potentially security risks if you are sending any sensitive data it will be shown and can be easily altered by the end user.
If you are trying a to re-post without relying on the querystring to a different page in your application there are probably workarounds (maybe by populating fields on an intermediate page, or manually building a response...then having one of them autopost to your ultimate target?) But I have never tried these before.
|
|
|
|
|
i need Administrator of my website to add forms at runtime. is it possible to add webforms at runtime. if yes then how.
|
|
|
|
|
S_Aijaz1 wrote: is it possible to add webforms at runtime. if yes then how.
Google Says
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
i have added page dynamicaly now i need to add controls to these pages dynamically with setting properties and default values
|
|
|
|
|
Hi friends,
When I retrieve some text from database, a Long line be created in my control and a horizontal scroll be created.
I want this long line be shown in multi line.
How I can solve this problem?
Thank You
Hoda
|
|
|
|
|
You could either:
1.) Store the text with new line-seperators
2.) or set your textbox as multiline and wordwrap
Regards
Sebastian
|
|
|
|
|
Thank you,
Please give me more information about line-seperators.
i used Wrap but my poroblem not solved.
Hoda
|
|
|
|
|
I have written a web service that reads from a message queue. This works fine under Cassini.
Now that I have deployed the service under IIS, I receive an error message when the service tries to access the queue:
The queue does not exist or you do not have sufficient permissions to perform the operation.
I have set the anonymous access user on the IIS virtual directory to be my own domain account, which is a member of the administrators group on the local machine. I have granted this same user full permissions on the queue, as well as NETWORK SERVICE and ASPNET.
I still get the same error message (The queue does exist and the spelling is correct).
I have also tried disabling anonymous access on the virtual directory and connecting to the service using my own login details - to no avail.
Any help with this problem will be greatly appreciated!
I have also tried various combinations of: Windows authentication, impersonation, local users, domain users, all of them having full permissions on the queue. I have added permissions for the user and ASPNET on the MSMQ store folders on C:\
|
|
|
|
|
BillyGoatGruff wrote: The queue does not exist or you do not have sufficient permissions to perform the operation.
I have set the anonymous access user on the IIS virtual directory to be my own domain account, which is a member of the administrators group on the local machine. I have granted this same user full permissions on the queue, as well as NETWORK SERVICE and ASPNET.
Do the following :
1. Create A Application Pool In IIS (Say MSMQWEBAppPool)
2. Change the Identity of Application Pool To Local System ( Default > NetworkService )
3. Write Click You Virtual Directory, Select the MSMQWEBAppPool Application Pool from Application Pool Dropdown list.
4. Click on Apply.
Then Test your application.
Its is because, by default your you web sites run under default application pool, which identity is "Network Service" and which has very minimum privilege on the server. Local System having the higher privilege on you system.
You may face the same problem, while loogin error on Event viewer
So, Try, and Let me know the result.
Hope this will help you
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Thanks Abhijit,
Your understanding of the problem is pretty close, in that the process trying to execute the code is running as a different under IIS than it does under Cassini.
I am using IIS 5.0 and so I cannot create a separate app pool, although I can alter bay various means the user that the code runs as.
The problem was that regardless of which user I ran it as - I always got the same error message - even when the user was a member of the local and domain administrator groups, and this user had full permissions on the queue. i.e. It is barely possible to assign more rights to a user.
It turns out, that using a FormatName for the queue, rather than a path name (myMachine\queueName) has solved the problem...
FormatName:DIRECT=OS:myMachine\myQueue
I am uncertain as to exactly why this is the case. Reading up has showed that when a path name is used, there is a necessity for an AD lookup, and although I think that the users that I have been testing with should have rights to do this, perhaps there is something missing.
However the immediate problem is solved and that's good enough for me.
Thanks very much for your response.
|
|
|
|
|
|
|
how we create a login page in which we enter a user name or password,so i want the coding for that in c#
|
|
|
|
|
pallavi shrivastava wrote: how we create a login page in which we enter a user name or password,so i want the coding for that in c#
You can use ASP.NET Login Control
Or you can write your custom code using two text box, one of them will take username and another will take the Password. On Click of login button validate the user id and password from Database( If you have stored user info there else any other place ).
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
look at your OS login Form and add a web form and design it just like that
|
|
|
|
|
pallavi shrivastava wrote: code to create login page
First of all welcome come to Code Project.
Before posting a questions , you should read the forum guide line that how to ask question.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
