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
May 7, 2016 techsupport
Blog, Tech
원문보기 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
May 5, 2016 techsupport
Blog, Tech
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> <asp:Button id="cmdUpdate" runat="server" Text="Update" onclick="cmdUpdate_Click"></asp:Button> <asp:Button...
Continue reading
May 5, 2016 techsupport
Blog, Tech
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
May 5, 2016 techsupport
Blog, Tech
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
May 5, 2016 techsupport
Blog, Tech
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
May 5, 2016 techsupport
Blog, Tech
