Comments by mrprakash

mrprakash 14-Jul-16 1:35am View

sorry its my mistake.

mrprakash 5-Jul-16 9:54am View

but i need MM/dd/yyyy this format but by default this (Thu Jun 09 2011 00:00:00 GMT+0530 (India Standard Time)) format show i dont need this format

mrprakash 23-Jun-16 10:32am View

spouse i have 163 data and i have binding data in table row and each row 3 colunm show i bind 10 rows each page then now in last condition how to print 1 or 2 data

mrprakash 17-Jun-16 2:32am View

it is some format issue? i m putting all 163 data in stringbuilder but when i convert in only 162 records show if i have fatching even no of records like 132 then all records show but when i passing 133 then last data not show in pdf but i have all 133 data in stringbuilder all data save in html format to check is any thing missing but not a singal records missed here is issue if pdf convertion is right can you re-check it? please its urgert. and thanks your suggestion.

mrprakash 28-Aug-15 8:10am View

i checked it but its not a issue table are not empty there

mrprakash 29-Jul-15 3:36am View

ok thnks give some valuable time

mrprakash 29-Jul-15 3:29am View

i added space but main problem here
ItemPart=''Hose Pipe ¾” (Green Line) (3224-1856)''

mrprakash 29-Jul-15 3:08am View

solve its, its urgent

mrprakash 29-Jul-15 3:07am View

DECLARE @sqlCommand varchar(max)
SET @sqlCommand ='
select DISTINCT * from
(SELECT StockLedger.SledId, StockLedger.SledCode, StockLedger.StockDetId, StockLedger.SLedType, StockLedger.SLedQty, StockLedger.SLedInOut,
StockLedger.SLedPrice, StockLedger.SLedDate, StockLedger.SLedRefNo, StockLedger.BranchId, StockLedger.CustId, StockMaster.StockId,
StockMaster.StockParent, StockMaster.StockName, StockMaster.StockAlias, StockMaster.StockUnit, StockMaster.StockType, StockMaster.Branch,
StockMaster.StockComp, StockMaster.StockName + ''(''+ CASE WHEN dbo.StockDetails.PartNo IS NOT NULL
THEN dbo.StockDetails.PartNo END + '')'' AS ItemPart, CASE WHEN sledinout = ''1'' AND sledtype <> ''OPN'' THEN sledqty ELSE ''0'' END AS QtyIn,
CASE WHEN sledinout = ''0'' AND sledtype <> ''OPN'' THEN sledqty ELSE ''0'' END AS QtyOut, StockDetails.PartNo, ''0'' AS [OPEN], ''0'' AS PositiveOpeningQtyIn,
''0'' AS positiveClosingQty, ''0'' AS [CLOSE], AcctMaster.AcctAlias AS PartyName, StockMaster.Active,
StockLedger.BranchId as Branch
FROM StockLedger INNER JOIN
StockMaster ON StockLedger.StockDetId = StockMaster.StockId INNER JOIN
StockDetails ON StockMaster.StockId = StockDetails.StockId LEFT OUTER JOIN
AcctMaster ON StockLedger.CustId = AcctMaster.AcctId
WHERE (StockMaster.Active = ''1'')) as tab1'+
'WHERE Branch=50 AND PartyName=''A B Composites Pvt. Ltd.''
and ItemPart=''Hose Pipe ¾”(Green Line)(3224-1856)'''
execute(@sqlCommand)

Msg 102, Level 15, State 1, Line 15
Incorrect syntax near 'Branch'.

mrprakash 29-Jul-15 2:42am View

data not showing colunm show without data

mrprakash 29-Jul-15 2:32am View

not working

mrprakash 29-Jul-15 2:32am View

not working

mrprakash 29-Jul-15 2:31am View

not working

mrprakash 23-Jul-15 4:57am View

ok then make another way its better

mrprakash 23-Jul-15 4:38am View

can use this query using case statement
(select JobrDate from JobReportMaster left outer JOIN
JnMBJobSp on JobReportMaster.JobrNo=JnMBJobSp.JRNo

and JnMBJobSp.LedNo=sb.QuotationNo
union
select ChlnDate from JobReportMaster_Chln left outer JOIN
JnMBMuSp on JobReportMaster_Chln.ChlnNo=JnMBMuSp.ChalanNo

and JnMBMuSp.LedNo=sb.QuotationNo
)as corjdate how can do it

mrprakash 10-Jun-15 6:08am View

after button click show the data inside div and we are using table and now we click pdf button above code not show data

mrprakash 10-Jun-15 5:59am View

i m not geting data inside div

mrprakash 10-Jun-15 5:15am View

error after using this code

mrprakash 10-Jun-15 5:07am View

pnlPerson.RenderControl(hw);

here pnlperson inner text="" found

mrprakash 27-May-15 4:53am View

sir i hv a prblm to this query

mrprakash 27-May-15 4:53am View

where id='50' and refno='ref1'

mrprakash 27-May-15 2:10am View

Sir,

thanks for solve this issue.

Comments by mrprakash (Top 22 by date)