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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
<CodeSnippet Format="1.0.0">
<Header>
<Title>Database2</Title>
<Shortcut>Database2</Shortcut>
<Description>Codeausschnitt für Datenbank</Description>
<Author>Nico Patitz</Author>
<SnippetTypes>
<SnippetType>Expansion</SnippetType>
<SnippetType>SurroundsWith</SnippetType>
</SnippetTypes>
</Header>
<Snippet>
<Declarations>
<Literal>
<ID>expression</ID>
<ToolTip>Ausnahmetyp</ToolTip>
<Function>SimpleTypeName(global::System.Exception)</Function>
</Literal>
<Literal>
<ID>funktionname</ID>
<ToolTip>Funktion, die Exeption geworfen hat</ToolTip>
<Default>var</Default>
</Literal>
<Literal>
<ID>con</ID>
<ToolTip>Bezeichner der Verbindung</ToolTip>
<Default>con</Default>
</Literal>
<Literal>
<ID>reader</ID>
<ToolTip>Bezeichner des Reader</ToolTip>
<Default>reader</Default>
</Literal>
<Literal>
<ID>command</ID>
<ToolTip>Bezeichner des Commandos</ToolTip>
<Default>command</Default>
</Literal>
<Literal>
<ID>constring</ID>
<ToolTip>ConnectionString Name aus App.Conf/Web.Conf</ToolTip>
<Default>CustConnectionString</Default>
</Literal>
<Literal>
<ID>sqlstring</ID>
<ToolTip>Sql statement</ToolTip>
<Default></Default>
</Literal>
</Declarations>
<Code Language="csharp">
<![CDATA[$selected$SqlConnection $con$ = new SqlConnection(ConfigurationManager.ConnectionStrings["$constring$"].ConnectionString);
SqlCommand $command$ = new SqlCommand("",$con$ );
$command$.CommandText = "$sqlstring$";
SqlDataReader $reader$=null;
try
{
$con$.Open();
$reader$= command.ExecuteReader();
while($reader$.Read())
{
}
}
catch(Exception ex)
{
//TODO: Exception-handling
}
finally
{
$con$.Close();
}
$end$]]>
</Code>
</Snippet>
</CodeSnippet>
</CodeSnippets>
|