Database

<br />
           SqlConnection conn= new SqlConnection("ConnectionString");<br />
			conn.Open();<br />
			MessageBox.Show("Connection est.."); <br />
			SqlCommand comCreate = new SqlCommand("CREATE  TABLE  EMP_TABLE_CREATE(EmpID INT , EmpName  VARCHAR(20))",conn);<br />
			int intCreate = comCreate.ExecuteNonQuery();<br />
            MessageBox.Show("Table Created.." + intCreate); <br />
            SqlCommand conInsert = new SqlCommand("INSERT INTO EMP_TABLE_CREATE VALUES(11,'MyName')",conn ) ;<br />
		    int intInsert = conInsert.ExecuteNonQuery(); <br />
			MessageBox.Show("Row Inserted.." + intInsert); <br />
			MessageBox.Show("Displaying Row : "); <br />
			SqlCommand conSelect = new SqlCommand("SELECT * FROM EMP_TABLE_CREATE",conn) ;<br />
			SqlDataReader dr= conSelect.ExecuteReader(); <br />
			dr.Read();<br />
			while(dr.HasRows)<br />
			{<br />
                              MessageBox.Show(dr.GetInt32(0).ToString() +":"+dr.GetString(1)) ; <br />
				dr.NextResult(); <br />
			}<br />
			conn.Close(); <br />