-
Notifications
You must be signed in to change notification settings - Fork 0
/
bilgilerimigoruntule.cs
97 lines (80 loc) · 2.85 KB
/
bilgilerimigoruntule.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Data.Sql;
namespace bankmanagementapp
{
public partial class bilgilerimigoruntule : Form
{
SqlConnection con = new SqlConnection(@"Data Source");
SqlCommand com = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable dt;
int Move;
int Mouse_X;
int Mouse_Y;
public bilgilerimigoruntule(string value)
{
string accno = value;
InitializeComponent();
this.TopMost = true;
this.StartPosition = FormStartPosition.CenterScreen;
showdata(accno);
}
private void button4_Click(object sender, EventArgs e)
{
this.Close();
}
public void showdata(string accno)
{
con = new SqlConnection(@"Data Source");
con.Open();
com = new SqlCommand("SELECT customerinfo.customerno,customerinfo.firstname," +
"customerinfo.lastname,customerinfo.address,customerinfo.phone,customerinfo.birth," +
"customerinfo.salary,balances.balance " +
"FROM customerinfo FULL OUTER JOIN balances " +
"ON customerinfo.customerno = balances.customerno" +
" WHERE customerinfo.customerno=@customerno", con);
com.Parameters.AddWithValue("@customerno", accno);
SqlDataReader da = com.ExecuteReader();
while (da.Read())
{
txtHesapnumara.Text = da.GetValue(0).ToString();
txtİsim.Text = da.GetValue(1).ToString();
txtSoyad.Text = da.GetValue(2).ToString();
txtAdres.Text = da.GetValue(3).ToString();
txtDogumtarih.Text = da.GetValue(5).ToString();
txtTelefonnumara.Text = da.GetValue(4).ToString();
txtMaas.Text = da.GetValue(6).ToString();
txtMevcutbakiye.Text = da.GetValue(7).ToString();
}
da.Close();
con.Close();
}
private void bilgilerimigoruntule_MouseDown(object sender, MouseEventArgs e)
{
Move = 1;
Mouse_X = e.X;
Mouse_Y = e.Y;
}
private void bilgilerimigoruntule_MouseMove(object sender, MouseEventArgs e)
{
if (Move == 1)
{
this.SetDesktopLocation(MousePosition.X - Mouse_X, MousePosition.Y - Mouse_Y);
}
}
private void bilgilerimigoruntule_MouseUp(object sender, MouseEventArgs e)
{
Move = 0;
}
}
}