PcDr C# & FireBird & Oracle |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Kullanıcı & Şifre Kontrolü |
|
|
DataBase'den Kontrolü
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using FirebirdSql.Data.FirebirdClient;
using System.Text;
using System.Windows.Forms;
namespace PcDr
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
FbConnection cnn = new FbConnection("User=SYSDBA;Password=masterkey;Database=c:DATAPCDR.gdb;DataSource=127.0.0.1; Port=3050;Dialect=3; Charset=WIN1254;Role=;Connection lifetime=15;Pooling=true; MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;");
private void button4_Click(object sender, EventArgs e)
{
FbCommand cmm = new FbCommand("select kk.sira_no,kk.adi||' '||kk.soyadi from kullanicilar kk where kk.kullanici_adi='"+textBox6.Text+"' and kk.kullanici_sifre='"+textBox7.Text+"' and kk.goster is null",cnn);
FbDataReader dtr = null;
cnn.Open();
dtr = cmm.ExecuteReader();
int k_sira = -1;
string k_ad = "";
while (dtr.Read())
{
k_sira = int.Parse(dtr[0].ToString());
k_ad = dtr[1].ToString();
}
cnn.Close();
if (k_sira != -1 && k_ad != "")
{
MessageBox.Show(k_ad + " HOŞGELDİNİZ...!","PCDR KONTROL MERKEZİ...!");
RibbonForm2 pcdr = new RibbonForm2();
pcdr.Show();
this.Hide();
}
else
{
MessageBox.Show("KULLANICI ADI VE ŞİFREYİ KONTROL EDİNİZ...!","PCDR KONTROL MERKEZİ...!");
}
}
}
Form İçinde Kullanıcı & Şifre Belirleme
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using FirebirdSql.Data.FirebirdClient;
using System.Text;
using System.Windows.Forms;
namespace PcDr_Asat_Scada
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
timer1.Start();
}
private void button4_Click(object sender, EventArgs e)
{
string kullaniciAdi = textBox6.Text;
string sifre = textBox7.Text;
if (textBox6.Text == "1" & sifre == "Q")
{
RibbonForm2 pcdr = new RibbonForm2();
pcdr.ribbonPage2.Visible = false;
pcdr.Show();
this.Hide();
}
else
{
MessageBox.Show("KULLANICI ADI VE ŞİFREYİ YANLIŞ GİRDİNİZ LÜTFEN KONTROL EDİNİZ...!", "PCDR KONTROL MERKEZİ...!");
}
}
|
|
|
|
|
|
|
Bugün 20 ziyaretçi (22 klik) kişi burdaydı! |
|
|
|
|
|
|
|