-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathProgram.cs
49 lines (41 loc) · 1.39 KB
/
Program.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
using System;
namespace SqlHelpers
{
static class Program
{
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Select();
}
private static void Select()
{
ConnectionInfo connectionInfo = new ConnectionInfo()
{
ServerName ="THANHPC",
UserName="sa",
Password= "@dmin123",
DatabaseName= "Wii",
TimeOutCommand = 300,
TimeOutConnection = 20
};
SqlHelpers.CreateConnectionString(connectionInfo);
string sqlString = "select [プロジェクトID] , [機能ID], [機能名], [タイムスタンプ] FROM [Wii].[dbo].[Fes機能ID] where [プロジェクトID] = @プロジェクトID AND [機能ID] = @機能ID";
Parameters parameter = new Parameters();
parameter.Add(new Parameter()
{
Name = "@機能ID",
Values = 110
});
parameter.Add(new Parameter()
{
Name = "@プロジェクトID",
Values =1
});
var dt = SqlHelpers.ExecuteDataset(SqlHelpers.ConnectionString, System.Data.CommandType.Text, sqlString, parameter);
}
}
}