ASP.NET

3-Nov-07 8:36

I learning and have a problem this topic. Here is what I'm tryig to figure out in my head. I need to pass a function the name "Joe" and then have the function look it up in the database and return it back so it can go inside a text vale.

Here is the example I'm work through. I can't seem to get it to work so I need to make sure I understand how to pass arguments and return them.

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim name as String = "Joe"
Dim Userid as Integer

GetUserID(name, result_sUserID)

result_sUserId = txtUserid.text

End Sub

Public Function GetUserID(ByVal name As String, result_sUserID As Integer) As Integer

.... datbase connection stuff
.... userid as int32 in database

sUserID = Convert.ToInt32(myCommand.ExecuteScalar())

Return

Result_sUserID = sUserID

End Function

Chris Stewart

www.pluginforsuccess.com

pmarfleet3-Nov-07 9:03

pmarfleet

3-Nov-07 9:03

The second argument to GetUserID is unnecessary as your function only needs to return 1 value. Change Return to Return sUserID and remove the following line. Modify the calling code to assign the value returned by the function to a variable.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

csinva3-Nov-07 9:12

3-Nov-07 9:12

So I do that

GetUserID(Subdomain)
'Populate lblUserId with result_sUserID
Dim sUserID As Integer
sUserID = lblUserID.Text

sUserID = Convert.ToInt32(myCommand.ExecuteScalar())

objConnection.Close()
Return sUserID

and I get the following error message:

[FormatException: Input string was not in a correct format.]
Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat) +211
Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +84

[InvalidCastException: Conversion from string "" to type 'Integer' is not valid.]
Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +238
UrlCompare.Button1_Click(Object sender, EventArgs e) in C:\inetpub\wwwroot\UrlCompare.aspx.vb:34
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Chris Stewart

www.pluginforsuccess.com

pmarfleet3-Nov-07 9:21

pmarfleet

3-Nov-07 9:21

csinva wrote:
Dim sUserID As Integer
sUserID = lblUserID.Text

sUserID = Convert.ToInt32(myCommand.ExecuteScalar())

This bit of code doesn't make any sense. Why do you assign a value to sUserID in one line and then reassign the value in the next line. Surely this is unnecessary?

I assume the code crashes on the first assignment. You can't implicitly cast a string value to an Integer. If the value of lblUserID.Text is an empty string obviously there is no numeric equivalent. You should use Integer.TryParse to perform type conversions if you don't know in advance that they will be successful.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Guffa3-Nov-07 9:27

Guffa

3-Nov-07 9:27

That's because you are trying to assign the contents of the Text property of the control to the integer variable.

This, and all the other mistakes in the code, is outlined in my other reply in this thread.

Experience is the sum of all the mistakes you have done.

Guffa3-Nov-07 9:12

Guffa

3-Nov-07 9:12

I made corrections in the code and started to write comments, but I had to put number references in the comments, and the notes separately:

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

   Dim name as String = "Joe"
   Dim Userid as Integer

   ' 1, 2, 3 
   Userid = GetUserID(name)

   ' 4, 5
   txtUserid.Text = Userid.ToString()

End Sub

' 6
Public Function GetUserID(ByVal name As String) As Integer

   .... datbase connection stuff
   .... userid as int32 in database

   sUserID = Convert.ToInt32(myCommand.ExecuteScalar())

   ' 7
   ' Return

   ' 8
   ' Result_sUserID = sUserID

   ' 9
   Return sUserID

End Function

1. You were trying to use the variable Userid by the name result_sUserID. If you use the same name for the same variable, you will find that the compiler is much more cooperative.

2. Sending the value of the variable Userid to the function doesn't make it possible for the function to return a value to the variable.

3. The function returns a value, you should assign that value to the variable.

4. You got it backwards. You should assign the value of the variable to the Text property of the control, not the other way around.

5. The Text property is a string value, so you should convert the integer value to a string.

6. Remove the integer argument from the function.

7. You are returning from the function before assigning a return value. The rest of the code would not be executed.

8. Assigning a value to one of the arguments of the function doesn't change the variable from where the value was taken that was sent to the function.

9. Use the Return statement to set the return value of the function.

Experience is the sum of all the mistakes you have done.

csinva3-Nov-07 9:56

3-Nov-07 9:56

Thanks it really helpes me out.

Chris Stewart

www.pluginforsuccess.com

csinva3-Nov-07 10:29

3-Nov-07 10:29

So let me expand my understanding and figure out how to pull back more than just piece of data.

Would I then have to create a SqlDataReader such as:

Dim myReader As SqlDataReader = myCommand.ExecuteReader
Do While myReader.Read()
'look at columns and set the value to sUserID
sUserID = myReader.Item("Userid")
sUserEmail = myReader.Item("Email")
Loop

myReader.Close()
myReader = Nothing

Return sUserID, sUserEmail

Chris Stewart

www.pluginforsuccess.com

Re: i want to know how to create page dynamically like Sulekha.com

Guffa3-Nov-07 11:22

Guffa

3-Nov-07 11:22

A method can only have one return value. Make a user class, create an instance of it in the method, populate it with the data and return it.

Experience is the sum of all the mistakes you have done.

[Message Deleted]

Unknown Ajanabi3-Nov-07 2:42

Unknown Ajanabi

3-Nov-07 2:42

[Message Deleted]

Malcolm Smart3-Nov-07 4:23

Malcolm Smart

3-Nov-07 4:23

Try this link - you might recognise it[^]

[Reply | Email | View Thread | PermaLink | Go to Thread Start] Rate this message: 1 2 3 4 5 (out of 5)
Report as Spam or Abuse

Re: i want to know how to create page dynamically like Sulekha.com

Mircea Grelus3-Nov-07 5:15

Mircea Grelus

3-Nov-07 5:15

Dude, what world are you living in? Nobody's going to send you the solution by email. So you can stop hoping for that. What I recommend is reading an ASP.NET book, like Professional ASP.NET[^] which has the answer to your problem.

Oh, and to ease the way through, you're not looking for dynamic page creation, but paging.

Cheers,
Mircea
"Pay people peanuts and you get monkeys" - David Ogilvy

Re: i want to know how to create page dynamically like Sulekha.com

Paul Conrad3-Nov-07 5:22

Paul Conrad

3-Nov-07 5:22

Mircea Grelus wrote:
what world are you living in? Nobody's going to send you the solution by email. So you can stop hoping for that.

Exactly.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

ajax.net

Rinki Mukheraji3-Nov-07 1:19

Rinki Mukheraji

3-Nov-07 1:19

I am using ajax.net. I am using the update panal. I have already put a script manager control. When run this form then display run time message below this.

"Only one instance of a ScriptManager can be added to the page."

InsDev3-Nov-07 1:33

InsDev

3-Nov-07 1:33

Mr Gagan just not ask repeated question again and again. Do yourself ok. And try to find out why error is coming. Not like Sonia Gupta to get all the solve code.
Ok ........

Devjit Das.

Rinki Mukheraji3-Nov-07 1:49

Rinki Mukheraji

3-Nov-07 1:49

Not reapeat same question. My previous error:

"The control with ID 'UpdatePanel1' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it."

Now error: Only one instance of script manager control.

I am using the webuserconrol when webusercontrol under the use ajax.net

I am using the webusercontrol my aspx page under update panel. then create this problem

Only one instance of script manager control.

when webusercontrol put outside the update panel. and not use scriptmanager control. run project and not display error. but project requirment that under updatepanel.

Mircea Grelus3-Nov-07 2:10

Mircea Grelus

3-Nov-07 2:10

Have you tried these[^] solutions?

Cheers,
Mircea
"Pay people peanuts and you get monkeys" - David Ogilvy

Unknown Ajanabi3-Nov-07 2:34

Unknown Ajanabi

3-Nov-07 2:34

if u install ajax.net setup

and u found
Only one instance of a ScriptManager can be added to the page.?????

then u can try to create another website under chose ajaxenablewebsite

in give template

and put hole file and folder in ajax enable directory

no knowledge in .net

Braulio Dez3-Nov-07 6:20

Braulio Dez

3-Nov-07 6:20

That's usually because you have already defined the ScriptManager in... for instance the MasterPage.

If you need to access the script manager from a child page, or from a user control use ScriptManagerProxy. Here you will find a selection of articles useful to start with AJAX ASP .net:

http://www.tipsdotnet.com/ArticleBlog.aspx?KWID=2&Area=AJAX&PageIndex=0[^]

HTH

/// -------------------------
Braulio Díez

tipsdotnet.com
/// -------------------------

form closing event

Sonia Gupta3-Nov-07 1:00

Sonia Gupta

3-Nov-07 1:00

how should i call my javascript function when the page is of master type.i mean the javascript code is under the content tag.

<asp:content id="Content1" contentplaceholderid="ContentPlaceHolder1" runat="Server">

function abc()
{
if(confirm('ok'))
{

}
}

i mean there is no body tag(because of master type page).hpow should i call the abc() function on browser closing

imran gave me the code

string attributeKey = "onunload";
string attributeValue = "abc();";
HtmlGenericControl body = (HtmlGenericControl)this.Master.FindControl("bid");
body.Attributes.Add(attributeKey, attributeValue);

which i wrote at form load , on the page having master page properties.

in the master page , i defined the function as below

function abc()
{
alert('hi');

}

function is not arising after clicking the form closing button

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

InsDev3-Nov-07 1:30

InsDev

3-Nov-07 1:30

what is this yet u have not solve this problem.
Just use like this.
HtmlGenericControl body = (HtmlGenericControl)this.Master.FindControl("bid");
body.Attributes.Add("onbeforeunload", "alert('Close');");

Hope to solve ur problem.

Devjit Das.

Sonia Gupta3-Nov-07 1:42

Sonia Gupta

3-Nov-07 1:42

Let me make u understand again.i want this message to invoke , only on the form closing button , it is emerging on all controls click (button click) of form.How should i deprieve it off , from apppearing on clicking all controls .

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Mircea Grelus3-Nov-07 2:05

Mircea Grelus

3-Nov-07 2:05

There is no way to know when the user closes the browser. No event is thrown. What you were presented here were methods commonly used to support this functionality. Like the method states, the event fires when the page is unloaded, but the page is unloaded as well when it roundtrips to the server.

Seriously though, you should learn to use Google. While trying to find solutions for your problems you will be forced to read arcticles, comments, forums and you will learn a great deal from that. Instead of posting the same questions here again and again and complain the code doesn't work.

Cheers,
Mircea
"Pay people peanuts and you get monkeys" - David Ogilvy