wat nasty replies happen recently in the forum? I guess maybe the codeproject adminstration should give some notice to the member what should write and what whould not in the forum.

can predict by some measurement of course, anyway is already solve already been tested the system.thanks anyway.

so sorry didnt seend b4 this is the first time. just knew it. but wats the big deal? just an extra word anyway. to express some mood.

yes, recently the data i passing not really reach until 100. But u r, u may try go to the datagrid properties change the row length small, normally is 200 so maybe u try 100-50 u can see the row size was squez smaller. so that mean the Height of ur datagrid can contain more row inside. Cause i found out if my height is smaller then the data which suppose to show. Let said My datagrid height just able to show 10 row at one time.Even datagrid able for u to click scroll down to next row but it will have problem when passing to EXCEL. so i just drag the height higher to able to show all the data out without using the scoll. Hope u understand wat i mean... :)

i learn to put this urgent is because i saw ppl do it. sure i woundnt sit and wait anwser while i doing research and i wait anyone able to find out the solution more faster then me, anyway now this question i got my own solution from myself. so i dont mind they ignore my question or watever, as long as i happy to reless some of my recent problem here , maybe is a kind of way to reless my stress. And i more and more like to put bracket [xxx] anything inside, so is easy for me to know where is my post . FORUM FREEdom anyway ;P

there is no coding error at all i found out ! i solve it by only draging the data grid height longer! oh my..:laugh:

cause is very urgent, but anyway i solve most of it myself. maybe just to express some stress in the forum then

I not sure y everytime i pass the data from DATAGRID to EXCEL above more then 10 row then the datagrid pointer will skip after row 10 until the end. So my excel will look like this let said u use number as the data value.i showing 1-15 data. 1 2 3 4 5 6 7 8 9 10 15 15 15 15 15 I just found the solution , wat a crazy solution i never expect. I just drag the datagrid height longer then solve the problem .HAH!;P -- modified at 21:16 Thursday 7th December, 2006

i was EXport some data form my vb6 to EXCEL. But when i close my program i found out that the EXCEL.exe is still running... wat is the command to terminate the EXCEL.exe when i close my program????

anyone know how to pass some information from datagrid to EXCEL?? which from the row 1 of the datagrid to the last row.

wat do i need to type after DataGrid1.DataBind() = ??????

i havet already check the connection string ans test the connection , is ok .

I have this error when i run my program "connection timeout expired" i was using ADODC to retrieve data from MYSQL on at SP and show it on my DATAgird. wat happen? even i set the adodc on longer the connection timeout. but problem still exsist... will it because the network bandwidth slow so SQL cannot finish retrieve those data ? My datagrid have those column fill name but no data inside when the error msg pop up . -- modified at 2:25 Wednesday 8th November, 2006

There is an error when i run my script.... wat it mean??? will be becasue my command too complicated of computer hardware problem?? actually it work at first b4 i add the COST column after add it then error comes out....Those SQL i underline which is the code i added. SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. Connection Broken SELECT Query1.bizdate, TSuper,TSoft, THard, (TSoft+ THard+ TSuper) as TOTAL , ((TSoft+ THard+ TSuper)-(TsCost+ThCost+TsuCost))as GP FROM (SELECT bizdate, SUM(totalsales+returnamt) AS TSoft ,sum(totalcost+returncost)as TsCost FROM tot_item WHERE deptcode IN (11, 12, 13, 14, 15, 16, 17) GROUP BY bizdate) AS Query1 LEFT JOIN (SELECT bizdate, SUM(totalsales+returnamt) AS THard ,sum(totalcost+returncost)as ThCost FROM tot_item WHERE deptcode IN (21, 22, 23, 24, 25, 26, 27, 28, 29) GROUP BY bizdate) AS Query2 ON Query1.bizdate = Query2.bizdate LEFT JOIN (SELECT bizdate, sum(totalsales+returnamt) AS TSuper ,sum(totalcost+returncost)as TsuCost FROM tot_item WHERE deptcode IN (30, 40, 50, 60, 70, 80, 90) GROUP BY bizdate) AS Query3 ON Query1.bizdate = Query3.bizdate where query1.bizdate>= '2006-10-01' and query1.bizdate<= '2006-10-15' order by query1.bizdate

I have create a SQL there r some calculation involve, but i got this error:Divide by zero error encountered. But there is some which work when i select some others DATE but with some other date which no result came out becasue "Divide by zero error encountered." how can i make the SQL will just continue show those value out even is 0.01... something?? select bizdate,concesscode,con. [description],totaltrans,totalqty,totalwgt,totalsales,taxper, (totalsales*taxper/100) as TaxAmt,baseamt,level3per as APPLY , (level3per*(totalsales-Taxper/100))as LeaseAmt,(totalsales-baseamt- (totalsales*taxper/100)-(level3per*(totalsales-taxper/100)))as AmountDue ,discountamt, returnamt,(totalsales-totalcost)*100/totalsales as GP from tot_item ti, concess con where con.code=ti.concesscode and ti.bizdate='2006-04-11' and concesscode>='A' and concesscode<='D'

dc suppose to be column...?? For dc = 0 To (DataGrid1.Columns.Count - 1)

the connection is ok

at first the DR which mean the row~ since i'm showing the data in the datagrid first, then pass to EXCEL. DC which is the column , which there is 5 column. when goes to row 1, then pass the datagrid column data to excel, after passing the row 1 column data, then next dr which is ROW 2.

the code which i have underline it. I know y there is an error because when i read there is no more information cause it have skip to the last line which i did not ask it to do so... so i not sure happen with the system.... when i run the system i check one by one... example, suppose it will pass 14 row with 5 column information each of it. when it goes to row 12, then the first 2 colum data which is not the correct one the vb itself have skip to row 13-14 and get the value. after that sure it will have error becasue when it try to read the row 13, but the arrow have been point to the last 14 row b4 when it put the value to row 12, so the next data will be 15 which is an empty one.

no code all in properties. DATAGRID properties i set: DATAsource: dataenvoriment1 datamember: command1 when i try to retrieve, yes the column title data show out. when i try to run it suppose the datagrid will show some data but it's blank. About my SQL is correct cause b4 that i use ADODC1 to link to datagrid and show the data show correctly. but when i try to use dataenviroment it not showing data out.