Author Archives: admin

What is a PAD file?

29 de Junho de 2012 – 14:48

PAD stands for Portable Application Description, and a PAD file is a clear and easy way for software authors to provide online sources with information about their products. The advantage of using a PAD file is that it enables you to store all the descriptions and specifications in one single place – system requirements, price, contact info, file names, download URL’s and more.

Another great thing about PAD files is that they’re so easy to create – and that it doesn’t cost you anything! The Association of Shareware Professionals have put together a range of totally free tools that allow you to create and modify your PAD files. Here at SoftwarePromotions, we have also created our own PAD file tools to make life easier for software authors – check out our guide to using PADGen and our PAD validation tool.

Once you have created your PAD file, you should put it in two different places. First in your ZIP file, so that the people who distribute your software can access all the information that they might need. Second, you also want to put your PAD file on your own website, since this is what many of the download sites will ask you for.

Since June 2001, SoftwarePromotions has been working exclusively with PAD files. This is because the PAD format allows us to get your software listed on as many sites as possible, in the shortest amount of time.

source info: http://www.softwarepromotions.com/glossary/pad_file.asp

Permalink | Comment (0)

Visual Studio shortcut keys

14 de Junho de 2012 – 11:28

You are familiar with many of Visual Studio’s shortcut keys, but not all of them. Here is a handy reference that can make your .NET lifestyle easier and a lot more productive.
read more »

Permalink | Comment (0)

MariaDB, SQL server

5 de Junho de 2012 – 11:06

MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server. To accomplish this, Monty Program works to hire the best and brightest developers in the industry, work closely and cooperatively with the larger community of users and developers in the true spirit of Free and open source software, and release software in a manner that balances predictability with reliability. Much more information is available on the Monty Program website, and we heartily encourage you to spend some time reading before installing or deploying MariaDB.

Here are some important resources to get you started. All links will redirect you to external sites, noted in parentheses.

MariaDB Foundation

Tags , | Permalink | Comment (0)

MySQL, CREATE FUNCTION Syntax

25 de Maio de 2012 – 13:52

The general syntax of Creating a Function is :

 CREATE FUNCTION func_name ([func_parameter[,...]]) RETURNS type routine_body

func_name : Function name
func_parameter : param_name type
type : Any valid MySQL datatype
routine_body : Valid SQL procedure statement

 The RETURN clause is mandatory for FUNCTION . It used to indicate the return type of function.

Now we are describing you a simple example a function. This function take a parameter and it is used to perform an operation by using an SQL function and return the result. In this example there is no need to use delimiter because it contains no internal ; statement delimiters. Example :

CREATE FUNCTION func(str CHAR(20))
RETURNS CHAR(50)
RETURN CONCAT('WELCOME TO, ',str,'!');

Query OK, 0 rows affected (0.00 sec)

 SELECT func('Galhano.com');

 

+------------------------+
| func('Galhano.com')      |
+------------------------+
| WELCOME TO, Galhano.com |
+------------------------+
1 row in set (0.00 sec)

http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html

http://www.roseindia.net/mysql/mysql5/stored-procedures-and-functions.shtml

Permalink | Comment (0)

Finding Duplicates with SQL

11 de Maio de 2012 – 16:05

Here’s query for finding duplicates in a table. Suppose you want to find all Usernames values in a table that exist more than once:


SELECT Username, COUNT(Username) AS NumOccurrences
FROM   Users
GROUP BY Username
HAVING      (COUNT(Username) > 1)
Tags , | Permalink | Comment (0)

Count words in table

8 de Maio de 2012 – 20:13
SELECT SUM( LENGTH(myfield) - LENGTH(REPLACE(myfield, ' ', ''))+1) as nreg
FROM myTable
Permalink | Comment (0)

Highcharts .Net (with vb sample)

27 de Abril de 2012 – 18:30

Highcharts .Net is a charts library written in pure javascript, offering an easy way to add complex charts to your Web application. Highcharts .Net encapsulates the Highcharts API on ASP.net controls making it easier to use.

Project page at codeplex: http://highcharts.codeplex.com

You can see some Highcharts.Net examples at this link: http://highcharts.paulovich.com.br/

Install:

After download the newest release, add it as reference on your web application, and then add it to the page controls on your web.config:

<pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID">
<controls>
<add tagPrefix="highchart" namespace="Highchart.UI" assembly="Highchart"/>
</controls>
</pages>

After that, you only need to import the jQuery script.

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" type="text/javascript"></script>

it’s ready to use 😉

aspx:

 

<highchart:columnchart id="hcVendas" width="600" height="400" runat="server"></highchart:columnchart>

VB Sample:


read more »

Tags , , , | Permalink | Comment (0)

Manually update and rebuild the Exchange 2003 GAL

20 de Abril de 2012 – 11:31

This how-to walks through the process of manually updating offline address books for users from Exchange 2003 as well as the Global Address List.

  1. Open Exchange System Manager
    This how-to was actually made on a WS2003STD SP2.
  2. Expand Recipients and Select “Offline Address Lists”
  3. In the right pane, right click the “Default Offline Address List” and select “Rebuild”
  4. It will give you a prompt about how long it can take
    Just click “Yes”
  5. Repeat this for the “Global Address List”
    In the left pane, now click on “Recipient Update Services”
  6. In the right pane, right click on each choice, first selecting “Update Now” on both, and then again selecting “Rebuild” on both
  7. That’s all

This can take several hours though, with my 100 users it generally takes about 40 minutes max.

I would also submit that you can manually re-download the address books via Outlook by selecting the small arrow next to send/receive and then clicking on (you guessed right!) “Download Address Book”.

Tags | Permalink | Comment (0)

CalendarExtender and globalization

19 de Abril de 2012 – 18:42

Set the ScriptManager:


&lt;asp:ScriptManager ID=&quot;ScriptManager1&quot; runat=&quot;server&quot; EnableScriptGlobalization=true  &gt;&lt;/asp:ScriptManager&gt;
Permalink | Comment (0)

Microsoft Visual Studio LightSwitch 2011

19 de Abril de 2012 – 9:02

Microsoft Visual Studio LightSwitch is a simplified, self-service development tool that enables you to build business applications quickly and easily for the desktop and cloud.

read more »

Tags | Permalink | Comment (0)

« Página anterior — Página seguinte »

« Página anterior — Página seguinte »