how to change password in c# with ms access database..
please provide me full c# code....
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
pramod ojhaPosted Aug 23, 2013, 9:37 AM
thnks
Satyapriya NayakPosted Aug 22, 2013, 11:52 PM
pramod ojhaPosted Aug 22, 2013, 12:44 PM
Satyapriya NayakPosted Aug 21, 2013, 2:31 PM
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace Forgot_password
{
public partial class Form1 : Form
{
string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];
OleDbCommand com;
string str;
byte up = 0;
//OleDbDataAdapter oledbda;
public Form1()
{
InitializeComponent();
}
private void btn_change_Click(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(ConnectionString);
if (textBox3.Text != textBox2.Text)
{
MessageBox.Show("confirm password not matching with new passsword");
textBox3.Focus();
return;
}
try
{
con = new OleDbConnection(ConnectionString);
con.Open();
str = "select * from login";
com = new OleDbCommand(str, con);
OleDbDataReader reader = com.ExecuteReader();
while (reader.Read())
{
if (textBox1.Text == reader["empid"].ToString())
{
up = 1;
}
}
if (up == 1)
{
str = "update login set newpwd='" + textBox3.Text + "' where empid='" + textBox1.Text + "'";
com = new OleDbCommand(str, con);
com.ExecuteNonQuery();
MessageBox.Show("Password changed");
}
else
{
MessageBox.Show("Please enter correct empid and Newpassword");
textBox1.Focus();
}
reader.Close();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}