C#

        public void CreateFileColumn(ArrayList array, Array Numbe)<br />
        {<br />
            object missing = System.Reflection.Missing.Value;<br />
            object fileName = "normal.dot";<br />
            object newTemplate = false;<br />
            object docType = 0;<br />
            object isVisible = true;<br />
            Object oUnit = Word.WdUnits.wdCell;<br />
<br />
<br />
            wordApp = new Word.ApplicationClass();<br />
            wordDoc = wordApp.Documents.Add(ref fileName, ref newTemplate, ref docType, ref isVisible);<br />
            wordApp.Visible = true;<br />
            wordDoc.Activate();<br />
            <br />
            //draw table into document<br />
            wordApp.Selection.Tables.Add(wordApp.Selection.Range, 1, 8, ref missing, ref missing);<br />
           <br />
            wordApp.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;<br />
            wordApp.Selection.Font.Bold = (int)Word.WdConstants.wdToggle;<br />
<br />
<br />
            //replace each number with picture then add to document<br />
            foreach (string part in Numbe)<br />
            {<br />
                wordApp.Selection.InlineShapes.AddPicture(@"C:\Users\Jon\Documents\Nick\Chin Font Files\" + part + ".jpg", ref missing, ref missing, ref missing);<br />
                //wordApp.Selection.InlineShapes.AddPicture(@"C:\Documents and Settings\All Users\Documents\nick\Chin Font Files\" + part + ".jpg", ref missing, ref missing, ref missing);<br />
                wordApp.Selection.MoveRight(ref oUnit, ref missing, ref missing);<br />
            }<br />
<br />
<br />
            <br />
<br />
        }

button1_Click(object sender, EventArgs e)  
{
    List.Form2 List = new List.From2();
      List.ChkList();
}

Public void ChkList()
 
   foreach (string s in checkedListBox1.Items)
   
    {
        if (s.Equals(dt))
         { Do Work
    }

button2_Click(object sender, EventArgs e)

{
   List.Form2 List = new List.From2();
      List.ChkList();
}

class Sql
    {
       public SqlConnection sqlCon;
        public void connectToSql (string adr)
        {
            sqlCon = new SqlConnection(adr);
            
            try
            {
                sqlCon.Open();
            }
            catch (Exception e)
            {
                string str = e.ToString();
                  using (StreamWriter sw = new StreamWriter ("out1.txt"))
                {
                    sw.WriteLine (e.ToString());
                }
            }

        }

        public void readSql(String col, String tab)
        {
            try
            {
                SqlDataReader sqlRead = null;
                SqlCommand sqlCmd = new SqlCommand("SELECT * FROM " + tab + " WHERE Column =" + col, sqlCon);
                sqlRead = sqlCmd.ExecuteReader();
                using (StreamWriter sw = new StreamWriter ("out.txt"))
                {
                    sw.WriteLine(sqlRead.ToString());
                }
            }
            catch (Exception e)
            {
                  using (StreamWriter sw = new StreamWriter ("out.txt"))
                {
                    sw.WriteLine (e.ToString());
                }
            }
        }

        public void exitSql()
        {
            sqlCon.Close();
        }
    }
    }

System.Data.SqlClient.SqlException: 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)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at longliveSorin.functiiSql.Sql.connectToSql(String adr) in D:\work\cte\C#\cifru\longliveSorin\longliveSorin\functiiSql\Sql.cs:line 19