🚀 go-pugleaf

Thenk you for your response.

I am using AjaxPro 6.5.17.1 http://www.ajaxpro.info/ for .NET 1.1.

This is the Javascript I am using to call the function:
-----------------------------------
<script language="javascript">
function getServerTime()
{
   TBNet.Index.SaveData(document.getElementById('Downloads_Email').value,
        true,
         document.getElementById('Downloads_Fullname').value,
         document.getElementById('Downloads_Organization').value,
         'Test', getServerTime_callback);
}

function getServerTime_callback(res)
{
    alert(res.value);
}
</script>
-----------------------------------

And this is the code I used for the Ajax function:

-----------------------------------
[AjaxPro.AjaxMethod]
public String SaveData(String EmailAddress, bool SendNews,
    String FullName, String Organization,
    String DownloadedFileStr)
{
 int RowNum = 0;
 String CommandStr;

 try
 {
  bdpDataAdapter1.Active = true;
  bdpConnection1.Open();
  BdpTransaction Trans = (BdpTransaction) bdpConnection1.BeginTransaction();

  bdpDataAdapter1.SelectCommand.CommandText = "SELECT * FROM Info WHERE 
Email = '" +
       EmailAddress + "'";
  bdpDataAdapter1.FillSchema(dataSet1, SchemaType.Source, "Info");
  RowNum = bdpDataAdapter1.Fill(dataSet1);

  bdpConnection1.Close();
  BdpConnection Connection = new 
BdpConnection(bdpConnection1.ConnectionString);

  if(RowNum == 0)
  {
   CommandStr = "INSERT INTO Info (Email, SendNews) VALUES ('" +
     EmailAddress + "', " +
     (SendNews ? "true" : "false") +
     ")";
   BdpCommand Command = new BdpCommand(CommandStr, Connection);

   try
   {
    Command.Connection.Open();
    Command.ExecuteNonQuery();
   }
   finally
   {
    Command.Connection.Close();
    bdpConnection1.Close();
    bdpDataAdapter1.Active = false;
   }
  }

  Trans.Commit();
 }
 catch
 {
  return "Test failed";
 }

 return "Test success";
}
-----------------------------------

I don't know what is the Error message, but after executing the first line 
of the Ajax function, the "catch" part is running.

Thank you in advance,
Mehrdad









"Marc Rohloff [TeamB]" <"on request"> wrote in message 
news:1993c9wwxgx7y$.dlg@dlg.marcrohloff.com...
> On Thu, 25 May 2006 01:43:51 +0330, M. Noroozi Eghbali wrote:
>
>> Would you please let me know what is my mistake?
> You are really going to need to show a bit more code and also tell us
> what exception you get.
> Also which AJAX libraries are you using?
>
> -- 
> Marc Rohloff [TeamB]
> marc rohloff -at- myrealbox -dot- com