var d = new Date,
dformat = [ (d.getMonth()+1).padLeft(),
d.getDate().padLeft(),
d.getFullYear()].join(‘-‘)+
‘T’ +
[ d.getHours().padLeft(),
d.getMinutes().padLeft(),
d.getSeconds().padLeft()].join(‘:’);
$(‘#result’).html(dformat);
the output will be get in below format
2/07/2017T04:25:20
feedjit helps to capture your site traffic, please follow the below steps.
1. Sign into your WordPress blog or website
2. Go to “Appearance” and then the “Widgets” submenu.
3. Give it a title and then paste in the code below.
<a href=”http://feedjit.com/ir1/a3cdd27151c088d2ff2d89b626183b35/”><img src=”http://feedjit.com/b/a3cdd27151c088d2ff2d89b626183b35.png” alt=”” border=”0″ ISMAP /></a>
That’s it!! Easy as pie. You’re now watching your traffic in real-time.
// Main Program
class Program : Test
{
static void Main(string[] args)
{
Program p = new Program();
p.add();
p.sub();
p.SayHello();
p.SayGoodbye();Console.ReadLine();
}
}// Abstract Class
public abstract class Sample
{
public void SayHello()
{
Console.WriteLine(“Hello”);
}public abstract void add(); // Abstract method
public abstract void sub(); // Abstract methodpublic virtual void SayGoodbye() // Virtual Method
{
Console.WriteLine(“Goodbye”);
}
}// override virtual method
public class Test :Sample
{
public override void add() // Abstract definition
{
Console.WriteLine(“called abstract add method”);
}public override void SayGoodbye() // overide with virtual method
{
Console.WriteLine(“See you later”);
}public override void sub() // Abstract definition
{
Console.WriteLine(“called abstract sub method”);
}
}
I have face this issue read an excel file in asp.net and windows application, please follow below instruction to eradicate this issue.
ASP.NET
1.-Open IIS
2.-Change the appPool on Advanced Settings
3.-true to enable to 32-bit application.WINDOWS APPLICATION
To resolve this issue open the project in Visual Studio then:
1. From the solution explorer right-click your project then click Properties
2. Click the Build tab
3. Change Platform target from: Any CPU to x86
4. Re-build your solution and run your application.Step 1 :
Step 2 :
Step 3:
Step 4 :
Step 5 :
Re-build your solution and run your application.
We create the new encrypted record from the SQL table. Please read the following procedure. We should to create the master keys and insert the values into the table and viewing the inserted record. Drop the key if not using the encryption method.
1 ) CREATE MASTER KEY
CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘Windows@123’
2)CREATE CERTIFICATE
CREATE CERTIFICATE PasswordFieldCertificate
WITH SUBJECT =’PasswordFieldCertificate’3) CREATE SYMMETRIC KEY
CREATE SYMMETRIC KEY PasswordFieldSymmetricKey
WITH ALGORITHM = TRIPLE_DES
ENCRYPTION BY CERTIFICATE PasswordFieldCertificate
INSERT THE NEW RECORD
INSERT INTO LoginAccount(
LoginID,
UserName,
Name,
Password
)
VALUES (
12120,
Windows08,
Gates,
Mircosoft2013
)VIEWING THE NEW RECORD
OPEN SYMMETRIC KEY PasswordFieldSymmetricKey
DECRYPTION BY CERTIFICATE PasswordFieldCertificate;SELECT LoginID,
UserName,
Name,
convert(varchar(150),DecryptByKey(Password)) AS Password
FROM dbo.LoginAccount where LoginID = 12120CLOSE SYMMETRIC KEY PasswordFieldSymmetricKey;
DROP ALL YOUR MASTER KEYS
DROP MASTER KEY
DROP CERTIFICATE PASSWORDFIELDCERTIFICATE
DROP SYMMETRIC KEY PASSWORDFIELDSYMMETRICKEY
<script type=”text/javascript”>
function ValidateCurrentTimezone() {
// ********************** VALIDATION *******************
if (document.getElementById(‘ddlTimezone’).value == ‘0’) {
document.getElementById(‘result’).style.display = ‘none’;
document.getElementById(‘ShowServerTime’).style.color = ‘red’;
document.getElementById(‘ShowServerTime’).innerHTML = ‘Please select the timezone’;
return false;
}var now = new Date();
// ****************** GET CURRENT UTC TIME **************
var now_utc = new Date(now.getUTCFullYear(), now.getUTCMonth(), now.getUTCDate(), now.getUTCHours(), now.getUTCMinutes(), now.getUTCSeconds());var Hr = document.getElementById(‘ddlTimezone’).value.split(‘:’)[0];
var Min = document.getElementById(‘ddlTimezone’).value.split(‘:’)[1];
var Cur_TimeZoneVal;var UTC_Hr;
var UTC_min;UTC_Hr = now.getUTCHours() + parseInt(Hr, 10);
UTC_min = now.getUTCMinutes() + parseInt(Min, 10);//***************** GET TIMEZONE PRESENT TIME ************
Cur_TimeZoneVal = new Date(now.getUTCFullYear(), now.getUTCMonth(), now.getUTCDate(), UTC_Hr, UTC_min, 0);
document.getElementById(‘result’).style.display = ‘block’;
document.getElementById(‘ShowServerTime’).style.color = ‘green’;
document.getElementById(‘ShowServerTime’).innerHTML = ‘local Time =’ + now + ‘</br> UTC = ‘ + now_utc + ‘</br> Timezone present time =’ + Cur_TimeZoneVal;return false;
}
</script>
<body>
<div>
<div>
<div style=”float: left”>
<select id=”ddlTimezone”>
<option selected=”selected” value=”0″>–select–</option>
<option value=”00:00:00″>(UTC) Casablanca</option>
<option value=”00:00:00″>(UTC) Coordinated Universal Time</option>
<option value=”00:00:00″>(UTC) Dublin, Edinburgh, Lisbon, London</option>
<option value=”00:00:00″>(UTC) Monrovia, Reykjavik</option>
<option value=”01:00:00″>(UTC+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna</option>
<option value=”01:00:00″>(UTC+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague</option>
<option value=”01:00:00″>(UTC+01:00) Brussels, Copenhagen, Madrid, Paris</option>
<option value=”01:00:00″>(UTC+01:00) Sarajevo, Skopje, Warsaw, Zagreb</option>
<option value=”01:00:00″>(UTC+01:00) West Central Africa</option>
<option value=”01:00:00″>(UTC+01:00) Windhoek</option>
<option value=”02:00:00″>(UTC+02:00) Amman</option>
<option value=”02:00:00″>(UTC+02:00) Athens, Bucharest</option>
<option value=”02:00:00″>(UTC+02:00) Beirut</option>
<option value=”02:00:00″>(UTC+02:00) Cairo</option>
<option value=”02:00:00″>(UTC+02:00) Damascus</option>
<option value=”02:00:00″>(UTC+02:00) Harare, Pretoria</option>
<option value=”02:00:00″>(UTC+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius</option>
<option value=”02:00:00″>(UTC+02:00) Istanbul</option>
<option value=”02:00:00″>(UTC+02:00) Jerusalem</option>
<option value=”02:00:00″>(UTC+02:00) Nicosia</option>
<option value=”03:00:00″>(UTC+03:00) Baghdad</option>
<option value=”03:00:00″>(UTC+03:00) Kaliningrad, Minsk</option>
<option value=”03:00:00″>(UTC+03:00) Kuwait, Riyadh</option>
<option value=”03:00:00″>(UTC+03:00) Nairobi</option>
<option value=”03:30:00″>(UTC+03:30) Tehran</option>
<option value=”04:00:00″>(UTC+04:00) Abu Dhabi, Muscat</option>
<option value=”04:00:00″>(UTC+04:00) Baku</option>
<option value=”04:00:00″>(UTC+04:00) Moscow, St. Petersburg, Volgograd</option>
<option value=”04:00:00″>(UTC+04:00) Port Louis</option>
<option value=”04:00:00″>(UTC+04:00) Tbilisi</option>
<option value=”04:00:00″>(UTC+04:00) Yerevan</option>
<option value=”04:30:00″>(UTC+04:30) Kabul</option>
<option value=”05:00:00″>(UTC+05:00) Islamabad, Karachi</option>
<option value=”05:00:00″>(UTC+05:00) Tashkent</option>
<option value=”05:30:00″>(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi</option>
<option value=”05:30:00″>(UTC+05:30) Sri Jayawardenepura</option>
<option value=”05:45:00″>(UTC+05:45) Kathmandu</option>
<option value=”06:00:00″>(UTC+06:00) Astana</option>
<option value=”06:00:00″>(UTC+06:00) Dhaka</option>
<option value=”06:00:00″>(UTC+06:00) Ekaterinburg</option>
<option value=”06:30:00″>(UTC+06:30) Yangon (Rangoon)</option>
<option value=”07:00:00″>(UTC+07:00) Bangkok, Hanoi, Jakarta</option>
<option value=”07:00:00″>(UTC+07:00) Novosibirsk</option>
<option value=”08:00:00″>(UTC+08:00) Beijing, Chongqing, Hong Kong, Urumqi</option>
<option value=”08:00:00″>(UTC+08:00) Krasnoyarsk</option>
<option value=”08:00:00″>(UTC+08:00) Kuala Lumpur, Singapore</option>
<option value=”08:00:00″>(UTC+08:00) Perth</option>
<option value=”08:00:00″>(UTC+08:00) Taipei</option>
<option value=”08:00:00″>(UTC+08:00) Ulaanbaatar</option>
<option value=”09:00:00″>(UTC+09:00) Irkutsk</option>
<option value=”09:00:00″>(UTC+09:00) Osaka, Sapporo, Tokyo</option>
<option value=”09:00:00″>(UTC+09:00) Seoul</option>
<option value=”09:30:00″>(UTC+09:30) Adelaide</option>
<option value=”09:30:00″>(UTC+09:30) Darwin</option>
<option value=”10:00:00″>(UTC+10:00) Brisbane</option>
<option value=”10:00:00″>(UTC+10:00) Canberra, Melbourne, Sydney</option>
<option value=”10:00:00″>(UTC+10:00) Guam, Port Moresby</option>
<option value=”10:00:00″>(UTC+10:00) Hobart</option>
<option value=”10:00:00″>(UTC+10:00) Yakutsk</option>
<option value=”11:00:00″>(UTC+11:00) Solomon Is., New Caledonia</option>
<option value=”11:00:00″>(UTC+11:00) Vladivostok</option>
<option value=”12:00:00″>(UTC+12:00) Auckland, Wellington</option>
<option value=”12:00:00″>(UTC+12:00) Coordinated Universal Time+12</option>
<option value=”12:00:00″>(UTC+12:00) Fiji</option>
<option value=”12:00:00″>(UTC+12:00) Magadan</option>
<option value=”12:00:00″>(UTC+12:00) Petropavlovsk-Kamchatsky – Old</option>
<option value=”13:00:00″>(UTC+13:00) Nuku’alofa</option>
<option value=”13:00:00″>(UTC+13:00) Samoa</option>
<option value=”-01:00:00″>(UTC-01:00) Azores</option>
<option value=”-01:00:00″>(UTC-01:00) Cape Verde Is.</option>
<option value=”-02:00:00″>(UTC-02:00) Coordinated Universal Time-02</option>
<option value=”-02:00:00″>(UTC-02:00) Mid-Atlantic</option>
<option value=”-03:00:00″>(UTC-03:00) Brasilia</option>
<option value=”-03:00:00″>(UTC-03:00) Buenos Aires</option>
<option value=”-03:00:00″>(UTC-03:00) Cayenne, Fortaleza</option>
<option value=”-03:00:00″>(UTC-03:00) Greenland</option>
<option value=”-03:00:00″>(UTC-03:00) Montevideo</option>
<option value=”-03:00:00″>(UTC-03:00) Salvador</option>
<option value=”-03:30:00″>(UTC-03:30) Newfoundland</option>
<option value=”-04:00:00″>(UTC-04:00) Asuncion</option>
<option value=”-04:00:00″>(UTC-04:00) Atlantic Time (Canada)</option>
<option value=”-04:00:00″>(UTC-04:00) Cuiaba</option>
<option value=”-04:00:00″>(UTC-04:00) Georgetown, La Paz, Manaus, San Juan</option>
<option value=”-04:00:00″>(UTC-04:00) Santiago</option>
<option value=”-04:30:00″>(UTC-04:30) Caracas</option>
<option value=”-05:00:00″>(UTC-05:00) Bogota, Lima, Quito</option>
<option value=”-05:00:00″>(UTC-05:00) Eastern Time (US & Canada)</option>
<option value=”-05:00:00″>(UTC-05:00) Indiana (East)</option>
<option value=”-06:00:00″>(UTC-06:00) Central America</option>
<option value=”-06:00:00″>(UTC-06:00) Central Time (US & Canada)</option>
<option value=”-06:00:00″>(UTC-06:00) Guadalajara, Mexico City, Monterrey</option>
<option value=”-06:00:00″>(UTC-06:00) Saskatchewan</option>
<option value=”-07:00:00″>(UTC-07:00) Arizona</option>
<option value=”-07:00:00″>(UTC-07:00) Chihuahua, La Paz, Mazatlan</option>
<option value=”-07:00:00″>(UTC-07:00) Mountain Time (US & Canada)</option>
<option value=”-08:00:00″>(UTC-08:00) Baja California</option>
<option value=”-08:00:00″>(UTC-08:00) Pacific Time (US & Canada)</option>
<option value=”-09:00:00″>(UTC-09:00) Alaska</option>
<option value=”-10:00:00″>(UTC-10:00) Hawaii</option>
<option value=”-11:00:00″>(UTC-11:00) Coordinated Universal Time-11</option>
<option value=”-12:00:00″>(UTC-12:00) International Date Line West</option>
</select>
</div>
</div>
<div>
<asp:Button ID=”btnTimezone” runat=”server” Text=”Check Time” OnClientClick=”javascript:return ValidateCurrentTimezone();” />
</div>
</div>
<div id=”result” style=”background-color: orange; text-align: center; display:none; width:40%”>
<p>
Time zone Present time</p>
</div>
<div id=”ShowServerTime”>
</div></body>
Header File
using System.Drawing;
Coding
System.Drawing.Color col = System.Drawing.ColorTranslator.FromHtml(‘#23AE11’);
Color forColor = new Color();
forColor = IdealTextColor(col);tblColor10.Style.Add(“background”, ‘#’ + objBLEvent.StrEventColor);
tblColor1.Style.Add(“color”, forColor.ToString() == “Color [White]” ? “#ffffff” : “#000000”);
Sub Function
public Color IdealTextColor(Color bg)
{
int nThreshold = 105;
int bgDelta = Convert.ToInt32((bg.R * 0.299) + (bg.G * 0.587) +
(bg.B * 0.114));Color foreColor = (255 – bgDelta < nThreshold) ? Color.Black : Color.White;
return foreColor;
}
CREATE FUNCTION [dbo].[FN_GetArrayList]
(
@Val VARCHAR(25),
@Pos INT
)
RETURNS INT
AS
BEGIN
DECLARE @ColumnRowList VARCHAR(MAX)
DECLARE @Tbl TABLE(row int Identity(1,1),VALS varchar(10))
INSERT INTO @Tbl
SELECT Items FROM Split(@Val,’:’)
SELECT @ColumnRowList = VALS FROM @Tbl WHERE row=@PosRETURN @ColumnRowList
ENDExecute following commend
SELECT dbo.[FN_GetArrayList](’23:25:37‘,3) as Val
OUTPUT
VAL OF 37 AT THE 3rd position in the list
if (ds != null)
{
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
StringWriter tw = null;
HtmlTextWriter hw = null;
DataTable dt1 = null;
GridView gv = null;
try
{
Response.Clear();
string filename = “InQuiryExport.xls”;
filename = filename.Substring(0, filename.IndexOf(‘.’));
filename = filename + “.xls”;
Response.Cache.SetExpires(DateTime.Now.AddSeconds(1));
Response.ContentType = “application/vnd.ms-excel”;
Response.ContentEncoding = Encoding.Unicode;
Response.BinaryWrite(Encoding.Unicode.GetPreamble());
Response.Charset = “”;
this.EnableViewState = false;
Response.Write(“<html xmlns:x=\”urn:schemas-microsoft-com:office:excel\”>”);
Response.Write(“\r\n”);
Response.Write(“<style> .text ” + “\r\n” + ” {mso-style-parent:style0;mso-number-format:\”” + @”\@” + “\”” + “;} ” + “\r\n” + “</style>”);
tw = new StringWriter();
hw = new HtmlTextWriter(tw);
dt1 = (DataTable)ds.Tables[0];
gv = new GridView();
gv.DataSource = dt1;
gv.DataBind();
gv.RenderControl(hw);
Response.AppendHeader(“content-disposition”, “attachment;filename=” + filename);
Response.Write(tw.ToString());
Response.Flush();
Response.End();
}
catch (Exception ex)
{
if (tw != null) tw.Dispose();
if (hw != null) hw.Dispose(); ;
if (dt1 != null) dt1.Dispose();
if (gv != null) gv.Dispose();
}
finally
{
if (tw != null) tw.Dispose();
if (hw != null) hw.Dispose();
if (dt1 != null) dt1.Dispose();
if (gv != null) gv.Dispose();
}
}
}
<script type="text/javascript">
<!--
function popup(url)
{
params = 'width='+screen.width;
params += ', height='+screen.height;
params += ', top=0, left=0'
params += ', fullscreen=yes';
newwin=window.open(url,'windowname4', params);
if (window.focus) {newwin.focus()}
return false;
}
// -->
</script>
<a href="javascript: void(0)"
onclick="popup('popup.html')">Fullscreen popup window</a>
The Complete .Net Forum 
