我应该学习哪些主题 [英] What topics I shoud learn

问题描述

我正在开发c＃win app

我想在运行服务器2008的局域网服务器上创建数据库os

这个数据库从multyple客户端机器获取数据。

可以解释一下c＃i必须要执行此任务的哪些主题。

i可以理解本地数据库。

但是我很困惑服务器客户端以及如何在服务器中创建数据库并使用应用程序和数据库连接服务器和客户端。



i am newbe in c＃。



thanx提前帮助



我尝试过：



还没试过。

因为我无法理解在哪里找到连接字符串以及如何连接

i am devloping c# win app
and i want to create database in lan server machine running with server 2008 os
and this databse get datas from multyple client machine.
can some one explain which topics of c# i must lern to do this task.
i can understand local database.
but i am confuse with server client and how to create database in server and connect server and client with app and database.

i am newbe in c#.

thanx for helping in advance

What I have tried:

nothing yet tried.
because i cant understand where to find connection string and how to connect

推荐答案

实际的数据库访问与本地数据库的操作方式非常相似，唯一的区别是您使用SqlConnection，SqlCommand，SqlDataAdapter等对象而不是SqLiteConnection或OleDb您一直在使用的连接等。

连接字符串很难：我们无法告诉您使用什么，因为每个安装都可能不同。但是......与安装SQL Server安装的人交谈，他们会给你一个连接字符串或告诉你具体细节：服务器名称和登录详细信息。然后你可以从它们构建一个连接字符串。

尝试使用Server Explorer窗格在VS中建立连接：

1）打开服务器资源管理器。

2）右键单击数据连接并选择添加连接

3）在随后的对话框中，选择您的数据源和数据库，指定安全信息，然后按测试连接按钮。

4）连接工作时，按确定

5）在服务器资源管理器窗格中突出显示数据库，然后查看属性窗格。将显示连接字符串的工作示例，您可以将其复制并粘贴到您的应用程序或配置文件中。

The actual database access is pretty much identical to how you do the local database, the only difference is that you use SqlConnection, SqlCommand, SqlDataAdapter, and so forth objects instead of the SqLiteConnection, or OleDbConnection and so forth you have been using.
The connection string is difficult: we can't tell you what to use as every installation can be different. But...talk to whoever installed your SQL Server installation and they will either give you a connection string or tell you what the details are: Server name and login details. Then you can build a connection string from them.
Try setting up a connection in VS with the Server Explorer pane:
1) Open Server Explorer.
2) Right click "Data connections" and select "Add connection"
3) In the dialog that follows, select your DataSource, and database, specify the security info, and press the "Test connection" button.
4) When the connection works, press "OK"
5) Highlight your database in the Server Explorer pane, and look at the Properties pane. A working example of the connection string will be shown, which you can copy and paste into your app or config file.

这篇关于我应该学习哪些主题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！