• DLL version issue and SQL Parameters Issue


    1. 在工程中Reference dll: 

       1).specify version: true or false should be same.Other wise, there will be conflick between these dlls expecily that have depence.

       2). We can set all of them are true or all false.

    2.SqlException: The parameterized query ## expects the pa... RSS

    Resolved.

            
    public void UpdateTableInfo(string command, string dbTableName, DataTable dataTable, IList<string> parameters) 
            { 
                _dataAdapter.InsertCommand 
    = new SqlCommand(@command); 
                IList tableColumnTypes 
    = GetTableColumnTypes(dbTableName); 
                
    for (int i = 0; i < parameters.Count; i++
                { 
                    _dataAdapter.InsertCommand.Parameters.Add(
    new SqlParameter("@" + parameters[i], tableColumnTypes[i])); 
                    _dataAdapter.InsertCommand.Parameters[
    "@" + parameters[i]].SourceVersion = DataRowVersion.Current; 
                    _dataAdapter.InsertCommand.Parameters[
    "@" + parameters[i]].SourceColumn = dataTable.Columns[i].ColumnName; 
                } 
                SqlConnection conn 
    = DbConnection; 
                _dataAdapter.InsertCommand.Connection 
    = conn; 
                
    using (conn) 
                { 
                    _dataAdapter.Update(dataTable.DataSet, dbTableName); 
                } 
            }

    I'm wondering if my problem possibly has to do with null or empty values in my DataTable ("dataTable"). The exception error seems to imply that a parameter value was not supplied in the parameterized query? Like the value of @Value0 was empty or null in my DataTable (for a particular row)?

    If this is the case, how can I handle empty or null values in my DataTable so that this problem does not arise? Insert a DbNull value into my database for each empty or null value in the DataTable? How might that be best accomplished? I guess I would have to allow NULL values in my database table to do this?

    做个快乐的自己。
  • 相关阅读:
    [安卓]AndroidManifest.xml文件简介及结构
    [网络技术][转]PPTP协议解析
    ubuntu 12.04 (64位)下安装oracle 11g过程及问题总结
    deb包制作(转)
    短信部分之PDU简介及其格式(转)
    Siemens3508手机AT指令发送短信的实验
    GDB中应该知道的几个调试方法【转陈浩】
    JLink间接烧写【转自armobbs】
    [转]Java事件处理机制- 事件监听器的四种实现方式
    asp.net验证码
  • 原文地址:https://www.cnblogs.com/Jessy/p/2068552.html
Copyright © 2020-2023  润新知