ASP.NET

export excel to pdf formate in c#

11-Jan-10 1:14

Why would you want to read your HTML tags through code? Are you trying screen scrapping by doing HTML parsing?

In that case you have to identify the starting of an image tag using <img then look for the nearest src tag property and then look for quotes ["]

Is there any other way, yes you have to define a good regular expression to parse for patterns but that would be too much work, but definitely possible and efficient.

Pankaj Saha10-Jan-10 23:43

Pankaj Saha

10-Jan-10 23:43

Hi, I have an asp.net web application. I have an excel sheet and I have to export that excel sheet to a pdf file. I have done it, but still facing some problems.
1. Whenever I do export, its open excel file. I do not want to open the excel file.
2. I have to convert the pdf file to landscape.

Here is the code

private void ExportExcelToPDF()
        {


            string sourceFilePath = Server.MapPath("~/aaa.xlsx");
            string destinationFilePath = Server.MapPath("~/aaa.pdf");

            Microsoft.Office.Interop.Excel.Application myExcelApp;

            Microsoft.Office.Interop.Excel.Workbooks myExcelWorkbooks = null;

            Microsoft.Office.Interop.Excel.Workbook myExcelWorkbook = null;

            try
            {

                object misValue = System.Reflection.Missing.Value;

                myExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();

                myExcelApp.Visible = true;
                object varMissing = Type.Missing;

                myExcelWorkbooks = myExcelApp.Workbooks;


                //if file already exist then delete the file
                if (System.IO.File.Exists(destinationFilePath))
                {
                    System.IO.File.Delete(destinationFilePath);
                }

                myExcelWorkbook = myExcelWorkbooks.Open(sourceFilePath, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue);

                myExcelWorkbook.ExportAsFixedFormat(Microsoft.Office.Interop.Excel.XlFixedFormatType.xlTypePDF,
                    destinationFilePath, Microsoft.Office.Interop.Excel.XlFixedFormatQuality.xlQualityStandard,
                    varMissing, false, varMissing, varMissing, false, varMissing);

                myExcelWorkbooks.Close();

                myExcelApp.Quit();

            }
            catch
            {

            }
            finally
            {
                myExcelApp = null;
            }


        }

Pankaj

Re: export excel to pdf formate in c#

Pankaj Saha11-Jan-10 0:09

Pankaj Saha

11-Jan-10 0:09

Pankaj Saha wrote:
1. Whenever I do export, its open excel file. I do not want to open the excel file.

I got the solution for this. Actually I did not see that little important thing. OMG | :OMG:

myExcelApp.Visible = false;

now excel file is not opening.
Now need the solution for the second problem. Confused | :confused:

Pankaj

help c#

ptvce10-Jan-10 22:57

ptvce

10-Jan-10 22:57

i get the value f my field. it is contain "

"
my code is this form:
drMyRow["reqDesc"] = item["xxx"].ToString();

after that drMyRow["reqDesc"] =

now i want dont show

what do i do

i want show drMyRow["reqDesc"] = hi

modified on Monday, January 11, 2010 5:08 AM

mylogics10-Jan-10 22:22

mylogics

10-Jan-10 22:22

hii am trying to send email using smtp.net.mail namespace.
I have written the appropriate code for it in vb.net bu t am getting following error.
"No connection could be made because the target machine actively refused it (ip address)"
what shud i do....plz guide../

Re: email

Vimalsoft(Pty) Ltd11-Jan-10 2:20

Vimalsoft(Pty) Ltd

11-Jan-10 2:20

can we see the code ?

Re: email

mylogics11-Jan-10 19:35

mylogics

11-Jan-10 19:35

i have written the following code:

Dim message As MailMessage = New MailMessage()
        message.From = New MailAddress("xyz@jmfinfotech.com")
        message.To.Add(New MailAddress("xyz@gmail.com"))
        message.Subject = "Yous Selection:"
        message.Body = "You have selected following options:" + txtselection.Text
        Dim client As SmtpClient = New SmtpClient()
        client.Send(message)

and web config code:

<system.net>
    <mailSettings >
      <smtp>
        <network host="smtp.1and1.com" port="25" userName="xyx" password="123" defaultCredentials="true"/>
      </smtp>
    </mailSettings>
  </system.net>

but getting error:target machine actively refused (ipaddress).tell me what to do plz guide...

Re: email

Vasudevan Deepak Kumar12-Jan-10 4:09

Vasudevan Deepak Kumar

12-Jan-10 4:09

mylogics wrote:
smtp.1and1.com

may not be running or if it is running the port might not be correct. Please check with your Email Administrator/Helpdesk for more assistance.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

Delete record in Gridview

Nopo10-Jan-10 21:46

10-Jan-10 21:46

Hi all,

I have a Gridview that I populate with values from textboxes. These populated values doesn't have any ID. I can edit and update records but I don't know how to delete records. Please advice on how I can achieve this.

P.S: These records are NOT being saved on the database, only on the Gridview.

I'll appreciate any help I can get.

Thanks.

Dinesh Mani10-Jan-10 22:14

10-Jan-10 22:14

What is the datastore that you use to populate the gridview. If you can share the logic that you use for edit then we can avoid reinventing the wheel.

Nopo10-Jan-10 22:36

10-Jan-10 22:36

I'm using dataTable as staorage and then I save it in a Session. Here is the code.

private void DataBindGrid()
{
try
{

string checkflag;

//Create DataTable.
DataTable dt = (DataTable)Session["dtInfoProfile"];

if (dt == null)
{
//Create DataTable.
dt = new DataTable();

//Assign Columns to it.
dt.Columns.Add(new DataColumn("Full Names"));
dt.Columns.Add(new DataColumn("Type"));
dt.Columns.Add(new DataColumn("Identifying Number"));
dt.Columns.Add(new DataColumn("Passport Number"));
}

//Create a DataRow by dt.NewRow().
DataRow dr = dt.NewRow();

if (rdbIndividual.Checked)
{
//Fill that row and add it to datatable.
checkflag = rdbIndividual.Text;
dr["Full Names"] = IndividualDetailsControl.FirstName + " " + IndividualDetailsControl.LastName;
dr["Type"] = checkflag;
dr["Identifying Number"] = IndividualDetailsControl.IdentityNo;
dr["Passport Number"] = IndividualDetailsControl.PassportNo;
dt.Rows.Add(dr);
}
else if (rdbTrust.Checked)
{
checkflag = rdbTrust.Text;
//Fill that row and add it to datatable.
dr["Full Names"] = EntityDetailsControl.Name;
dr["Type"] = checkflag;
dr["Identifying Number"] = EntityDetailsControl.RegistrationNo;
dt.Rows.Add(dr);
}
else
{
checkflag = rdbEntity.Text;
//Fill that row and add it to datatable.
dr["Full Names"] = EntityDetailsControl.Name;
dr["Type"] = checkflag;
dr["Identifying Number"] = EntityDetailsControl.RegistrationNo;
dt.Rows.Add(dr);

}

Session["dtInfoProfile"] = dt;

//Bind GridView Here with this Table
this.BindData();

//Rename the button
btnAdd.Text = "Add New";

}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}

private void BindData()
{
dgInfoProfile.DataSource = Session["dtInfoProfile"];
dgInfoProfile.DataBind();
}

For Edit and Update:

//Edit
protected void dgInfoProfile_RowEditing(object sender, GridViewEditEventArgs e)
{
//Set the edit index.
dgInfoProfile.EditIndex = e.NewEditIndex;
//Bind data to the GridView control.
this.BindData();
}

//Update
protected void dgInfoProfile_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//Retrieve the table from the session object.
DataTable dt = (DataTable)Session["dtInfoProfile"];

//Update the values.
GridViewRow row = dgInfoProfile.Rows[e.RowIndex];
dt.Rows[row.DataItemIndex]["Full Names"] = ((TextBox)(row.Cells[1].Controls[0])).Text;
dt.Rows[row.DataItemIndex]["Type"] = ((TextBox)(row.Cells[2].Controls[0])).Text;
dt.Rows[row.DataItemIndex]["Identifying Number"] = ((TextBox)(row.Cells[3].Controls[0])).Text;
dt.Rows[row.DataItemIndex]["Passport Number"] = ((TextBox)(row.Cells[4].Controls[0])).Text;

//Reset the edit index.
dgInfoProfile.EditIndex = -1;

//Bind data to the GridView control.
this.BindData();
}

Dinesh Mani10-Jan-10 22:50

10-Jan-10 22:50

I didn't have the time to experiment, but I think GridViewDeleteEventArgs e is available on the Row Delete event and you can use it to retrieve the row id.

If that is not possible, how about altering the code to add one more value as an identifier and setting the value as the command value for a command button and delete the row corresponding to the command value?

HTH!

Nopo10-Jan-10 22:59

10-Jan-10 22:59

yes, the GridViewDeleteEventArgs e is available but i don't understand where I can get the value of an index, or of an Id if I add another Id column?

Dinesh Mani10-Jan-10 23:05

10-Jan-10 23:05

I assume GridViewDeleteEventArgs e has a row index just like the Update event arg. So, you can use it to get the gridview row and use it to get the datatable row just like what you have done for edit.

I've just got these out of the original code that you posted and modified it slightly -

GridViewRow row = dgInfoProfile.Rows[e.RowIndex];
dt.Rows[row.DataItemIndex].Remove();

Try on these lines and I'm sure you must be able to get it to work!

Nopo10-Jan-10 23:23

10-Jan-10 23:23

Thanks. There are two event for delete, one is RowDeleting and the other is RowDelete. I tried with RowDeleting. they both don't have Remove() method, thereforre i tried Delete().

GridViewRow row = dgSendFeedbackTo.Rows[e.RowIndex];
dt.Rows[row.DataItemIndex].Delete();

I get the following error when debugging:
"There is no row at position 1."

Dinesh Mani10-Jan-10 23:32

10-Jan-10 23:32

I'm sorry Nopo, I don't have access to VS at this point it time so I cannot help you out on the error message.

But, going by the looks of it try reducing the value of DataItemIndex. May be it might work.

Nopo11-Jan-10 2:51

11-Jan-10 2:51

Hi Dinesh,

I've got it right. Wink | ;)

protected void dgSendFeedbackTo_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataTable dt = (DataTable)Session["dtFeedback"];
dt.Rows[e.RowIndex].Delete();
this.BindData();
}

Thanks a lot for all your help.

Dinesh Mani11-Jan-10 18:35