Comments by Sanman Marathe (Top 13 by date)

Hi Sir,

I ran the Split function
And the updated query, it still says sunstring returned more than 1 value..

IF i substring as top 1, output comes... but i need all the records..

M googling issue meanwhile ..

Any ideas more sir??

--Sanman

Hi,

I actually worte this query below.. I also got error saying substring returned more than 1 value..



declare @parameter int

set @parameter = (Select MedicalCenters from PreClaimRequestor where ClientID = '1300')

select stuff ((select ',' +cast( KaiserClientName as nvarchar(max)) From Kaiserclient where KaiserClientID in(@parameter) for xml path ('')),1,1,'')

Hi,Thanks man for the stuff funtion..!!It really works..

But now i have multiple records in the db like we have passed the parameters (1,2,3).

I have multiple rows with values like (1,2,3) next is (22,34,15) and (45,33,21) and so on..!!

How can i pass those in the above query,,

M aslo getting error "Conversion failed when converting the varchar value ' 10, 4' to data type int." i think which means it is expecting only 1 set of parameter values seprated by comma, but i am passing the values with multiple rows...

How can i pass those in the above query,,Plz help..!!

Where is visual studio on the servers.. c'mon man..!!

Please let me know any iis settings or anything when i need to display app_offline while code deploment on servers..

hey...
use this simple code..

<asp:HiddenField ID="hdn" runat="server" Value='<%# Eval("FullName")%>' /> <asp:CheckBox ID="chk" runat="server"/>

And in ur code behind use hdn.value wherever u need to use the checkbox value...

lucky for me i answered all remaining one's and cleared the round. Having my next round in the coming week... !!

Actually they asked me this question at my Microsoft interview.. i couldn't answer it... i didn't even expect such questions...

Hi Edo,

Actually i tried itextsharp also. It is working,, but not for my scenario..

I tried with FileStream outStream = new FileStream(targetFilename, FileMode.Create)

even with FileMode.Append,FileAccess.Write

But all it does is it removes the previously written data in pdf and writes this new image only.

Actually i needed to add an image at bottom of pdf and also pertain the old data already present in pdf..


but i'll try the above code which u gave as it is again.....


Thanks!!


I had tried this code...

private void AppendPDFFile()
{
Document doc = new Document();
try
{
string pdfFilePath = Server.MapPath(".") + "/pdf/MynewPDF.pdf";

//Create Document class object and set its size to letter and give space left, right, Top, Bottom Margin
PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(pdfFilePath, FileMode.Append,FileAccess.Write));
doc.Open();//Open Document to write

// Now image in the pdf file
// iTextSharp.text.Image ppp = iTextSharp.text.Image.GetInstance(pdfFilePath);
string imageFilePath = Server.MapPath(".") + "/image/Desert.jpg";
iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(imageFilePath);


//Resize image depend upon your need
jpg.ScaleToFit(100f, 80f);

//Give space before image
// jpg.SpacingBefore = 10f;

//Give some space after the image
// jpg.SpacingAfter = 1f;
//jpg.Alignment = Element.ALIGN_BOTTOM;


doc.Add(jpg); //add an image to the created pdf document

}
catch (DocumentException docEx)
{
//handle pdf document exception if any
}
catch (IOException ioEx)
{
// handle IO exception
}
catch (Exception ex)
{
// ahndle other exception if occurs
}
finally
{
//Close document and writer
doc.Close();

}
}