Hello All, I have a quick question. I'm trying to create a test in the Application Center for my ASP.Net application by using the "Record a new test" option from the Ne Test Wizard, but for no apparent reason ACT doesn't record any thing. Quick Info: - I'm Running Windows XP - ACT in unblocked from the Windows XP firewall - I tried to record a test case from the ACT UI and also by creating an ACT project from the Visual Studio IDE, neither of them worked. - I uninstalled/Re-Installed ACT and still wouldn't record a test. - The ACT is working in the same environment on another machine Any suggestions or comment will be greatly appreciated Thanks in advance.

Hello All Guru, I’m facing a little problem:

• I’m working on a multi tier C#/ASP.NET web application.
• There is a server outside my application that contains some password protected resources that is needed by my application.
• I was able to connect to the resources I need through a SOAP call by passing in the server IP address and the resource username/password.
• Now, the system admin created a login for the server, and provided me with the username/password for the server.
• I can login to the resource through IE, by providing the server IP address and entering the server’s username/password when presented by the login prompt.
• The problem is from my code I can’t reach the resource any more, I presume it is because the extra layer of security that has been added.
• The question now, is how to send the login credentials to the server, and how to access the resource again.

Thank you very much all in advance for all your help.

Hello All, I have a quick question!!! I have an excel file (.xls) with one sheet (Sheet1) with 4 columns, I’m trying to access the data in this file from an ASP.Net application, but no luck. Here is what I did so far

string conString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("ExcelData.xls") + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection con = new OleDbConnection(conString);
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter("Select * from ExcelData", conString);
DataSet ds = new DataSet("ds");
da.Fill(ds);

When I try to run that I get the following error

The Microsoft Jet database engine could not find the object 'ExcelData'. Make sure the object exists and that you spell its name and the path name correctly. 

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.Data.OleDb.OleDbException: The Microsoft Jet database engine could not find the object 'ExcelData'. Make sure the object exists and that you spell its name and the path name correctly.

Source Error: 

Line 55: 			OleDbDataAdapter da = new OleDbDataAdapter("Select * from [ExcelData]", conString);
Line 56: 			DataSet ds = new DataSet("ds");
Line 57: 			da.Fill(ds);
Line 58: 			/// Put the Data Grid Here.
Line 59: 			con.Close();

So, I was wondering if any one have an idea on how to access the data from an excel sheet from an ASP.Net form.? Any help would be greatly appreciated. Thank you all in Advance.

Hello All, I have 2 SQL2000 DBs on the same server, in DB#1 I have a stored procedure from which I need to get a field from a table that exists in DB#2. Any Ideas, Thanks in advance

Actually I'm looking for a way other than Crystal Report, because I can't use Crystal Reports for other reasons. So, is there any other way to acomplish that. Thanks

Hello All, I’m facing a little problem; I’m working on a .net web application with ASP.Net and C#. The Application ends up generating a standardized formatted report that the user needs to print. I have the report in a way that the contents of each intended page are in a separate panel. The problem now is: 1- Making/formatting each panel (virtual page) to fit in exactly one printable page (standard letter size paper) 2- Enforcing a page break between each two panels, they don’t print continuously Any ideas or suggested controls, any help is greatly appreciated Thanks in Advance.

Thank you..

Hello All, I have a SQL 200 DB in place, but now I want to run a script or SP that will give me as an output the name and data type of all the columns in one of the tables. Any Ideas? Thanks in Advance.

Hello, Thank you all very much for your fast response. - For keeping the object in the Session, this is out of the question because the business objects are large. (That is actually why I posted this question; I was looking for a way other than the Session) - For the ViewState: that is a really good suggestion, I know that for the web controls you can access and keep the state from the ViewState, but can you shed some light ( few hints or a quick example) on how to accomplish the same for my business objects, I would really appreciate it. Thanks again,

Hello All, I've a quick question. I'm developing a Multi tier web application with the business logic class separate from the ASPX pages. Now, what I'm having a problem with is: when a declare an instance of a business class in the code behind, this object gets destroyed and re-initialized every time the page gets posted back, what I'm looking for is a way to keep the object as is after its initial initialization so I don't loose the information contained in it. Thank you all in advance PS. The reason behind this, I have one main aspx page from which I load and unload several user controls, and before unloading any user control I gather its information and put in the business class.

Hello all, I writing several user controls for a ASP.NET in C#. I want to get all the controls to be able to raise the same event, how can I do that? More info: The problem I’m facing is: I defined the delegate under the name space so it can be seen from any class, but the events are defined within the class scope. Now the problem is when the user control tries to raise the event, I found that the event is null (it hasn’t been constructed). Any help is highly appreciated Thanks

Thank you for your reply

Thanks for your reply, Actually, an id is what I have. Here is a snippet of code of what I have <form id="Form1" method="post" runat="server"> **<asp:textbox id="txtNumber"** _onkeyup="return txtQuoteNumber_onkeyup()"_ style="Z-INDEX: 101; LEFT: 24px; POSITION: absolute; TOP: 32px" runat="server" AutoPostBack="True"> </asp:textbox> **<asp:textbox id="txtFrmClient"** style="Z-INDEX: 104; LEFT: 400px; POSITION: absolute; TOP: 40px" runat="server"></asp:textbox> **<asp:textbox id="txtFrmServer"** style="Z-INDEX: 105; LEFT: 400px; POSITION: absolute; TOP: 80px" runat="server"></asp:textbox> **<asp:button** id="btnGet" style="Z-INDEX: 102; LEFT: 240px; POSITION: absolute; TOP: 32px" runat="server" Text="Get Quote"></asp:button> **<asp:datagrid** id="dgQuotes" style="Z-INDEX: 103; LEFT: 24px; POSITION: absolute; TOP: 88px" runat="server"></asp:datagrid> </form> now I also have function txtQuoteNumber_onkeyup() { //I want to be able to update one control from the other, for example txtFrmClient.value = txtQuoteNumber.value } Bsically I want to be able to update when another control gets updated, ultimately what I want to be able to do, is from the onkeyup function I want to force the grid to update Thanks for your help

Hello all, I have a couple of questions, 1- How can I reference a server control from within a client side java script block. Say if I have an onkeypress function on the client side for a control named "abc" and I have a control named "xyz" that is a server control. How can I reference "xyz" control from within the onkeypress function? 2- Once I can reference the server side control "xyz", how can I force it to update, or causes a post back from within the same client side function above. Thank you all for your responses,

Thank you for your response, Well, I see what you mean, what drove me to this solution is: I want to update a specific server control each time a character changes in the text box. so if there is a way to do that from within the client side Java script handling the "onkeypress" That would be great. The control I'm trying to update is a datagrid Thank you in advance for your help

Hello all, Another quick question, I was wondering if it is possible to define my own events for a server control (built in controls), and define their event handlers. For example if I have a text box, how can I define and event and its handler for the text box that gets raised every time a character gets add or deleted from the text box, something like "onkeypress" but not from the client side, so I can catch the event and handle it on the server. Thanks all,

Hello all, a quick question, I was wondering how could I force a server side control to update, or postback from a client side script in the same page. What I want to be able to do is, onkeyup for a text box, force another control to update/postback Thanks you in advance.

Hello all, I have a quick question. :confused: I'm trying to populate the data grid based on each character the user enters in a text box. More details: I'm making a user control at which I have a data grid and a text box at which the user enters a customer name for example, clicks a button at which time the results from the database are displayed in the data grid. So if the user entered ‘A’ the data grid automatically displays all the names starting with an ‘A’. then if he adds a ‘B’ the selection is limited to ‘AB’ and so on. The problem I’m facing are, if I used a server side text box even of onTextChange. It only gets invoked after the user enters the entire string and the control loses focus. I also tried to do the following but they didn’t work. 1- tried to use </code> this seems not to work in the user control, it doesn’t even get into the script block <u>2- Tried to use. </u>A client side java script even handler for onkeyup. The problems with the last 2 approaches are that I also can't invoke any thing from the client side that will force the data grid to update on the server side All your help is really appreciated. Thanks all </x-turndown>

Hello all, I have a quick question. I’m working on a web application that takes the user in step-by-step data entry (a wizard like). The menus, top and left, are created as a user control. The question now is: 1- For the actual screens where the user enters the data, is it better to create each screen as a user control then include that control in a web form, or create each screen as a web form with the individual controls (text boxes, buttons, ..etc) as server controls in the web form it self. 2- What are the benefits of each approach, given that each screen will be viewed only once (not reusable) Thanks you all in advance, your opinions are highly appreciated

Hello all, A quick question, I’m working on designing a SQL (7.0) database and for 37 of the tables I have 2 fields that are common between them and I’m using these 2 fields as the primary key for the 37 tables and also as the Foreign key to define the relations between these tables. For example: Project_ID1: part of the Primary Key Project_ID2: part of the Primary key Both of them together form the primary key for the 37 tables because they are the only unique fields within each table. And when I create a relation between 2 of the tables I use these same 2 fields as the foreign keys So, I would just like to get your opinion on if that is a correct design or not, I had some people telling me that this is a poor design? Thanks in advance