Ajax Post XMLHttpRequest take long time - ASP.NET Discussion Boards

Hey Rekha,

Did you run aspnet_compiler from the same location as you run MSBuild? Same path and same machine? Is there any UNC share invloved when you saw the error? If so, you might need to run caspol.exe (in the framework installation location) to grant permission to the share.

Regards,

Satips. Rose | [Rose]

I have following stored Procedure. I am writng following ado.net code
to get return value from stored procedure but it doesn't work.

String constr =
System.Configuration.ConfigurationManager.ConnectionStrings["twcsanConnectionString"].ConnectionString;
SqlConnection objConn = new SqlConnection(constr);
string sqlstmt = "usp_Update_tbtickets";
SqlCommand objCmd = new SqlCommand(sqlstmt, objConn);
objConn.Open();

//objCmd.ExecuteNonQuery();
SqlDataReader sqlDr;
sqlDr = objCmd.ExecuteReader();
while (sqlDr.Read())
{
Session["TCKid"] = Convert.ToInt32(sqlDr.GetValue(0));
}
sqlDr.Close();
objConn.Close();

CREATE PROCEDURE [twcsan].[usp_Update_tbtickets]
-- Add the parameters for the stored procedure here

AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
DECLARE @id INT

SET NOCOUNT ON;
SET @id = (select top 1 ticketid from tbtickets where TcktStatusid
= 1)

update tbtickets
Set tcktopened = GetDate(), TcktAudited = GetDate(),TcktStatusid =
2
where ticketid = @id and TcktStatusid = 1

Return @id
END

seema

you can use out parameter to get the returned value or you have to do the following.

int tickedID = 0;
tickedID = Convert.ToInt32(SqlHelper.ExecuteScalar(connection string, command type, command text, parameters));

Thanks
Warm Regards
Prakash-B

Hi,
I don’t know if I am posting this message in the right forum, but any way here is my problem. We have developed an application in .Net which runs on the SmartPhone. The application runs fine but we could not able to do one thing, that is, the application should read the cell phone number from the SIM card on which it is installed. I need help on this, If you can provide code, it will really help us.

Thanks in Advance
Kuber

Hi,

I want to know what is the difference between the Membership and MembershipProvider classes? The reason why I ask is because they both have a CreateUser method.

I hope someone can shed some light.

Regards
ma se

Please some body let me know how to declare, instaciate and create a two dimensional arraylist
Thanks in Advance

Try using Array instead, Arralist is a collection.

hello i dont know where i had to post this
I have a postonly.html page which send a "POST" xmlhttprequest at register.php

my problem is while query is complete (and table is updated) extremly fast(1-2 sec) as i can see
my database via Putty.exe

Responce of the

if(http.readyState == 4 && http.status == 200) 
			{
				alert(http.responseText);
			}

is takes about 15 sec (so the alert box pop up)

anyone knows any suggestion so it would be response faster? (my get method Ajax works fine and fast)

<code><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> 

<html> 
<head> 
    <title>Customer Account Information</title> 
    <script type="text/javascript"> 
	function postForm()
	{
		//var httppost = new getHTTPObject(); 
		var url2 = "register2.php";
		var params = "account=testisok&email=yeah";

		http.open("POST", url2, true);

		//Send the proper header information along with the request
		http.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
		http.setRequestHeader("Content-length", params.length);
		http.setRequestHeader("Connection", "close");
		
		http.send(params);
		http.onreadystatechange = function() 
		{
			
			if(http.readyState == 4 && http.status == 200) 
			{
				alert(http.responseText);
			}
		}		

	}

function getHTTPObject() { 
  var xmlhttp; 

  if(window.XMLHttpRequest){ 
    xmlhttp = new XMLHttpRequest(); 
  } 
  else if (window.ActiveXObject){ 
    xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); 
    if (!xmlhttp){ 
        xmlhttp=new ActiveXObject("Msxml2.XMLHTTP"); 
    } 
    
} 
  return xmlhttp; 

  
} 
var http = getHTTPObject(); // We create the HTTP Object 
</script> 
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head> 
<body> 
    <p>Enter customer ID number to retrieve information:</p> 
    <p>Account: <input type="text" id="account" value="" /></p>
    <p>E-mail :<input type="text" id="email" value="" /></p> 
    <p><input type="button" value="Register" onClick="postForm"/></p> 
    <div id="divAccountInfo"></div> 
</body> 
</html></code>

Peace be upon you all
I have a time consuming method and I call it many times in my code.
Every time I call this method it hangs the system.
I need to call this function every time in a background thread, but I need to call it in the same thread every time.

Help me please.

have a stored procedure which is returning an int. Could you
pleasde give me ADO.Net code that how can I retrieve the returning
value from from stored procedure in aspx page and put that returning
value in a variable.

seema

Your procedure is returning int, you can get that in a table (adapter.fill(table) method) which will have one column and a row. and the you can access that int value using
int value = table.row[0];

If I have a gridview containing products it automatically adds the page numbers to the bottom row and when the user clicks the number a postback is done and they are taken to page X listing the other products.

I'd like to make it more search engine friendly so that it doesn't do a postback to get to the next page of items in the gridview. Is that possible?

Only by either displaying all the data at once or implementing AJAX methods. The latter case would not be search engine friendly either.

only two letters away from being an asset

hello all
I am using VS2003 and Sql server2000
how to create install shield to deploy my web application and auto create SQL server database and auto install .net framework and do the configuration to IIS automatically

please help me by sample code and some websites that describe this topic

Regards

ABDULLAH

one way is create a batch file which contains the sql query to create the database stuff and attach the batch file to run along with the installation shield for this you have known the user id and password coz its going to be hot coded.

Another way is create a windows application for creating database stuff and attach that exe to the installation shield.

as per my suggestion i ll go for creating windows application for creating database stuff. because we can get the sql server name, user id, and password from the user (in case there no database server installed in the machine we can handle that) and we can configure the web.config file thru this windows application.

Thanks
Warm Regards
Prakash-B

I use one contentpage of my MySite.Master page as an Error-page. How do I redirect from that page to any other page after 5 seconds.

_____________________________

...and justice for all

APe

Either using a meta redirect or through javascript with setTimeout(funciton, time). Of course you should always provide a plain hyperlink in case the browser doesn't support either of these methods (or they don't want to wait 5 seconds)

But where do I insert a meta-tag or a script in my contentpage?

My content page look like this:

<%@ Page Language="C#" MasterPageFile="~/NFI.Master" AutoEventWireup="true" CodeBehind="Error.aspx.cs" Inherits="NFIWWW.Error" Title="::: :::" %><br />
 <br />
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">    <br />
    <h2>Error</h2>    <br />
    <p>...</p><br />
</asp:Content>

_____________________________

...and justice for all

APe

Hi,

I need some input here. I am looking for a common/general/global word for membership, profile, personalisation, roles, users, etc.

Anyone with any ideas?

Regards
ma se

Is there a way to find out what a user's default Media player is? We are running into a instance where Windows Media Player acts different that QuickTime Media player where WMP opens up in a new window to where QT opens up in the current window. Any kind of insight would be great.

One possible solution is to read the registry for version #

Hi, can anyone please tell me how i can read from a global resource file in my javascript function? I need to show the message which will be there in a resource file on alert message.

Can anyone tell me ?

deep7 wrote:
how i can read from a global resource file in my javascript function?

I think you can't do this. You can take this value at the server side and put that to hidden textbox. Then you can show this message with javascript alert

Sincerly
Navaneeth
My Website

yes even i think that...thanks a lot Smile | :)

Regards,
Dee

There is no need for a hidden field. The text can be placed in a javascript variable during page load or init.

only two letters away from being an asset