Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Set Username and Password for a database in SQL Server

Mar 19, 2012 12 comments
Introduction:

In this article I will explain how to create credentials or set userid and password for a particular database in
SQL server.

Description:
In our asp.net web applications generally we used database connection strings like “Data Source=MyServer; Initial Catalog=MySampleDB;uid=test;pwd=test to connect with SQL server database to get data.

How to reset identity column value in sql server

Mar 2, 2012 17 comments
Introduction:

In this article I will explain how to reset identity column value of table in in
SQL server.

Description:
In previous post I explained how set identity or auto increment column in SQL server. After set identity property on particular column I inserted few records in table and that value automatically increase whenever I inserted data that would be like this

JQuery Display/show average rating with decimal values from database in asp.net

21 comments
Introduction:

In this article I will explain how to show average rating with decimal values in asp.net using JQuery.


Description:
  
In previous post I explained Ajax rating example with database in asp.net . If we use ajax rating control to display rating we have one disadvantage that is if we get average rating like 4.3 or 2.7 etc we don’t have chance to show rating based on that value because ajax rating supports only integer values to solve this problem I am writing this article to display average rating including decimal values using JQuery in asp.net.

save/upload files in folder and download files from folder in asp.net

Feb 27, 2012 98 comments
Introduction:

In this article I will explain how to save/upload files in folder and download files from folder system when click on link in gridview using asp.net.


Description:
  
In many websites we will see download link whenever we click on that we will have a chance to download that files into our system.

JQuery Auto Complete textbox with Images in asp.net

Feb 22, 2012 41 comments
Introduction:

In this article I will explain how to display images with auto complete search in asp.net using JQuery.


Description:
  
In previous posts I explained many articles relating to
JQuery. Now I will explain another article relating to JQuery. If we search for user in facebook we will get user name with image. After seen that search I decided to write a post to implement auto complete search with images in asp.net.

JQuery display time in facebook/ twitter formats like minute ago, hour ago, week ago in asp.net

Feb 16, 2012 25 comments
Introduction:

In this article I will explain how to show time in facebook/ twitter formats like minute ago, hour ago, week ago in asp.net using JQuery.


Description:
  
In previous posts I explained many articles relating to
JQuery. Now I will explain another article relating to JQuery. If we share anything on facebook or twitter we will get time in different format like 1 minute ago, 1 hour ago, 1 week ago etc.

Remove or delete duplicate records from datatable/ dataset in asp.net

Feb 15, 2012 8 comments
Introduction:

In this article I will explain how to remove duplicate records from datatable or dataset in asp.net.


Description:
  
In previous posts I explained many articles regarding
Asp.net, Gridview, Ajax, JQuery and many more. During write articles on those concepts generally we bind data to datatable or dataset that data contains duplicate records of data also that would be like this

SQL Server - Create Identity Column or Auto Increment Column

Feb 12, 2012 20 comments
Introduction:

Here I will explain how to set or create auto increment column or identity property on column in
SQL server.

Description:
In many situations we will insert records in table during that time we need to set unique value for that record if we use auto increment column then automatically generate unique number for newly insert record in table (Like generate EmployeeID of each employee whenever employee record inserted).

Crystal report not showing data when click on export/ print options in asp.net

Feb 11, 2012 12 comments
Introduction:

In this article I will explain how to solve the problem of showing data when click on export/print options in crystal report using asp.net.


Description:

In Previous posts I explained many articles relating to crystal reports. During work with crystal report I find problem to display data when click on Print/Export options in crystal report using asp.net. To solve this problem I made small modification in my code to display data when click on print/export options in crystal report. 

Dynamically display images in crystal report from database in asp.net

Feb 10, 2012 29 comments
Introduction:

In this article I will explain how to show images in crystal reports from database in asp.net.


Description:

In Previous posts I explained many articles relating to
crystal reports. Now in this post I will explain how to dynamically display images in crystal reports from database in asp.net.
© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.