FilesExpand file tree

 master

/

SqlHelper.cs

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

42 lines (41 loc) · 1.12 KB

 master

/

SqlHelper.cs

Copy path

Top

File metadata and controls

• Code
• Blame

42 lines (41 loc) · 1.12 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.SqlClient;

using System.Data;

namespace ServerListQueryFormDll

{

public class SqlHelper

{

/// <summary>

/// query data using constr & sqltext

/// </summary>

/// <param name="conStr"></param>

/// <param name="sqlText"></param>

/// <returns></returns>

public static DataTable Query(string conStr, String sqlText)

{

using (SqlConnection con = new SqlConnection(conStr))

{

try

{

con.Open();

DataSet ds = new DataSet();

SqlCommand cmd = new SqlCommand(sqlText, con);

SqlDataAdapter sda = new SqlDataAdapter(cmd);

sda.Fill(ds);

return ds.Tables[0];

}

catch(Exception ex)

{

throw ex;

}

finally

{

con.Close();

}

}

}

}

}