MySQL has useful extention to the GROUP BY operation – function GROUP_CONCAT: GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group. Returns NULL when there are no non-NULL values. Where it can be useful? For example to get array without looping inside the code, In single SQL query …
Category: .NET
Permanent link to this article: https://blog.openshell.in/2013/05/mysql-group_concat/
Oct 24
Custom Date Validation in ASP.Net
The validators shipped with .NET are great tools to check and validate what the user enters on a web form, before processing it. With the DateValidator control this gap has been filled. User can insert date in a common text box and that’s all: you won’t have to bother about validating their input, the only …
Permanent link to this article: https://blog.openshell.in/2011/10/custom-date-validation-in-asp-net/
Jul 21
Window.open Not Working In IE
If you use window.open to open custom windows with JavaScript, you might encounter problems in Internet Explorer. Even though you can open new windows in other browsers, it doesn’t work in IE. The reason to this is it depends on how you name your JavaScript windows. IE doesn’t allow space here. window.open takes three parameters …
Permanent link to this article: https://blog.openshell.in/2011/07/window-open-not-working-in-ie/
Jun 09
Guide to MySQL database Engine.
A MySQL database gives you a choice of database engines and an easy way to switch them. Default MySQL Engine would be enough for most of your application but in certain circumstances where the other available engines may be better suited to the task at hand. Choose your engine The number of database engines available …
Permanent link to this article: https://blog.openshell.in/2011/06/guide-to-mysql-database-engine/
Feb 26
Adding dynamic controls in Asp.net
1.Declare public variables static DropDownList[] drp_arr; static int drp_count; 2.Write methods to develop dynamic controls protected void add_dropdown(DropDownList drp) { try { //add to a container on the page pnltitle.Controls.Add(drp); //add a spacer after the control pnltitle.Controls.Add(new LiteralControl(“<br><br>”)); } catch (Exception ex) { } } private void createdropdown() { try { for (int i = …
Permanent link to this article: https://blog.openshell.in/2011/02/adding-dynamic-controls-in-asp-net/
Dec 29
MySQL Subquery Optimization
Never use a subquery inside a WHERE field IN(…) the SQL query. It will slow down the process. Slow: SELECT * FORM table1 WHERE field1 IN (SELECT field2 FROM table2 GROUP BY field1) Instead of using a subquery inside an IN(…), use INNER JOIN query. It will speed up the process, but in IN(…) query …
Permanent link to this article: https://blog.openshell.in/2010/12/mysql-subquery-optimization/
Dec 24
Actually what is .Net ???
.NET provides tools and libraries that enable developers to create Windows software much faster and easier. .NET benefits end-users by providing applications of higher capability, quality and security. The .NET Framework must be installed on a user’s PC to run .NET applications. The .NET Framework allows you to: * Apply common skills across a variety …
Permanent link to this article: https://blog.openshell.in/2010/12/actually-what-is-net/
Dec 01
Passing Parameters to Crystal Report in .Net
Now we are going to see, how we can show report by passing parameters or values. For example, Let us see how to retrieve details of an employee by means of Empid. First Step Create a table like the below structure. Eg: Column name Datatype Name varchar(50) Empid varchar(20) Gender char(10) Designation varchar(30) Second Step …
Permanent link to this article: https://blog.openshell.in/2010/12/passing-parameters-to-crystal-report-in-net/
Nov 30
OLTP Vs OLAP
OLTP(On-Line Transaction Processing) It is a set of information which processes a data transaction in a database system that manage transaction-oriented applications, typically for data entry and retrieval transaction processing. OLAP(On-Line Analytical Processing) OLAP is an approach to quickly provide answers to analytical queries that are multi-dimensional in nature.It supports the regular retrieving of information …
Permanent link to this article: https://blog.openshell.in/2010/11/oltp-vs-olap/
Nov 27
Locate ASP.Net AJAX AutoCompleteExtender inside TabContainer
ASP.Net Ajax contains rich array of controls used to create an interactive Web experience.While creating a ajax website you might face problems in binding two controls.For example locating AutoCompleteExtender inside the tab Container.Let us see how to solve this above problem. 1. First, create the a script manager in your .aspx page.like this, <asp:ScriptManager ID=”ScriptManager1″ …
Permanent link to this article: https://blog.openshell.in/2010/11/locate-asp-net-ajax-autocompleteextender-inside-tabcontainer/