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

Gridview checkbox validation using javascript

Sep 21, 2010 15 comments
Introduction

Hi here I will explain how to check the checked status of checkboxes in gridview using JavaScript 

Description

I have a one gridview with checkboxes and one button if user clicks on button I need to raise validation if user doesn’t checked at least one checkbox in gridview for that I have written one JavaScript function to check whether checkboxes selected in gridview or not.

For that write the following code in aspx page

Validation for Email and URL using in javascript

Sep 20, 2010 1 comments
Introduction:

Here I will explain how to validate the textbox and whether that textbox contain valid email or url address using asp.net

Description:

Here I will explain how to validate the textbox and whether that textbox contain valid email or url address using asp.net.

First write the following code in aspx page 

how to Import data from EXCEL to SQL Database in ASP.NET

Sep 15, 2010 196 comments
Introduction

Here I will explain how to Import or insert data into SQL database from Excel spreadsheet using Sqlbulkcopy method.

Description

 I have searched for so many posts that explain static manner some of the posts are not clearly some of the posts are not supporting for latest excel files so many problems i faced by using those examples I have done application that will support for all excel versions and it will work for you without having any problems and it will dynamically you can upload excel sheet from anywhere from your computer.

First of all create Excel workbook as shown in image below and insert some data into it. Please design excel sheet like whatever I shown in image

finding sundays in given month using SQL Server

Sep 12, 2010 3 comments
Introduction:

Here I will explain how to finding Sundays in given month using SQL Server.

Description:

Till now I kept some articles which are related to asp.net and c# the following query is used to find the Sundays in the given month, I hope it’s very useful any query regarding it you can post as comments

Disable button if gridview doesn't contains any Data in asp.net

Sep 7, 2010 3 comments

Here I will explain how to disable button if gridview doesn’t contain records.
Now I have a two button Button1 and Button2 and one gridview. Now I want to display Button2 and gridview whenever user click on Button1.if user clicks on Button1 before displaying the Button2 and gridview I need to check if gridview has data or not if that gridview doesn’t contain data disable Button2 and display gridview with No Records found .For that I have written one function in button click like this

What is the difference between Unit testing,Assembly testing,Integration Testing and Regression testing

Sep 4, 2010 7 comments
Introduction:

Here I will explain difference between Unit testing, Assembly testing, Integration testing and Regression testing 

Description:

Unit testing is also called as Component testing. Unit testing ensures that reliable program unit meets their requirements. Unit testing is normally conducted by programmer under the supervision of the project lead or the team Lead. Main objective of this testing is to test each unit in isolation and individually. This is done by knowing what the inputs to the unit are and what the expected outputs for the same. Unit testing is a white box activity. Unit test normally comes in the implementation phase of the project. 

If we have two version of same assembly in GAC how do we make a choice in asp.net?

0 comments
Introduction:

Here I will explain if we have two version of same assembly in GAC how we make a choice.

Description:

In interviews it’s common Question for everyone. Let’s say you have made an application and its using a DLL which is present in GAC. Now for some reason you make second version of the same DLL and put it in GAC. Now which DLL does the application refer? Ok by default it always uses the version by which you have compiled you application in IDE. But you want that it should actually use the older version. 

Publish or Deploy website in our local machine using asp.net

37 comments
Here I will explain how to publish or deploy the website in local machine. To publish website first we need to check whether IIS installed in our local machine or not and whether that IIS working properly or not because sometimes IIS will not work properly even that IIS already installed in our local machine for that reason we need to check all these conditions before going to publish or deploy our website in local machine. 

After that now open the application in visual studio whatever the application we need publish. 

How to get length of data in each Column of a table Using SQL Server

0 comments
Introduction:

Here I will explain how to get length of data in each Column of a table using SQL Server.

Description:

There is sometimes we need to figure out the maximum space that is being used by a particular column in your database.  You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image data types, so how do you figure out the length of a value in a column that has one of these data types?

Query to change column name or table name in sql server

1 comments
Introduction:

In this article I will explain how to change or rename column name or table name in SQL server.

Description:

In previous posts I explained many articles relating to SQL Server. Now I will explain how to rename or change column name or table name in SQL Server. 
© 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.