the

the

关注
发信
关注(28)粉丝(399)

DataBindings不起作用

本文介绍了DataBindings不起作用的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

在Windows 7企业版下运行的VS 2012中，我试图在表单上的数据集中显示数据。我已使用数据绑定将表单上的控件绑定到dataTable。表单正在工作并在dataTable中显示记录，但此后一直停止工作。
在调试模式下，我可以看到  dataTable 具有从我的存储过程返回的记录，但这些记录不再显示在表单上。不知道我做错了什么。谢谢。


使用System; 
使用System.Collections.Generic;使用System.ComponentModel 
; 
使用System.Data;使用System.Drawing 
; 
使用System.Linq; 
使用System.Text; 
使用System.Threading.Tasks; 
使用System.Windows.Forms; 
使用System.Data.SqlClient; 
使用System.Globalization; 
使用System.Diagnostics; 
使用System.Collections; 
 
名称空间MSP_Outreach 
 {
公共部分类MSPOutreach：表格
 {
 SqlDataAdapter da; 
 DataTable dataTable; 
 DataSet cobNonHorizo​​n; 
 CurrencyManager currManager; 
布尔bolDUlete; 
布尔bolConfirm; 
布尔bolEdit; 
 
 public MSPOutreach（）
 {
 InitializeComponent（）; 
} 
 
 private void btnShow_Click（object sender，EventArgs e）
 {
 GetCOBNonHorizo​​nRecsForGrp（）; 
 
 / *启用表格上的对象* / 
 btnConfirm.Enabled = true; 
 btnEdit.Enabled = true; 
 btnDelete.Enabled = true; 
 btnSave.Enabled = true; 
 btnNext.Enabled = true; 
 btnPrevious.Enabled = true; 
 
 bolEdit = false; 
 bolDelete = false; 
 bolConfirm = false; 
 
 txtComments.Enabled = true; 
 
 // RefreshDataGrid（）; 
 
} 
 
 private void GetCOBNonHorizo​​nRecsForGrp（）
 {
 Int32 rowsAffected; 
 
 
 string GroupName = cboGroups.Text 
 
 //填充dataTable 
 SqlCommand cmd1 = new SqlCommand（" Insurer_Select"，sqlConnection1）; 
 cmd1.Parameters.Clear（）; 
 cmd1.Parameters.Add（new SqlParameter（" @ InsurerGroup"，GroupName））; 
 cmd1.CommandType = CommandType.StoredProcedure; 
 
 // cobNonHorizo​​n = new DataSet（）; 
 da = new SqlDataAdapter（cmd1）; 
 this.cobNonHorizo​​n.Clear（）; 
 da.Fill（cobNonHorizo​​n，" dataTable"）; 
 sqlConnection1.Close（）; 
 
 DataTable tbl = cobNonHorizo​​n.Tables [0]; 
 
 txtPosition.Text =" 1 of of + tbl.Rows.Count.ToString（）; 
 
 
 currManager =（CurrencyManager）this.BindingContext [cobNonHorizo​​n.Tables [" dataTable"]]; 
 
 / *启用状态选择按钮* / 
 btnEdit.Enabled = true; 
 btnConfirm.Enabled = true; 
 btnDelete.Enabled = true; 
 
 / * DetermineStatus（）; * / 
 
 
} 
 
 private void MSPOutreach_Load（object sender，EventArgs e）
 {
 cboGroups.Items.AddRange（GetGroups（ ））; 
 
 //创建新的dataTable 
 dataTable = new DataTable（" dataTable"）; 
 
 / *将列添加到datatable * / 
 dataTable.Columns.Add（" relHICN"，typeof（String））; 
 dataTable.Columns.Add（" relCCID"，typeof（String））; 
 dataTable.Columns.Add（" relSubscriberFirst"，typeof（String））; 
 dataTable.Columns.Add（" relSubscriberLast"，typeof（String））; 
 dataTable.Columns.Add（" relRelation"，typeof（String））; 
 dataTable.Columns.Add（" relMSPEffDate"，typeof（String））; 
 dataTable.Columns.Add（" relMSPTermDate"，typeof（String））; 
 dataTable.Columns.Add（" relMSPCode"，typeof（String））; 
 dataTable.Columns.Add（" relInsurerName"，typeof（String））; 
 dataTable.Columns.Add（" relInsurerAddress1"，typeof（String））; 
 dataTable.Columns.Add（" relInsurerCity"，typeof（String））; 
 dataTable.Columns.Add（" relInsurerSt"，typeof（String））; 
 dataTable.Columns.Add（" relInsurerZip"，typeof（String））; 
 dataTable.Columns.Add（" relPolicyNumber"，typeof（String））; 
 dataTable.Columns.Add（" relInsurerType"，typeof（String））; 
 dataTable.Columns.Add（" relSourceCode"，typeof（String））; 
 dataTable.Columns.Add（" relInsGroup"，typeof（String））; 
 dataTable.Columns.Add（" relInsurerGroupName"，typeof（String））; 
 dataTable.Columns.Add（" relOccuranceStatus"，typeof（String））; 
 dataTable.Columns.Add（" relActSource"，typeof（String））; 
 dataTable.Columns.Add（" relActMSPEffDate"，typeof（String））; 
 dataTable.Columns.Add（" relActMSPtermDate"，typeof（String））; 
 dataTable.Columns.Add（" relActMSPStatus"，typeof（String））; 
 dataTable.Columns.Add（" relIKAEffDate"，typeof（String））; 
 dataTable.Columns.Add（" relIKATermDate"，typeof（String））; 
 dataTable.Columns.Add（" relActInsurerName"，typeof（String））; 
 dataTable.Columns.Add（" relActRelation"，typeof（String））; 
 dataTable.Columns.Add（" relActInsurerAddress1"，typeof（String））; 
 dataTable.Columns.Add（" relActMSPCode"，typeof（String））; 
 dataTable.Columns.Add（" relActPolicyNumber"，typeof（String））; 
 dataTable.Columns.Add（" relActInsGroup"，typeof（String））; 
 dataTable.Columns.Add（" relActInsurerGroupName"，typeof（String））; 
 dataTable.Columns.Add（" relActInsurerType"，typeof（String））; 
 dataTable.Columns.Add（" relComment"，typeof（String））; 
 dataTable.Columns.Add（" relTransActionCd"，typeof（String））; 
 
 / *为dataTable设置数据绑定* / 
 txtHICN.DataBindings.Add（" Text"，dataTable，" relHICN"）; 
 txtCCID.DataBindings.Add（" Text"，dataTable，" relCCID"）; 
 txtFN.DataBindings.Add（" Text"，dataTable，" relSubscriberFirst"）; 
 txtLN.DataBindings.Add（" Text"，dataTable，" relSubscriberLast"）; 
 txtPatRel.DataBindings.Add（" Text"，dataTable，" relRelation"）; 
 txtMSPEffDt.DataBindings.Add（" Text"，dataTable，" relMSPEffDate"）; 
 txtMSPTermDt.DataBindings.Add（" Text"，dataTable，" relMSPTermDate"）; 
 txtMSPCode.DataBindings.Add（" Text"，dataTable，" relMSPCode"）; 
 txtInsurerName.DataBindings.Add（" Text"，dataTable，" relInsurerName"）; 
 txtInsurerAddress.DataBindings.Add（" Text"，dataTable，" relInsurerAddress1"）; 
 txtInsurerCity.DataBindings.Add（" Text"，dataTable，" relInsurerCity"）; 
 txtInsurerSt.DataBindings.Add（" Text"，dataTable，" relInsurerSt"）; 
 txtInsurerZip.DataBindings.Add（" Text"，dataTable，" relInsurerZip"）; 
 txtPolicyNum.DataBindings.Add（" Text"，dataTable，" relPolicyNumber"）; 
 txtInsurerType.DataBindings.Add（" Text"，dataTable，" relInsurerType"）; 
 txtSourceCode.DataBindings.Add（" Text"，dataTable，" relSourceCode"）; 
 txtInsurerGrp.DataBindings.Add（" Text"，dataTable，" relInsGroup"）; 
 txtInsurerGrpName.DataBindings.Add（" Text"，dataTable，" relInsurerGroupName"）; 
 txtStatus.DataBindings.Add（" Text"，dataTable，" relOccuranceStatus"）; 
 txtSourceCd.DataBindings.Add（" Text"，dataTable，" relActSource"）; 
 txtActEffDt.DataBindings.Add（" Text"，dataTable，" relActMSPEffDate"）; 
 txtActTermDt.DataBindings.Add（" Text"，dataTable，" relActMSPtermDate"）; 
 txtMSPStatus.DataBindings.Add（" Text"，dataTable，" relActMSPStatus"）; 
 txtIKAEff.DataBindings.Add（" Text"，dataTable，" relIKAEffDate"）; 
 txtIKATerm.DataBindings.Add（" Text"，dataTable，" relIKATermDate"）; 
 txtActInsurerName.DataBindings.Add（" Text"，dataTable，" relActInsurerName"）; 
 txtActPatientRel.DataBindings.Add（" Text"，dataTable，" relActRelation"）; 
 txtActInsurerAddress1.DataBindings.Add（" Text"，dataTable，" relActInsurerAddress1"）; 
 txtActMSPCode.DataBindings.Add（" Text"，dataTable，" relActMSPCode"）; 
 txtActPolicyNum.DataBindings.Add（" Text"，dataTable，" relActPolicyNumber"）; 
 txtActInsurerGrp.DataBindings.Add（" Text"，dataTable，" relActInsGroup"）; 
 txtActInsurerGrpName.DataBindings.Add（" Text"，dataTable，" relActInsurerGroupName"）; 
 txtActInsurerType.DataBindings.Add（" Text"，dataTable，" relActInsurerType"）; 
 txtComments.DataBindings.Add（" Text"，dataTable，" relComment"）; 
 txtTransActionCd.DataBindings.Add（" Text"，dataTable，" relTransActionCd"）; 
 
 // DataTable dtIKASpans = new DataTable（）; 
 cobNonHorizo​​n = new DataSet（）; 
} 
 
 public string [] GetGroups（）
 {
 var groups = new List< string>（）; 
 sqlConnection1.Open（）; 
 SqlCommand cmd = new SqlCommand（" GetInsurerGroups"，sqlConnection1）; 
 cmd.CommandType = CommandType.StoredProcedure; 
 var reader = cmd.ExecuteReader（）; 
 while（reader.Read（））
 {
 groups.Add（reader.GetString（0））; 
} 
 
 sqlConnection1.Close（）; 
 
返回groups.ToArray（）; 
} 
} 
}
解决方案

In VS 2012 running under Windows 7 Enterprise I am trying to display data in a dataset on a form. I have bound the controls on the form to the dataTable using databindings. The form was working and showed records in the dataTable, but has since stopped working. In debug mode I can see that the dataTable has records returned from my stored procedure but those records are no longer showing on the form. Not sure what I'm doing wrong. Thank you.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Globalization;
using System.Diagnostics;
using System.Collections;

namespace MSP_Outreach
{
    public partial class MSPOutreach : Form
    {
        SqlDataAdapter da;
        DataTable dataTable;
        DataSet cobNonHorizon;
        CurrencyManager currManager;
        Boolean bolDelete;
        Boolean bolConfirm;
        Boolean bolEdit;

        public MSPOutreach()
        {
            InitializeComponent();
        }

        private void btnShow_Click(object sender, EventArgs e)
        {
            GetCOBNonHorizonRecsForGrp();

            /* Enable objects on form */
            btnConfirm.Enabled = true;
            btnEdit.Enabled = true;
            btnDelete.Enabled = true;
            btnSave.Enabled = true;
            btnNext.Enabled = true;
            btnPrevious.Enabled = true;

            bolEdit = false;
            bolDelete = false;
            bolConfirm = false;

            txtComments.Enabled = true;

            //RefreshDataGrid();

        }

        private void GetCOBNonHorizonRecsForGrp()
        {
            Int32 rowsAffected;

       
            string GroupName = cboGroups.Text

            //Populate dataTable
            SqlCommand cmd1 = new SqlCommand("Insurer_Select", sqlConnection1);
            cmd1.Parameters.Clear();
            cmd1.Parameters.Add(new SqlParameter("@InsurerGroup", GroupName));
            cmd1.CommandType = CommandType.StoredProcedure;

            //cobNonHorizon = new DataSet();
            da = new SqlDataAdapter(cmd1);
            this.cobNonHorizon.Clear();
            da.Fill(cobNonHorizon, "dataTable");
            sqlConnection1.Close();

            DataTable tbl = cobNonHorizon.Tables[0];

            txtPosition.Text = "1 of " + tbl.Rows.Count.ToString();


            currManager = (CurrencyManager)this.BindingContext[cobNonHorizon.Tables["dataTable"]];

            /* Enable status selection buttons */
            btnEdit.Enabled = true;
            btnConfirm.Enabled = true;
            btnDelete.Enabled = true;

            /* DetermineStatus(); */


        }

        private void MSPOutreach_Load(object sender, EventArgs e)
        {
            cboGroups.Items.AddRange(GetGroups());

            //Create new dataTable
            dataTable = new DataTable("dataTable");

            /* Add columns to datatable */
            dataTable.Columns.Add("relHICN", typeof(String));
            dataTable.Columns.Add("relCCID", typeof(String));
            dataTable.Columns.Add("relSubscriberFirst", typeof(String));
            dataTable.Columns.Add("relSubscriberLast", typeof(String));
            dataTable.Columns.Add("relRelation", typeof(String));
            dataTable.Columns.Add("relMSPEffDate", typeof(String));
            dataTable.Columns.Add("relMSPTermDate", typeof(String));
            dataTable.Columns.Add("relMSPCode", typeof(String));
            dataTable.Columns.Add("relInsurerName", typeof(String));
            dataTable.Columns.Add("relInsurerAddress1", typeof(String));
            dataTable.Columns.Add("relInsurerCity", typeof(String));
            dataTable.Columns.Add("relInsurerSt", typeof(String));
            dataTable.Columns.Add("relInsurerZip", typeof(String));
            dataTable.Columns.Add("relPolicyNumber", typeof(String));
            dataTable.Columns.Add("relInsurerType", typeof(String));
            dataTable.Columns.Add("relSourceCode", typeof(String));
            dataTable.Columns.Add("relInsGroup", typeof(String));
            dataTable.Columns.Add("relInsurerGroupName", typeof(String));
            dataTable.Columns.Add("relOccuranceStatus", typeof(String));
            dataTable.Columns.Add("relActSource", typeof(String));
            dataTable.Columns.Add("relActMSPEffDate", typeof(String));
            dataTable.Columns.Add("relActMSPtermDate", typeof(String));
            dataTable.Columns.Add("relActMSPStatus", typeof(String));
            dataTable.Columns.Add("relIKAEffDate", typeof(String));
            dataTable.Columns.Add("relIKATermDate", typeof(String));
            dataTable.Columns.Add("relActInsurerName", typeof(String));
            dataTable.Columns.Add("relActRelation", typeof(String));
            dataTable.Columns.Add("relActInsurerAddress1", typeof(String));
            dataTable.Columns.Add("relActMSPCode", typeof(String));
            dataTable.Columns.Add("relActPolicyNumber", typeof(String));
            dataTable.Columns.Add("relActInsGroup", typeof(String));
            dataTable.Columns.Add("relActInsurerGroupName", typeof(String));
            dataTable.Columns.Add("relActInsurerType", typeof(String));
            dataTable.Columns.Add("relComment", typeof(String));
            dataTable.Columns.Add("relTransActionCd", typeof(String));
 
            /* Set data bindings for dataTable */
            txtHICN.DataBindings.Add("Text", dataTable, "relHICN");
            txtCCID.DataBindings.Add("Text", dataTable, "relCCID");
            txtFN.DataBindings.Add("Text", dataTable, "relSubscriberFirst");
            txtLN.DataBindings.Add("Text", dataTable, "relSubscriberLast");
            txtPatRel.DataBindings.Add("Text", dataTable, "relRelation");
            txtMSPEffDt.DataBindings.Add("Text", dataTable, "relMSPEffDate");
            txtMSPTermDt.DataBindings.Add("Text", dataTable, "relMSPTermDate");
            txtMSPCode.DataBindings.Add("Text", dataTable, "relMSPCode");
            txtInsurerName.DataBindings.Add("Text", dataTable, "relInsurerName");
            txtInsurerAddress.DataBindings.Add("Text", dataTable, "relInsurerAddress1");
            txtInsurerCity.DataBindings.Add("Text", dataTable, "relInsurerCity");
            txtInsurerSt.DataBindings.Add("Text", dataTable, "relInsurerSt");
            txtInsurerZip.DataBindings.Add("Text", dataTable, "relInsurerZip");
            txtPolicyNum.DataBindings.Add("Text", dataTable, "relPolicyNumber");
            txtInsurerType.DataBindings.Add("Text", dataTable, "relInsurerType");
            txtSourceCode.DataBindings.Add("Text", dataTable, "relSourceCode");
            txtInsurerGrp.DataBindings.Add("Text", dataTable, "relInsGroup");
            txtInsurerGrpName.DataBindings.Add("Text", dataTable, "relInsurerGroupName");
            txtStatus.DataBindings.Add("Text", dataTable, "relOccuranceStatus");
            txtSourceCd.DataBindings.Add("Text", dataTable, "relActSource");
            txtActEffDt.DataBindings.Add("Text", dataTable, "relActMSPEffDate");
            txtActTermDt.DataBindings.Add("Text", dataTable, "relActMSPtermDate");
            txtMSPStatus.DataBindings.Add("Text", dataTable, "relActMSPStatus");
            txtIKAEff.DataBindings.Add("Text", dataTable, "relIKAEffDate");
            txtIKATerm.DataBindings.Add("Text", dataTable, "relIKATermDate");
            txtActInsurerName.DataBindings.Add("Text", dataTable, "relActInsurerName");
            txtActPatientRel.DataBindings.Add("Text", dataTable, "relActRelation");
            txtActInsurerAddress1.DataBindings.Add("Text", dataTable, "relActInsurerAddress1");
            txtActMSPCode.DataBindings.Add("Text", dataTable, "relActMSPCode");
            txtActPolicyNum.DataBindings.Add("Text", dataTable, "relActPolicyNumber");
            txtActInsurerGrp.DataBindings.Add("Text", dataTable, "relActInsGroup");
            txtActInsurerGrpName.DataBindings.Add("Text", dataTable, "relActInsurerGroupName");
            txtActInsurerType.DataBindings.Add("Text", dataTable, "relActInsurerType");
            txtComments.DataBindings.Add("Text", dataTable, "relComment");
            txtTransActionCd.DataBindings.Add("Text", dataTable, "relTransActionCd");
 
            //DataTable dtIKASpans = new DataTable();
            cobNonHorizon = new DataSet();
        }

        public string[] GetGroups()
        {
            var groups = new List<string>();
            sqlConnection1.Open();
            SqlCommand cmd = new SqlCommand("GetInsurerGroups", sqlConnection1);
            cmd.CommandType = CommandType.StoredProcedure;
            var reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                groups.Add(reader.GetString(0));
            }

            sqlConnection1.Close();

            return groups.ToArray();
        }
    }
}
解决方案


这篇关于DataBindings不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

11-03 07:48
Powered by LMLPHP ©2024 the 0.004217