本文整理汇总了C#中System.Data.DataRelation类的典型用法代码示例。如果您正苦于以下问题:C# DataRelation类的具体用法?C# DataRelation怎么用?C# DataRelation使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DataRelation类属于System.Data命名空间,在下文中一共展示了DataRelation类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: run
//Activate This Construntor to log All To Standard output
//public TestClass():base(true){}
//Activate this constructor to log Failures to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, false){}
//Activate this constructor to log All to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, true){}
//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES
public void run()
{
Exception exp = null;
DataSet ds = new DataSet();
DataTable dtChild = GHTUtils.DataProvider.CreateChildDataTable();
DataTable dtParent = GHTUtils.DataProvider.CreateParentDataTable();
ds.Tables.Add(dtParent);
ds.Tables.Add(dtChild);
DataRelation dRel;
dRel = new DataRelation(null,dtParent.Columns[0],dtChild.Columns[0]);
ds.Relations.Add(dRel);
try
{
BeginCase("Nested default ");
Compare(dRel.Nested , false);
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
dRel.Nested = true;
try
{
BeginCase("Nested get/set");
Compare(dRel.Nested ,true);
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
}
示例2: ChildPropertyName
private string ChildPropertyName(DataRelation relation, out bool usesAnnotations)
{
usesAnnotations = true;
string str = (string) relation.ExtendedProperties["typedChildren"];
if (!StringUtil.Empty(str))
{
return str;
}
string str2 = (string) relation.ChildTable.ExtendedProperties["typedPlural"];
if (StringUtil.Empty(str2))
{
str2 = (string) relation.ChildTable.ExtendedProperties["typedName"];
if (StringUtil.Empty(str2))
{
usesAnnotations = false;
str = "Get" + relation.ChildTable.TableName + "Rows";
if (1 < TablesConnectedness(relation.ParentTable, relation.ChildTable))
{
str = str + "By" + relation.RelationName;
}
return NameHandler.FixIdName(str);
}
str2 = str2 + "Rows";
}
return ("Get" + str2);
}
示例3: Form1_Load
private void Form1_Load(object sender, EventArgs e)
{
DbADOTest = new DataSet("DbADOTest");
tblPeople = MakePeopleTable();
tblSale = MakeSaleTable();
DbADOTest.Tables.Add(tblPeople);
DbADOTest.Tables.Add(tblSale);
//* 관계 객체 생성
RelBuy = new DataRelation("Buy",
DbADOTest.Tables["tblPeople"].Columns["Name"],
DbADOTest.Tables["tblSale"].Columns["Customer"]);
DbADOTest.Relations.Add(RelBuy);
//*/
/* FK 직접 생성
ForeignKeyConstraint fk = new ForeignKeyConstraint("Buy",
DbADOTest.Tables["tblPeople"].Columns["Name"],
DbADOTest.Tables["tblSale"].Columns["Customer"]);
tblSale.Constraints.Add(fk);
//*/
/* 삭제 규칙 변경
ForeignKeyConstraint fk= (ForeignKeyConstraint)tblSale.Constraints["Buy"];
fk.DeleteRule = Rule.None;
//*/
dataGridView1.DataSource = DbADOTest.Tables["tblPeople"];
dataGridView2.DataSource = DbADOTest.Tables["tblSale"];
}
示例4: run
//Activate This Construntor to log All To Standard output
//public TestClass():base(true){}
//Activate this constructor to log Failures to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, false){}
//Activate this constructor to log All to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, true){}
//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES
public void run()
{
Exception exp = null;
DataSet ds = new DataSet();
DataTable dtChild = GHTUtils.DataProvider.CreateChildDataTable();
DataTable dtParent = GHTUtils.DataProvider.CreateParentDataTable();
ds.Tables.Add(dtParent);
ds.Tables.Add(dtChild);
DataRelation dRel;
dRel = new DataRelation("MyRelation",dtParent.Columns[0],dtChild.Columns[0]);
ds.Relations.Add(dRel);
PropertyCollection pc;
pc = dRel.ExtendedProperties ;
try
{
base.BeginCase("Checking ExtendedProperties default ");
base.Compare(pc != null,true);
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
try
{
base.BeginCase("Checking ExtendedProperties count ");
base.Compare(pc.Count ,0);
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
}
示例5: Add
public void Add(DataRelation relation)
{
IntPtr ptr;
Bid.ScopeEnter(out ptr, "<ds.DataRelationCollection.Add|API> %d#, relation=%d\n", this.ObjectID, (relation != null) ? relation.ObjectID : 0);
try
{
if (this.inTransition != relation)
{
this.inTransition = relation;
try
{
this.OnCollectionChanging(new CollectionChangeEventArgs(CollectionChangeAction.Add, relation));
this.AddCore(relation);
this.OnCollectionChanged(new CollectionChangeEventArgs(CollectionChangeAction.Add, relation));
}
finally
{
this.inTransition = null;
}
}
}
finally
{
Bid.ScopeLeave(ref ptr);
}
}
示例6: relacionCursoAsignatura
private void relacionCursoAsignatura()
{
bindingSourceCurso = new BindingSource();
bindingSourceAsignatura = new BindingSource();
bindingSourceRelacionCursoAsignatura = new BindingSource();
bindingSourceRelacionAsignaturaNota = new BindingSource();
bindingSourceCurso.DataSource = dataset1.Tables["Cursos"];
bindingSourceAsignatura.DataSource = dataset1.Tables["Asignaturas"];
ColCurso = dataset1.Tables["Cursos"].Columns["COD_CUR"];
ColAsignaturaCUR = dataset1.Tables["Asignaturas"].Columns["COD_CUR"];
ColAsignaturaASI = dataset1.Tables["Asignaturas"].Columns["COD_ASI"];
ColNota = dataset1.Tables["Notas"].Columns["COD_ASI"];
RelacionCursoAsignatura = new DataRelation("RelCursoAsignatura", ColCurso, ColAsignaturaCUR);
RelacionAsignaturaNota = new DataRelation("RelAsignaturaNota", ColAsignaturaASI, ColNota);
dataset1.Relations.Clear();
dataset1.Relations.Add(RelacionCursoAsignatura);
dataset1.Relations.Add(RelacionAsignaturaNota);
bindingSourceRelacionCursoAsignatura.DataSource = bindingSourceCurso;
bindingSourceRelacionCursoAsignatura.DataMember = "RelCursoAsignatura";
bindingSourceRelacionAsignaturaNota.DataSource = bindingSourceRelacionCursoAsignatura;
bindingSourceRelacionAsignaturaNota.DataMember = "RelAsignaturaNota";
}
示例7: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string connStr = @"Data Source=Talha-PC\SQLExpress;Initial Catalog=LocalTestDB;User Id=talha;Password=talha123;Trusted_Connection=True;";
using (SqlConnection conn = new SqlConnection(connStr))
{
string sql = "Select MenuID, Text,Description, ParentID from Menu";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(ds);
da.Dispose();
}
ds.DataSetName = "Menus";
ds.Tables[0].TableName = "Menu";
DataRelation relation = new DataRelation("ParentChild",
ds.Tables["Menu"].Columns["MenuID"],
ds.Tables["Menu"].Columns["ParentID"], true);
relation.Nested = true;
ds.Relations.Add(relation);
XmlDataSource1.Data = ds.GetXml();
if (Request.Params["Sel"] != null)
Page.Controls.Add(new System.Web.UI.LiteralControl("You selected " + Request.Params["Sel"]));
}
示例8: relacionCursoAlumnos
private void relacionCursoAlumnos()
{
//bindingSourceAsignatura = new BindingSource();
bindingSourceAlumno = new BindingSource();
bindingSourceRelacionCursoAlumno = new BindingSource();
bindingSourceRelacionAlumnoNota = new BindingSource();
bindingSourceAlumno.DataSource = dataset1.Tables["Alumnos"];
ColAlumnoCUR = dataset1.Tables["Alumnos"].Columns["COD_CUR"];
ColAlumnoALU = dataset1.Tables["Alumnos"].Columns["COD_ALU"];
ColNota = dataset1.Tables["Notas"].Columns["COD_ALU"];
RelacionCursoAlumno = new DataRelation("RelCursoAlumno", ColCurso, ColAlumnoCUR);
RelacionAlumnoNota = new DataRelation("RelAlumnoNota", ColAlumnoALU, ColNota);
dataset1.Relations.Add(RelacionCursoAlumno);
dataset1.Relations.Add(RelacionAlumnoNota);
bindingSourceRelacionCursoAlumno.DataSource = bindingSourceCurso;
bindingSourceRelacionCursoAlumno.DataMember = "RelCursoAlumno";
bindingSourceRelacionAlumnoNota.DataSource = bindingSourceRelacionCursoAlumno;
bindingSourceRelacionAlumnoNota.DataMember = "RelAlumnoNota";
}
示例9: Add
public void Add()
{
DataRelationCollection drcol = _dataset.Relations;
DataColumn parentCol = _dataset.Tables["Customer"].Columns["custid"];
DataColumn childCol = _dataset.Tables["Order"].Columns["custid"];
DataRelation dr = new DataRelation("CustOrder",parentCol,childCol);
drcol.Add(dr);
AssertEquals("test#1","CustOrder",drcol[0].RelationName);
drcol.Clear();
drcol.Add(parentCol,childCol);
AssertEquals("test#2",1,drcol.Count);
drcol.Clear();
drcol.Add("NewRelation",parentCol,childCol);
AssertEquals("test#3","NewRelation",drcol[0].RelationName);
drcol.Clear();
drcol.Add("NewRelation",parentCol,childCol,false);
AssertEquals("test#4",1,drcol.Count);
drcol.Clear();
drcol.Add("NewRelation",parentCol,childCol,true);
AssertEquals("test#5",1,drcol.Count);
drcol.Clear();
}
示例10: Load_catesearch
private void Load_catesearch()
{
var list = per.Load_danhmuc_search(1);
if (list.Count > 0)
{
DataRelation relCat;
DataTable tbl = DataUtil.LINQToDataTable(list);
DataSet ds = new DataSet();
ds.Tables.Add(tbl);
tbl.PrimaryKey = new DataColumn[] { tbl.Columns["CAT_ID"] };
relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["CAT_ID"], ds.Tables[0].Columns["CAT_PARENT_ID"], false);
ds.Relations.Add(relCat);
DataSet dsCat = ds.Clone();
DataTable CatTable = ds.Tables[0];
DataUtil.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null);
Drcate_search.DataSource = dsCat.Tables[0];
Drcate_search.DataTextField = "CAT_NAME";
Drcate_search.DataValueField = "CAT_ID";
Drcate_search.DataBind();
}
ListItem l = new ListItem("Tất cả", "0");
l.Selected = true;
Drcate_search.Items.Insert(0, l);
}
示例11: Form1_Load
private void Form1_Load(object sender, EventArgs e)
{
connectionString = "Data Source=(local);Initial Catalog=Exam-UserRuns;Integrated Security=SSPI;";
dbConn = new SqlConnection(connectionString);
usersDA = new SqlDataAdapter("select * from Users", dbConn);
runsDA = new SqlDataAdapter("select * from Runs", dbConn);
runsCB = new SqlCommandBuilder(runsDA);
dataSet = new DataSet();
usersDA.Fill(dataSet, "Users");
runsDA.Fill(dataSet, "Runs");
dataRelation = new DataRelation("User_Runs", dataSet.Tables["Users"].Columns["userID"], dataSet.Tables["Runs"].Columns["userID"]);
dataSet.Relations.Add(dataRelation);
usersBS = new BindingSource();
runsBS = new BindingSource();
usersBS.DataSource = dataSet;
usersBS.DataMember = "Users";
runsBS.DataSource = usersBS;
runsBS.DataMember = "User_Runs";
usersComboBox.DataSource = usersBS;
usersComboBox.DisplayMember = "userName";
runsDataGridView.DataSource = runsBS;
}
示例12: Form1_Load
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand comm = new SqlCommand("select * from UserData",con);
DataTable master = new DataTable();
DataTable child = new DataTable();
// Fill Table 2 with Data
SqlDataAdapter da = new SqlDataAdapter(comm);
da.Fill(master);
// Fill Table1 with data
comm = new SqlCommand("select * from UserDetail",con);
da.Fill(child);
con.Close();
DataSet ds = new DataSet();
//Add two DataTables in Dataset
ds.Tables.Add(master);
ds.Tables.Add(child);
// Create a Relation in Memory
DataRelation relation = new DataRelation("",ds.Tables[0].Columns[0],ds.Tables[1].Columns[0],true);
ds.Relations.Add(relation);
dataGrid1.DataSource = ds.Tables[0];
}
示例13: run
//Activate This Construntor to log All To Standard output
//public TestClass():base(true){}
//Activate this constructor to log Failures to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, false){}
//Activate this constructor to log All to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, true){}
//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES
public void run()
{
Exception exp = null;
DataSet ds = new DataSet();
DataTable dtChild = GHTUtils.DataProvider.CreateChildDataTable();
DataTable dtParent = GHTUtils.DataProvider.CreateParentDataTable();
ds.Tables.Add(dtParent);
ds.Tables.Add(dtChild);
DataRelation dRel;
dRel = new DataRelation("MyRelation",dtParent.Columns[0],dtChild.Columns[0]);
ds.Relations.Add(dRel);
try
{
BeginCase("ParentColumns 1");
Compare(dRel.ParentColumns.Length , 1 );
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
try
{
BeginCase("ParentColumns 2");
Compare(dRel.ParentColumns[0] , dtParent.Columns[0] );
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
}
示例14: Add
public void Add ()
{
DataRelationCollection drcol = _dataset.Relations;
DataColumn parentCol = _dataset.Tables ["Customer"].Columns ["custid"];
DataColumn childCol = _dataset.Tables ["Order"].Columns ["custid"];
DataRelation dr = new DataRelation ("CustOrder", parentCol, childCol);
drcol.Add (dr);
Assert.That (drcol [0].RelationName, Is.EqualTo ("CustOrder"), "test#1");
drcol.Clear ();
drcol.Add (parentCol, childCol);
Assert.That (drcol.Count, Is.EqualTo (1), "test#2");
drcol.Clear ();
drcol.Add ("NewRelation", parentCol, childCol);
Assert.That (drcol [0].RelationName, Is.EqualTo ("NewRelation"), "test#3");
drcol.Clear ();
drcol.Add ("NewRelation", parentCol, childCol, false);
Assert.That (drcol.Count, Is.EqualTo (1), "test#4");
drcol.Clear ();
drcol.Add ("NewRelation", parentCol, childCol, true);
Assert.That (drcol.Count, Is.EqualTo (1), "test#5");
drcol.Clear ();
}
示例15: run
//Activate This Construntor to log All To Standard output
//public TestClass():base(true){}
//Activate this constructor to log Failures to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, false){}
//Activate this constructor to log All to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, true){}
//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES
public void run()
{
Exception exp = null;
DataTable dt1 = GHTUtils.DataProvider.CreateParentDataTable();
DataTable dt2 = GHTUtils.DataProvider.CreateChildDataTable();
dt1.PrimaryKey = new DataColumn[] {dt1.Columns[0]};
dt2.PrimaryKey = new DataColumn[] {dt2.Columns[0],dt2.Columns[1]};
DataRelation rel = new DataRelation("Rel",dt1.Columns["ParentId"],dt2.Columns["ParentId"]);
DataSet ds = new DataSet();
ds.Tables.AddRange(new DataTable[] {dt1,dt2});
ds.Relations.Add(rel);
ds.Reset();
try
{
BeginCase("Reset - Relations");
Compare(ds.Relations.Count ,0 );
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
try
{
BeginCase("Reset - Tables");
Compare(ds.Tables.Count ,0 );
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
}