Csharp CSV File Data Inserted into SQL Server Database Table in ASP.Net Using C# and VB.Net

csharp csv file data inserted into sql server table using asp.net

Inserting data using form is a time consuming task like bill pay queue (if not automated). If it’s taking much time then usually we seek alternative solution. One of the most common solution is to import data from CSV to sql server using C# in Asp.net. Moreover while you are going to deploy a fresh website, sometimes it could have obvious to import or upload existing data into the live system. That’s why here I am trying to discuss about Csharp CSV File Data Inserted into SQL Server Database Table using C# and VB.Net. Based on our back end infrastructure setup to read CSV file in Asp.net C#/VB.Net we could decide one of the following way: Read more ›

Posted in Asp.net, C#, VB.Net

Only Character Validation in Javascript for HTML Input TextBox Using Regular Expression

Code Example on - only character validation in javascript

In many cases, we need javascript validation for textbox to allow only alphabets. Most probably it’s the most common validation requirement that HTML & Javascript programmers have performed significantly. Thus I am trying to give you a complete example with the code so that you can perform Only Character Validation in Javascript for HTML Input TextBox Using Regular Expression. We need this javascript validation to allow only alphabets and space in HTML form especially for 2 cases: Read more ›

Posted in Client, Javascript

TreeNode Node onclick Server Side Event Implementation – ASP.Net TreeView Click C# VB.Net

treenode node onclick server side-Treeview Node Click Event code for asp.net c# vb.net

Asp.Net gives us a nice TreeView Control to re present data in hierarchical way. But unfortunately we did not get any TreeNode Node onclick Server Side Event to implement. After searching a lot feeling unlucky & realize that it’s a must need feature which is still absent. The truth is no direct way to implement the TreeView node click event from server side code. So what is the alternative way to implement it? Finally I came back with a tricky solution & hope it will definitely help some of C# & VB.Net Asp.Net coders to overcome the issue. Though it’s not an elegant solution at all but for those who is running out of time, the below code example on treeview node click event in asp.net c# VB.Net will surely help you a lot. To load data into a TreeView Control please read “Bind TreeView Control with SQL Server Database to Display Hierarchical Data“. Now I am assuming that you can fill or populate the control with data. Read more ›

Posted in .Net, Asp.net, C#, VB.Net

DataGridView DataTable Bind to Fill Data Using C# VB.Net

c# datagridview datatable example

Bind DataGridView DataTable:

DataGridView is basically used to display data in tabular format though data source could be different. It could be database, XML, JSON etc. Here in this C# & VB.Net code example I will explain the most common functionality – DataGridView DataTable data binding from a SQL Server Database table. So I will populate the DataGridView DataTable data from database and after that will display or bind data in DataGridView. Note that, DataGridView is such a powerful control in windows application, you can also over ruled almost all features at run time. I will also try to share how you can display records based on your selected columns at run time. After reading hope it will help you to bind datatable to datagridview in c# windows application. Read more ›

Posted in .Net, C#, SQL Server, VB.Net

Login Panel JQuery in Asp.net – Login With Twitter Drop Down Style

Login Panel JQuery in Asp.net AJAX

I have searched a lot to find a complete work around on implementing Twitter style JQuery Login Panel with ajax in Asp.net C# & VB.net. Unfortunately i did not get any complete solution around the web. Hence decided to write an article on Login Panel JQuery in Asp.net C# & VB.net which will help my readers to quickly grab the code & the implementation as well. Finally to complete this example here i have used very simple CSS code to style the UI like Twitter and JQuery Ajax to call the aspx page web method. It’s very easy & simple to follow. So let’s start. Read more ›

Posted in .Net, Ajax, Asp.net, C#, Client, JQuery, VB.Net

Cheap Domain Registration Company – Top 5 to Buy Domain Names

A price comparison table to get Cheap Domain Registration Company – To Buy Domain Names

If you want to do something in online then there is no option without buying a relevant domain name from a best domain registrar company. First of all it’s the first entry point to enter into the world wide web. Choosing a domain name is not an easy task. If you are not lucky (at least i am not) you have to spend a lot of time to find a great domain name. Before choosing a domain name you have to be cautious on the below 5 common points in parallel to search for a cheap domain registration company:

cheap domain registration decission

  1. Relevancy – It will help you to rank in SERP. The ultimate goal for SEO.
  2. Meaningful – So that sharpers can presume about your site. As a result you can grab searchers attention.
  3. Memorable – It will help visitors to come back again.
  4. Thoughtful – It’s your identity. It’s your signature. So create thoughtfully.
  5. Easy to type – Sharper won’t go to your competitor site mistakenly. Because its easy.

Read more ›

Posted in Others

Why C# or VB.net Generics perform better than Collections – a case study with example

Generics are the most powerful feature of .NET 2.0. Generics not only allow us to define type-safe data structures but also gives us a significant performance boost and higher quality code. Collections means we are talking about System.Collections and Generics means we are talking about System.Collections.Generic. The data structures in System.Collections are all Object-based, and thus inheriting the two problems: performance and lack of type safety. Hence .NET 2.0 introduces a set of generic collections under System.Collections.Generic namespace to overcome these two problems mainly. For example, generic List<T> data structure is equivalent to the non-generic ArrayList. Here in this article we are going to analysis the performance between Generics(List) and Collections(ArrayList). After doing the example hope you will get a lot of confidence on using Generics instead of typical Collections.

Read more ›

Posted in .Net, Asp.net C# Vb.net Interview Question, C#, VB.Net

JQuery Click Event to Highlight a Row of an HTML table with Even Odd CSS

Highlighting a row is very essential when the table is very wide & need to scroll horizontally to read whole row. Using CSS and JQuery it’s very easy to implement, but a bit complex while the table has alternate row color or other conditional/unconditional CSS in it’s cells. Because, before highlighting the row you need to preserve the original style of the row even might be cells to apply those in next highlight. Covering every scenarios is very difficult. So better to concentrate on different techniques & basic in built relevant properties/functions of CSS & JQuery. Such as JQuery index() & hasClass() function. JQuery index() function helps us to retrieve a row number or position of a table, hence we can directly apply Even or Odd CSS based on the number without preserving the previous row number. JQuery hasClass() boolean function helps us to determine whether any of the matched elements are assigned with the given class or not. So we have a lot of ways to highlight an HTML table row having Even & Odd CSS. In this article we will demonstrate some implementations so that you can apply those not only to handle a specific case rather can manipulate whole HTML table CSS using JQuery in every aspects.

Read more ›

Posted in .Net, Asp.net, C#, Client, CSS, Javascript, JQuery, VB.Net

Replace Sub Queries within “IN” or “Not IN” command by JOIN Operator to improve SQL Query Performence

As a developer we have to ensure faster response time of our applications. From our practical experiences, we found that most of the performance degradation are caused by non optimized SQL query. At the very initial stage developers may not experience slow query performance but sooner or later he will realize or acknowledge when database started growing rapidly. So for performance issues we have to concentrate on costly database queries first. Tuning SQL queries is not an easy task. Because lot of parameters may increase query execution time. One of the most common thumb rule for optimizing SQL query is to replace all sub queries within “IN” or “NOT IN” clause. Here in this article we will show you how a sub query decrease the performance and what will be the remedy.

Read more ›

Posted in Database, SQL Server, SQL Server SQL/TSQL Performence Tuning

JQuery to Read HTML Table Row Column Cell Data Records

JQuery or Javascript is an awesome language (though some people don’t want to say language) to improve user experience dramatically. For better user interface we can’t imagine it without JQuery or Javascript. JQuery makes our life more easier. If you are a fan of Javascript, we are requesting you to try JQuery. Why? please start first. Now, we are talking about HTML Table. Table is a major HTML element that we have used a lot. So manipulating table or DOM element using JQuery is a common task in every developer’s life. Here in this article we will guide you “how we can read all Row Column Cell data of an HTML Table using JQuery for each loop”. Also we will discuss a little bit on different JQuery selector’s, we have to use most likely for an HTML Table. So let’s start with example:

Read more ›

Posted in Client, Javascript, JQuery