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 ›
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 ›
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 ›
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 ›
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:
- Relevancy – It will help you to rank in SERP. The ultimate goal for SEO.
- Meaningful – So that sharpers can presume about your site. As a result you can grab searchers attention.
- Memorable – It will help visitors to come back again.
- Thoughtful – It’s your identity. It’s your signature. So create thoughtfully.
- Easy to type – Sharper won’t go to your competitor site mistakenly. Because its easy.
Read more ›
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 ›
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 ›
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 ›
Read more ›