insert into TBL_TARGET([USERNAME],[PASSWORD],[ACTION])
select [USERNAME] ,[PASSWORD], 'I'
from [TBL_SOURCE]
SELECT COUNT(*) as TotalTables FROM sys.tables WHERE type in ('u')
Of course, first you have to connect to your database.
Hope it helps.
private struct GeoIPResponse
{
//this is the response I get
//{"IP":"127.0.0.1","continentCode":"Unknown","continentName":"Unknown",
//"countryCode2":"Unknown","COUNTRY":"Unknown","countryCode3":"Unknown","countryName":"Unknown","regionName":"Unknown",
//"cityName":"Unknown","cityLatitude":0,"cityLongitude":0,"countryLatitude":0,"countryLongitude":0,"localTimeZone":"Unknown",
//"localTime":"0"}
public string IP;
public string continentCode;
public string continentName;
public string countryCode2;
public string COUNTRY;
public string countryCode3;
public string countryName;
public string regionName;
public string cityName;
public string cityLatitude;
public string cityLongitude;
public string countryLatitude;
public string countryLongitude;
public string localTimeZone;
public string localTime;
}
/*
then I defined some needful methods:
*/
///
/// Returns Client Ip Address
///
static public string ClientIpAddress
{
get
{
string _clientIPAddress = HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (!string.IsNullOrEmpty(_clientIPAddress))
{
string[] ipRange = _clientIPAddress.Split(',');
_clientIPAddress = ipRange[ipRange.Length - 1];
}
else
{
_clientIPAddress = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
}
return _clientIPAddress;
}
}
public string _WebRequest(string strURL)
{
String strResult;
WebResponse objResponse;
WebRequest objRequest = HttpWebRequest.Create(strURL);
objRequest.Method = "GET";
objResponse = objRequest.GetResponse();
using (StreamReader sr = new StreamReader(objResponse.GetResponseStream()))
{
strResult = sr.ReadToEnd();
sr.Close();
}
return strResult;
}
and finally this is the way I used a service from www.easyjquery.com: :
protected void Page_Load(object sender, EventArgs e)
{
txtMessage.Text = "";
string Result = _WebRequest("http://api.easyjquery.com/ips/?ip=" + ClientIpAddress + "&full=true");
txtMessage.Text = Result;
JavaScriptSerializer jss = new JavaScriptSerializer();
var clientGeoLocation = jss.Deserialize < GeoIPResponse >(Result);
lblMessage.Text = "
Your short details: " + "Country: " + clientGeoLocation.COUNTRY + ", CountryCode 2: " + clientGeoLocation.countryCode2 + ", CountryCode 3: " + clientGeoLocation.countryCode3 +
", TimeZone: " + clientGeoLocation.localTimeZone;
}
< ? xml version="1.0" encoding="UTF-8" ? >
< ! DOCTYPE
xsl:stylesheet [
< ! ENTITY nbsp " ">
] >
If you need explanations about code please write it as a comment ;)
DECLARE @TableName varchar(500)
DECLARE cur CURSOR
FOR SELECT [name] FROM sys.tables WHERE type in ('u')
OPEN cur
FETCH NEXT FROM cur INTO @TableName
WHILE @@fetch_status = 0
BEGIN
EXEC('DROP TABLE ' + @TableName)
--select @TableName
FETCH NEXT FROM cur INTO @TableName
END
CLOSE cur
DEALLOCATE cur
In case you have constraints take special care you delete tables one by one ;)
DECLARE @procedureName varchar(500)
DECLARE cur CURSOR
FOR SELECT [name] FROM sys.procedures WHERE type in ('p', 'fn') and is_ms_shipped=0 and name not like 'sp[_]%diagram%'
OPEN cur
FETCH NEXT FROM cur INTO @procedureName
WHILE @@fetch_status = 0
BEGIN
EXEC('DROP PROCEDURE ' + @procedureName)
--select @procedureName
FETCH NEXT FROM cur INTO @procedureName
END
CLOSE cur
DEALLOCATE cur
SELECT [name], [type], create_date, modify_date
FROM sys.objects
WHERE [type] in ('P', 'FN', 'V')
order by [Type ] asc
public string GenerateLink(string Option)
{
string Response = "";
Response = "<a href=\"YourPage.aspx?option=" + ((Option == "holiday") ? "goHoliday" : "goAndWork").ToString() + "\">Click</a>";
return Response;
}
public bool IsEmailSyntaxValid(string emailToValidate)
{
return System.Text.RegularExpressions.Regex.IsMatch(emailToValidate,
@"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$");
}
.your_div textarea {
resize: none;
}
//Returns an array with properties of an object
function GetAnArrayOfPropertiesForAnObject($Object)
{
$arrayProperties = get_object_vars( $Object);
foreach($arrayProperties as $key=>$value)
{
$returnArray[] = strtolower($key);
}
return $returnArray;
}
if(isset($_POST['newsletter'])) $newsletter= 1; else $newsletter= 0;
DataTable dtCompanies = GetCompanies();
string Message = "";
int rowCount = 0;
foreach (DataRow dRow in dtCompanies.Rows)
{
Message += "Row:" + rowCount + ", Columns: ";
foreach (DataColumn dCol in dtCompanies.Columns)
{
Message += dCol.ColumnName + "( " + dtCompanies.Rows[rowCount][dCol].ToString() + " ) ";
}
rowCount++;
}
void Application_End(object sender, EventArgs e)
{
// This is a custom function that you must make and
// check your threads in the program
MyTheadClass.WaitForAllMyThreadsToExist();
// after this function exit the rest of the threads are killed.
}
If you use the app_offline.htm feature, you should make sure you have at least 512 bytes of content within it to make sure that your HTML (instead of IE's friendly status message) shows up to your users. If you don't want to have a lot of text show-up on the page, one trick you can use is to just add an html client-side comment with some extra content to push it over 512 bytes. You can insert html comments just to make your file bigger.
var navigatorVersion = navigator.appVersion;
var navigatorAgent = navigator.userAgent;
var browserName = navigator.appName;
var fullVersionName = '' + parseFloat(navigator.appVersion);
var majorVersionName = parseInt(navigator.appVersion, 10);
var nameOffset, verOffset, ix;
// In Firefox, the true version is after "Firefox"
if ((verOffset = navigatorAgent.indexOf("Firefox")) != -1) {
browserName = "Firefox";
fullVersionName = navigatorAgent.substring(verOffset + 8);
}
// In MSIE, the true version is after "MSIE" in userAgent
else if ((verOffset = navigatorAgent.indexOf("MSIE")) != -1) {
browserName = "Microsoft Internet Explorer";
fullVersionName = navigatorAgent.substring(verOffset + 5);
}
// In Chrome, the true version is after "Chrome"
else if ((verOffset = navigatorAgent.indexOf("Chrome")) != -1) {
browserName = "Chrome";
fullVersionName = navigatorAgent.substring(verOffset + 7);
}
// In Opera, the true version is after "Opera" or after "Version"
else if ((verOffset = navigatorAgent.indexOf("Opera")) != -1) {
browserName = "Opera";
fullVersionName = navigatorAgent.substring(verOffset + 6);
if ((verOffset = navigatorAgent.indexOf("Version")) != -1)
fullVersionName = navigatorAgent.substring(verOffset + 8);
}
// In Safari, the true version is after "Safari" or after "Version"
else if ((verOffset = navigatorAgent.indexOf("Safari")) != -1) {
browserName = "Safari";
fullVersionName = navigatorAgent.substring(verOffset + 7);
if ((verOffset = navigatorAgent.indexOf("Version")) != -1)
fullVersionName = navigatorAgent.substring(verOffset + 8);
}
// In most other browsers, "name/version" is at the end of userAgent
else if ((nameOffset = navigatorAgent.lastIndexOf(' ') + 1) <
(verOffset = navigatorAgent.lastIndexOf('/'))) {
browserName = navigatorAgent.substring(nameOffset, verOffset);
fullVersionName = navigatorAgent.substring(verOffset + 1);
if (browserName.toLowerCase() == browserName.toUpperCase()) {
browserName = navigator.appName;
}
}
// trim the fullVersionName string at semicolon/space if present
if ((ix = fullVersionName.indexOf(";")) != -1)
fullVersionName = fullVersionName.substring(0, ix);
if ((ix = fullVersionName.indexOf(" ")) != -1)
fullVersionName = fullVersionName.substring(0, ix);
majorVersionName = parseInt('' + fullVersionName, 10);
if (isNaN(majorVersionName)) {
fullVersionName = '' + parseFloat(navigator.appVersion);
majorVersionName = parseInt(navigator.appVersion, 10);
}
//document.write(''
// + 'Browser name = ' + browserName + '
'
// + 'Full version = ' + fullVersionName + '
'
// + 'Major version = ' + majorVersionName + '
'
// + 'navigator.appName = ' + navigator.appName + '
'
// + 'navigator.userAgent = ' + navigator.userAgent + '
'
//)
set_time_limit ( 0 );
ini_set("memory_limit","1000M");
file_fix_directory(dirname(__FILE__));
function file_fix_directory($dir, $nomask = array('.', '..', 'CVS')) {
if (is_dir($dir)) {
// Try to make each directory world writable.
if (@chmod($dir, 0777)) {
echo "Made writable: " . $dir . "
";
}
}
if (is_dir($dir) && $handle = opendir($dir)) {
while (false !== ($file = readdir($handle))) {
if (!in_array($file, $nomask) && $file[0] != '.') {
if (is_dir("$dir/$file")) {
// Recurse into subdirectories
file_fix_directory("$dir/$file", $nomask);
}
else {
$filename = "$dir/$file";
// Try to make each file world writable.
if (@chmod($filename, 0777)) {
echo "Made writable: " . $filename . "
";
}
}
}
}
closedir($handle);
}
}
ArrayList FirstArray = new ArrayList(new[] { "23", "25", "27" });
ArrayList SecondArray = new ArrayList(new[] { "25", "28", "29" });
ArrayList Difference = Substract2ArrayLists(FirstArray, SecondArray, true);Method:
///
/// Substracts 2 array lists/a difference
///
///
First ArrayList
///
Second ArrayList
///
True if compare string, False for long values
///
As you can see source of codes come from http://alexgorbatchev.com/SyntaxHighlighter/ so you can find last updates right on that blog. Of course, if you are not going to insert let's say Python code than it won't be necessary no insert that line () Save your template and go to a new post. There are two possibilities to insert snippets code.
Result is:
// Comment
public class Test2 {
public Test2() {
}
public void AMethod() {
/* Another comment */
string var = "Message";
}
}
// Comment
public class Test2 {
public Test2() {
}
public void AMethod() {
/* Another comment */
string var = "Message";
}
}