موارد اضافه رو حذف کردم.ممنون از شما.
اینم اسکریپتش :
private void taraz()
{
DataTable DT = new DataTable();
SqlDataAdapter DAL1 = new SqlDataAdapter("SELECT tblregnewmoshtari.shhesab, tblregnewmoshtari.name,tblregnewmoshtari.family as namefamily, tblregnewmoshtari.codemelli, Sum(tblvarizbardasht.variz)-Sum(tblvarizbardasht.bardasht) AS Mandeh FROM tblvarizbardasht INNER JOIN tblregnewmoshtari ON tblvarizbardasht.shhesab = tblregnewmoshtari.shhesab GROUP BY tblregnewmoshtari.shhesab, tblregnewmoshtari.name+ ' '+ tblregnewmoshtari.family, tblregnewmoshtari.name, tblregnewmoshtari.family, tblregnewmoshtari.codemelli", scn);
DAL1.Fill(DT);
dataGridViewX1.DataSource = DT;
DataTable DT2 = new DataTable();
SqlDataAdapter DAL2 = new SqlDataAdapter("SELECT Sum(tblaghsat.mablaghghest)-Sum(tblaghsat.variz) AS MandehVam FROM tblaghsat GROUP BY tblaghsat.shhesab", scn);
DAL2.Fill(DT2);
dataGridViewX2.DataSource = DT2;
}
پاسخ با نقل قول
