Re: How to Call a Server side Function on the Client side - C# Discussion Boards

Re: How to Call a Server side Function on the Client side

4-Aug-10 22:04

Good Day All

i have a Function e.g

public String Getdata(String mystr)

{

//Do what ever

//return  a String

}

and i want to call this function and pass data in Javascript like this

function KeyPress() {
            var TExtbox1 = document.getElementById('Text1');
        
         if (TExtbox1.value.length == 2) {

        //call the function here and pass the textbox1 value.  

   return false;
         }
        }

Thanks

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Prosanta Kundu online4-Aug-10 22:40

Prosanta Kundu online

4-Aug-10 22:40

You can use PageMethod.

Re: How to Call a Server side Function on the Client side

Vimalsoft(Pty) Ltd4-Aug-10 23:52

Re: How to Call a Server side Function on the Client side

4-Aug-10 23:52

Thanks , Now i have this

On the Server side

[WebMethod, System.Web.Script.Services.ScriptMethod]
public static string Getadata(String Data)
{
  String Scriptt  = "<script>alert('" + Data + "');</script>";
  return Scriptt;
}

function KeyPress() {


      var TExtbox1 = document.getElementById('Text1');
      var Results;
      if (TExtbox1.value.length == 2)
      {
         Results = Getadata(TExtbox1.value);
         alert(Results);
      }
      return false;
  }

and my ScriptManager

<asp:ScriptManager ID="ScriptManager1" EnablePageMethods="true"  runat="server">
</asp:ScriptManager>

but when i run it nothing happens

Thanks

Pete O'Hanlon5-Aug-10 0:07

5-Aug-10 0:07

You call Getadata in your javascript. You should call PageMethods.Getadata instead.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

Re: How to Call a Server side Function on the Client side

Vimalsoft(Pty) Ltd5-Aug-10 0:16

Re: How to Call a Server side Function on the Client side

5-Aug-10 0:16

Thanks , sorry i missed that, now i have a small problem with my javascript

<br />
     function KeyPress() {<br />
<br />
<br />
            var TExtbox1 = document.getElementById('Text1');<br />
            var Results;<br />
             if (TExtbox1.value.length == 2) {<br />
             <br />
                Results = PageMethods.Getadata(TExtbox1.value);<br />
                alert(Results);<br />
             }   <br />
             return false;<br />
         }<br />

the alert shows me "undefined"

is there anything wrong there ?

Pete O'Hanlon5-Aug-10 1:31

5-Aug-10 1:31

That's because a script method doesn't return like this. What you need to do is supply a callback function which your javascript executes. Here's a sample page:

HTML

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
  <title>Untitled Page</title>
  <script>
    function keyPress()
    {
      var tb = document.getElementById('Text1');
      if (tb.value.length == 2)
        PageMethods.Getadata(tb.value, myFunction);
      return false;
    }
    function myFunction(msg)
    {
		alert(msg);
    }
  </script>
</head>
<body>
  <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="True" />
    <div>
      <input type="text" id="Text1" onkeypress="keyPress()" />
    </div>
  </form>
</body>
</html>

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

Re: How to Call a Server side Function on the Client side

Vimalsoft(Pty) Ltd5-Aug-10 20:16

Re: How to Call a Server side Function on the Client side

5-Aug-10 20:16

Good Morning Pete

Thank you for your kind reples. its working like wonders. I have one last question. as you have seen i have been using a html textbox not an asp.net textbox. i see the asp text does not have the Keypress event , Is there a way that i can modify this working code to work with asp.net textbox defined like this

<asp:TextBox ID="Text2" runat="server"></asp:TextBox>

Thanks

Vimalsoft(Pty) Ltd6-Aug-10 22:07

Cant find BannerBitmap property ( win form setup creation )

6-Aug-10 22:07

Thanks for your help , i found the solution to my last request.

Krishna Varadharajan4-Aug-10 21:55

Krishna Varadharajan

4-Aug-10 21:55

Hi,

I need to insert a logo image in banner bitmap property while creating a setup. But from the property i couldn't find the bannerbitmap property. Can you pls help me.....

Thanks.

krishna

Re: Cant find BannerBitmap property ( win form setup creation )

freakyit5-Aug-10 1:56

freakyit

5-Aug-10 1:56

win form setup creation???? you meen wix setup or you are writing your own ?!?!? there are definalty missing information. in wix you can set the banner image using the old one by just renaming the file Wink | ;)

Re: Cant find BannerBitmap property ( win form setup creation )

GenJerDan5-Aug-10 8:33

GenJerDan

5-Aug-10 8:33

Do you mean in a Setup project in Visual Studio?

If so, right-click the Project and select View | User Interface (or us the menu View |Editor | User Interface)

In the properties of Install | Start | Welcome, "Banner Bitmap" is at the top. Just browse for what you want to use.

How do I include textbox data in SQL query?

Joe Stansfield4-Aug-10 20:44

Joe Stansfield

4-Aug-10 20:44

Hi,

This is most likely a basic problem but I can't get my head around it!

I am trying to construct a parameterized sql query that takes information entered from a textbox (the search box of the query) and adds it to the query before it executes.

What I would like to do is have the user search the 'CODE' column by entering something like:

= "CO" or "SO"

and have that added to my sql query after WHERE CODE

Any help greatly appreciated!

Joe

JHizzle4-Aug-10 21:55

JHizzle

4-Aug-10 21:55

Erm. AFAIK the whole point of a parameterized query was to stop this kind of design so that's not going to work.
You'd have to go back to the old skool method of generating the entire SQL statement and firing it back to your DB. I'd check if you really need to as this is horrendously insecure. Can you just not create a search stored proc and pass in a search term on that?

Joe Stansfield10-Aug-10 14:01

Joe Stansfield

10-Aug-10 14:01

Thanks,

I'll look at doing it through the stored procedure as you mentioned.

Pete O'Hanlon5-Aug-10 0:19

5-Aug-10 0:19

It depends on the type of database you are using as to how you tackle this, but you could add a temporary table that you use to add the individual parsed out elements in as individual elements, and then perform your main query using that table as a linked table, so you'd end up with SQL along the lines of:

SELECT ... FROM MyTable INNER JOIN MyTemporaryTable ON MyTable.Code = MyTemporaryTable.Code

Also, rather than having them enter the codes, why not display them in a list that they can select from? This way you save them having to remember potentially archane code sequences.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

PIEBALDconsult5-Aug-10 3:08

PIEBALDconsult

5-Aug-10 3:08

Something like cmd.Parameters [ "@CodeVal" ].Value = tbCode.Text ; ?

Message Removed

5-Aug-10 3:40

brunoseixas

5-Aug-10 3:40

Message Removed

Pete O'Hanlon5-Aug-10 11:42

5-Aug-10 11:42

Apart from being wide open to a SQL injection attack, this just won't work because it only applies to 1 value.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.