Wednesday, September 19, 2012
Monday, July 9, 2012
Lessons : C# with SQL Server
Retrieve data to dataGridview
SqlDataAdapter da = new SqlDataAdapter(" sql quary", con);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
Retrieve data to combo box
SqlDataAdapter da = new SqlDataAdapter(" sql quary ", con);
con.Open();
DataTable dt = new DataTable();
da.Fill(dt);
txtcrs.DataSource = dt;
txtcrs.ValueMember = "crs_name";
con.Close();
Insert ,Update, Remove
SqlCommand cmd = new SqlCommand("sql quary", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
SqlData Reader
con.Open();
SqlCommand cmd = new SqlCommand("sql quary", con);
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
txypwd.Text = dr[0].ToString();
dr.Close();
con.Close();
Play Sound
import this - using System.Media;
SoundPlayer sp2 = new SoundPlayer("C:\\sounds\\access_denied.wav");
timer2.Start();
Check Connection State
if (con.State == ConnectionState.Open)
con.Close();
Connection Dbcon class Method
public static SqlConnection getConnection()
{
return new SqlConnection("Data Source=.;Initial Catalog=SAS;Integrated Security=True");
}
and import this to your windows form
SqlConnection con = DbCon.getConnection();
Read Image from database
SqlDataAdapter adp = new SqlDataAdapter("sp_SearchStImage '" + bn + "'", con);
DataTable dt = new DataTable();
adp.Fill(dt);
pictureBox1.Image = coverter.byteArrayToImage((byte[])dt.Rows[0][0]);
select datagrid view first column and current row
dataGridView1.CurrentRow.Cells[0].Value.ToString()
Complete Crystal Reports tutorial A to Z with C#
csharp.net-informations.com
SqlDataAdapter da = new SqlDataAdapter(" sql quary", con);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
Retrieve data to combo box
SqlDataAdapter da = new SqlDataAdapter(" sql quary ", con);
con.Open();
DataTable dt = new DataTable();
da.Fill(dt);
txtcrs.DataSource = dt;
txtcrs.ValueMember = "crs_name";
con.Close();
Insert ,Update, Remove
SqlCommand cmd = new SqlCommand("sql quary", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
SqlData Reader
con.Open();
SqlCommand cmd = new SqlCommand("sql quary", con);
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
txypwd.Text = dr[0].ToString();
dr.Close();
con.Close();
Play Sound
import this - using System.Media;
SoundPlayer sp2 = new SoundPlayer("C:\\sounds\\access_denied.wav");
timer2.Start();
Check Connection State
if (con.State == ConnectionState.Open)
con.Close();
Connection Dbcon class Method
public static SqlConnection getConnection()
{
return new SqlConnection("Data Source=.;Initial Catalog=SAS;Integrated Security=True");
}
and import this to your windows form
SqlConnection con = DbCon.getConnection();
Read Image from database
SqlDataAdapter adp = new SqlDataAdapter("sp_SearchStImage '" + bn + "'", con);
DataTable dt = new DataTable();
adp.Fill(dt);
pictureBox1.Image = coverter.byteArrayToImage((byte[])dt.Rows[0][0]);
select datagrid view first column and current row
dataGridView1.CurrentRow.Cells[0].Value.ToString()
Complete Crystal Reports tutorial A to Z with C#
csharp.net-informations.com
Sunday, June 24, 2012
Friday, December 16, 2011
Age Of Mythology
Description
Age Of Mythology (2002/RUS/ENG)
Year: 2002 | PC Game | Developer: Ensemble Studios | Publisher: Microsoft | 974 MB
Genre: Strategy (Real-time) / 3D
The Definitive Gold Edition famous Real Time Strategy! Stunning gameplay, nice graphics and excellent balance immediately brought this game on a special level. Established in the best tradition of the great hits of Age of Empires and Age of Kings, it is worthy of a place in the collection of any, even the most advanced player! Nine absolutely different peoples, each of them - the unique skills and talents over. Epic battles in the atmosphere of ancient legends and stories. Here are fighting even the ancient gods of Greece, Egypt and the Scandinavian countries. Its the era when the flow of blood is shed, and people worship the great inhabitants of heaven. The era of myths and legends!
Download This game:
Click "Download" to download this Game
Size:974MB
Wednesday, December 14, 2011
G I Joe: The Rise of Cobra (2009)
Download this movie:
Click "Download" to download this movie
DVDRip
Size: 810MB
[support for Download Managers]