select t.ID,x.Code
from Emp t
cross apply (select Code from dbo.Split(t.Data,',') ) x
from Emp t
cross apply (select Code from dbo.Split(t.Data,',') ) x
public class
File
{
private
string
filePath;
[DllImport(
"kernel32"
)]
private
static
extern
long
WritePrivateProfileString(
string
section,
string
key,
string
val,
string
filePath);
[DllImport(
"kernel32"
)]
private
static
extern
int
GetPrivateProfileString(
string
section,
string
key,
string
def,
StringBuilder retVal,
int
size,
string
filePath);
public
File(
string
filePath)
{
this
.filePath = filePath;
}
public
void
Write(
string
section,
string
key,
string
value)
{
WritePrivateProfileString(section, key, value.ToLower(),
this
.filePath);
}
public
string
Read(
string
section,
string
key)
{
StringBuilder SB =
new
StringBuilder(255);
int
i = GetPrivateProfileString(section, key,
""
, SB, 255,
this
.filePath);
return
SB.ToString();
}
public
string
FilePath
{
get
{
return
this
.filePath; }
set
{
this
.filePath = value; }
}
}