ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Validate TextBox inside UserControl using JavaScript in ASP.Net<p>Hi,</p> <div class="post-text"> <p>I am using a usercontrol which has two textboxes named txtUserName,txtPassword and a button&nbsp; named btnSubmit.I am using this usercontrol in my webpage.I want to show alert message in the webpage if the user didnot enter the username or password .&nbsp;&nbsp; </p> <p>How can i achieve this?</p> <p>Thanks</p> </div> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/552423/Validate-TextBox-inside-UserControl-using-JavaScript-in-ASPNet/https://www.aspforums.net:443/Threads/552423/Validate-TextBox-inside-UserControl-using-JavaScript-in-ASPNet/Wed, 10 Apr 2013 00:03:40 GMTValidate Session set after login and redirect user back to login page if it is NULL in ASP.Net<p>Hi</p> <p>I have made a web page in which there is login screen when user login it goes next page</p> <p>but my problem is if i directly enter the url of that page it open</p> <p>i want it should not open unless the user log in</p> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/917862/Validate-Session-set-after-login-and-redirect-user-back-to-login-page-if-it-is-NULL-in-ASPNet/https://www.aspforums.net:443/Threads/917862/Validate-Session-set-after-login-and-redirect-user-back-to-login-page-if-it-is-NULL-in-ASPNet/Fri, 26 Apr 2013 00:24:05 GMTValidate Money Currency format in ASP.Net TextBox using Validators<p>dear fellas,&nbsp;</p> <p>im trying to dcreate a requiredfieldvalidator that only accept amount of money.&nbsp;</p> <p>first i used this expresvalidator as it cant receive any letter.</p> <p>&nbsp;</p> <pre class="brush: vb">&lt;asp:RegularExpressionValidator ID=&#34;rvcheckno&#34; runat=&#34;server&#34; ErrorMessage=&#34;Amount receive numbers only!&#34; ControlToValidate=&#34;tbamount&#34; InitialValue=&#34;0&#34; ValidationGroup=&#34;number&#34;&gt; &lt;/asp:RegularExpressionValidator&gt;</pre> <p>but then it also cant receive cent.</p> <p>i was trying to do something that can accept <span style="text-decoration: underline;"><strong>130.00</strong></span></p> <p>tq</p>https://www.aspforums.net:443/Threads/122608/Validate-Money-Currency-format-in-ASPNet-TextBox-using-Validators/https://www.aspforums.net:443/Threads/122608/Validate-Money-Currency-format-in-ASPNet-TextBox-using-Validators/Wed, 08 Jan 2014 08:50:21 GMTUsing Class Library inside UserControl in ASP.Net C#<p>Hi all,<br /> I have a query. In my Solution i have Test.DL &amp; Test.Web.UI.</p> <p>Under Test.DL i have Ddlfile.cs in this file i have a class "Fruit"<br /> under Test.Web.UI i have Fruits.ascx file.</p> <p>Can i call fruit class from Test.DL to Fruits.ascx file?&nbsp;<br /> How should i achieve??<br /> Please help me<br /> Thanks in advance</p>https://www.aspforums.net:443/Threads/141141/Using-Class-Library-inside-UserControl-in-ASPNet-C/https://www.aspforums.net:443/Threads/141141/Using-Class-Library-inside-UserControl-in-ASPNet-C/Wed, 10 Jan 2018 22:51:05 GMTUser Login Form in Bootstrap Modal Popup in ASP.Net<p>Hi Mudassar</p> <p>refer to this link guide me to this in modal popup</p> <p><a href="https://www.aspsnippets.com/Articles/Simple-User-Login-Form-example-in-ASPNet.aspx">https://www.aspsnippets.com/Articles/Simple-User-Login-Form-example-in-ASPNet.aspx</a></p>https://www.aspforums.net:443/Threads/882624/User-Login-Form-in-Bootstrap-Modal-Popup-in-ASPNet/https://www.aspforums.net:443/Threads/882624/User-Login-Form-in-Bootstrap-Modal-Popup-in-ASPNet/Mon, 25 Dec 2017 12:24:03 GMTUser Email Activation link returning back to registration page in ASP.Net<p>When i click activation link in my mail, instead of redirecting to useractivation.aspx it goes back to registration.aspx page again, please why? and it also doesnt clear the useractivation table</p> <p>but the question i want to ask from this example is this below code on same registration page?</p> <p><a href="https://www.aspsnippets.com/Articles/Send-user-Confirmation-email-after-Registration-with-Activation-Link-in-ASPNet.aspx">https://www.aspsnippets.com/Articles/Send-user-Confirmation-email-after-Registration-with-Activation-Link-in-ASPNet.aspx</a></p> <p>is this code on a different page or same registration page</p> <p>here is the code</p> <pre class="brush: csharp">private void SendActivationEmail(int userId) { &nbsp;&nbsp;&nbsp; string constr = ConfigurationManager.ConnectionStrings[&#34;constr&#34;].ConnectionString; &nbsp;&nbsp;&nbsp; string activationCode = Guid.NewGuid().ToString(); &nbsp;&nbsp;&nbsp; using (SqlConnection con = new SqlConnection(constr)) &nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; using (SqlCommand cmd = new SqlCommand(&#34;INSERT INTO UserActivation VALUES(@UserId, @ActivationCode)&#34;)) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; using (SqlDataAdapter sda = new SqlDataAdapter()) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cmd.CommandType = CommandType.Text; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cmd.Parameters.AddWithValue(&#34;@UserId&#34;, userId); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cmd.Parameters.AddWithValue(&#34;@ActivationCode&#34;, activationCode); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cmd.Connection = con; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; con.Open(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cmd.ExecuteNonQuery(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; con.Close(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp; using (MailMessage mm = new MailMessage(&#34;sender@gmail.com&#34;, txtEmail.Text)) &nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mm.Subject = &#34;Account Activation&#34;; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string body = &#34;Hello &#34; + txtUsername.Text.Trim() + &#34;,&#34;; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; body += &#34;&lt;br /&gt;&lt;br /&gt;Please click the following link to activate your account&#34;; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; body += &#34;&lt;br /&gt;&lt;a href = &#39;&#34; + Request.Url.AbsoluteUri.Replace(&#34;CS.aspx&#34;, &#34;CS_Activation.aspx?ActivationCode=&#34; + activationCode) + &#34;&#39;&gt;Click here to activate your account.&lt;/a&gt;&#34;; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; body += &#34;&lt;br /&gt;&lt;br /&gt;Thanks&#34;; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mm.Body = body; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mm.IsBodyHtml = true; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SmtpClient smtp = new SmtpClient(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; smtp.Host = &#34;smtp.gmail.com&#34;; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; smtp.EnableSsl = true; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NetworkCredential NetworkCred = new NetworkCredential(&#34;sender@gmail.com&#34;, &#34;&lt;password&gt;&#34;); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; smtp.UseDefaultCredentials = true; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; smtp.Credentials = NetworkCred; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; smtp.Port = 587; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; smtp.Send(mm); &nbsp;&nbsp;&nbsp; } }</pre> <p>table for user activation code</p> <pre class="brush: sql">CREATE TABLE [dbo].[UserActivation]( [ID] [int] IDENTITY(1,1) NOT NULL, [UserId] [int] NULL, [ActivationCode] [uniqueidentifier] NULL, CONSTRAINT [PK_UserActivation] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO </pre>https://www.aspforums.net:443/Threads/244233/User-Email-Activation-link-returning-back-to-registration-page-in-ASPNet/https://www.aspforums.net:443/Threads/244233/User-Email-Activation-link-returning-back-to-registration-page-in-ASPNet/Thu, 07 Jun 2018 19:49:01 GMTuser claims<p>haw to use user claims?&nbsp;</p> <p>i want use of user claims to customize users profiles</p>https://www.aspforums.net:443/Threads/441402/user-claims/https://www.aspforums.net:443/Threads/441402/user-claims/Wed, 21 Aug 2019 02:25:38 GMTUser adccms already has more than max_user_connections active connections<h2><em>Hello sir,</em></h2> <p><em>i am geting this error when an product add or edit from the siteadmin.</em></p> <p><em>this error show on public sidealso.</em></p> <h2>&nbsp;</h2> <h2><em>User adccms already has more than 'max_user_connections' active connections</em></h2>https://www.aspforums.net:443/Threads/382488/User-adccms-already-has-more-than-maxuserconnections-active-connections/https://www.aspforums.net:443/Threads/382488/User-adccms-already-has-more-than-maxuserconnections-active-connections/Wed, 25 Feb 2015 03:21:23 GMTUploading audio file based on the user specified ID.<p>I want to upload audio file based on the ID which i choose</p> <p>For ex: I have three ID's in drop downlist, say</p> <p>ID #1: 1001</p> <p>ID #2: 1002</p> <p>ID #3: 1003</p> <p>I want to upload audio file for 1001. Later, On the same id i may upload another file also.&nbsp;</p> <p>Then, If i choose 1001, the list of files that has been uploaded on 1001 sholud be displayed with download option in Gridview.</p> <p>For SQL SERVER 2008.&nbsp;</p> <p>Kindly help me. Thanks in advance.</p>https://www.aspforums.net:443/Threads/178331/Uploading-audio-file-based-on-the-user-specified-ID/https://www.aspforums.net:443/Threads/178331/Uploading-audio-file-based-on-the-user-specified-ID/Mon, 25 Apr 2016 01:47:50 GMTUpload Image and display on User Profile page in ASP.Net<p>Hi all,</p> <p>I am making a Human resource Management system in which i have to make &nbsp;employee profiles, there is a page in which i am entering employee name and uploading a rofile picture and i want the next page to show that image on a left corner of every employee...after clicking on the submit button of the previous page please help !!!</p>https://www.aspforums.net:443/Threads/393752/Upload-Image-and-display-on-User-Profile-page-in-ASPNet/https://www.aspforums.net:443/Threads/393752/Upload-Image-and-display-on-User-Profile-page-in-ASPNet/Wed, 08 Jan 2014 03:21:41 GMTUpdate Login status for particular user after browser close in ASP.Net<p>Hello Everyone,</p> <p>I want to update my user table column 'loginStatus' to 0 for logout or 1 for fresh login, to prevent multiple logins!</p> <p>So, i wrote update code in logout button click event but the problem is when i close browser or browser tab the loginStatus column will be 1 only, hence it'll not allow me to login again.</p> <p>Please help me...&nbsp;</p>https://www.aspforums.net:443/Threads/668112/Update-Login-status-for-particular-user-after-browser-close-in-ASPNet/https://www.aspforums.net:443/Threads/668112/Update-Login-status-for-particular-user-after-browser-close-in-ASPNet/Mon, 10 Apr 2017 00:55:14 GMTTrigger one UserControl event from another UserControl event<p>Hi</p> <p>I have page having two user controls. Now I have a requirement for which i have to trigger one user control event from another user control.</p> <p>If this is possible then please guide me in this regard</p> <p>Regards</p> <p>TanzeelurRehman</p>https://www.aspforums.net:443/Threads/785537/Trigger-one-UserControl-event-from-another-UserControl-event/https://www.aspforums.net:443/Threads/785537/Trigger-one-UserControl-event-from-another-UserControl-event/Thu, 14 Feb 2013 03:36:35 GMTSwitching users from HTTP to HTTPS after login<p>Hi</p> <p>I have a following requirment. In my website, any user login with his/her credentials at that time URL should be switched to HTTPS from HTTP till the user logged out. After Log Out, URL change to HTTP from HTTPS.</p> <p>I am storing username in Session and from that I can check whether user is logged in or not but how to change URL at that time.</p> <p>Kindly help.</p>https://www.aspforums.net:443/Threads/627506/Switching-users-from-HTTP-to-HTTPS-after-login/https://www.aspforums.net:443/Threads/627506/Switching-users-from-HTTP-to-HTTPS-after-login/Thu, 13 Sep 2012 08:10:44 GMTStoring invalid user details into database<p>If any of the username or password is wrong, the incorrect credentials must be saved into the database.</p> <pre class="brush: js">var n = navigator; Agent = n.userAgent; browserName = n.appName; appVersion = n.appVersion.substr(0, n.appVersion.indexOf(&#39; &#39;)); fullVersion = &#39;&#39; + parseFloat(n.appVersion); platform = n.platform; cookie = n.cookieEnabled; BrMajorVersion = parseInt(n.appVersion, 10); OSname = &#39;unknownOS&#39;; width = (screen.width) ? screen.width : &#39;&#39;; height = (screen.height) ? screen.height : &#39;&#39;; screensize = &#39;&#39;; screensize += &#39;&#39; + width + &#34; x &#34; + height; var mobile = { Android: function () { return Agent.match(/Android/i); }, BlackBerry: function () { return Agent.match(/BlackBerry/i); }, iOS: function () { return Agent.match(/iPhone|iPad|iPod/i); }, Opera: function () { return Agent.match(/Opera Mini/i); }, Windows: function () { return Agent.match(/IEMobile/i); }, any: function () { return (mobile.Android() || mobile.BlackBerry() || mobile.iOS() || mobile.Opera() || mobile.Windows()); } }; // In Chrome if ((objOffsetVersion = Agent.indexOf(&#34;Chrome&#34;)) != -1) { browserName = &#34;Chrome&#34;; fullVersion = Agent.substring(objOffsetVersion + 7); } // In Microsoft internet explorer else if ((objOffsetVersion = Agent.indexOf(&#34;MSIE&#34;)) != -1) { browserName = &#34;Microsoft Internet Explorer&#34;; fullVersion = Agent.substring(objOffsetVersion + 5); } // In Firefox else if ((objOffsetVersion = Agent.indexOf(&#34;Firefox&#34;)) != -1) { browserName = &#34;Firefox&#34;; } // In Safari else if ((objOffsetVersion = Agent.indexOf(&#34;Safari&#34;)) != -1) { browserName = &#34;Safari&#34;; fullVersion = Agent.substring(objOffsetVersion + 7); if ((objOffsetVersion = Agent.indexOf(&#34;Version&#34;)) != -1) fullVersion = Agent.substring(objOffsetVersion + 8); } // For other browser &#34;name/version&#34; is at the end of userAgent else if ((OffsetName = Agent.lastIndexOf(&#39; &#39;) + 1) &lt; (objOffsetVersion = Agent.lastIndexOf(&#39;/&#39;))) { browserName = Agent.substring(OffsetName, objOffsetVersion); fullVersion = Agent.substring(objOffsetVersion + 1); if (browserName.toLowerCase() == browserName.toUpperCase()) { browserName = navigator.appName; } } // trimming the fullVersion string at semicolon/space if present if ((ix = fullVersion.indexOf(&#34;;&#34;)) != -1) fullVersion = fullVersion.substring(0, ix); if ((ix = fullVersion.indexOf(&#34; &#34;)) != -1) fullVersion = fullVersion.substring(0, ix); BrMajorVersion = parseInt(&#39;&#39; + fullVersion, 10); if (isNaN(BrMajorVersion)) { fullVersion = &#39;&#39; + parseFloat(navigator.appVersion); BrMajorVersion = parseInt(navigator.appVersion, 10); } //OS if (appVersion.indexOf(&#34;Win&#34;) != -1) { OSname = &#39;windowsOS&#39;; } if (appVersion.indexOf(&#34;Mac&#34;) != -1) { OSname = &#39;macOS&#39;; } if (appVersion.indexOf(&#34;X11&#34;) != -1) { OSname = &#39;unixOS&#39;; } if (appVersion.indexOf(&#34;Linux&#34;) != -1) { OSname = &#39;linuxOS&#39;; } angular.module(&#39;myApp&#39;) .controller(&#39;loginController&#39;, function ($scope, $sessionStorage, $http, $window, $location, $timeout, useragent) { $scope.loadingState = true; $timeout(function () { $scope.loadingState = false; }, 1000); $scope.currentdate = new Date(); $scope.device = useragent.device(); $scope.browserName = useragent.browser(); $scope.platform = useragent.platform(); $scope.cookie = useragent.cookie(); $scope.version = useragent.version(); $scope.versiontrue = useragent.version(true); $scope.OS = useragent.OS(); $scope.appVersion = useragent.appVersion(); $scope.screen = useragent.screen(); $http.get(&#34;https://ipinfo.io/json&#34;).then(function (response) { $scope.ip = response.data.ip; }); var apiUrl = &#34;http://stagingserver:85/EBSApi&#34;; $scope.login = function () { debugger; $scope.mydata = {}; $http.get(apiUrl + &#34;/api/Users/GetAllUsers?username=&#34; + $scope.user.username + &#34;&amp;password=&#34; + $scope.user.password + &#34;&#34;) .then(function (response) { $scope.mydata = JSON.parse(response.data); //$sessionStorage.SessionMessage = response.data; $scope.stat = &#34;false&#34;; angular.forEach($scope.mydata, function (item) { if ((item.username != $scope.user.username) || (item.password != $scope.user.password)) { var iloginDetails = { &#34;device&#34;: $scope.device, &#34;browserName&#34;: $scope.browserName, &#34;version&#34;: $scope.version, &#34;screen&#34;: $scope.screen, &#34;cookie&#34;: $scope.cookie, &#34;ip&#34;: $scope.ip, &#34;LoginTime&#34;: $scope.currentdate, &#34;LogoutTime&#34;: $scope.LogoutTime, &#34;username&#34;: $scope.user.username, &#34;empid&#34;: $scope.mydata[0].empid, &#34;CreatedDate&#34;: $scope.currentdate, &#34;CreatedBy&#34;: $scope.user.username, &#34;password&#34;: $scope.user.password }; $http({ method: &#34;POST&#34;, url: apiUrl + &#34;/api/Warehouse/addILoginDetails&#34;, data: JSON.stringify(iloginDetails), dataType: &#39;json&#39;, contentType: &#39;application/json&#39; }).then(function (data, status) { $scope.iloginDetails = &#34;&#34;; }); } stat = &#34;true&#34;; $scope.user.username = &#34;&#34;; $scope.user.password = &#34;&#34;; if (stat == &#34;true&#34; &amp;&amp; item.userid == 18) { $location.path(&#39;/dashboard&#39;); $sessionStorage.SessionMessage = response.data; } else { alert(&#34;Access denied!&#34;); $sessionStorage.reset(); //$scope.user.username = &#34;&#34;; } }); }); }; $scope.user = { &#34;username&#34;: &#34;&#34;, &#34;password&#34;: &#34;&#34; }; }).factory(&#39;useragent&#39;, function () { return { browser: function () { return browserName; }, device: function () { return mobile.any() ? mobile.any().toString() : &#39;Desktop&#39;; }, platform: function () { return platform; }, version: function (v) { return v ? fullVersion : BrMajorVersion; }, OS: function () { return OSname; }, cookie: function () { return cookie; }, appVersion: function () { return appVersion; }, screen: function () { return screensize; } } });</pre> <p>&nbsp;</p> <pre class="brush: csharp"> [HttpPost] [ActionName(&#34;addILoginDetails&#34;)] public int insertInvalidLoginDetails(loginDetails ld) { SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = ConfigurationManager.ConnectionStrings[&#34;ERPConnectionString&#34;].ConnectionString; SqlCommand sqlCmd = new SqlCommand(); DateTime now = DateTime.Now; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = &#34;INSERT_INVALID_LOGIN_DETAILS&#34;; sqlCmd.Connection = myConnection; sqlCmd.Parameters.AddWithValue(&#34;@device&#34;, ld.device); sqlCmd.Parameters.AddWithValue(&#34;@browserName&#34;, ld.browserName); sqlCmd.Parameters.AddWithValue(&#34;@version&#34;, ld.version); sqlCmd.Parameters.AddWithValue(&#34;@screen&#34;, ld.screen); sqlCmd.Parameters.AddWithValue(&#34;@cookie&#34;, ld.cookie); sqlCmd.Parameters.AddWithValue(&#34;@ip&#34;, ld.ip); sqlCmd.Parameters.AddWithValue(&#34;@LoginTime&#34;, now); sqlCmd.Parameters.AddWithValue(&#34;@LogoutTime&#34;, ld.LogoutTime); sqlCmd.Parameters.AddWithValue(&#34;@username&#34;, ld.username); sqlCmd.Parameters.AddWithValue(&#34;@empid&#34;, ld.empid); sqlCmd.Parameters.AddWithValue(&#34;@CreatedDate&#34;, now); sqlCmd.Parameters.AddWithValue(&#34;@CreatedBy&#34;, ld.CreatedBy); sqlCmd.Parameters.AddWithValue(&#34;@password&#34;, ld.password); myConnection.Open(); int rowInserted = sqlCmd.ExecuteNonQuery(); myConnection.Close(); return 1; }</pre> <p>&nbsp;</p> <pre class="brush: sql">USE [ERPT] GO /****** Object: StoredProcedure [dbo].[INSERT_INVALID_LOGIN_DETAILS] Script Date: 8/14/2019 12:07:03 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[INSERT_INVALID_LOGIN_DETAILS] ( @device varchar(50), @browserName varchar(50), @version varchar(50), @screen varchar(50), @cookie varchar(50), @ip varchar(50), @LoginTime datetime = null, @LogoutTime datetime = null, @username varchar(50) = null, @empid integer =null, @CreatedDate datetime = null, @CreatedBy varchar(50) = null, @password varchar(50) = null ) AS BEGIN SET NOCOUNT ON; insert into LOGV1_INVALIDUSER ( device, browserName, version, screen, cookie, ip, LoginTime, LogoutTime, username, empid, CreatedDate, CreatedBy, password ) values ( @device, @browserName, @version, @screen, @Cookie, @ip, @LoginTime, @LogoutTime, @username, @empid, @CreatedDate, @CreatedBy, @password ) END </pre> <p>&nbsp;</p> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/203409/Storing-invalid-user-details-into-database/https://www.aspforums.net:443/Threads/203409/Storing-invalid-user-details-into-database/Wed, 14 Aug 2019 00:42:21 GMTSimple User Comments Form using Database in ASP.Net<p>Hello everyone,</p> <p>i was owndering if you happen to have a simple Comments form syntax with CSS, so that &nbsp;a person can leave his/her name, e-mail, subject and comments. the form that can write under the question when Reply is pressed by the person.</p> <p>example:&nbsp;</p> <p>Question<br />&nbsp; &nbsp; &nbsp; &nbsp;Reply</p> <p><span style="font-size: 9pt;">thank you.&nbsp;</span></p> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/190413/Simple-User-Comments-Form-using-Database-in-ASPNet/https://www.aspforums.net:443/Threads/190413/Simple-User-Comments-Form-using-Database-in-ASPNet/Mon, 18 Nov 2013 06:34:03 GMTShow Session Expire Timeout Countdown to users in ASP.Net<p>Hi friends,</p> <p>&nbsp;&nbsp;&nbsp; I need to show how to show countdownwhen the user session expire? if users session expire means i need to redirct user to login page..</p> <p>&nbsp;&nbsp; How can i achieve this?</p>https://www.aspforums.net:443/Threads/475580/Show-Session-Expire-Timeout-Countdown-to-users-in-ASPNet/https://www.aspforums.net:443/Threads/475580/Show-Session-Expire-Timeout-Countdown-to-users-in-ASPNet/Mon, 17 Dec 2012 01:38:14 GMTShow Hide specific section of page based on User Type or Role in ASP.Net<p>I have LOGIN PANEL for student, and I want to disable it in different page. And only the admin can enable and disable it. I dont know the logic behind here. Thanks~</p>https://www.aspforums.net:443/Threads/106380/Show-Hide-specific-section-of-page-based-on-User-Type-or-Role-in-ASPNet/https://www.aspforums.net:443/Threads/106380/Show-Hide-specific-section-of-page-based-on-User-Type-or-Role-in-ASPNet/Mon, 24 Nov 2014 01:31:09 GMTSend email with a webform link through a WebService in ASP.Net using C# and VB.Net<p>Hi,<br />I need to send data like emp id and device id with a webform link through a condition of webservice.asmx</p>https://www.aspforums.net:443/Threads/130338/Send-email-with-a-webform-link-through-a-WebService-in-ASPNet-using-C-and-VBNet/https://www.aspforums.net:443/Threads/130338/Send-email-with-a-webform-link-through-a-WebService-in-ASPNet-using-C-and-VBNet/Thu, 22 Mar 2018 05:02:23 GMTSend email to user when clicks Forgot Password button in ASP.Net<p>when user click forgot password it asked user name and email and send his password on his email.</p> <p>How implement this task in asp.net. with datbase sql server.</p> <p>reply me please ...</p> <p>provide me live demo or source code</p> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/244031/Send-email-to-user-when-clicks-Forgot-Password-button-in-ASPNet/https://www.aspforums.net:443/Threads/244031/Send-email-to-user-when-clicks-Forgot-Password-button-in-ASPNet/Wed, 06 Feb 2013 08:04:22 GMTSend Approval email to user after Registration with Activation Link in ASP.Net<p>I asked my questions for three times and it couldn't send me the approval email???&nbsp;</p>https://www.aspforums.net:443/Threads/169227/Send-Approval-email-to-user-after-Registration-with-Activation-Link-in-ASPNet/https://www.aspforums.net:443/Threads/169227/Send-Approval-email-to-user-after-Registration-with-Activation-Link-in-ASPNet/Tue, 02 Aug 2016 02:28:43 GMT