ASP.Net Error: Format of the initialization string does not conform to specification starting at index 0

Hi Sumeet,

Please take reference the below code and correct your code.

HTML

<asp:GridView ID="GridView1" runat="server" CssClass="Grid" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="ContactName" HeaderText="Customer Name" />
        <asp:BoundField DataField="City" HeaderText="City" />
        <asp:BoundField DataField="Country" HeaderText="Country" />
        <asp:BoundField DataField="PostalCode" HeaderText="PostalCode" />
    </Columns>
</asp:GridView>

Namespaces

C#

using System.Data.SqlClient;

Code

Default.aspx.cs

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        SqlConnection con = MyConnection.ConnectionStr();
        SqlDataSource SqlDataSource1 = new SqlDataSource();
        SqlDataSource1.ID = "SqlDataSource1";
        this.Page.Controls.Add(SqlDataSource1);
        SqlDataSource1.ConnectionString = con.ConnectionString;
        SqlDataSource1.SelectCommand = "SELECT top 3 ContactName, City, Country, PostalCode from Customers";
        this.GridView1.DataSource = SqlDataSource1; ;
        this.GridView1.DataBind();
    }
}

MyConnection.cs

using System.Data.SqlClient;

/// <summary>
/// Summary description for MyConnection
/// </summary>
public class MyConnection
{
    public static SqlConnection ConnectionStr()
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=.;Initial Catalog=Northwind; UID=xxx;Password=xxxxxxx;";

        return conn;
    }
}

Screenshot