SQL Server - Move Data from One Database Server to Another Database Server

Introduction

Here I will explain how to transfer or copy or move data from one server database table to another server database table in SQL Server.

Background

I created one table Addresstype in database1 in server1 with some data. I have created same table Addresstype with same columns in database2 in server2. Now I want to fill AddressTpe table in server2 with data of Addresstype in server1.

Cannot open database requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Introduction

Here I will explain about my database connection error in SQL Server if trying to get data by using asp.net.

Description

I have created one database in my Local SQL Server Management Studio in that I created one table and entered some data in that table.

Asp.net set session timeout in web.config IIS

Introduction:

Here I will explain how to set session timeout in web.config,IIS and in application using asp.net manually.

Description:

By default our websites session timeout is 20 mins after that session will gets expire suppose if we want to set our custom timeout in our applications we can set it in different ways (web.config, global.asax and in IIS)

Convert objectdatasource to dataset or datatable in asp.net | How to bind dataset with an Objectdatasource data in asp.net

Introduction:

Here I will explain how to bind dataset with objectdatasource data using asp.net

Description:

Here we need to remember that if we bind our gridview with objectdatasource that objectdatasource fill with data only whenever gridview databind is called like this 

gridview1.DataBind()=ods (ods is ObjectDataSource);

How to show only current dates of current month in ajax calendar extender using asp.net

Introduction

Here I will explain how to show only current dates of current month or whichever month in ajax calendar extender using asp.net.

Description

We can display only current month days to user in calendar control just by using css styles First add Ajax tollkit reference to your project and register that ajax referece like this in your aspx page

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>

After that design your aspx like this

How to Create Controls Dynamically in code behind files using asp.net

Introduction:

Here I will explain how to generate the controls dynamically in code behind using asp.net

Description:

Hi here I will explain how to generate the controls dynamically in asp.net code behind

First design the your aspx page with one panel like this 

how to get read only textbox control values in codebehind using asp.net

Introduction

Here I will explain how to get read only control values in codebehind using asp.net 

Description

If we set ReadOnly="true" property  for textbox it won’t give any chance to enter value or change the existed value .If we try to get data in textbox server doesn’t process the read only text box because the value of the text property is preserved in the view state between postbacks unless modified by server-side code. In some situations we don’t want give chance to user to enter data except from calendar control in that situation we need to set that textbox read only in serverside like this 

Gridview checkbox validation using javascript

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

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

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

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

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

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?

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.