useful jquery examples

EXAMPLE OF JQUERY BANK CREDIT CALCULATOR

http://jsfiddle.net/48Hpa/19/

EXAMPLE OF NICE BACKGROUND COLORING WITH CSS

http://jsfiddle.net/vGeYB/3/

EXAMPLE OF JQUERY FOR SCROLLTOP

http://jsfiddle.net/xe7aL/883/

EXAMPLE OF JQUERY FOR CHANGE CHECKBOX EVENT

http://jsfiddle.net/JsUWv/737/

EXAMPLE OF JQUERY FOR CHANGE SELECTBOX EVENT

http://jsfiddle.net/WUtty/11/

EXAMPLE OF JQUERY UI BOUNCE EFFECT 

http://jsfiddle.net/Hx65Q/

EXAMPLE OF JQUERY UI EASEOUTBOUNCE EFFECT

http://jsfiddle.net/Hx65Q/11/

EXAMPLE OF ANIMATE AND JQUERY UI EASEOUTBOUNCE EFFECT

http://jsfiddle.net/Z8knE/2/

EXAMPLE OF setTimeout FUNCTION FOR DELAYS

http://jsfiddle.net/CrLNU/229/

How to create automatic ID numeration for MSSQL table

How to use Datareader on C# via ADO.NET

using System.Data.SqlClient; SqlConnection cnn = new SqlConnection("Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;"); cnn.Open(); SqlCommand cmd = new SqlCommand("SELECT FirstName,LastName FROM Employees WHERE EmployeeID = 1", cnn); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { textBox1.Text = dr.GetString(0); textBox2.Text = dr.GetString(1); } } cnn.Close();

How to delete data C# to SQL via ADO.NET

using System.Data.SqlClient; SqlConnection cnn = new SqlConnection("Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;"); private void button1_Click(object sender, EventArgs e) { cnn.Open(); SqlCommand cmd = new SqlCommand("DELETE FROM Employees WHERE EmployeeID = @CalisanID", cnn); cmd.Parameters.AddWithValue("@CalisanID", textBox1.Text); cmd.ExecuteNonQuery(); cnn.Close(); }

How to update data C# to SQL via ADO.NET

using System.Data.SqlClient; SqlConnection cnn = new SqlConnection("Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;"); private void button1_Click(object sender, EventArgs e) { cnn.Open(); SqlCommand cmd = new SqlCommand("UPDATE Employees SET FirstName = @CalisanAdi,LastName = @CalisanSoyadi WHERE EmployeeID = 1", cnn); cmd.Parameters.AddWithValue("@CalisanAdi", textBox1.Text); cmd.Parameters.AddWithValue("@CalisanSoyadi", textBox2.Text); cmd.ExecuteNonQuery(); cnn.Close(); }

How to insert data C# to SQL via ADO.NET

using System.Data.SqlClient; SqlConnection cnn = new SqlConnection("Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;"); private void button1_Click(object sender, EventArgs e) { cnn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO Employees (FirstName, LastName) VALUES (@CalisanAdi, @CalisanSoyadi)", cnn); cmd.Parameters.AddWithValue("@CalisanAdi", textBox1.Text); cmd.Parameters.AddWithValue("@CalisanSoyadi", textBox2.Text); cmd.ExecuteNonQuery(); cnn.Close(); }

INSERT UPDATE DELETE MSSQL

INSERT INTO Ogrenciler
(OgrenciAdi, OgrenciSoyadi)
VALUES
('Fatih', 'Yilmaz')

UPDATE Ogrenciler
SET
    OgrenciAdi = 'Ahmet',
    OgrenciSoyadi = 'Yusuf'
WHERE OgrenciID = '28'

DELETE FROM Ogrenciler
WHERE OgrenciID = 28