Sunday

SMTP Server: Authentication the Server Response was 5.5.1 Authentication required in gmail

Introduction

I was working on MVC (C#) application sending email through Gmail Server, meanwhile popped up me issue the server response was 5.5.1 authentication required, So we required action to set on security issue which is default off in Gmail Email settings.

Error Description

An exception of type 'System.Net.Mail.SmtpException' occurred in System.dll but was not handled in user code
Additional information: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required.

Tuesday

Internet Browser: Internet Explorer replacing with Microsoft Edge in Windows 10

Introduction

Microsoft has introduced replacing Internet Explorer with Microsoft Edge in Windows 10 operating System. Microsoft Edge is fully capable to run seamlessly across multiple devices.

Cutting off ActiveX and BHOs

ActiveX are dropping off by new look of Microsoft Edge replacing of old Internet Explorer.
ActiveX contains mainly plugin of Flash, Silver light, Java and PDF plugins. Main reason to dropping off ActiveX is to come off fully of HTML 5 of today brilliant demand to run the content over internet browser across the multiple devices.
Now flash will work alike same as Chrome provides, now Microsoft Edge will provide PDF in native language.

SQL Error: Saving Changes not permitted in SQL Server

Introduction

Today, I am explaining about error saving Changes is not permitted in MS SQL Server, to authorize this permission you have to un-check check box under Tools >> Options menus. If we keep it checked then it will not allow us to change data type during the development so that we require to frequent change or specific requirement then we required it immediately.

Error Description

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

Saving Changes not permitted in SQL Server

Saturday

RDLC reports in C#

Introduction

Here is explained in detail to generate RDLC reports in C#, RDLC is very good business intelligence (BI) tool. RDLC is the best component to display reports in tabular form.

Step 1: Add new project, select Windows Desktop, then select Windows Forms Application and type solution name and then finally click on OK button.

Create Solution for RDLC Report

The underlying provider failed on open

Introduction

I am today providing resolution of The underlying provider failed on open problem when we are working on across the network. If you see inner exception message then you will find below error description in detail. This problem occurs mostly when we are working with Entity Framework with MVC, ASP.Net, Windows Forms, WPF etc. This issue can be encountered mentioned scenarios. I am also written in detail associated with issue   Could not open a connection to SQL Server.

Error Description

{"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. 
Verify that the instance name is correct and that SQL Server is configured to allow remote connections. 
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"}

Friday

DataTable in C#

Introduction

DataTable is formed with rows and columns, it stored the data in the same way as stored others objects in C#.

Namespace

If we are dealing with DataTable in C# then we require to define following Namespace in our C# program.

using System;

using System.Data;

Here demonstrating to get columns name from a DataTable.

private void Get_Column_name()
{
            // Declare data table
            DataTable _ dtTC = new DataTable();
             
          // get column name using with foreach loop
           foreach(DataColumn _Cols in _dtTC.Columns)
            {
                string _str_Col_name = _Cols.ColumnName;
            }

}

DataTable In C#

Another method to select data from a specific DataTable in C#.

        private void Select_Data_From_Datatable_In_CSharp()
        {
            // Declare data table
            DataTable _dtSelectTC = new DataTable();

            // add column to data table
            _dtSelectTC.Columns.Add("ID", typeof(Int32));

            // adding rows to data table
            _dtSelectTC.Rows.Add(10);
            _dtSelectTC.Rows.Add(20);
            _dtSelectTC.Rows.Add(30);
            _dtSelectTC.Rows.Add(40);
            _dtSelectTC.Rows.Add(50);

            // filtering data on demand
            DataRow[] _resultTc = _dtSelectTC.Select("ID > 30");

            // Display results
            foreach (DataRow _rowTc in _resultTc)
            {
                Console.Write(_rowTc[0] + "\n");
            }

            // Output
            // 40
            // 50
        }

Conclusion

I have explained in detail about DataTable in C#, it uses system.Data to define DataTable and further uses of its properties, constraints etc. We can use “Clear “ method to clear data from DataTable, “Clone” helps us to cloning of a DataTable with structure and data, “Copy” copies its data with schema.

Suggested Reading:



Thursday

ArrayList in C#

Introduction

Today, I bet to throw light on ArrayList in C#. ArrayList has great feature because it can increase and decrease its size dynamically. ArrayList accepts also null value, moreover it allows to add duplicate values.

Namespace:

using System.Collections;
using System;