using System;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;
namespace atmsystem
{
public partial class AdminForm : Form
{
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbConnection con = new OleDbConnection();
DataTable dt = new DataTable();
string sql;
OleDbCommand cmd = new OleDbCommand();
public AdminForm()
{
InitializeComponent();
}
private void AdminForm_Load(object sender, EventArgs e)
{
con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + "\\ATMsystem.accdb";
Label11.Text = DateTime.Now.ToString();
txtfname.Enabled = false;
GroupBox2.Enabled = false;
btnok.Enabled = false;
}
private void Button4_Click(object sender, EventArgs e)
{
txtfname.Enabled = true;
btnok.Enabled = true;
}
private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int i = e.RowIndex;
int j = e.ColumnIndex;
if (j == 0)
{
try
{
txtAcctNo.Text = Convert.ToString(DataGridView1.Rows[i].Cells[j].Value);
txtfnme.Text = Convert.ToString(DataGridView1.Rows[i].Cells[j + 1].Value);
lblhide.Text = Convert.ToString(DataGridView1.Rows[i].Cells[j + 1].Value);
txtaddr.Text = Convert.ToString(DataGridView1.Rows[i].Cells[j + 3].Value);
cbGender.Text = Convert.ToString(DataGridView1.Rows[i].Cells[j + 5].Value);
txtbday.Text = Convert.ToString(DataGridView1.Rows[i].Cells[j + 6].Value);
txtPincode.Text = Convert.ToString(DataGridView1.Rows[i].Cells[j + 7].Value);
GroupBox2.Enabled = true;
btnedit.Enabled = false;
Button4.Enabled = false;
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
}
private void Button5_Click(object sender, EventArgs e)
{
try
{
con.Open();
da = new OleDbDataAdapter("select * from ATM", con);
dt.Clear(); // Clear the DataTable before filling it again
da.Fill(dt);
DataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
private void btnok_Click(object sender, EventArgs e)
{
try
{
con.Open();
sql = "SELECT * FROM ATM WHERE FullName = ?";
da = new OleDbDataAdapter(sql, con);
da.SelectCommand.Parameters.AddWithValue("@fullname", txtfname.Text);
dt.Clear(); // Clear the DataTable before filling it again
da.Fill(dt);
DataGridView1.DataSource = dt;
btnok.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
private void btnedit_Click(object sender, EventArgs e)
{
GroupBox2.Enabled = true;
btnedit.Enabled = false;
Button4.Enabled = false;
}
private void btncancel_Click(object sender, EventArgs e)
{
GroupBox2.Enabled = false;
btnedit.Enabled = true;
Button4.Enabled = true;
txtfname.Enabled = false;
btnok.Enabled = false;
}
private void btnupdate_Click(object sender, EventArgs e)
{
try
{
con.Open();
sql = "UPDATE ATM SET ClientID=?, Pin=?, FullName=?, Address=?, Gender=? WHERE FullName=?";
cmd = new OleDbCommand(sql, con);
cmd.Parameters.AddWithValue("@clientid", txtAcctNo.Text);
cmd.Parameters.AddWithValue("@pin", txtPincode.Text);
cmd.Parameters.AddWithValue("@fullname", txtfnme.Text);
cmd.Parameters.AddWithValue("@address", txtaddr.Text);
cmd.Parameters.AddWithValue("@gender", cbGender.Text);
cmd.Parameters.AddWithValue("@oldfullname", lblhide.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Success");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
DataGridView1.Refresh();
}
}
private void Button1_Click(object sender, EventArgs e)
{
Login_frm.Default.Show();
this.Hide();
}
}
}
Write, Run & Share C# code online using OneCompiler's C# online compiler for free. It's one of the robust, feature-rich online compilers for C# language, running on the latest version 8.0. Getting started with the OneCompiler's C# compiler is simple and pretty fast. The editor shows sample boilerplate code when you choose language as C# and start coding.
OneCompiler's C# online compiler supports stdin and users can give inputs to programs using the STDIN textbox under the I/O tab. Following is a sample program which takes name as input and print your name with hello.
using System;
namespace Sample
{
class Test
{
public static void Main(string[] args)
{
string name;
name = Console.ReadLine();
Console.WriteLine("Hello {0} ", name);
}
}
}
C# is a general purpose object-oriented programming language by Microsoft. Though initially it was developed as part of .net but later it was approved by ECMA and ISO standards.
You can use C# to create variety of applications, like web, windows, mobile, console applications and much more using Visual studio.
| Data Type | Description | Range | size |
|---|---|---|---|
| int | To store integers | -2,147,483,648 to 2,147,483,647 | 4 bytes |
| double | to store large floating point numbers with decimals | can store 15 decimal digits | 8 bytes |
| float | to store floating point numbers with decimals | can store upto 7 decimal digits | 4 bytes |
| char | to store single characters | - | 2 bytes |
| string | to stores text | - | 2 bytes per character |
| bool | to stores either true or false | - | 1 bit |
datatype variable-name = value;
When ever you want to perform a set of operations based on a condition or set of few conditions IF-ELSE is used.
if(conditional-expression) {
// code
}
else {
// code
}
You can also use if-else for nested Ifs and If-Else-If ladder when multiple conditions are to be performed on a single variable.
Switch is an alternative to If-Else-If ladder.
switch(conditional-expression) {
case value1:
// code
break; // optional
case value2:
// code
break; // optional
...
default:
// code to be executed when all the above cases are not matched;
}
For loop is used to iterate a set of statements based on a condition.
for(Initialization; Condition; Increment/decrement) {
// code
}
While is also used to iterate a set of statements based on a condition. Usually while is preferred when number of iterations are not known in advance.
while(condition) {
// code
}
Do-while is also used to iterate a set of statements based on a condition. It is mostly used when you need to execute the statements atleast once.
do {
// code
} while (condition);
Array is a collection of similar data which is stored in continuous memory addresses. Array values can be fetched using index. Index starts from 0 to size-1.
data-type[] array-name;
Method is a set of statements which gets executed only when they are called. Call the method name in the main function to execute the method.
static void method-name()
{
// code to be executed
}