c#连接Sql Server 2000数据库的问题(100分)

下面是一段C#代码，我需要将接收到的三个信息存入Sql Server 2000数据库。
数据库名为db，表名为Tb，三个字段为SContent,Spn,SSp，均为字符型。
我只要您判断一下Sp的值如果为"9999"，就将他们写入数据库，我就需要这一段代码！
本人对C#不熟，但只要这个简单功能就可以了；另对数据库的操作不要造成程序
异常关闭（这算一个服务程序）以及Sql server的访问速度缓慢！
void Deliver()
{
string loginName = "123456";
string loginPassword = "123456";
app.Service objSmsService = new Service();
app.DeliverMessage[] oDeliverMessages;
app.DeliverMessage oDeliverMessage;
while(true)
{
try
{
oDeliverMessages = objSmsService.Deliver(loginName,loginPassword);
if (oDeliverMessages == null)
{
//No Message
}
else
{
for (int i = 0;
i < oDeliverMessages.Length;
i++)
{
oDeliverMessage = oDeliverMessages;
//判断以下如果sp的值为"9999"，就将下面三个信息存入Tb表
Console.WriteLine("Content：{0}",oDeliverMessage.MessageContent);
//对应字段为SContent
Console.WriteLine("Pn：{0}",oDeliverMessage.MobileNo);
//对应字段为SPn
Console.WriteLine("Sp：{0}",oDeliverMessage.SpNumber);
//对应字段为SSp

objSmsService.DeliverResp(loginName,loginPassword,oDeliverMessage.MessageId);
}
}
}
catch(Exception e)
{
//Exception
}
System.Threading.Thread.Sleep(1000);
}
}

先看看编译是能否连接.

void Deliver()
{
string loginName = "123456";
string loginPassword = "123456";
app.Service objSmsService = new Service();
app.DeliverMessage[] oDeliverMessages;
app.DeliverMessage oDeliverMessage;
while(true)
{
try
{
oDeliverMessages = objSmsService.Deliver(loginName,loginPassword);
if (oDeliverMessages == null)
{
//No Message
}
else
{
for (int i = 0;
i < oDeliverMessages.Length;
i++)
{
oDeliverMessage = oDeliverMessages;
//可以这样连接sql 2k并插入数据
string source="server=Jacky;uid=sa;pwd=hh0526;database=m5city";
string ins;
SqlConnection conn;
SqlCommand cmd;
ins="insert into upmobile(content,spn,ssp) values(oDeliverMessage.MessageContent,oDeliverMessage.MobileNo,oDeliverMessage.SpNumber)";
Console.Write(ins);
conn=new SqlConnection(source);
conn.Open();
cmd=new SqlCommand(select,conn);
cmd.ExecuteNonQuery();
conn.Close();

objSmsService.DeliverResp(loginName,loginPassword,oDeliverMessage.MessageId);
}
}
}
catch(Exception e)
{
//Exception
}
System.Threading.Thread.Sleep(1000);
}
}

接受答案了.