Windows Forms

Rahul Say hiiiii wrote:

Can u give me a names of thoird party control

public void DoBackgroundWork(string stringParameter, int intParameter)
{
    bgWorker = new BackgroundWorker();
    bgWorker.WorkerReportsProgress = false;
    bgWorker.WorkerSupportsCancellation = false;
    bgWorker.DoWork += new DoWorkEventHandler(DoWorkAsync);
    bgWorker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(DoWorkAsyncCompleted);
    bgWorker.RunWorkerAsync(new object[] { stringParameter, intParameter }); <--- pass parameters here
}

public void DoWorkAsync(object sender, DoWorkEventArgs e)
{
    object[] parameters = (object[])e.Argument; <--- unpack the parameters here
    string stringParameter = (string)parameters[0];
    int intParameter = (int)parameters[1];
    <... do work tasks here ...>
    bool boolResultValue = ...; <--- prepare result values for WorkCompleted handler
    string stringResultValue = ...;
    object[] results = new object[2];
    results[0] = boolResultValue;
    results[1] = stringResultValue
    e.Result = results; <--- pass result data to WorkCompleted handler
}

public void DoWorkAsyncCompleted(object sender, RunWorkerCompletedEventArgs e)
{
    object[] results = (object[])e.Result; <--- unpack the result data here
    bool boolResultValue = (bool)results[0];
    string stringResultValue = (string)results[1];
    <... do result tasks here ...>
}

Uma Kameswari wrote:

can some one let me know the points to be taken care when working with huge volumes of data

Uma Kameswari wrote:

Each of them has 30+lakhs of records

Mika Wendelius wrote:

I don't know what 30+lakhs means.

Luc Pattyn [Forum Guidelines] [My Articles]

---

Fixturized forever.

---

Luc Pattyn wrote:

30+lakhs is more than 3 million

Luc Pattyn wrote:

that is a lot of rows...

Uma Kameswari wrote:

a stored procedure that uses cursor

"select rm1.docnumbr DOCNUMBR,rm1.custnmbr CUSTNMBR,rm1.trxsorce TRXSORCE,rm2.docdate DOCDATE,rm2.postdate POSTDATE,rm2.glpostdt GLPOSTDT,PSTUSRID,ORTRXAMT,rm2.DEX_ROW_ID H_DEX_ROW_ID,rm1.DEX_ROW_ID D_DEX_ROW_ID, rm1.dstindx,rm1.debitamt,rm1.crdtamnt,(select rtrim(actnumbr_1) + '-'+rtrim(actnumbr_2) + '-'+rtrim(actnumbr_3) + '-' + rtrim(actnumbr_4) + '-' + rtrim(actnumbr_5) + '-' + rtrim(actnumbr_6) + '-' + rtrim(actnumbr_7) from gl00100 where actindx = rm1.dstindx) 'Account',seqnumbr  from rm10101 rm1,rm20101 rm2  where rm2.docdate between convert(datetime,'" + dtFrom.ToShortDateString() + "',103) and convert(datetime,'" + dtTo.ToShortDateString() + "',103 and rm1.docnumbr = rm2.docnumbr and rm1.custnmbr = rm2.custnmbr and rm1.rmdtypal = rm2.rmdtypal  and rm1.dstindx in(" + strAcc + ")"

DataTable DT = new DataTable();
               DT = ds.Tables["SRC"];

               #region bulkcopy
               string strDB = conn.Database.ToString();
               SqlBulkCopy bk = new SqlBulkCopy(conn);
               bk.DestinationTableName = strDB + ".dbo.gl_sl_cmpr";
               bk.WriteToServer(DT);

for (int i = 0; i < ds.Tables["InGL"].Rows.Count; i++)
                  {
                      iJrnEntry = Convert.ToInt32(ds.Tables["InGL"].Rows[i]["JRNENTRY"]);
                      dtTrxDate = Convert.ToDateTime(ds.Tables["InGL"].Rows[i]["trxdate"]);
                      strTrxSorce = ds.Tables["InGL"].Rows[i]["trxsorce"].ToString();
                      strActIndex = ds.Tables["InGL"].Rows[i]["account"].ToString();
                      strGLUser = ds.Tables["InGL"].Rows[i]["USWHPSTD"].ToString();
                      strOrgnTrxSorce = ds.Tables["InGL"].Rows[i]["orgntsrc"].ToString();
                      strOrgnDocNo = ds.Tables["InGL"].Rows[i]["orctrnum"].ToString();
                      strOrTrxSrc = ds.Tables["InGL"].Rows[i]["ortrxsrc"].ToString();
                      dclGLDr = Convert.ToDecimal(ds.Tables["InGL"].Rows[i]["debitamt"]);
                      dclGLCr = Convert.ToDecimal(ds.Tables["InGL"].Rows[i]["crdtamnt"]);
                      dexrowid = Convert.ToInt32(ds.Tables["InGL"].Rows[i]["Dex_row_id"]);
                      iGLACT = Convert.ToInt32(ds.Tables["InGL"].Rows[i]["actindx"]);
                      iGlSeqNo = Convert.ToInt32(ds.Tables["InGL"].Rows[i]["origseqnum"]);
                      strOrgnDocNo = strOrgnDocNo.Replace("'", "''");
                      strSource = strOrgnTrxSorce.Trim();
                      if (strOrgnTrxSorce.Trim() == "")
                          strSource = strOrTrxSrc;
                      if(iGlSeqNo !=0)
                          cmd.CommandText = "update gl_sl_cmpr set JRNENTRY= " + iJrnEntry + ",GLTRXDATE=COnvert(datetime,'" + dtTrxDate.ToShortDateString() + "',103),SOURCE='" + strTrxSorce + "',GLACTINDEX='" + strActIndex + "',USWHPSTD='" + strGLUser + "',ORTRXSRC='" + strOrgnTrxSorce + "',ORGCTRNUM='" + strOrgnDocNo + "',GLDR=" + dclGLDr + ",GLCR =" + dclGLCr + ",gldexrowid=" + dexrowid + " ,glact = " + iGLACT + ", status = 1 where sopno='" + strOrgnDocNo + "' and actindex ='" + strActIndex + "' and trxsorce='" + strSource + "' and seqnumbr=" + iGlSeqNo;
                      else
                          cmd.CommandText = "update gl_sl_cmpr set JRNENTRY= " + iJrnEntry + ",GLTRXDATE=COnvert(datetime,'" + dtTrxDate.ToShortDateString() + "',103),SOURCE='" + strTrxSorce + "',GLACTINDEX='" + strActIndex + "',USWHPSTD='" + strGLUser + "',ORTRXSRC='" + strOrgnTrxSorce + "',ORGCTRNUM='" + strOrgnDocNo + "',GLDR=" + dclGLDr + ",GLCR =" + dclGLCr + ",gldexrowid=" + dexrowid + " ,glact = " + iGLACT + ", status = 1 where sopno='" + strOrgnDocNo + "' and actindex ='" + strActIndex + "' and trxsorce='" + strSource + "'";// and seqnumbr=" + iGlSeqNo;
                      //if (iJrnEntry == 747927)
                      //    MessageBox.Show(strSource + " " + cmd.CommandText);
                      int cnt = cmd.ExecuteNonQuery();
                      if (cnt == 0)
                      {
                          cmd.CommandText = " insert into gl_sl_cmpr(jrnentry,gltrxdate,SOURCE,GLACTINDEX,USWHPSTD,ORTRXSRC,ORGCTRNUM,GLDR,GLCR,gldexrowid,glact,status) values (" + iJrnEntry + ",COnvert(datetime,'" + dtTrxDate.ToShortDateString() + "',103),'" + strTrxSorce + "','" + strActIndex + "','" + strGLUser + "','" + strOrgnTrxSorce + "','" + strOrgnDocNo + "'," + dclGLDr + "," + dclGLCr + "," + dexrowid + "," + iGLACT + ",2)";
                          cmd.ExecuteNonQuery();
                      }
                      iCount++;
                  }

CREATE PROCEDURE [dbo].[spSetStatus]  --@strAcc nvarchar(1000)
AS
BEGIN
	declare @SopNo nvarchar(31)
    declare @SLAct int
    Declare @trxsorce nvarchar(31)
    declare @OnAccount decimal
    declare @SLDr decimal
    declare @SLCr decimal
    declare @GLDr decimal
    declare @GLCr decimal
    declare @jrnEntry int
	declare @SLDrSum decimal
	declare @SLCrSum decimal
	declare @GLDrSum decimal
	declare @GLCrSum decimal
	declare @Status int
declare cur_status_update cursor for  select sopno,act,trxsorce,onaccount,SLDr,SLCr,GLDr,GLCr,jrnentry from gl_sl_cmpr where status not in (2,4) 
open cur_status_update
fetch next from cur_status_update into 
@SopNo,@SLAct,@trxsorce,@OnAccount,@SLDr,@SLCr,@GLDr,@GLCr,@jrnentry
while @@fetch_status = 0
begin
    Set @Status = 1
	select @SLDrSum = sum(SLDr),@SLCrSum = sum(SLCr), @GLDrSum = sum(GLDr), @GLCrSum = sum(GLCr) from gl_sl_cmpr where sopno=@SopNo --and convert(nvarchar,act) in (@strAcc) 
    if (@Onaccount = @SLDrSum or @Onaccount = @SLCrSum )
		Set @Status = 1
    else
        Set @Status = 5
   
	if 	(@SLDrSum = @GLDrSum and @SLCrSum = @GLCrSum )
		Set @Status = 1
    else
        Set @Status = 6
    
	update gl_sl_cmpr set status = @Status where sopno = @SopNo  and act = @SLAct and trxsorce = @trxsorce
	fetch next  from cur_status_update into
	@SopNo,@SLAct,@trxsorce,@OnAccount,@SLDr,@SLCr,@GLDr,@GLCr,@jrnentry
end
close cur_status_update
deallocate cur_status_update
END

update gl_sl_cmpr 
set status = 1
WHERE status not in (2,4) 
AND   (  OnAccount = (SELECT sum(SLDr) FROM from gl_sl_cmpr sub1 where sub1.sopno = gl_sl_cmpr.sopno)
      OR OnAccount = (SELECT sum(SLCr) FROM from gl_sl_cmpr sub1 where sub1.sopno = gl_sl_cmpr.sopno))
      OR (   (SELECT sum(SLDr) FROM gl_sl_cmpr sub1 where sub1.sopno = gl_sl_cmpr.sopno) 
         =   (SELECT sum(GLDr) FROM gl_sl_cmpr sub2 where sub2.sopno = gl_sl_cmpr.sopno)
         AND (SELECT sum(SLCr) FROM gl_sl_cmpr sub3 where sub3.sopno = gl_sl_cmpr.sopno) 
         =   (SELECT sum(GLCr) FROM gl_sl_cmpr sub4 where sub4.sopno = gl_sl_cmpr.sopno)))
--
update gl_sl_cmpr 
set status = 6
WHERE status not in (2,4) 
AND   (   OnAccount != (SELECT sum(SLDr) FROM from gl_sl_cmpr sub1 where sub1.sopno = gl_sl_cmpr.sopno)
      AND OnAccount != (SELECT sum(SLCr) FROM from gl_sl_cmpr sub1 where sub1.sopno = gl_sl_cmpr.sopno))
      AND (  (SELECT sum(SLDr) FROM gl_sl_cmpr sub1 where sub1.sopno = gl_sl_cmpr.sopno) 
         !=  (SELECT sum(GLDr) FROM gl_sl_cmpr sub2 where sub2.sopno = gl_sl_cmpr.sopno)
         OR  (SELECT sum(SLCr) FROM gl_sl_cmpr sub3 where sub3.sopno = gl_sl_cmpr.sopno) 
         !=  (SELECT sum(GLCr) FROM gl_sl_cmpr sub4 where sub4.sopno = gl_sl_cmpr.sopno)))