System.Data.ConstraintExceptio ... [英] System.Data.ConstraintExceptio...
问题描述
你可以帮我吗？我遇到了约束问题。 无法启用约束。一行或多行包含违反非null，唯一或外键约束的值。
private void BindtheUserControls（DataTable dtTechGroup）
{
尝试
{
RadDockZone dockZone1 =（RadDockZone）FindControl（RadDockZone1）;
RadDockZone dockZone2 =（RadDockZone）FindControl（RadDockZone2）;
RadDock dockSystemStatus = GetDock（）;
RadDock dockControllers = GetDock（）;
RadDock radDockProcessFlow = GetDock（）;
Nalco.WPS.BusinessLayer.ControllerSystem controllerSystem = Nalco.WPS.BusinessLayer.ControllerSystem.GetByID（SystemID，true）;
string userType = Convert.ToString（UserSession.NalcoUser.UserType）;
for（int i = 0; i< dtTechGroup.Rows.Count; i ++）
{
bool isFullWidth = dtTechGroup.Rows [i] [Width]。ToString（）==Full;
bool isSettingButton = dtTechGroup.Rows [i] [setting]。ToString（）==True;
RadDock objDock = GetControlObject（dtTechGroup.Rows [i] [UserControls]。ToString（），controllerSystem，isFullWidth）;
if（isSettingButton == true）
{
lnkSystemSettings.Visible = true;
}
else
{
lnkSystemSettings.Visible = false;
}
if（objDock！= null）
{
if（isFullWidth == false）
{
RadDockLayoutOthers.Visible = true;
if（i％2 == 0）
{
RadDockZone1.Visible = true;
dockZone1.Controls.Add（objDock） ;
}
其他
{
RadDockZone2.Visible = true;
dockZone2.Controls.Add（objDock）;
}
}
else if（dtTechGroup.Rows [ i] [UserControls]。ToString（）==SystemDetailsStreamGaugesSugar.ascx|| dtTechGroup.Rows [i] [UserControls]。ToString（）==SystemDetailsSummaryCalibration.ascx|| dtTechGroup.Rows [i] [UserControls]。ToString（）==SystemDeatilsGaugesSideStream.ascx）
{
RadDockLayoutMembranes.Visible = true;
RadDockZoneGauges.Controls.Add（objDock）;
}
else if（Constants.SUGAR == TechGroupName）
{
RadDockLayoutMembranes.Visible = true;
RadDockZoneGauges.Controls.Add（objDock）;
}
else
{
RadDockLayoutDAFGauges.Visible = true;
RadDockZoneDAFGauges.Controls.Add（objDock）;
}
}
}
}
catch（exception ex）
{
UIException UiExp = new UIException（例如，ExceptionBase.PriorityEnum.High，Page.Request）;
}
}
could you please help me. i got constraints issue. "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. "
private void BindtheUserControls(DataTable dtTechGroup)
{
try
{
RadDockZone dockZone1 = (RadDockZone)FindControl("RadDockZone1");
RadDockZone dockZone2 = (RadDockZone)FindControl("RadDockZone2");
RadDock dockSystemStatus = GetDock();
RadDock dockControllers = GetDock();
RadDock radDockProcessFlow = GetDock();
Nalco.WPS.BusinessLayer.ControllerSystem controllerSystem = Nalco.WPS.BusinessLayer.ControllerSystem.GetByID(SystemID, true);
string userType = Convert.ToString(UserSession.NalcoUser.UserType);
for (int i = 0; i < dtTechGroup.Rows.Count; i++)
{
bool isFullWidth = dtTechGroup.Rows[i]["Width"].ToString() == "Full";
bool isSettingButton = dtTechGroup.Rows[i]["setting"].ToString() == "True";
RadDock objDock = GetControlObject(dtTechGroup.Rows[i]["UserControls"].ToString(), controllerSystem, isFullWidth);
if (isSettingButton == true)
{
lnkSystemSettings.Visible = true;
}
else
{
lnkSystemSettings.Visible = false;
}
if (objDock != null)
{
if (isFullWidth == false)
{
RadDockLayoutOthers.Visible = true;
if (i % 2 == 0)
{
RadDockZone1.Visible = true;
dockZone1.Controls.Add(objDock);
}
else
{
RadDockZone2.Visible = true;
dockZone2.Controls.Add(objDock);
}
}
else if (dtTechGroup.Rows[i]["UserControls"].ToString() == "SystemDetailsStreamGaugesSugar.ascx" || dtTechGroup.Rows[i]["UserControls"].ToString() == "SystemDetailsSummaryCalibration.ascx" || dtTechGroup.Rows[i]["UserControls"].ToString() == "SystemDeatilsGaugesSideStream.ascx")
{
RadDockLayoutMembranes.Visible = true;
RadDockZoneGauges.Controls.Add(objDock);
}
else if (Constants.SUGAR == TechGroupName)
{
RadDockLayoutMembranes.Visible = true;
RadDockZoneGauges.Controls.Add(objDock);
}
else
{
RadDockLayoutDAFGauges.Visible = true;
RadDockZoneDAFGauges.Controls.Add(objDock);
}
}
}
}
catch (Exception ex)
{
UIException UiExp = new UIException(ex, ExceptionBase.PriorityEnum.High, Page.Request);
}
}
推荐答案
Hi Kiran Susarla，
我已经解决了这个问题。谢谢你的评论。
我的代码：
< b> ds.EnforceConstraints = false; ////新行由sriram添加。
DT.DataSource = ds.Tables（0）.DefaultView;
BindtheUserControls（）;
问候，
Sriram
Hi Kiran Susarla,
I''ve fixed this issue. Thanks for you comments.
my code:
ds.EnforceConstraints = false; //// New Line Add by sriram.
DT.DataSource = ds.Tables(0).DefaultView;
BindtheUserControls();
Regards,
Sriram
这篇关于System.Data.ConstraintExceptio ...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
