class DBParameter Member of iAnywhere.MobiLink.Script
代表捆绑的 ODBC 参数。
要执行带有参数的命令,需要 DBParameter。执行该命令前,必须准备好所有参数。
例如,以下 C# 代码使用 DBCommand 执行带有参数的更新:
public void handleUpload(UploadData ud) { UploadedTableData UTDAdmin = ud.GetUploadedTableByName("Admin"); IDataReader AdminIns = UTDAdmin.GetInserts(); DBCommand stmt1 = _conn.CreateCommand(); DBParameter p_id = new DBParameter(); DBParameter p_data = new DBParameter(); stmt1.CommandText = "INSERT INTO Admin(admin_id,data) VALUES (?,?)"; p_id.DbType = SQLType.SQL_BIGINT; stmt1.Parameters.Add(p_id); p_data.DbType = SQLType.SQL_VARCHAR; p_data.Size = 30; stmt1.Parameters.Add(p_data); stmt1.Prepare(); while (AdminIns.Read()) { p_id.Value = AdminIns.GetInt64(0); p_data.Value = AdminIns.GetString(1); stmt1.ExecuteNonQuery(); } stmt1.Close(); } |
DbType 属性
Direction 属性
IsNullable 属性
ParameterName 属性
Precision 属性
Scale 属性
Size 属性
Value 属性
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |