ASP / Veri Tabanı

protected void Button4_Click(object sender, EventArgs e) { OleDbConnection yeni = new OleDbConnection(); OleDbCommand eski = new OleDbCommand(); OleDbDataReader rdr; yeni.ConnectionString = ” Provider = Microsoft.Jet.OleDb.4.0; Data Source = ” + Server.MapPath(“kayit.mdb”); yeni.Open(); eski.Connection = yeni; eski.CommandText = “SELECT * from kayit”; rdr = eski.ExecuteReader(); string KulAd, Sifre; KulAd = TextBox6.Text; Sifre = TextBox7.Text; while (rdr.Read()) { if (KulAd == Convert.ToString(rdr[“KulAd”]) […]

» Devamını Oku

DATABASE / SQL Server 2005 GSM No Kontrolü

CREATE FUNCTION [dbo].[fn_GSM] ( @deger nvarchar(1000) ) RETURNS @RtnValue table ( GSM nvarchar(10), Durum bit ) AS BEGIN SET @deger = LTRIM(RTRIM(@deger)) DECLARE @karakterler NVARCHAR(10) SET @karakterler = ‘0123456789’ DECLARE @deger_ NVARCHAR(1000) SET @deger_ = ” DECLARE @say INT SET @say = 1 DECLARE @harf NVARCHAR(1) WHILE (@say < = LEN(@deger)) BEGIN SET @harf = '' SET @harf = SUBSTRING(@deger, [...]

» Devamını Oku

DELPHI / Loop

// show 1,2,3,4,5 message boxes var i: integer; begin for i := 1 to 5 do begin ShowMessage(‘Box: ‘+IntToStr(i)); end; end; var i: integer; begin for i := 5 downto 1 do begin ShowMessage(‘T minus ‘ + IntToStr(i) + ‘seconds’); end; ShowMessage(‘For sequence executed!’); end; var i,j: integer; begin //be aware: //this double loop is executed 4×4=16 times for i:= […]

» Devamını Oku
1 34 35 36 37 38 73