i am creating a simple login page with 2 text boxes and a button in C#.NET. I actually couting the number of rows matching the username and password entered and if count is greater than 0 i am redirecting them to a welcome page else i am directing them to
[Code]....
[Code]....
Im new to stored procedures so this may seem a stupid question. What i'm trying to do is create a procedure that checks if username and password match, if true then reset the failed password counter to '0'.
The problem i get is that it keeps prompting for a userID as a variable, see code:
[Code]....
I have a Sql query (I made it shorter for an example) belowselect top 4 Count (distinct[x].ProductID ) as [Count], y.Category as Category FROM [y] left OUTER JOIN [x] on [x].CategoryID = [y].CategoryID where x.MainID in (SELECT item FROM split(@MainID, ';')) group by y.Category order by Count descthe results will show all Categories with the Count next to it... I need to get the sql query to only get all the Categories with a Count greater then 10...How can I get this?.. .........what do I need to do to let the Sql Query work?
View 3 RepliesI am facing an intresting problem now with entity framework. if i did a count of the some table with linq statement its give some count and it is not matching with my normal sql query count. my sql query returning count of all the records in that table where as linq query returns some count which is less than sql count. is this a problem with my edmx or table navigation properties..i do have some 5 to 6 child tables inside this table with foreignkey relation. will it do a join on each child table and returns only those records. I am very much confused and don't know how to slove this.
View 9 RepliesURL...how we can sending formatted email now in my Login.aspx page i have Textbox that when users forget their password they should type their Username on the textbox and after that click on send button.I want when users click on send button their user name that they type in textbox be on the email that send to me .
View 1 RepliesI have a label lblCountCharacter with text "4000" and a textbox txtAddNote where users can enter text.
On entering one character in txtAddNote, the label text is decreased by one.
write a function for this in asp.net using C#.
What is the best way to put a Greater than sign in an SqlDataSource
The code will run but it is underlined with an error "Attribute values must be enclosed in quotation marks."
Sample code looks like this...
SelectCommand="Link.Section, Link.PostDate.....
WHERE...
and (PostDate <= GetDate()) and (isnull(postremove, getdate()) >= getdate()))">
How to make a secure login page using sql database by matching a user name and password and redirect them to differnt page as admin and user
View 2 RepliesNow to my question. I would like to check for username availability. For this I need to extract the text entered in the UserName textbox from the CreateUserWizard. I don't know how to do so. I need to cast somewhere but where?
Here's my code: (the bold word draws a cast error which I need to sort out)
[Code]....
I want to retrieve all the records where the datetime is greater than or equal to 30 days ago. What is the correct formatting for this line: WHERE Property.dateadded >= NOW -30 days .. Dateadded field is in datetime format.
SELECT TOP (1) Property.Name, Property.Price, Department.DepartmentTitle, Images.ImageId, Property.DateAdded
FROM Property LEFT OUTER JOIN
Department ON Property.DepartmentId = Department.DepartmentId LEFT OUTER JOIN
Images ON Property.PropertyId = Images.PropertyId
WHERE Property.dateadded >= NOW -30 days
Today my client asked to implement SMS Counter and restriction to 150 characters in SMSalert.aspx form,I have done only Validation Control. I am working with SMS for the first time.
View 1 RepliesHow to view the created id password in asp.net configuration
View 1 RepliesWe use the LoginControl to authenticate our users. For this particular site, security isn't a HUGE concern but the Membership provider allowed us to customize the users menu and do some other handy things.
Lately, our Customer Service department has been complaining that there is something wrong, because many users are being "locked out". What I would like to do is capture the login and password (I know how to get the login) and log it to our SQL database. Is there a way to get the un-encypted password? I am pretty sure there isn't but thought someone might know a workaound (without using a custom control of something of that nature).
I have the following code:
[Code]....
How do I get the Letter_ID of the row just created, and use it later on in the code?
I wanted to show message "NOT valid user"; when user provide wrong userid/password ...but it does not showing any label in it..
Code:
public string Checkuser(string value1, string value2)
{
ExecuteTSQL ts = new ExecuteTSQL();
DataSet ds = ts.SelectQueryDS("select * from tbl_user where USERNAME =" + "'" + value1 +"'" +" and password1 = " +"'"+ value2+ "'" );
if (ds.Tables[0].Rows.Count > 0)
[code]....
I have a webform, that needs to check the values entered against a database, and then send an email if the request turns out positiv.
View 11 RepliesI'm a rookie at all this and need some insight from veterans.
I'm working on a web form that submits data to a database. I'm using C# as my code behind language and am using LINQ to SQL with a LINQ data source. I'm working in the code-behind page to format/concatenate the user's data before going into the database.
Everything looks like it's formatted and aligned correctly. I am not receiving any errors or warnings, but on submission none of my data gets entered into the database.
My question is... how should I troubleshoot or go about finding out what's keeping my data from being entered into the db.
How to count no. of characters entered in multiline textbox, i wanna enter maximum 140 characters in my multiline textbox using vb.net ...
In short i want textbox to enter limit is only 140 characters ....
i have te following code to do that .... but i wanna implement 140 characters limit in multiline textbox :
<script type="text/javascript">
function Count(x) {
document.getElementById("Label1").innerHTML = document.getElementById("TextBox2").value.length;
}
</script>
<asp:TextBox ID="TextBox2" runat="server" Height="78px"
TextMode="MultiLine" Width="224px" onkeyup="Count(this.id)"
MaxLength="140"></asp:TextBox>
Looking at the html below, why I can not get the right side of the username and password textboxes to lign up underneath eachother?
[Code]....
I am developing a .net application using Web Services, and the application is consuming them using Spring.Net WebServiceProxyFactory. I need to send to the web service the username and password of the user that is logged in to the application, consuming the web service. Reading some forum post [URL] they seem to refer to an example that used to be in the spring documentation [URL], an example of how using SOAP headers for authentication using the WebServiceExporter and WebServiceProxyFactory, but the link to the file is broken. Do you know a way that I can send the user credentials as a soap header using spring.net? Or any data (for example, a token ID that the web service will use later to get the user credentials).
View 1 RepliesI have created a test user/password on my web site. The intent is to have prospective clients login and try out the tool. Instead of telling them the userid/password of the test user, I'd like to tweak the Login wizard.
In the Load event, I was able to specify login1.UserName = "test user"
But when I try to specify the password, I'm told it is a readonly field. How can I 'force' a specific password? Or, how can I call the login event directly and pass the needed values?
I designed a website, in login page username and password should be encrypted and sent to server for validation. How to do this.
View 5 RepliesI have a root folder college when you type in server/college/science it will ask for the user name and password.
(The usename and password are stored in controlpanel->administartivetools->computermanagement->localusersandgroups->users
userid is Test and password is PWD
Now I addea a folder in college
so when I type in college/english it is not asking me for the user id and password. It is showing the content directly.
How can I make english folder ask for the userrid and pasword stored in users (Test)
public FilePathResult GetFileFromDisk(int id){ var file = dbSample.FileStores.Where(f => f.FileID == id).FirstOrDefault(); string path = Server.MapPath(@"~Images"); string fileName = file.FileUrl;.....
return File(path + fileName, file.MimeType, file.FileName);}hey I have this code for getting file from my server.In some downloader like IDM we have a SiteLogin,we can input usernameand password in your downloader,how can i retrieve from this to check this Username is exists from my database.
I m crating contact reader functionality in my site. for this i have taken class from. from which i m working on tracing input box from yahoo pages. after seaching this text box i'll send value to respective textbox but for searching text box i used one fucntion in which i used one reguler expression for tracing input box.
Here is the function
[Code].....
and here is the page code
[Code]....
so there is anything problem in the regex. so except username and password i m getiing all the input types.