Click here to Skip to main content
15,904,023 members
Home / Discussions / C#
   

C#

 
GeneralRe: ADO.Net with C# tutorial websites Pin
metinergoktas27-Nov-06 20:50
metinergoktas27-Nov-06 20:50 
AnswerRe: ADO.Net with C# tutorial websites Pin
Rocky#26-Nov-06 22:33
Rocky#26-Nov-06 22:33 
AnswerRe: ADO.Net with C# tutorial websites Pin
Rocky#26-Nov-06 22:39
Rocky#26-Nov-06 22:39 
Questionreading data into a windows form from a xml file Pin
Sonu.T26-Nov-06 18:48
Sonu.T26-Nov-06 18:48 
AnswerRe: reading data into a windows form from a xml file Pin
bankai12326-Nov-06 18:55
bankai12326-Nov-06 18:55 
GeneralRe: reading data into a windows form from a xml file Pin
payback26-Nov-06 19:13
payback26-Nov-06 19:13 
QuestionStatic or instance methods in Data Access Layer Pin
roel_v26-Nov-06 18:35
roel_v26-Nov-06 18:35 
AnswerRe: Static or instance methods in Data Access Layer Pin
Eduard Keilholz26-Nov-06 20:46
Eduard Keilholz26-Nov-06 20:46 
GeneralRe: Static or instance methods in Data Access Layer Pin
roel_v26-Nov-06 20:56
roel_v26-Nov-06 20:56 
QuestionAccessing data from data set Pin
Sarguna Reddiar26-Nov-06 18:23
Sarguna Reddiar26-Nov-06 18:23 
AnswerRe: Accessing data from data set Pin
Shajeel26-Nov-06 20:50
Shajeel26-Nov-06 20:50 
GeneralRe: Accessing data from data set Pin
Sarguna Reddiar26-Nov-06 23:18
Sarguna Reddiar26-Nov-06 23:18 
AnswerRe: Accessing data from data set Pin
Eduard Keilholz26-Nov-06 20:53
Eduard Keilholz26-Nov-06 20:53 
QuestionSearching for a key release event etc in console application Pin
Ghoditsttoawn26-Nov-06 17:23
Ghoditsttoawn26-Nov-06 17:23 
QuestionGetting default PDF viewer Pin
bankai12326-Nov-06 16:44
bankai12326-Nov-06 16:44 
AnswerRe: Getting default PDF viewer Pin
JacquesDP26-Nov-06 19:27
JacquesDP26-Nov-06 19:27 
AnswerRe: Getting default PDF viewer Pin
Weckmann27-Nov-06 4:04
Weckmann27-Nov-06 4:04 
QuestionDataRelation Problem Pin
Deepasubramanian26-Nov-06 16:11
Deepasubramanian26-Nov-06 16:11 
Hi,
I'm getting a datarelation problem.I'm having Parent- Child table relation between the following tables.
Product - Inventory - through ProductCode

Inventory - PackageDetail - through InvRefId
I can be able to save the data.But When I'm displaying in the datalist,I'm getting the following error as follows:

System.ArgumentException - The constraints cannot be enabled as not all values have corresponding parent values.
Here is the code:

StringBuilder stbSQLStatement0 = new StringBuilder();
stbSQLStatement0.Append("SELECT B.[ProductCode] ");
stbSQLStatement0.Append(" ,B.[ProductDesc] ");
stbSQLStatement0.Append(" ,SUM(A.QtyIn) As [In] ");
stbSQLStatement0.Append(" ,SUM(A.QtyOut) As [Out] ");
stbSQLStatement0.Append(" ,SUM(A.QtyIn) - SUM(A.QtyOut) As [BalBillQty] ");
stbSQLStatement0.Append(" ,(SUM(A.QtyIn) - SUM(A.QtyOut)) * Avg(B.ConvFactor) As [BalReportQty] ");

stbSQLStatement0.Append("FROM [MARTblInventory] As A WITH (NOLOCK) ");
stbSQLStatement0.Append(" INNER JOIN [MARTblProduct] As B WITH (NOLOCK) ");
stbSQLStatement0.Append(" ON A.ProductCode = B.ProductCode ");
stbSQLStatement0.Append(" and A.MarketSegID = B.MarketSegmtID ");
stbSQLStatement0.Append(" and A.SourceID = B.SourceID ");


if (! vstrProductCode.Equals(""))
{
stbSQLStatement0.Append("WHERE B.[ProductCode] LIKE '" + vstrProductCode + "%' ");
}

stbSQLStatement0.Append("GROUP BY B.[ProductCode] ");
stbSQLStatement0.Append(" ,B.[ProductDesc] ");


DataSet dtsResult0 = new DataSet();
dtsResult0 = QueryData(stbSQLStatement0.ToString());

StringBuilder stbSQLStatement1 = new StringBuilder();
stbSQLStatement1.Append("SELECT A.InvRefID ");
stbSQLStatement1.Append(" ,A.EntryDate ");
stbSQLStatement1.Append(" ,B.[ProductCode] ");
stbSQLStatement1.Append(" ,B.[ProductDesc] ");
stbSQLStatement1.Append(" ,A.[ReferenceNo] ");
stbSQLStatement1.Append(" ,A.QtyIn As [In] ");
stbSQLStatement1.Append(" ,A.QtyOut As [Out] ");

stbSQLStatement1.Append(" FROM [MARTblInventory] As A WITH (NOLOCK) ");
stbSQLStatement1.Append(" INNER JOIN [MARTblProduct] As B WITH (NOLOCK) ");
stbSQLStatement1.Append(" ON A.ProductCode = B.ProductCode ");
stbSQLStatement0.Append(" and A.MarketSegID = B.MarketSegmtID ");
stbSQLStatement0.Append(" and A.SourceID = B.SourceID ");


if (! vstrProductCode.Equals(""))
{
stbSQLStatement1.Append("WHERE B.[ProductCode] LIKE '" + vstrProductCode + "%' ");
}

DataSet dtsResult1 = new DataSet();
dtsResult1 = QueryData(stbSQLStatement1.ToString());


StringBuilder stbSQLStatement2 = new StringBuilder();
stbSQLStatement2.Append("SELECT A.InvRefID ");
stbSQLStatement2.Append(" ,B.PackageNo ");
stbSQLStatement2.Append(" ,B.Length ");
stbSQLStatement2.Append(" ,B.Area ");
stbSQLStatement2.Append(" ,B.ReferenceNo ");

stbSQLStatement2.Append("FROM [MARTblInventory] As A WITH (NOLOCK) ");
stbSQLStatement2.Append(" INNER JOIN [MARTblInventoryPkgDetail] As B WITH (NOLOCK) ");
stbSQLStatement2.Append(" ON A.InvRefID = B.InvRefID ");

if (! vstrProductCode.Equals(""))
{
stbSQLStatement2.Append("WHERE A.[ProductCode] LIKE '" + vstrProductCode + "%' ");
}

DataSet dtsResult2 = new DataSet();
dtsResult2 = QueryData(stbSQLStatement2.ToString());


DataSet dtsCombine = new DataSet();
dtsCombine.Tables.Add(dtsResult0.Tables[0].Copy());
dtsCombine.Tables[0].TableName = "Product";

if (dtsResult1.Tables[0].Rows.Count > 0)
{
dtsCombine.Tables.Add(dtsResult1.Tables[0].Copy());
dtsCombine.Tables[1].TableName = "ProductDetail";

dtsCombine.Relations.Add("ProductDetail",
dtsCombine.Tables["Product"].Columns["ProductCode"],
dtsCombine.Tables["ProductDetail"].Columns["ProductCode"]);
}


if (dtsResult2.Tables[0].Rows.Count > 0)
{
dtsCombine.Tables.Add(dtsResult2.Tables[0].Copy());
dtsCombine.Tables[2].TableName = "PackageDetail";

dtsCombine.Relations.Add("PackageDetail",
dtsCombine.Tables["ProductDetail"].Columns["InvRefID"],
dtsCombine.Tables["PackageDetail"].Columns["InvRefID"]);
}

ugdDataList.Text = mstrGridName;
ugdDataList.DataSource = dtsCombine;
ugdDataList.DataBind();
// if (txtProductCode.Text != "")
// SeekTheSelectedRowInGrid(txtProductCode.Text);




Can anyone let me know how I can proceed?


Thank you,
Sincerely,
Deepa!

QuestionGet containing class? Pin
Lord Kixdemp26-Nov-06 16:01
Lord Kixdemp26-Nov-06 16:01 
AnswerRe: Get containing class? Pin
Judah Gabriel Himango26-Nov-06 16:27
sponsorJudah Gabriel Himango26-Nov-06 16:27 
GeneralRe: Get containing class? Pin
Lord Kixdemp27-Nov-06 8:05
Lord Kixdemp27-Nov-06 8:05 
GeneralRe: Get containing class? Pin
Lord Kixdemp27-Nov-06 11:03
Lord Kixdemp27-Nov-06 11:03 
Questionhow to open a folder and get its handle? Pin
Shirley, Wang26-Nov-06 15:40
Shirley, Wang26-Nov-06 15:40 
QuestionSpliting short to 2 bytes Pin
Dwayner7926-Nov-06 14:47
Dwayner7926-Nov-06 14:47 
AnswerRe: Spliting short to 2 bytes Pin
Dwayner7926-Nov-06 14:55
Dwayner7926-Nov-06 14:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.