|
i have created the asmx code for the webservice and it works fine. it sends the data that i need to the database, but when i use the code behind page to send the information to the webservice, it does not send anything to the service even though the names are all correct etc.
please can someone send me the code for a code behind page to to a basic webservice so i can see if i have the wrong code.
ie.
if my webservice is sending a firstname to a database and i want the code behind page to take the text from a textbox and insert it into the database
thanks
Daniel
|
|
|
|
|
The code behind code is no different to any other app code that calls a database. Where is your code falling down ? Does the webservice call occur ? What happens ? Why do you need a webservice, are they not on the same server as each other ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
this is what happens. i have a create account page where i need to invoke the users details into my database, the webservice side works well on its own when i test it but running just the asmx page, but as soon as i use the webpage to pass the values to the service, it throws an error. so i assume there is an error in my code behind?
|
|
|
|
|
what is the error ? hard to comment without seeing the code.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
if u want i can post the code?
here's my error
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.OleDb.OleDbException: Could not use ''; file already in use. at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at CreateAccountService..ctor() --- End of inner exception stack trace ---
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.OleDb.OleDbException: Could not use ''; file already in use. at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at CreateAccountService..ctor() --- End of inner exception stack trace ---
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.OleDb.OleDbException: Could not use ''; file already in use.
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at CreateAccountService..ctor()
--- End of inner exception stack trace ---]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1485
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +218
CreateAccountService.Sign(String FName, String Sname, String IDNum, String address, String ContactNum, String email, String pass, String secretQ, String answer) +171
CreateAccountCodeBehind.Submitbtn_Click(Object sender, EventArgs e) +226
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +83
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
|
|
|
|
|
Interesting - can you step into the webservice and see what line causes it ? Could it be the connection string is broken ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
well the webservice works when i run the asmx page? not sure how to step through it
|
|
|
|
|
attach the debugger to the process, then call it.
It's really hard to say more without seeing code.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
the error said it was an invalid method... i dont know why
this is the code behind:
//////////////////////////////////////////////////
using System;
using System.Collections;
using System.Data;
using System.Data.OleDb;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public class CreateAccountCodeBehind : Page
{
protected TextBox FirstNameTB; //declaring the objects that are used within the aspx page and need coding
protected TextBox SurnameTB;
protected TextBox IDTB;
protected TextBox AddressTB;
protected TextBox ContactNumTB;
protected TextBox EmailAddTB;
protected TextBox PasswordTB;
protected TextBox ConfirmPasswordTB;
protected TextBox AnswerTB;
protected DropDownList QuestionList;
public void Submitbtn_Click(object sender, EventArgs e) //creating the new instance of the webservice and using the correct parameters
{
string First = FirstNameTB.Text;
string Surn = SurnameTB.Text;
string ID = IDTB.Text;
string Add = AddressTB.Text;
string con = ContactNumTB.Text;
string em = EmailAddTB.Text;
string pa = PasswordTB.Text;
string qu = QuestionList.SelectedItem.Text;
string an = AnswerTB.Text;
CreateAccountService SignUp = new CreateAccountService();
SignUp.Sign(First, Surn, ID, Add, con, em, pa, qu, an);
Response.Redirect("LoginPage.aspx");
}
public void ClearBtn_Click(object sender, EventArgs e) //clearing all user-entered fields
{
FirstNameTB.Text = "";
SurnameTB.Text = "";
IDTB.Text = "";
AddressTB.Text = "";
ContactNumTB.Text = "";
EmailAddTB.Text = "";
PasswordTB.Text = "";
ConfirmPasswordTB.Text = "";
AnswerTB.Text = "";
}
}
////////////////////////////////////////
this is the amsx:
//////////////////////////////////////
<%@ WebService language="C#" Debug="True" class="CreateAccountService" %>
using System;
using System.Web.Services;
using System.Xml.Serialization;
using System.Data;
using System.Data.OleDb;
using System.IO;
using System.Collections;
[WebService(Namespace="http://localhost/LocalWebServices/")]
public class CreateAccountService : WebService
{
OleDbConnection conn;
public CreateAccountService()
{
conn = new OleDbConnection(@"provider=Microsoft.JET.OLEDB.4.0;
data Source = c:\\LocalWebServices\\Bank.mdb");
conn.Open();
}
[WebMethod]
public void Sign(string FName, string Sname, string IDNum, string address, string ContactNum, string email, string pass, string secretQ, string answer)
{
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO Customers (FirstName,Surname,IDNumber,Address,ContactNumber,EmailAddress,Passwrd,SecretQuestion,Answer) VALUES ('" + FName + "','" + Sname + "','" + IDNum + "','" + address + "','" + ContactNum + "','" + email + "','" + pass + "','" + secretQ + "','" + answer + "')" ;
cmd.ExecuteNonQuery();
conn.Close();
}
}
|
|
|
|
|
My guess is that the connection is still open between 2 consecutive clicks. You should declare in your service the connection as a member and lock the connection in the Sign method.
|
|
|
|
|
Sorry for the member part...didn't see it there  . But you should still lock the connection because I believe that 2 different objects try to use it. Maybe I am wrong but it wouldn't hurt to try.
|
|
|
|
|
how do i lock the connection?
thanks for the help
|
|
|
|
|
You write something like this :
using System.Threading;
..............
Sign(...)
{
lock(connection)
{
----===Your insertion code===----
}
}
I am fighting against the Univers...
Reference-Rick Cook
|
|
|
|
|
You should also have the connection.Open() and connection.Close() in the same code block. Between 2 method calls there can be a lot of things happening.
I am fighting against the Universe...
Reference-Rick Cook
|
|
|
|
|
I have two classes
public class class1
{
public class1()
{
}
}
public class class2:class1
{
public class2()
{
}
}
class2 inherits class1. So whenever an object is created for class2, will class1 constructor code work ?
|
|
|
|
|
Why don't you put some code in class1, set a breakpoint, and find out ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Christian Graus wrote: Why don't you put some code in class1, set a breakpoint, and find out ?
I can't. because I am not in debugger user list. It's a restricted account.
|
|
|
|
|
You can't debug ? How is that possible ? How/why can it be locked ? I mean, where are you, that you're not allowed to debug ? That's just retarded.
BTW, you can do it with a message box then.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
That's really funny thing. Our system admin thinks that whoever in the debugger list, they will misuse. So no access. Any way I managed with putting messagebox. Thanks.
|
|
|
|
|
Your system admin is a retard. How can you do your job, if you can't debug. I'd raise hell if it were me.
I'm also still amazed that it's possible to block you from debugging your code.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
N a v a n e e t h wrote: Our system admin thinks that whoever in the debugger list, they will misuse.
I'd quit faster than you could say 'power whore'.
|
|
|
|
|
Hello,
N a v a n e e t h wrote: I can't. because I am not in debugger user list.
I have never heard that bevore.
But ok, the answere is "Yes" it will run the base constructor as well.
And it will be worked threw bevor the derived classes constructor
If you have a base constructor which takes parameters, you have to do it like this:
public baseclass(string text, int number)
public derivedclass(string text, int number, .....) : base(text, number)
All the best,
Martin
|
|
|
|
|
|
You are wellcome!
All the best,
Martin
|
|
|
|
|
Hi All,
i am new to asp.net 2.0 please help me.
Exception:A potentially dangerous Request.Form value was detected from the client (ctl00$ContentPlaceHolder1$txtCompanyType="&#").
while enter special charecters in textbox how to validate this combination '&#' using regular expression pls help me in this .
Thanks And Regards,
Guru.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
