dynamic excel = Activator.CreateInstance(Type.GetTypeFromProgID("Excel.Application", true));
excel.Visible = true;
Console.WriteLine("Press Enter to close Excel.");
Console.ReadLine();
excel.Quit(); System.__ComObject does not contain a definition for 'Visible'
using Excel = Microsoft.Office.Interop.Excel;
// ...
var excel = new Excel.Application();
excel.Visible = true;
Console.WriteLine("Press Enter to close Excel.");
Console.ReadLine();
excel.Quit(); <ItemGroup>
<Reference Include="Interop.WIA">
<HintPath>..\DNTScanner.Core.TypeLibrary\bin\Debug\Interop.WIA.dll</HintPath>
<EmbedInteropTypes>True</EmbedInteropTypes>
</Reference>
</ItemGroup> <ItemGroup Condition=" '$(TargetFramework)' == 'net40' ">
<Reference Include="Microsoft.CSharp" />
</ItemGroup>
<ItemGroup Condition="'$(TargetFramework)' == 'netstandard2.0'">
<PackageReference Include="Microsoft.CSharp" Version="4.5.0" />
</ItemGroup> <Project Sdk="Microsoft.NET.Sdk">
<PropertyGroup>
<OutputType>Exe</OutputType>
<TargetFramework>netcoreapp3.0</TargetFramework>
</PropertyGroup>
<!--
The following 'COMReference' items were copied from a .NET Framework project.
They were added by using the Visual Studio COM References window.
See https://docs.microsoft.com/en-us/visualstudio/ide/managing-references-in-a-project?view=vs-2017.
Observe the 'EmbedInteropTypes' tag value.
See https://docs.microsoft.com/en-us/visualstudio/msbuild/common-msbuild-project-items?view=vs-2017#comreference
-->
<ItemGroup>
<COMReference Include="Microsoft.Office.Core">
<Guid>{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}</Guid>
<VersionMajor>2</VersionMajor>
<VersionMinor>8</VersionMinor>
<Lcid>0</Lcid>
<WrapperTool>primary</WrapperTool>
<Isolated>False</Isolated>
<EmbedInteropTypes>True</EmbedInteropTypes>
</COMReference>
<COMReference Include="Microsoft.Office.Interop.Excel">
<Guid>{00020813-0000-0000-C000-000000000046}</Guid>
<VersionMajor>1</VersionMajor>
<VersionMinor>9</VersionMinor>
<Lcid>0</Lcid>
<WrapperTool>primary</WrapperTool>
<Isolated>False</Isolated>
<EmbedInteropTypes>True</EmbedInteropTypes>
</COMReference>
<COMReference Include="VBIDE">
<Guid>{0002E157-0000-0000-C000-000000000046}</Guid>
<VersionMajor>5</VersionMajor>
<VersionMinor>3</VersionMinor>
<Lcid>0</Lcid>
<WrapperTool>primary</WrapperTool>
<Isolated>False</Isolated>
<EmbedInteropTypes>True</EmbedInteropTypes>
</COMReference>
</ItemGroup>
</Project> using System;
using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;
namespace ExcelDemo
{
class Program
{
public static void Main(string[] args)
{
Excel.Application excel;
Excel.Workbook workbook;
Excel.Worksheet sheet;
Excel.Range range;
try
{
// Start Excel and get Application object.
excel = new Excel.Application();
excel.Visible = true;
// Get a new workbook.
workbook = excel.Workbooks.Add(Missing.Value);
sheet = (Excel.Worksheet)workbook.ActiveSheet;
// Add table headers going cell by cell.
sheet.Cells[1, 1] = "First Name";
sheet.Cells[1, 2] = "Last Name";
sheet.Cells[1, 3] = "Full Name";
sheet.Cells[1, 4] = "Salary";
// Format A1:D1 as bold, vertical alignment = center.
sheet.get_Range("A1", "D1").Font.Bold = true;
sheet.get_Range("A1", "D1").VerticalAlignment =
Excel.XlVAlign.xlVAlignCenter;
// Create an array to multiple values at once.
string[,] saNames = new string[5, 2];
saNames[0, 0] = "John";
saNames[0, 1] = "Smith";
saNames[1, 0] = "Tom";
saNames[1, 1] = "Brown";
saNames[2, 0] = "Sue";
saNames[2, 1] = "Thomas";
saNames[3, 0] = "Jane";
saNames[3, 1] = "Jones";
saNames[4, 0] = "Adam";
saNames[4, 1] = "Johnson";
// Fill A2:B6 with an array of values (First and Last Names).
sheet.get_Range("A2", "B6").Value2 = saNames;
// Fill C2:C6 with a relative formula (=A2 & " " & B2).
range = sheet.get_Range("C2", "C6");
range.Formula = "=A2 & \" \" & B2";
// Fill D2:D6 with a formula(=RAND()*100000) and apply format.
range = sheet.get_Range("D2", "D6");
range.Formula = "=RAND()*100000";
range.NumberFormat = "$0.00";
// AutoFit columns A:D.
range = sheet.get_Range("A1", "D1");
range.EntireColumn.AutoFit();
// Make sure Excel is visible and give the user control
// of Microsoft Excel's lifetime.
excel.Visible = true;
excel.UserControl = true;
}
catch (Exception e)
{
Console.WriteLine($"Error: {e.Message} Line: {e.Source}");
}
}
}
} During the two-day event we will have more than 16 hours of content on subjects such as ASP.NET 5, .NET Core, C#, F#, Roslyn, debugging with VS2015, learnings from running large scale websites, and more!
// from http://www.microsoft.com/en-us/download/details.aspx?id=14839
var connectionString = "Provider=VFPOLEDB.1;Data Source=" +
@"D:\path\JVJ100.DBF" +
";Password=;Collating Sequence=MACHINE";
using (var dbConnection = new OleDbConnection(connectionString))
{
using (var dataAdapter = new OleDbDataAdapter("select FAMILY from JVJ100.DBF", dbConnection))
{
using (var dataset = new DataSet())
{
dataAdapter.Fill(dataset, "table1");
foreach (DataRow dataRow in dataset.Tables[0].Rows)
{
var familyIranSystem = dataRow[0] as string;
var familyIranUnicode = ConvertTo.Unicode(familyIranSystem, 1256);
if (!string.IsNullOrWhiteSpace(familyIranUnicode))
{
}
}
}
}
} using (var db = new BloggingContext())
{
var blog = new Blog { Url = "http://sample.com" };
db.Blogs.Add(blog);
db.SaveChanges();
} using (var db = new BloggingContext())
{
var blog = db.Blogs.First();
blog.Url = "http://sample.com/blog";
db.SaveChanges();
} using (var db = new BloggingContext())
{
var blog = db.Blogs.First();
db.Blogs.Remove(blog);
db.SaveChanges();
} using (var context = new BloggingContext())
{
var blog = context.Blogs
.Select(b =>
new
{
Blog = b,
Posts = b.Posts.Count()
});
} using (var context = new BloggingContext())
{
var blog = context.Blogs
.Select(b =>
new
{
Id = b.BlogId,
Url = b.Url
});
} using (var context = new BloggingContext())
{
var blogs = context.Blogs.AsNoTracking().ToList();
} using (var context = new BloggingContext())
{
context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; using (var context = new BloggingContext())
{
var blog = context.Blogs.First();
var post = new Post { Title = "Intro to EF Core" };
blog.Posts.Add(post);
context.SaveChanges();
} using (var context = new BloggingContext())
{
var blog = new Blog { Url = "http://blogs.msdn.com/visualstudio" };
var post = context.Posts.First();
blog.Posts.Add(post);
context.SaveChanges();
} var blog = new Blog { Id = 2, Url = "https://www.dntips.ir" };
context.Blog.Attach(blog);
context.SaveChanges(); var blog = new Blog { Id = 2, Url = "https://www.dntips.ir" };
context.Entry(blog).State = EntityState.Modified ;
context.SaveChanges(); var blog = new Blog { Id = 2, Url = "https://www.dntips.ir" };
context.Update(blog);
context.SaveChanges(); context.ChangeTracker.TrackGraph(blog, e => e.Entry.State = EntityState.Added);
public class BaseEntity
{
public int Id { set; get; }
public DateTime? DateAdded { set; get; }
public DateTime? DateUpdated { set; get; }
} public class Person : BaseEntity
{
public string FirstName { get; set; }
public string LastName { get; set; }
} public class ApplicationDbContext : DbContext
{
// same as before
public override int SaveChanges()
{
this.ChangeTracker.DetectChanges();
var modifiedEntries = this.ChangeTracker
.Entries<BaseEntity>()
.Where(x => x.State == EntityState.Modified);
foreach (var modifiedEntry in modifiedEntries)
{
modifiedEntry.Entity.DateUpdated = DateTime.UtcNow;
}
var addedEntries = this.ChangeTracker
.Entries<BaseEntity>()
.Where(x => x.State == EntityState.Added);
foreach (var addedEntry in addedEntries)
{
addedEntry.Entity.DateAdded = DateTime.UtcNow;
}
return base.SaveChanges();
}
} protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Blog>().Property<DateTime>("DateAdded"); var blogs = context.Blogs.OrderBy(b => EF.Property<DateTime>(b, "DateAdded"));
context.Entry(myBlog).Property("DateAdded").CurrentValue = DateTime.Now; foreach (var addedEntry in addedEntries)
{
addedEntry.Property("DateAdded").CurrentValue = DateTime.UtcNow;
} 
<Report>
<DocumentPreferences RunDirection="RTL" PageOrientation="Portrait" PageSize="A4">
<Watermark RunDirection="" Text="پس زمینه نمونه" Font="bardia.ttf" FillOpacity="0.7" StrokeOpacity="0.5" />
</DocumentPreferences>
<DefaultFonts PrimaryFont="irsans.ttf" SecondaryFont="farnaz.ttf" Size="12px" Color="#CCFFBB" />
<DefaultFooter Message="پا صفحه نمونه" />
<DefaultHeader Message="سرصفحه نمونه" MessageFontColor="#ََََAA0012" ImagePath="logo.png" />
<MainTableTemplate TemplateName="AppleOrchardTemplate" />
<MainTablePreferences ColumnsWidthsType="Relative" NumberOfDataRowsPerPage="0" >
<GroupsPreferences GroupType="HideGroupingColumns" ShowOneGroupPerPage="true" />
</MainTablePreferences>
<MainTableSummarySettings OverallSummarySettings="جمع کل" PreviousPageSummarySettings="نقل از صفحه قبل"
PageSummarySettings="جمع کل صفحه" AllGroupsSummarySettings="جمع کل گروه ها" />
<MainTableDataSource ProviderName="System.Data.SQLُServerCE"
ConnectionString="Data Source=MyData.sdf;Persist Security Info=False;"
SqlStatement="SELECT [url], [name], [NumberOfPosts], [AddDate]
FROM [tblBlogs]
WHERE [NumberOfPosts]>=@p1” >
<Parameters>
<Param Type="int" Name="@p1"/>
</Parameters>
</MainTableDataSource>
<MainTableColumns>
<Columns>
<Column CellHorizontalAlignment="Right" ColumnItemsTemplate="TextBlock" HeaderCell="عنوان ستون 1" PropertyName="Title" Order="0" Width="1" />
<Column CellHorizontalAlignment="Right" Group="true" ColumnItemsTemplate="TextBlock" HeaderCell="عنوان ستون 2" PropertyName="Category" Order="1" Width="2" />
<Column CellHorizontalAlignment="Right" ColumnItemsTemplate="Image" HeaderCell="عنوان ستون 3" PropertyName="Image" Order="2" Width="2" />
</Columns>
</MainTableColumns>
<MainTableEvents>
<DataSourceIsEmpty Message="داده ای برای نمایش وجود ندارد" />
</MainTableEvents>
<Export ToExcel="True" ToCsv="False" ToXml="True" />
<Generate Type="AsPdfFile" FileName="Report.pdf" />
</Report> editoptions: { dataUrl: '...url to get json....',
buildSelect: function (response) {
var data = typeof response === "string" ? $.parseJSON(response.responseText) : response,
var s = "<select>";
s += '<option value="0">--No Manager--</option>';
$.each(data, function () {
s += '<option value="' + this.EmployeeId + '">' + this.EmployeeName + '</option>';
});
return s + "</select>";
}
} namespace System
{
public interface IProgress<in T>
{
void Report( T value );
}
} namespace System
{
public class Progress<T> : IProgress<T>
{
public Progress();
public Progress( Action<T> handler );
protected virtual void OnReport( T value );
}
} using System;
using System.Threading;
using System.Threading.Tasks;
namespace Async09
{
public class TestProgress
{
public async Task DoProcessingReportProgress()
{
var progress = new Progress<int>(percent =>
{
Console.WriteLine(percent + "%");
});
var cts = new CancellationTokenSource();
// call some where cts.Cancel();
try
{
await doProcessing(progress, cts.Token);
}
catch (OperationCanceledException ex)
{
//todo: handle cancellations
Console.WriteLine(ex);
}
Console.WriteLine("Done!");
}
private static async Task doProcessing(IProgress<int> progress, CancellationToken ct)
{
await Task.Run(async () =>
{
for (var i = 0; i != 100; ++i)
{
await Task.Delay(100, ct);
if (progress != null)
progress.Report(i);
ct.ThrowIfCancellationRequested();
}
}, ct);
}
}
} 
هنگام استفاده از Full IIS دو خاصیت از LocalDb باعث بروز مشکل می‌شوند:
در ادامه این مقاله روی بارگذاری پروفایل کاربر تمرکز می‌کنیم، و در قسمت بعدی به مالکیت وهله LocalDb می‌پردازیم.
بگذارید دوباره به خطای موجود نگاهی بیاندازیم:
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: SQL Network Interfaces, error: 0 - [x89C50120])
این پیغام خطا زیاد مفید نیست، اما LocalDb اطلاعات بیشتری در Event Log ویندوز ذخیره میکند. اگر Windows Logs را باز کنید و به قسمت Application بروید پیغام زیر را مشاهده خواهید کرد.Cannot get a local application data path. Most probably a user profile is not loaded. If LocalDB is executed under IIS, make sure that profile loading is enabled for the current user.
پیغام خطای دوم واضح است، نیاز است پروفایل کاربر را بارگذاری کنیم. انجام اینکار زیاد مشکل نیست، هر Application Pool در IIS تنظیماتی برای بارگذاری پروفایل کاربر دارد که از قسمت Advanced Settings قابل دسترسی است. متاسفانه پس از انتشار سرویس پک 1 برای Windows 7 مسائل کمی پیچیده‌تر شد. در حال حاظر فعال کردن loadUserProfile برای بارگذاری کامل پروفایل کاربر به تنهایی کافی نیست، و باید setProfileEnvironment را هم فعال کنیم. برای اطلاعات بیشتر در این باره به مستندات KB 2547655 مراجعه کنید. بدین منظور باید فایل applicationHost.config را ویرایش کنید. فایل مذکور در مسیر C:\Windows\System32\inetsrv\config قرار دارد. همانطور که در مستندات KB 2547655 توضیح داده شده، باید پرچم هر دو تنظیمات را برای ASP.NET 4.0 فعال کنیم:
<add name="ASP.NET v4.0" autoStart="true" managedRuntimeVersion="v4.0" managedPipelineMode="Integrated">
<processModel identityType="ApplicationPoolIdentity" loadUserProfile="true" setProfileEnvironment="true" />
</add> 
جای هیچ نگرانی نیست، چرا که این پیغام خطا انتظار می‌رود. همانطور که در ابتدا گفته شد، دو خاصیت LocalDb باعث بروز این خطاها می‌شوند و ما هنوز به خاصیت دوم نپرداخته ایم. بصورت پیش فرض وهلههای LocalDb خصوصی (private) هستند و در Windows account جاری اجرا می‌شوند. بنابراین ApplicationPoolIdentity در IIS به وهلههای دیتابیس دسترسی نخواهد داشت. در قسمت دوم این مقاله، راه‌های مختلفی را برای رفع این مشکل بررسی می‌کنیم.
10) Practical .NET: Powerful JavaScript With Upshot and Knockout
The Microsoft JavaScript Upshot library provides a simplified API for
retrieving data from the server and caching it at the client for reuse. Coupled
with Knockout, the two JavaScript libraries form the pillars of the Microsoft
client-side programming model.
9) On VB: Database Synchronization with the Microsoft Sync
Framework
The Microsoft Sync Framework is a highly flexible framework
for synchronizing files and data between a client and a master data store. With
great flexibility often comes complexity and confusion, however.
8) C# Corner: Performance Tips for Asynchronous Development in
C#
Visual Studio Async is a powerful development framework, but it's
important to understand how it works to avoid performance hits.
7) 2 Great JavaScript Data-Binding Libraries
JavaScript
libraries help you build powerful, data-driven HTML5 apps.
6) On VB: Entity Framework Code-First Migrations
Code First
Migrations allow for database changes to be implemented all through code.
Through the use of Package Manager Console (PMC), commands can be used to
scaffold database changes.
5) C# Corner: The New Read-Only Collections in .NET 4.5
Some
practical uses for the long-awaited interfaces, IReadOnlyList and
IReadOnlyDictionary, in .NET Framework 4.5.
4) C# Corner: Building a Windows 8 RSS Reader
Eric Vogel
walks through a soup-to-nuts demo for building a Metro-style RSS reader.
3) C# Corner: The Build Pattern in .NET
How to separate
complex object construction from its representation using the Builder design
pattern in C#.
2) Inside Visual Studio 11: A Guided Tour
Visual Studio 2012
(code-named Visual Studio 11 then) is packed with new features to help you be a
more efficient, productive developer. Here's your guided tour.
1) HTML5 for ASP.NET Developers
The technologies bundled as
HTML5 finally support what developers have been trying to get HTML to do for
decades.
