0

I have created a simple table named myT, I am trying to print the data from the c# code but I'm getting exseption, here is my c# code:

using (SqlConnection conn = new SqlConnection())
            {                                //LAPTOP-69PFVE6D
                conn.ConnectionString = "Server =LAPTOP-69PFVE6D ; Database = Database1; Integrated Security = true";
                conn.Open();

                SqlCommand command = new SqlCommand("SELECT * FROM dbo.myT", conn);

                // Add the parameters.
                //command.Parameters.Add(new SqlParameter("0", 1));

                using (SqlDataReader reader = command.ExecuteReader())
                {                   
                    while (reader.Read())
                    {
                        // Console.WriteLine(String.Format("{0} \t | {1}",
                        // reader[0], reader[1]));
                        Console.WriteLine(reader.GetString(0));
                    }
                }              

            }

Here is a screenshot:

enter image description here

Here is my App.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
  </startup>
  <connectionStrings>
    <add name="SqlTest_CSharp.Properties.Settings.connectionStr"
           connectionString="Server = LAPTOP-69PFVE6D; Database = Database1; Integrated Security = true"
           providerName="System.Data.SqlClient" />
  </connectionStrings>
</configuration>

Here is the exception:

חריג שאינו מטופל: System.Data.SqlClient.SqlException: אירעה שגיאה הקשורה לרשת או שגיאה ספציפית למופע במהלך יצירת חיבור ל- SQL Server. השרת לא נמצא או שאינו נגיש. ודא ששם המופע נכון וש- SQL Server מוגדר לאפשר חיבורים מרחוק. (provider: Named Pipes Provider, error: 40 - לא הייתה אפשרות לפתוח חיבור ל- SQL Server) ---> System.ComponentModel.Win32Exception: The system cannot find the file specified
   --- סוף רכיב מעקב אחר מחסנית של מצב חריג פנימי ---
   ב-  System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
   ב-  System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   ב-  System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   ב-  System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   ב-  System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   ב-  System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   ב-  System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   ב-  System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   ב-  System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   ב-  System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   ב-  System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   ב-  System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   ב-  System.Data.SqlClient.SqlConnection.Open()
   ב-  SqlTest_CSharp.Program.Main(String[] args) ב- C:\Users\BadAss\Downloads\SqlTest_CSharp\SqlTest CSharp\SqlTest CSharp\Program.cs:שורה 14
Press any key to continue . . .
BadAss
  • 1
  • Related: https://stackoverflow.com/questions/8926512/how-do-i-connect-to-an-mdf-database-file – Caramiriel Mar 10 '18 at 14:55
  • The error is that it can't open the connection. That can be caused by a lot of things. Are you allowing named pipe connections to your server? Is this instance name correct, etc. This error often is related to your SqlServer configuration - permissions, connections, etc. – pstrjds Mar 10 '18 at 15:07

0 Answers0