1:45 AM
Run below query and it will show you the dbname and number of connections SELECT DB_NAME(dbid) as DatabaseName, COUNT(dbid) as ...
Run below query and it will show you the dbname and number of connections
SELECT
DB_NAME(dbid) as DatabaseName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP BY
dbid, loginame;
4:00 PM
Avail the best discount coupons for free. ... Check all website coupons/Offers/Discounts code aggregated from a list of diverse sources ...
Avail the best discount coupons for free. ... Check all website coupons/Offers/Discounts code aggregated from a list of diverse sources on the Web. ... compare against all leading online shopping sites....
Type your shopping site name and get all the coupons & offers. Enjoyyyy shoppppiiiinnnngggggg..
2:24 AM
public void ExportToPdf(DataTable myDataTable) { Document pdfDoc = new Document(PageSize.A4, 10, 10, 10, 10); try ...
public void ExportToPdf(DataTable myDataTable)
{
Document pdfDoc = new Document(PageSize.A4, 10, 10, 10, 10);
try
{
PdfWriter.GetInstance(pdfDoc, System.Web.HttpContext.Current.Response.OutputStream);
pdfDoc.Open();
Font font8 = FontFactory.GetFont("ARIAL", 7);
DataTable dt = myDataTable;
DataRow toInsert = dt.NewRow();
if (dt != null)
{
toInsert[0] = "Name";
toInsert[1] = "Vehicle";
toInsert[2] = "Location";
toInsert[3] = "Customer";
toInsert[4] = "Goods";
toInsert[5] = "CreatedDate";
dt.Rows.InsertAt(toInsert, 0);
PdfPTable PdfTable = new PdfPTable(dt.Columns.Count);
PdfPCell PdfPCell = null;
for (int rows = 0; rows < dt.Rows.Count; rows++)
{
for (int column = 0; column < dt.Columns.Count; column++)
{
PdfPCell = new PdfPCell(new Phrase(new Chunk(dt.Rows[rows][column].ToString(), font8)));
PdfTable.AddCell(PdfPCell);
}
}
PdfTable.SpacingBefore = 15f;
pdfDoc.Add(PdfTable);
}
pdfDoc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment; filename= Consignment.pdf");
System.Web.HttpContext.Current.Response.Write(pdfDoc);
Response.Flush();
Response.End();
}
catch (DocumentException de)
{
System.Web.HttpContext.Current.Response.Write(de.Message);
}
catch (IOException ioEx)
{
System.Web.HttpContext.Current.Response.Write(ioEx.Message);
}
catch (Exception ex)
{
System.Web.HttpContext.Current.Response.Write(ex.Message);
}
}