Answer Posted / santro
/*Loginscreen.aspx.cs*/
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class loginScreen : System.Web.UI.Page
{
string strConnectionstring;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Login1_Authenticate(object sender,
AuthenticateEventArgs e)
{
strConnectionstring =
ConfigurationManager.AppSettings["strLogin"];
SqlConnection con = new SqlConnection
(strConnectionstring);
//SqlConnection con = new SqlConnection
("username=bhushan;password=softima;initial
catalog=sample;data source=localhost");
con.Open();
SqlCommand cmd = new SqlCommand("select count(*)
from login where username='" + Login1.UserName + "'and
password='" + Login1.Password + "'", con);
int i = (int)cmd.ExecuteScalar();
if (i > 0)
{
//FormsAuthentication.RedirectFromLoginPage
(Login1.UserName, Login1.RememberMeSet);
Response.Redirect("pgDrugNames.aspx");
}
}
}
/*Web.config
<appSettings>
<add key="strLogin" value="user
id=sa;password=sasa;initial catalog=sample;data
source=localhost" />
<add key="strSample" value="user
id=sa;password=sasa;initial catalog=sample;data
source=localhost" />
</appSettings>*/
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the electiricty charge per unit in Andhra Pradesh State Government?
What. Is. This sap mining
Some questions about the free Android game Grand Battle. Hi, I am a Grand Battle fan. In the process of playing the game, I get some problems. I really want to be a perfect commander and defeat my enemies. Senior players, just lend me a hand, please. Many thanks. 1. How to increase population? 2. How to repair combat vehicles？ 3. Where's the storage? 4. How to attack other players? 5. What should I do if the electric power is insufficient? 6. How to repair constructions? 7. What should I do if I'm not able to login the game, or the game gets stuck? 8. What should I do if the medals purchased haven't be received?
Hey I like to play online games .I damn crazy about it.My favorite one is sudoku and I have good steps to solve sudoku which I got from http://tictacdo.com/ttd/Solve-a-Sudoku Tell me some good online games list and some steps to solve that..
milk of magnesia is a suspension od what ?
sir, i completed my diploma at 2009,den i joined in a degree course but i didnt completed my btech due to some problem.so now 2012, dat means three years gap.i want a job in it sector.but in most companies,they want btech candidate.so wat type of problem'll come if i produce fake btech critificate???? they'll varify my qualification? and wat'll happen if they found my critificate's r false after getting job?
how to configure squirrel mail in rhel5???? guide step by step
which is the objective that admires u the most?
Interviewer: This is a phone/pen. How you will sell this item to me?
being a science how can u help a bank if we give u a job in a bank
Hello All, I m going to appear in Mass communicaion enterance exam from Jamia Milia university.Please let me know what kind of paper it will be. Only 20 seats are there, so i m worried. please help. if anyone is same course from same college please mail me on shivanisinha2020@gmail.com
Deloitte KPMG PwC and Ernst & Young – Big 4 Interview Questions 1. What accomplishment are you most proud of?
Kindly provide me test cases for Compatibility testing for Mobile on diffrent operating systems.
how can i get a Valid Certificate of Competency as Electrical Supervisor after completing diploma in electrical & electronics engineering in kakinada ...
What is the capital of Argentina?
