C# Discussion Boards - CodeProject

Christian Graus2-Aug-07 22:38

2-Aug-07 22:38

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 )

Daniel_Logan2-Aug-07 23:02

2-Aug-07 23:02

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

Christian Graus2-Aug-07 23:09

2-Aug-07 23:09

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 )

Daniel_Logan2-Aug-07 23:11

2-Aug-07 23:11

well the webservice works when i run the asmx page? not sure how to step through it

Christian Graus2-Aug-07 23:23

2-Aug-07 23:23

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 )

Daniel_Logan2-Aug-07 23:46

2-Aug-07 23:46

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();
}
}

Albu Marius3-Aug-07 0:00

3-Aug-07 0:00

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.

Albu Marius3-Aug-07 0:10

3-Aug-07 0:10

Sorry for the member part...didn't see it there Roll eyes | :rolleyes:

. 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.

Daniel_Logan3-Aug-07 0:35

3-Aug-07 0:35

how do i lock the connection?
thanks for the help

Albu Marius3-Aug-07 0:44

3-Aug-07 0:44

You write something like this :

using System.Threading;
..............
Sign(...)
{
   lock(connection)
   {
        ----===Your insertion code===----
   }
}

I am fighting against the Univers...
Reference-Rick Cook

Albu Marius3-Aug-07 0:54

Base Class Constructor on Inheritance

3-Aug-07 0:54

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. Smile | :)

I am fighting against the Universe...
Reference-Rick Cook

N a v a n e e t h2-Aug-07 21:14

2-Aug-07 21:14

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 ?

My Website | Ask smart questions

Christian Graus2-Aug-07 21:21

2-Aug-07 21:21

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 )

N a v a n e e t h2-Aug-07 21:24

2-Aug-07 21:24

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.

My Website | Ask smart questions

Christian Graus2-Aug-07 21:29

2-Aug-07 21:29

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 )

N a v a n e e t h2-Aug-07 21:33

2-Aug-07 21:33

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.

My Website | Ask smart questions

Christian Graus2-Aug-07 21:35

2-Aug-07 21:35

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 )

originSH2-Aug-07 21:50

originSH

2-Aug-07 21:50

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'.

Martin#2-Aug-07 21:30

Martin#

2-Aug-07 21:30

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

N a v a n e e t h2-Aug-07 21:33

2-Aug-07 21:33

Thank you Martin

My Website | Ask smart questions

Re: Validation Expression

Martin#2-Aug-07 21:35

Martin#

2-Aug-07 21:35

You are wellcome!

All the best,

Martin

Validation Expression

kinnuP2-Aug-07 20:03

kinnuP

2-Aug-07 20:03

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.

Christian Graus2-Aug-07 20:07