我想看看以下代码生成的真实sql语句(不带@参数,是输入的数据),如何查看?代码如下(用的微软企业库) Database db = DatabaseFactory.CreateDatabase();
string sqlcmd = "update ga_jcxx_aj_ajjbxx set ajmc='@ajmc',zab='@zab',zab2='@zab2',fab1='@fab1',fab2='@fab2'," +
"FASJ=to_date('@fasj','YYYYMMDDHHMMSS'),FASJXX=to_date('@fasjxx','YYYYMMDDHHMMSS'),qdfasjyj='@qdfasjyj'," +
"LARQ=to_date('@lasj','YYYYMMDDHHMMSS'),JYAQ='@jyaq',ajfsxxjg='@ajfsxxjg',FADXZ='@fadxz',fady='@fadybm'," +
"fabw='@fabwbm',zasdbm='@zasdbm',zasjbm='@zasjbm',zagjbm='@zagjbm',ssrs='@ssrs',swrs='@swrs',bar='@bar',lxdh='@lxdh' where ajbh='@ajbh'";
DbCommand cmd = db.GetSqlStringCommand(sqlcmd);
db.AddInParameter(cmd, "@ajmc", DbType.String, ajmc.Text);
db.AddInParameter(cmd, "@zab", DbType.String, dic.getDic_code(ajlb1.Text, "案别/案由"));
db.AddInParameter(cmd, "@zab2", DbType.String, ajlb2.SelectedValue);
db.AddInParameter(cmd, "@fab1", DbType.String, dic.getDic_code(fab1.Text, "案别/案由"));
db.AddInParameter(cmd, "@fab2", DbType.String, dic.getDic_code(fab2.Text, "案别/案由"));
db.AddInParameter(cmd, "@fasj", DbType.String, fasjsx.Text);
db.AddInParameter(cmd, "@fasjxx", DbType.String, fasjxx.Text);
db.AddInParameter(cmd, "@qdfasjyj", DbType.String, qdfasjyj.Text);
db.AddInParameter(cmd, "@lasj", DbType.String, lasj.Text);
db.AddInParameter(cmd, "@jyaq", DbType.String, jyjq.Text);
db.AddInParameter(cmd, "@ajfsxxjg", DbType.String, ajfsjg.Text);
db.AddInParameter(cmd, "@fadxz", DbType.String, fadxz.Text);
db.AddInParameter(cmd, "@fadybm", DbType.String, fady.SelectedValue);
db.AddInParameter(cmd,"@fabwbm",DbType.String,fabw.SelectedValue);
db.AddInParameter(cmd, "@zasdbm", DbType.String, zasd);
db.AddInParameter(cmd, "@zasjbm", DbType.String, zasj);
db.AddInParameter(cmd, "@zagjbm", DbType.String, zagj);
db.AddInParameter(cmd, "@ssrs", DbType.String, ssrs.Text);
db.AddInParameter(cmd, "@swrs", DbType.String, swrs.Text);
db.AddInParameter(cmd, "@bar", DbType.String, bar.Text);
db.AddInParameter(cmd, "@lxdh", DbType.String,lxdh.Text);
db.AddInParameter(cmd, "@ajbh", DbType.String,ajid_label.Text);
int row= db.ExecuteNonQuery(cmd);
string sqlcmd = "update ga_jcxx_aj_ajjbxx set ajmc='@ajmc',zab='@zab',zab2='@zab2',fab1='@fab1',fab2='@fab2'," +
"FASJ=to_date('@fasj','YYYYMMDDHHMMSS'),FASJXX=to_date('@fasjxx','YYYYMMDDHHMMSS'),qdfasjyj='@qdfasjyj'," +
"LARQ=to_date('@lasj','YYYYMMDDHHMMSS'),JYAQ='@jyaq',ajfsxxjg='@ajfsxxjg',FADXZ='@fadxz',fady='@fadybm'," +
"fabw='@fabwbm',zasdbm='@zasdbm',zasjbm='@zasjbm',zagjbm='@zagjbm',ssrs='@ssrs',swrs='@swrs',bar='@bar',lxdh='@lxdh' where ajbh='@ajbh'";
DbCommand cmd = db.GetSqlStringCommand(sqlcmd);
db.AddInParameter(cmd, "@ajmc", DbType.String, ajmc.Text);
db.AddInParameter(cmd, "@zab", DbType.String, dic.getDic_code(ajlb1.Text, "案别/案由"));
db.AddInParameter(cmd, "@zab2", DbType.String, ajlb2.SelectedValue);
db.AddInParameter(cmd, "@fab1", DbType.String, dic.getDic_code(fab1.Text, "案别/案由"));
db.AddInParameter(cmd, "@fab2", DbType.String, dic.getDic_code(fab2.Text, "案别/案由"));
db.AddInParameter(cmd, "@fasj", DbType.String, fasjsx.Text);
db.AddInParameter(cmd, "@fasjxx", DbType.String, fasjxx.Text);
db.AddInParameter(cmd, "@qdfasjyj", DbType.String, qdfasjyj.Text);
db.AddInParameter(cmd, "@lasj", DbType.String, lasj.Text);
db.AddInParameter(cmd, "@jyaq", DbType.String, jyjq.Text);
db.AddInParameter(cmd, "@ajfsxxjg", DbType.String, ajfsjg.Text);
db.AddInParameter(cmd, "@fadxz", DbType.String, fadxz.Text);
db.AddInParameter(cmd, "@fadybm", DbType.String, fady.SelectedValue);
db.AddInParameter(cmd,"@fabwbm",DbType.String,fabw.SelectedValue);
db.AddInParameter(cmd, "@zasdbm", DbType.String, zasd);
db.AddInParameter(cmd, "@zasjbm", DbType.String, zasj);
db.AddInParameter(cmd, "@zagjbm", DbType.String, zagj);
db.AddInParameter(cmd, "@ssrs", DbType.String, ssrs.Text);
db.AddInParameter(cmd, "@swrs", DbType.String, swrs.Text);
db.AddInParameter(cmd, "@bar", DbType.String, bar.Text);
db.AddInParameter(cmd, "@lxdh", DbType.String,lxdh.Text);
db.AddInParameter(cmd, "@ajbh", DbType.String,ajid_label.Text);
int row= db.ExecuteNonQuery(cmd);
解决方案 »
- 密码入库时,是否还需要过滤?
- 子菜单不能显示的问题
- 用C#生成cookie,但用Javascript访问此cookie很郁闷
- 我把一个全局的Dataset做为一个临时数据库,所有操作都在Dataset上执行,每隔10分钟更新到SQL Server,请问这样的方法实用吗?
- vs2005中有没有freetextbox那样的控件
- 关于table...
- ASP.NET操纵数据库的语句!
- treeview问题(在线求助)
- 如何编写GridView的Sorting事件处理程序
- 提问:如何 用JS 获取当前行的值?DEV AspxGridview
- 如何截取一段字符?
- ASP.NET 如何在一个类中用C#代码POST提交表单 (高分求解)!!!
select * from v$sqlarea t where t.PARSING_SCHEMA_NAME in ('用户名') order by t.LAST_ACTIVE_TIME desc