vijaymckvn.blogspot.com
Share ur Knowledge with others: Export SQl Data into PDF with image
http://vijaymckvn.blogspot.com/2011/10/export-sql-data-into-pdf-with-image.html
Tuesday, October 11, 2011. Export SQl Data into PDF with image. Add Reference the ItextSharp.dll file for creating PDF File. Using System.Collections.Generic;. Using System.Web;. Using System.Web.UI;. Using System.Web.UI.WebControls;. Using System.IO;. Using iTextSharp.text;. Using iTextSharp.text.pdf;. Using iTextSharp.text.pdf.events;. Using System.Data;. Using System.Data.SqlClient;. Using System.Collections;. Using System.Web.UI.HtmlControls;. Using System.Web.Security;. DataSet ds = new DataSet();.
footprintsoflife.blogspot.com
Footprints in the journey of Life: March 2010
http://footprintsoflife.blogspot.com/2010_03_01_archive.html
Footprints in the journey of Life. Monday, March 29, 2010. Itz all about enjoying the Journey. So, moral of the story: No matter what the results may be tmr, just gotta take it as part of the wole learning journey ;) Haha. Wednesday, March 10, 2010. I dont know why I am letting this affect me so much but for some reason it has. Just read my friend's blog yesterday where he was talking abt how healthcare is not and should not be seen as a service industry where people come in and demand things to be done&...
footprintsoflife.blogspot.com
Footprints in the journey of Life: August 2009
http://footprintsoflife.blogspot.com/2009_08_01_archive.html
Footprints in the journey of Life. Sunday, August 16, 2009. As much as I complain about how busy work gets at times, I guess it is therapeutic in a certain sense as well. It helps to keep my mind off the other things going on. Sometimes, I'd rather think about how to handle a demanding Mr XX's grandson's uncle and a Mdm XY's problems cropping up one after another than to think about my own! Subscribe to: Posts (Atom). As much as I complain about how busy work gets at . View my complete profile.
vijaymckvn.blogspot.com
Share ur Knowledge with others: Export SQl Data Table into Excel,CSV with image Header
http://vijaymckvn.blogspot.com/2011/10/export-sql-data-table-into-excelcsv.html
Tuesday, October 11, 2011. Export SQl Data Table into Excel,CSV with image Header. System.Web.UI;. System.Web.UI.WebControls;. System.Web.UI.WebControls.WebParts;. System.Web.UI.HtmlControls;. System.Data.SqlClient;. System.Data.OleDb;. System.Windows.Forms;. System.Web.UI. Page. Data Source=servername;Initial Catalog=Databasename;Integrated Security=True". Column count = 65;. Insert Data into Excel - - - - - - - - - - - - -*/. Sql cmd = new. Select * from table name". Dr = sql cmd.ExecuteReader();.
vijaymckvn.blogspot.com
Share ur Knowledge with others: October 2011
http://vijaymckvn.blogspot.com/2011_10_01_archive.html
Tuesday, October 11, 2011. Export SQl Data into PDF with image. Add Reference the ItextSharp.dll file for creating PDF File. Using System.Collections.Generic;. Using System.Web;. Using System.Web.UI;. Using System.Web.UI.WebControls;. Using System.IO;. Using iTextSharp.text;. Using iTextSharp.text.pdf;. Using iTextSharp.text.pdf.events;. Using System.Data;. Using System.Data.SqlClient;. Using System.Collections;. Using System.Web.UI.HtmlControls;. Using System.Web.Security;. DataSet ds = new DataSet();.
vijaymckvn.blogspot.com
Share ur Knowledge with others: Query for selecting first 3 rows from the table
http://vijaymckvn.blogspot.com/2011/07/query-for-selecting-first-3-rows-from.html
Tuesday, July 5, 2011. Query for selecting first 3 rows from the table. Select * from excel. The above query retrieve and show first 3 rows of records from the table,The set rowcount=0 stop the process suddenly and help to show only 3 rows. THERE ARE TWO WAYS OF MEETING DIFFICULITIES: U ALTER THE DIFFICULTIES, OR U ALTER URSELF TO MEET THEM. Subscribe to: Post Comments (Atom). Followers Of this Blog. Enter your email address:. Query for selecting first 3 rows from the table. Thiruppathur, Tamilnadu, India.
vijaymckvn.blogspot.com
Share ur Knowledge with others
http://vijaymckvn.blogspot.com/2011/10/add-image-in-excel-sheet-using-c-excel.html
Wednesday, October 5, 2011. Add image in Excel sheet using c#. ExcelWorkbook Excel Book;. ExcelWorksheet Excel sheet;. Object mis value = System.Reflection.Missing.Value;. App=new Excel.ApplicationClass();. Excel Book = app.Workbooks.Add(mis value);. Excel sheet = (Excel.Worksheet)Excel Book.Worksheets.get Item(1);. Excel Book.Close(true, mis value , mis value );. THERE ARE TWO WAYS OF MEETING DIFFICULITIES: U ALTER THE DIFFICULTIES, OR U ALTER URSELF TO MEET THEM. Subscribe to: Post Comments (Atom).
vijaymckvn.blogspot.com
Share ur Knowledge with others: November 2010
http://vijaymckvn.blogspot.com/2010_11_01_archive.html
Wednesday, November 24, 2010. Code for creating sql server table as a xml file. DataTable data table = new DataTable();. DataSet ds = new DataSet();. SqlDataAdapter da = new SqlDataAdapter("select * from test table", connection);. DsWriteXml(@"c: output2.xml", XmlWriteMode.IgnoreSchema);. Read XML file data. XmlTextReader xml reader = new XmlTextReader(@"c: output1.xml");. XmlDocument xml doc = new XmlDocument();. Xml doc.Load(xml reader);. XmlNode select node = xml doc.SelectSingleNode("NewDataSet");.
vijaymckvn.blogspot.com
Share ur Knowledge with others: September 2010
http://vijaymckvn.blogspot.com/2010_09_01_archive.html
Thursday, September 30, 2010. Copying text file values as a database column values. Create a table name as login. BULK INSERT login FROM 'c: test sql.txt' WITH. FIELDTERMINATOR = ',',- Data format in text file is username,password in a row.it is used to trminate the symbol comma and assume as a 2 column values. ROWTERMINATOR = ' n' ) - for next line. THERE ARE TWO WAYS OF MEETING DIFFICULITIES: U ALTER THE DIFFICULTIES, OR U ALTER URSELF TO MEET THEM. Wednesday, September 22, 2010. Declare @no of days int.
vijaymckvn.blogspot.com
Share ur Knowledge with others: July 2011
http://vijaymckvn.blogspot.com/2011_07_01_archive.html
Tuesday, July 5, 2011. Query for selecting first 3 rows from the table. Select * from excel. The above query retrieve and show first 3 rows of records from the table,The set rowcount=0 stop the process suddenly and help to show only 3 rows. THERE ARE TWO WAYS OF MEETING DIFFICULITIES: U ALTER THE DIFFICULTIES, OR U ALTER URSELF TO MEET THEM. Subscribe to: Posts (Atom). Followers Of this Blog. Enter your email address:. Query for selecting first 3 rows from the table. Thiruppathur, Tamilnadu, India.