我以SQL Server 2008 作为后端创建了一个桌面应用程序 。 我想使用我安装在多台机器上的应用程序中的此数据库 。
该应用程序与中央数据库连接的要求是什么?
很简单, 如果服务器拥有数据库, 您想要以客户- 服务器模型的形式建立架构。 您需要使用 MS SQLServer 2005 或更高版本, 并创建连接到 SqlServer 的数据库。 允许客户访问数据库 。
From visual studio side: Add the above created .mdf(database file) as the new data source. Data-->Add new Data Source , and follow the steps in the wizard[p.s the type of connection has to be sql sever type ] while doing this a connection string will be created by VS. Use tht connection string to access from the client side.
此链接将很有用 : < a href=""http://msdn.microsoft.com/ en- us/library/sxds9ett(v=vs.80).aspx" rel="nofollow" >http://msdn.microsoft.com/en-us/library/sxds9ett(v=vs.80).aspx
保持连接字符串 在其资源,当然。
资源是:
ConnectionString" with the value like "Data Source = ..." whatever.然后,你可以运行你的 Sql 脚本像:
SqlConnection conn =
new SqlConnection(Properties.Settings.Default.ConnectionString);
继续说
What is the use of default keyword in C#? Is it introduced in C# 3.0 ?
I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...
I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...
I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...
I have two EF entities. One has a property called HouseNumber. The other has two properties, one called StartHouseNumber and one called EndHouseNumber. I want to create a many to many association ...
How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...
Since I cannot order my dictionary, what is the best way of going about taking key value pairs and also maintaing an index?
Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...