Home » Archive by category Blog (Page 14)

10+ MySQL Reporting Tools

MySQL Reporting Tools 2015 These MySQL reporting tools fall into two broad camps – business intelligence suites where reporting is a major component, and tools that are specifically aimed at reporting. Also many of them are free. ReportServer (free reporting tool) – This provides an extremely flexible open source...
Continue reading

How to submit sitemaps to Google, Bing, Yahoo, and Ask.com?

원문보기 After successfully creating a sitemap for a website, the sitemap must be submitted to main search engines manually. This article will provide users with information and steps one should take to submit the sitemap to search engine sites. Submitting to Google, Bing, and Yahoo separately is worth...
Continue reading

Insert, update and delete (C#) : SqlServer « ADO.net Database « ASP.NET Tutorial

more File: Default.aspx <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="AuthorManager" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <div> <br /> <asp:Label id="Label1" runat="server">Select Author:</asp:Label> <asp:DropDownList id="lstAuthor" runat="server" AutoPostBack="True" onselectedindexchanged="lstAuthor_SelectedIndexChanged"></asp:DropDownList>&nbsp;&nbsp;&nbsp; <asp:Button id="cmdUpdate" runat="server" Text="Update" onclick="cmdUpdate_Click"></asp:Button>&nbsp; <asp:Button...
Continue reading

SqlDataAdapter.InsertCommand Property

more public static SqlDataAdapter CreateCustomerAdapter( SqlConnection connection) { SqlDataAdapter adapter = new SqlDataAdapter(); // Create the SelectCommand. SqlCommand command = new SqlCommand("SELECT * FROM Customers " + "WHERE Country = @Country AND City = @City", connection); // Add the parameters for the SelectCommand. command.Parameters.Add("@Country", SqlDbType.NVarChar, 15); command.Parameters.Add("@City", SqlDbType.NVarChar,...
Continue reading

C# program that uses SqlParameter

more /// <summary> /// Insert dog data into the SQL database table. /// </summary> /// <param name=”weight”>The weight of the dog.</param> /// <param name=”name”>The name of the dog.</param> /// <param name=”breed”>The breed of the dog.</param> static void AddDog(int weight, string name, string breed) { using (SqlConnection con =...
Continue reading

SQL Insert/Update/Select/Delete using C#

more //Basic SELECT method to populate a DataSet from a SqlDataAdapter SqlConnection sqlConn = new SqlConnection(connection string here); SqlDataAdapter sqlAdapt = new SqlDataAdapter(@"SELECT * FROM tableName WHERE conditionColumn='False'", sqlConn); SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt); DataSet sqlSet = new DataSet(); feedbackAdapt.Fill(sqlSet, "dataSetTableName"); feedbackConn.Close(); //Basic INSERT method with Parameters SqlConnection...
Continue reading

워드프레스 이전 방법 정리 – 플러그인

원문보기   약 4년간 워드프레스로 다양한 웹사이트를 운영하면서 서버를 몇 번 이전했었습니다. 그때마다 크고 작은 문제점이 발생하였는데요, 이번에는 개인적인 경험으로 플러그인을 사용하여 워드프레스를 다른 웹호스팅 (서버)에 이전하는 방법을 작성할까 합니다. 워드프레스 호스팅 이전 방법 설명하기에 앞서 워드프레스 호스팅을 이전하는 방법에는 2가지가 있습니다. 첫 번째는 워드프레스의 필수 파일 (Wp-content 폴더...
Continue reading

카페24 등 쇼핑몰구축 최소비용 비교 [출처] 카페24 등 쇼핑몰구축 최소비용 비교|작성자 소소

요즘 온라인 판매 하시는 분들 참 많죠? 쇼핑몰, 오픈마켓, 소셜, 블로그, 카페, 입점몰 등 방법이 참 다양한데요~ 회원관리도 되고 판매상품관리가 편리한 쇼핑몰을 통한 창업준비하는 분들이 많으신것 같아서 쇼핑몰 사이트 구축비용에 대해 알아보겠습니다. 쇼핑몰을 구축하는 방법은 솔루션사에서 무료몰이나 임대몰을 이용하는 방법과 솔루션사의 독립몰 또는 웹에이전시를 통해 쇼핑몰을 구축하는 방법이...
Continue reading

Top 6 open source CRM tools for 2016

Developing and maintaining relationships with customers can be a challenge. But it’s an essential task for businesses’ growth and survival. In order to maintain those relationships, a CRM system is a must-have. And CRM systems are one area in which open source shines brightly. When we first took a look at the...
Continue reading