You searched for the word(s): userid:609144

More Search Options

RSS Available

• Re: Session Variable Not Set in Global.aspx

  I may be wrong here but isn't 'on applcation error' in global.asax called after the application crashes? If this is so, I would expect the session variables to be destroyed..

  Posted to State Management (Forum) by majek on 6/1/2009

• Re: Database Design Help Request

  You probably mean 'Union Join' Try http://www.w3schools.com/sql/sql_union.asp . It will explain it all.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by majek on 6/1/2009

• Re: Web Service and SOAP

  Add the web Reference in the code behind and execute your functions from there. Example; Dim str as string str=myWebReference.HelloWorld

  Posted to XML Web Services (Forum) by majek on 5/31/2009

• Re: Passing SQL result to a label.

  Can you please make sure @Result is the same case in all application just in case you are case sensitive. If That fails, I need to see you asp.net code. I have tried this and it works.

  Posted to Data Presentation Controls (Forum) by majek on 5/31/2009

• Re: Passing SQL result to a label.

  try label1.text = cmd.Parameters( "@Myresult" ).Value.Tostring

  Posted to Data Presentation Controls (Forum) by majek on 5/30/2009

• Re: Passing SQL result to a label.

  run your sp in query analyer to make sure you are getting a valid result as there is no error check in your code; Delclare @result varchar (50) execute verify 23,@result output print @result Please replace 23 with a valid userid. If that works, check to make sure you are putting this in a valid property also make sure your user_id is unique as you will get an error otherwise

  Posted to Data Presentation Controls (Forum) by majek on 5/30/2009

• Re: Passing SQL result to a label.

  ALTER PROCEDURE verify @user_id int , @result varchar (50) Output AS Set @Result = ( Select student_id FROM Students WHERE students.student_id=@user_id ) RETURN @@Error Go If your student_id is an integer, you may want to change result to type 'int' "@result Int Output

  Posted to Data Presentation Controls (Forum) by majek on 5/30/2009

• Re: Passing SQL result to a label.

  This is because the @return parameter I have used is the built in return value from SQL which is 0 if you sp is successful. I dont know what fields you have in your db. You should change do something like this; Dim sconn As New SqlConnection() sconn.ConnectionString = _ {My connection string goes here} Dim cmd As New SqlCommand( "verify" , sconn) cmd.CommandType = CommandType.StoredProcedure cmd.Parameters.AddWithValue( "user_id" , user_field.Text) cmd.Parameters.Add( "@Myresult"

  Posted to Data Presentation Controls (Forum) by majek on 5/30/2009

• Re: Passing SQL result to a label.

  Dim sconn As New SqlConnection() sconn.ConnectionString = _ {My connection string goes here} Dim cmd As New SqlCommand( "verify" , sconn) cmd.CommandType = CommandType.StoredProcedure cmd.Parameters.AddWithValue( "user_id" , user_field.Text) cmd.Parameters.Add( "@Return" , SqlDbType.Int) cmd.Parameters( "@Return" ).Direction = ParameterDirection.ReturnValue sconn.Open() cmd.ExecuteNonQuery() label1.text = cmd.Parameters( "@Return" ).Value sconn.Close

  Posted to Data Presentation Controls (Forum) by majek on 5/30/2009

• Re: plz help me...beginner here...data table problem...its urgent.....plz..help[problem with datatable..how to call??

  Your questions is very unclear and your code doesn't help here. Ok this is my understanding; The code in the page load is irrelevant to your question You want to pass a list of columns to add to the table as array(totalColumnName) Not sure what the CriteriaName is for The For statement is not part of the logic And you want the result as a datatable My anwsers N/A -- -- -- user ByRef for 'Operand'

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by majek on 5/30/2009