Comments by sonu Ranjan (Top 9 by date)

sir OriginalGriff.
PrintDocument pd = new PrintDocument();
pd.DefaultPageSettings.PaperSize = pd.PrinterSettings.PaperSizes(myWidth, myHeight);

in this code PaperSize is properties and we have not use Like Method.

i want to know how to print Envelope in any paper size when user have decided to the Height and width of Envelope..

I am try to customize the Envelope size . where user set the value of envelope size or width...using this code
f (Convert.ToString(cmbEnvlopeSize.SelectedItem) == "Custome Size")
{
PrintDialog objDialog = new PrintDialog();
objDialog.ShowDialog();
}

PrintPreview objPreview = new EnvelopeSoftware.PrintPreview();
PagePreview objCrystalPreview = new EnvelopeSoftware.PagePreview();

DataTable dtEnvelope = _GetData.GetDataTable("Select * from EnvlopeSize Where SizeName='" + cmbEnvlopeSize.SelectedItem + "'");



if (Convert.ToString(cmbEnvlopeSize.SelectedItem) != "Custome Size")
{
// Not For custom paper
FontStyle objFontStyle = FontStyle.Regular;
if (Convert.ToBoolean(dtEnvelope.Rows[0]["Bold"]))
{
objFontStyle = FontStyle.Bold;
}
if (Convert.ToBoolean(dtEnvelope.Rows[0]["Italic"]))
{
objFontStyle = FontStyle.Italic;
}
if (Convert.ToBoolean(dtEnvelope.Rows[0]["UnderLine"]))
{
objFontStyle = FontStyle.Underline;
}

int SenderLeft = Convert.ToInt16(dtEnvelope.Rows[0]["SenLmargin"]), SenderTop = Convert.ToInt16(dtEnvelope.Rows[0]["SenTmargin"]), ReceiverLeft = Convert.ToInt16(dtEnvelope.Rows[0]["RecLmargin"]), ReceiverTop = Convert.ToInt16(dtEnvelope.Rows[0]["RecRmargin"]), pictureLeft = Convert.ToInt16(dtEnvelope.Rows[0]["LogoLeft"]), pictureTop = Convert.ToInt16(dtEnvelope.Rows[0]["LogoRight"]), MsgTop = Convert.ToInt16(dtEnvelope.Rows[0]["MsgTop"]), MsgLeft = Convert.ToInt16(dtEnvelope.Rows[0]["MsgLeft"]);
float SenderFontSize = float.Parse(Convert.ToString(dtEnvelope.Rows[0]["SenFontSize"])), receiverFontSize = float.Parse(Convert.ToString(dtEnvelope.Rows[0]["RecFontSize"])), paperWidth = 0, paperHeight = 0;
string paperSize = Convert.ToString(dtEnvelope.Rows[0]["PaperSize"]);
PrintDocument objPaperSize = new PrintDocument();
for (int i = 0; i < objPaperSize.PrinterSettings.PaperSizes.Count; i++)
{
if (objPaperSize.PrinterSettings.PaperSizes[i].PaperName == paperSize)
{
objCrystalPreview.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)objPaperSize.PrinterSettings.PaperSizes[i].RawKind;
break;
}
}
ReportObject objSender = objCrystalPreview.Section3.ReportObjects["SName1"] as ReportObject;
ReportObject objReceiver = objCrystalPreview.Section3.ReportObjects["RName1"] as ReportObject;
ReportObject objPicture = objCrystalPreview.Section3.ReportObjects["Picture1"] as ReportObject;
ReportObject objMsg = objCrystalPreview.Section3.ReportObjects["Message1"] as ReportObject;

FieldObject sFont = objCrystalPreview.Section3.ReportObjects["SName1"] as FieldObject;
FieldObject rFont = objCrystalPreview.Section3.ReportObjects["RName1"] as FieldObject;
FieldObject msgFont = objCrystalPreview.Section3.ReportObjects["Message1"] as FieldObject;

Font SenderFont = new Font(Convert.ToString(dtEnvelope.Rows[0]["SenFontStyle"]), SenderFontSize, o

I am using this code...
System.Data.OleDb.OleDbConnection MyConnection;
System.Data.DataSet DtSet;
System.Data.OleDb.OleDbDataAdapter MyCommand;
MyConnection = new System.Data.OleDb.OleDbConnection(@"provider=Microsoft.Jet.OLEDB.4.0;Data Source='"+excelFileName+"';Extended Properties=Excel 8.0;");
MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection);
MyCommand.TableMappings.Add("Table", "Net-informations.com");
DtSet = new System.Data.DataSet();
MyCommand.Fill(DtSet);
dataGridView1.DataSource = DtSet.Tables[0];
MyConnection.Close();

try to import xls file..but code is treble and Given exception....

External table is not in the expected format.

so do you have any idea please share me...How it is possible...