connection String Error database in c#

Question

I downloaded a project from the web with its database. I run the project and add its database to tab server on VS 2008 Sp1 and have SQl server 2008.

But when I copy a new connection string to the program, I get the following error message:

Unrecognized escape sequence

using System;

using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace AzmongirSource
{
class cl 

   {

    static public  string idstudent;
    static public string userteacher;
    static public string nameazmon;
    static public string codeazmon;

    static public string azmon_typ;
    static public string azmon_for_test_type;
    static public string time_limit;
    static public string tedade_soalat;

    static public  SqlConnection connection = new SqlConnection();
    static public  SqlCommand command = new SqlCommand();
    static public  SqlDataReader reader;
    static public  int truequestion = 0, falsequestion = 0, noquestion = 0;


    static public  void creatconnection()
    {

        connection.Close();
        connection.ConnectionString = "Data Source=WINXPX86-BE;AttachDbFilename=D:\payegah\azmoongir_data.MDF;Integrated Security=True";
        connection.Open();
        command.Connection = connection;
    }
   static public  DataTable StudentList()
    {
        creatconnection();
        string query = "Select idstu as[شماره دانشجویی],namestu as [نام],familystu as [نام خانوادگی],standardcode as [کداستاندارد],reshte as [رشته] from tbl_student";
        SqlDataAdapter da = new SqlDataAdapter(query, cl.connection);
        DataTable dtt = new DataTable();
        da.Fill(dtt);
        connection.Close();
        return dtt;

    }

}
}

Selman Genç · Accepted Answer · 2014-03-27 09:59:35Z

3

You need to escape backslashes in your connection string, or use @

connection.ConnectionString = @"Data Source=WINXPX86-BE;AttachDbFilename=D:\payegah\azmoongir_data.MDF;Integrated Security=True";

Documentation: Escape Sequences

answered Mar 27, 2014 at 9:59

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ehsan · Accepted Answer · 2014-03-27 10:06:56Z

1

By default \ is considered to be an escape character. To avoid that add @ before your connecting string.like

connection.ConnectionString = @"Data Source=WINXPX86-BE;AttachDbFilename=D:\payegah\azmoongir_data.MDF;Integrated Security=True";

edited Mar 27, 2014 at 10:06

answered Mar 27, 2014 at 10:00

Ehsan

32.8k6 gold badges61 silver badges66 bronze badges

Comments

Nagaraj S · Accepted Answer · 2014-03-27 10:03:26Z

0

Add @ symbol before your connection string

@--->Escape characters

connection.ConnectionString = @"Data Source=WINXPX86-BE;AttachDbFilename=D:\payegah\azmoongir_data.MDF;Integrated Security=True";

answered Mar 27, 2014 at 10:03

Nagaraj S

13.5k6 gold badges35 silver badges53 bronze badges

Collectives™ on Stack Overflow

connection String Error database in c#

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related