forked from Excel-DNA/Samples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathMyFunctions.cs
More file actions
40 lines (35 loc) · 1.38 KB
/
Copy pathMyFunctions.cs
File metadata and controls
40 lines (35 loc) · 1.38 KB
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
using System;
using System.Data;
using System.Data.SQLite;
using ExcelDna.Integration;
namespace UsingSQLite
{
public static class MyFunctions
{
static SQLiteConnection _connection;
static SQLiteCommand _productNameCommand;
private static void EnsureConnection()
{
if (_connection == null)
{
_connection = new SQLiteConnection(@"Data Source=C:\Temp\Northwind.db");
_connection.Open();
_productNameCommand = new SQLiteCommand("SELECT ProductName FROM Products WHERE ProductID = @ProductID", _connection);
_productNameCommand.Parameters.Add("@ProductID", DbType.Int32);
}
}
public static object ProductName(int productID)
{
try
{
EnsureConnection();
_productNameCommand.Parameters["@ProductID"].Value = productID;
return _productNameCommand.ExecuteScalar();
}
catch (Exception ex)
{
return ex.ToString();
}
}
}
}