ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Code Snippets >> Programming Code >> Dot Net Code >> C Sharp Code
 
 


 

 
 ASP.NET Code interview questions  ASP.NET Code Interview Questions (46)
 VB.NET Code interview questions  VB.NET Code Interview Questions (9)
 C Sharp Code interview questions  C Sharp Code Interview Questions (50)
 ADO.NET Code interview questions  ADO.NET Code Interview Questions (8)
Question
how to change password in .net with c # with ado.net and
also SQL server 2008
change password
 Question Submitted By :: C-Sharp-Code
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
SqlConnection objconnection = new SqlConnection();
protected void Page_Load(object sender, EventArgs e)
{
//objconnection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Constr"].ConnectionString);
// objconnection.Close();
// lblInfo.Visible = false;
}
protected void Button1_Click(object sender, EventArgs e)
{
String strUsername = txtUsername.Text;
String strPassword = txtCurrentpassword.Text;
SqlConnection con = new SqlConnection("Data Source=ARUN-PC\\SQLEXPRESS;Initial Catalog=newspaper;Integrated Security=True");
con.Open();
//objectcon=new ObjectCon();


SqlCommand objcommand;
SqlDataReader objdatareader;

//OleDbCommand cmd = new OleDbCommand("Select Username,Password from Admin", objconnection);
//OleDbDataReader dr;
//jcon = new objcon();
objcommand = new SqlCommand("Select Username,Password *from Login", objconnection);
objdatareader =objcommand.ExecuteReader();
{
if (txtUsername.Text ==objdatareader.GetValue(0).ToString())

if (txtCurrentpassword.Text ==objdatareader.GetValue(1).ToString())
{
SqlCommand cmd = new SqlCommand("Update Login set Password='" + txtNewPassword.Text + "' where Username ='" + txtUsername.Text + "'", objconnection);
cmd.ExecuteNonQuery();
}
else
{

lblInfo.Visible = true;
}

else
{

lblInfo.Visible = true;
}

}
con.Close();
}
}




but my programme is not running
 
Is This Answer Correct ?    1 Yes 6 No
Arun
 

 
 
 
Other C Sharp Code Interview Questions
 
  Question Asked @ Answers
 
how to get the table names via c sharp and column names also? Sify 2
how can i split sting in textbox in windows application using c# .net   2
program to reverse the order of digits in a given number of any length. Mind-Tree 1
how does the below eqation proceed to be solved: x*=y+z options: x=x*y+z or x=x*(y+z)   1
IS Array list is generic or non generic   1
Write a function which accepts a sentence as input parameter.Each word in that sentence is to be reversed. Space should be there between each words.Return the sentence with reversed words to main function and produce the required output. for eg:- i/p: jack jill jung kill o/p: kcaj llij gnuj llik Mind-Tree 1
How to Create Files by Using the FileInfo Class?   1
How to Create a Treeview Menu in ASP.NET with C#?   1
Code for Reading and writing from a file in c#?   1
program for string reverse(eg:- i am boy -> boy am i) Mind-Tree 8
Code for Working with Files under a Directory?   1
working with arrays   1
 
For more C Sharp Code Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com