Question

【求救！】C#.net 标准表达式中数据类型不匹配 以下Money为货币类型字段 用百度hi 联系我

主要实现，当某一UserID下，AccountLog中direction为IN的Money总和减去OUT的Money总和，最后两者相减，在名为balance的label上显示
主要代码：
private void BalanceInquire_Load(object sender, EventArgs e)
{

OleDbConnection oc = new OleDbConnection(ConfigurationManager.ConnectionStrings["ButterflyConnectionString"].ConnectionString);
oc.Open();

String strin = "select SUM([Money]) As income from AccountLog where UserID='" + BIUserID + "' and Direction ='IN'";
String strout = "select SUM([Money]) As payment from AccountLog Where UserID='" + BIUserID + "' and Direction = 'OUT'";

OleDbCommand comin = new OleDbCommand(strin);
comin.Connection = oc;
OleDbDataReader drin = comin.ExecuteReader();
OleDbCommand comout = new OleDbCommand(strout);
comin.Connection = oc;
OleDbDataReader drout = comout.ExecuteReader();
try
{
drin.Read();
drout.Read();

balance.Text = ((decimal)drin["income"] - (decimal)drout["payment"]).ToString();
}
catch(Exception ex)
{
balance.Text = ex.Message;
}
finally
{
drin.Close();
drout.Close();
oc.Close();
}

}
}
补充：现在第二句comin.Connection = oc;已改成comout.Connection = oc; 另外前面有代码：private static int BIUserID;
public BalanceInquire(int l1)
{
InitializeComponent();
BIUserID = l1;

}
而，再到退前面一个窗体
private void 余额查询ToolStripMenuItem_Click(object sender, EventArgs e)
{
ManageAccount.BalanceInquire frm = new ManageAccount.BalanceInquire(Login.USERID);
frm.MdiParent = this;
frm.Show();
}
再到退到主启动窗体：
public static int USERID; 这是USERID字段的定义
拜托！！！高手帮帮我啊！！！！满意的话我多给您加5分！

Answer 1

BIUserID 是 int类型 不能直接直接+
需要 BIUserID.ToString()

如果还不行的话
strin = "select SUM([Money]) As income from AccountLog where UserID='" + BIUserID + "' and Direction ='IN'";

UserID=’看到这个小逗号没
把他去掉
还有后边这个小豆号也去掉"' and

Answer 2

( ⊙ o ⊙ )啊！ 惊现学术帝