|
Hi
I have writing the following login screen in asp.net which uses an stored procedure, which if the login credentials equal whats returned from the select statement it should return a 1
I am having problems getting my asp page to grab the value which is returned from the stored procedure
for some reason this code sets the return value to 6, wether its right or wrong!
here is my stored procedure code
CREATE DEFINER=`jshort`@`localhost` PROCEDURE `sp_userlogin`(IN p_UserName VARCHAR(50), IN p_Password VARCHAR(50))
BEGIN
IF EXISTS(SELECT * FROM Users WHERE UserName = p_UserName AND PASSWORD = p_Password) THEN
SELECT 1;
ELSE
SELECT 0;
END IF;
END
and my code for the asp page is as follows
Sub sendData(ByVal sender As Object, ByVal e As EventArgs)
Dim litErr As New LiteralControl
'Create connection string to pass database, string holds login information to mySQL,
Dim connectionString As String
connectionString = "Server=localhost; uid=; pwd=;database=ftp1;"
'Builds .net mysql connection and passes connection string into method
Dim connection As New MySqlConnection(connectionString)
'Create mySql command string for passing query or SPROC(Stored Procedure)
Dim cmdString As New MySqlCommand
'Set Command to equal mySql connection,t so can pass SQL query
cmdString.Connection = connection
Try
'Set command string to equal SPROC
cmdString.CommandText = "sp_userlogin"
'ONLY PLACE THIS IF SPROC, sets the command to a SPROC
cmdString.CommandType = CommandType.StoredProcedure
Dim param As New MySqlParameter
param = cmdString.Parameters.Add("?p_username", MySqlDbType.VarChar)
param.Direction = ParameterDirection.Input
param.Value = txtUserName.Text
param = cmdString.Parameters.Add("?p_password", MySqlDbType.VarChar)
param.Direction = ParameterDirection.Input
param.Value = txtPassword.Text
param = cmdString.Parameters.Add("return", MySqlDbType.Int32)
param.Direction = ParameterDirection.Input
param.Value = ParameterDirection.ReturnValue
'Executes stored procedure
connection.Open()
cmdString.ExecuteNonQuery()
connection.Close()
Catch ex As Exception
'Returns error message
litErr.Text = ex.Message
MsgBox(ex.Message)
End Try
Dim validation As Object = cmdString.Parameters("return").Value
If validation = 0 Then
MsgBox("user login not valid")
Else
Response.Redirect("userhome.aspx")
End If
|
|
|
|
|
boyindie wrote: I am having problems getting my asp page to grab the value which is returned from the stored procedure
No wonder, as your procedure isn't returning any value.
As your procedure is sending a result (using a select query), you have to use ExecuteReader or ExecutScalar instead of ExecuteNonQuery to get the result.
---
single minded; short sighted; long gone;
|
|
|
|
|
can we hide (set visible = false) of an item inside the datalist? Note: this item is NOT a server control like asp:label or asp:button, etc so it does not have an ID. This item is just a link that is executed on clientside.
I would appreciate your help very much!
|
|
|
|
|
I have a gridview that contains a checkbox for a user to select his choice.
I want a code that enables user to check all and uncheck the check box at ones
I am using ASP.net and C_sharp.And this should be done with out postback.
Please advice
|
|
|
|
|
use javascript.
and performe your job in a java script function
|
|
|
|
|
javascript will solve it!!
but one thing,the id of the controls inside the gridview is different from the server controls!!!!
In the page check the id of the checkboxes with viewsource of the page!!!
Write the javascript accordingly!!!!
Hope itll help!!!
I was born dumb!!
 Programming made me laugh !!!
--sid--
|
|
|
|
|
Could you give me a code in javascript and how to incorporate in in to my ASP.net,C sharp?
I havent used Javascript before.
Thanks for your help
|
|
|
|
|
FUNCTION FUNC_NAME()
{
VAR CHK=DOCUMENT.GETELEMENTBYID("CHECK BOX NAME");
VAR COUNT="COUNT_OF_CHECKBOXES";
WHILE(COUNT>0)
{
IF(CHK.CHECKED==TRUE)
{
CHK1.CHECKED=TRUE;
}
ELSE
{
CHK1.CHECKED=FALSE;
}
}
IN THE CODE
CHECK_ALL_CHECK_BOX.ATTRIBUTES.ADD("ONCLICK","RETURN FUNC_NAME();");
HOPE IT HELPS!!!!
I was born dumb!!
Programming made me laugh !!!
--sid--
|
|
|
|
|
Thanks very much.Where will i put the code in the (.aspx) for the page together with the HTML. or somewhere else...
Please advice
Thanks for your time
|
|
|
|
|
I need to check enable and disable (using Javascript code) value of following steps:
Tools->Internet Options->Security->LocalIntranet->Custom Level->initialize and script activeX controls not marked as safe for scripting
I need to change values in registy of Enabling and Disabling using Javascript code.
If my question was not good defined plz ask.
I Love SQL
|
|
|
|
|
OK, if what you want to do works, then it's a huge security hole, and I hope Microsoft fixes it soon.
In other words, forget it. Perhaps your intentions are benign, but you're asking how to do something that every person trying to spread a virus via the web would want to do. I'm sure there were ways to do that in 1998, but not today.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hello All;
I have search page and result page.
in search page I have drop down list that specify the value of car
like this * <20000 * between 20000 and 300000 * >300000
the selected value sent in query string .I have colum in table Name (price) type (money) that get the value from QueryString diplay the datalist in depend of it .
but give error always? unable to convert string value to ... moeny and something like that
anybody can help
aj123
|
|
|
|
|
Based on your description, I doubt you'll get any help. The error you get obviously relates to a point in the code where you try to convert a string to a numeric value. Find that code, and fix it, and you'll be done. Or, perhaps the error is in the list control, your aspx is trying to bind a numeric format, and getting a string back.
Set some breakpoints and work out what data is causing the error, then you should be able to work out how to fix it.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I'm coming across a problem while trying to read values from dynamically added text boxes. This is my method:
*Create placeholder inside of the aspx.
*Read in data from sql, creating a label and textbox for each entry.
*Add those controls to the placeholder.
That works just fine. However, I can't seem to read the values from those dynamically added textboxes. When I run in debug mode, the placeholder is empty by the time the page loads. Any advice on the matter?
Thanks.
|
|
|
|
|
I found out that it will not delete the controls inside of the placeholder, provided I DO NOT assign the controls a unique id. This functionality is... strange at best. But I guess a part of learning a solution is becoming familiar with its quarks.
|
|
|
|
|
Hi everybody,
I'm new to asp.net, I was a PHP programmer so I have some questions.
How I can write something like include in asp.net, also I do not know why but master Pages do not work. 
Here is the Result of Running Master page:
"The type of page you have requested is not served because it has been explicitly forbidden. The extension '.Master' may be incorrect. Please review the URL below and make sure that it is spelled correctly. "
Thanks a lot,
|
|
|
|
|
Master pages are not served, only aspx pages, Master pages are used as templates by the aspx pages for layout and common controls across many pages, supose you want the same navigation on every single page you would create the navigation in the master page, maybe add some logic to it and then just reference the master page from the aspx page the easiest way to do this is first create the master page, and then just right click on the master page and select the "add new content page" option from menu.
Includes is a different thing, if is logic you want you can create this logic in classes and reference them in your logic for the pages, but if what your looking is for layout I would suggest researching more on the master pages.
Greets! Joel
|
|
|
|
|
Thanks for your answer 
Yes, I want includes for layout, but Master Pages are really better but I can't configure them correctly. So I create a Master Page, then Content page for this master page and execute this content page. Am I right?
Thanks
|
|
|
|
|
|
Hi,
I created a custom membership provider, and added it to my web.config file. Everything looks fine, but I can't test it with the ASP.NET Configuration tool.
My web.config:
<membership
defaultProvider="MyMembershipProvider"
hashAlgorithmType="SHA1"
userIsOnlineTimeWindow="15">
<providers>
<clear/>
<add
name="MyMembershipProvider"
applicationName="My"
connectionStringName="WebsiteSqlServer"
description="Stores and retrieves membership data from my database"
enablePasswordReset="true"
enablePasswordRetrieval="false"
maxInvalidPasswordAttempts="5"
minRequiredNonalphanumericCharacters="0"
minRequiredPasswordLength="8"
passwordAttemptWindow="10"
passwordFormat="Hashed"
passwordStrengthRegularExpression=""
requiresQuestionAndAnswer="true"
requiresUniqueEmail="true"
type="My.Web.Security.MyMembershipProvider, My.Web" />
</providers>
</membership>
Why doesn't this want to work?? Did I forget to add something??
Please can some one help me??
Regards
ma se
|
|
|
|
|
Hi all,
I just wanted to know how do we disable the text in the status bar that appears when i click the datagrid pager or the header,using javascript.My seniors suggested me this as a security perspective.pls help...
Thanks in advance
|
|
|
|
|
You can use a javascript to set the status bar to an empty message to prevent the javascript functions from appearing in the status bar of the browser,
Greets! Joel
|
|
|
|
|
Pls can you pls explain me in more detail!!!! Pls:->
|
|
|
|
|
http://www.computerhope.com/j17.htm
But this isn't security at all, the user just has to disable javascript or right click on the link and select "copy link location".
|
|
|
|
|
this problem is bizarre. i have only got it on my laptop. i have tried the obvious like reinstalling visual studio iis and the framework.. all in the correct order.
i have posted a screen shot of the error message.
http://www.johnsturgess.com/Images/error.JPG
i seem to remember a tutor of mine mentioning that this problem can be fixed but i am a bit lost.
any help much appreciated.
Cheers
John Michael Kinsella
kinsellajohn@hotmail.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
