本文介绍了内部联接获得重复价值-需要紧急帮助的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨
我需要紧急帮助
对于我的select语句,我正在使用三个表
1.客户详细信息
2. InvoiceItem
3. InvoiceParent
我得到了重复的值
一条记录显示4次.
请纠正我.
Hi
I need a urgent help
for my select statement i am using three table
1. CustomerDetails
2. InvoiceItem
3. InvoiceParent
I am getting repeated values
one record is displaying for 4 time.
Please correct me.
public void viewInvoiceByCompanyName(string cid, GridView viewingv)
{
try
{
DataSet ds = new DataSet();
string connectionString = ConfigurationManager.ConnectionStrings["InvoiceConnectionString"].ConnectionString;
string selectSql = "Select CustomerDetails.CompName,InvoiceParent.InvDate,InvoiceParent.InvoiceNo,InvoiceParent.CusId,InvoiceParent.PoNo,InvoiceParent.DoNumber,InvoiceParent.PayTerms,InvoiceParent.DueDate,InvoiceParent.ShipDate,InvoiceItem.ItemNo, InvoiceItem.Description,InvoiceItem.Qty,InvoiceItem.UnitPrice,InvoiceItem.TotalAmount,InvoiceItem.SubTotal,InvoiceItem.Gst,InvoiceItem.Total,InvoiceItem.Deposit,InvoiceItem.AmountDue FROM CustomerDetails INNER JOIN InvoiceItem ON CustomerDetails.CusId = InvoiceItem.CusId INNER JOIN InvoiceParent ON CustomerDetails.CusId = InvoiceParent.CusId WHERE InvoiceParent.CusId = @cusId";
SqlConnection conn = new SqlConnection(connectionString);
SqlDataAdapter da = new SqlDataAdapter(selectSql, conn);
da.SelectCommand.Parameters.AddWithValue("@cusId", cid);
da.Fill(ds, "Items");
viewingv.DataSource = ds.Tables["Items"];
viewingv.DataBind();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
感谢
推荐答案
这篇关于内部联接获得重复价值-需要紧急帮助的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!