arijusg

USE RedFoxAuto

DECLARE @PricelistID varchar(50), @lName varchar(50)
 
DECLARE cursorName CURSOR LOCAL SCROLL STATIC FOR
SELECT pricelistID, pricelistName FROM productPricelistNames

OPEN cursorName -- open the cursor
FETCH NEXT FROM cursorName INTO @PricelistID, @lName
WHILE @@FETCH_STATUS = 0

arijusg

 public class DataTableToCsv
    {
        public void Generate(DataTable dt, string fileName)
        {
            var sb = new StringBuilder();

            IEnumerable<string> columnNames = dt.Columns.Cast<DataColumn>().
                                              Select(column => column.ColumnName);
            sb.AppendLine(string.Join(",", columnNames));

arijusg

Assuming your services are already installed...

First you will need SubInACL (SubInACL.exe)
SubInACL is a command-line tool that enables administrators to obtain security information about files, registry keys, and services, and transfer this information from user to user, from local or global group to group, and from domain to domain.
http://www.microsoft.com/en-us/download/details.aspx?id=23510

Second you will need to run a batch or commands manualy to give Start/Stop rights ("T and O").

Third. Publish your app and test it.