Text = = "All" && CheckBoxList1.SelectedIndex = = -1) { cmd = new SqlCommand ( "select a.img, a.prop_name, b.state_name, c.city_name, d.price, d.prop_price_type, d.builtup_area, d.carpet_area, d.bedrooms, d.prop_desc, e.ownership_name from tbl_image_entry a, tbl_state_new b, tbl_city_new c, tbl_new_sale_property d, tbl_ownership_master e where a.user_id = d.user_id and b.state_id = d.state and c.city_id = d.city and a.prop_name = d.prop_name and e.ownership_id = d.prop_ownership and prop_type CheckBoxList1.Items[2].Selected = = false ) { cmd = new SqlCommand ( "select a.img, a.prop_name, b.state_name, c.city_name, d.price, d.prop_price_type, d.builtup_area, d.carpet_area, d.bedrooms, d.prop_desc, e.ownership_name from tbl_image_entry a, tbl_state_new b, tbl_city_new c, tbl_new_sale_property d, tbl_ownership_master e where a.user_id = d.user_id and b.state_id = d.state and c.city_id = d.city and a.prop_name = d.prop_name and e.ownership_id = d.prop_ownership and prop_ownership CheckBoxList1.Items[2].Selected = = false ) { cmd = new SqlCommand ( "select a.img, a.prop_name, b.state_name, c.city_name, d.price, d.prop_price_type, d.builtup_area, d.carpet_area, d.bedrooms, d.prop_desc, e.ownership_name from tbl_image_entry a, tbl_state_new b, tbl_city_new c, tbl_new_sale_property d, tbl_ownership_master e where a.user_id = d.user_id and b.state_id = d.state and
C# / Ping Hi. First I would like to thank all of yoy for your fast repleys System.Runtime.InteropServices; using System.Threading; using System.Data; using System.Data.SqlClient; namespace printHosts { class Program { static void Main( string [] args) { if (args.Length = = 0) { } SqlConnection oconn; SqlCommand ocomm; string Fill(ds, "Hostinfo" ); foreach ( DataRow row in ds.Tables[0].Rows) { address = row[ "hostname" ].ToString(); Console .WriteLine(address); try { sSql = "SELECT COUNT(*) FROM Hostinfo WHERE hostname = '" + address + "'" ; ocomm = new SqlCommand (sSql ip = null ; try { ip = Dns .GetHostEntry(address).AddressList[0]; } catch (System.Net.Sockets. SocketException ex) { Console .WriteLine( "DNS Error: {0}" , ex.Message); Console .WriteLine( "Press any key to exit." ); Console .ReadLine(); return ; } / / Console.WriteLine("Pinging {0} [{1}] with 32 bytes of data:", address, ip.ToString()); Console .WriteLine(); Thread pingThread = new Thread ( new ParameterizedThreadStart (StartPing)); pingThread.Start(ip); pingThread.Join(); } } [ Flags ] enum