This is a migrated thread and some comments may be shown as answers.

radgrid hyperlink column

20 Answers 3801 Views

Grid

This is a migrated thread and some comments may be shown as answers.

20 Answers, 1 is accepted

Accepted

answered on 30 Jun 2011, 07:26 AM

Hello Ram,

Try the following code snippet in ItemDataBound event to remove underline in HyperLinkColumn. Hope this helps.

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)

{

if (e.Item is GridDataItem)

{

GridDataItem item = (GridDataItem)e.Item;

HyperLink link = (HyperLink)item["HyperLinkColumn"].Controls[0];

link.CssClass = "hidelink";

}



CSS:


<style type="text/css">
        .hidelink
       {
           text-decoration:none;
       }

</style>

Thanks,
Shinu.

answered on 02 Sep 2011, 03:00 AM

Thank you so much Princy, i owe you one.

One more thing.. do you have any idea for downloading using GridAttachmentColumn, see below details where i got an error "
Unable to cast object of type 'System.String' to type 'System.Byte[]'."

Really sorry coz im new on this.

WBPODFilename = varchar (file path is in C:\download folder
ShipersCode = varchar

<telerik:GridAttachmentColumn DataSourceID="SqlDataSource2" MaxFileSize="1048576"
EditFormHeaderTextFormat="Upload File:" HeaderText="Download" AttachmentDataField="BinaryData"
AttachmentKeyFields="MTR_ShipersCode" FileNameTextField="TRN_WBPODFilename" DataTextField="TRN_WBPODFilename"
UniqueName="AttachmentColumn">
</telerik:GridAttachmentColumn>

codebehind:
if (e.CommandName == RadGrid.DownloadAttachmentCommandName)
           {
                    e.Canceled = true;

                    GridDownloadAttachmentCommandEventArgs args = e as GridDownloadAttachmentCommandEventArgs;
                    string fileName = args.FileName;
                    string attachmentId = (string)args.AttachmentKeyValues["MTR_ShipersCode"];

                    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LMSConnectionString9"].ConnectionString);
                    SqlCommand comm = new SqlCommand("SELECT [TRN_WBPODFilename] FROM [VW_InqTran] WHERE [MTR_ShipersCode] = @MTR_ShipersCode", conn);
                    comm.Parameters.Add(new SqlParameter("@MTR_ShipersCode", attachmentId));

                    SqlDataAdapter adapter = new SqlDataAdapter(comm);
                    DataSet data = new DataSet();
                    adapter.Fill(data);

                    //   System.Text.Encoding enc = System.Text.Encoding.ASCII;
                    // byte[] binaryData = enc.GetBytes("TRN_WBPODFilename");
                    // string myString = enc.GetString(binaryData);

                    //byte[] binaryData = System.Text.Encoding.Unicode.GetBytes(data.Tables[0].Rows[0]["TRN_WBPODFilename"].ToString());

                    byte[] binaryData = (byte[])data.Tables[0].Rows[0]["TRN_WBPODFilename"];
                    //byte[] binaryData = (byte[])data.Tables[0].Rows[0]["TRN_WBPODFilename"];
                    Response.Clear();
                    Response.ContentType = "application/octet-stream";
                    Response.AddHeader("content-disposition", "attachment; filename=" + fileName);
                    Response.BinaryWrite(binaryData);
                    Response.End();
            }

Thanks,
Jhess

answered on 03 Feb 2016, 02:55 PM

Am having a similar problem, but i want to access the pdf file a file part in my server here is my hyperlinkcolumn:

<telerik:GridHyperLinkColumn DataTextField="uploaded_document" DataNavigateUrlFields="PDF" DataTextFormatString="Open {0}" DataNavigateUrlFormatString="/file" Target="_new" FilterControlAltText="Filter uploaded_document column" HeaderText="uploaded_document" SortExpression="uploaded_document" UniqueName="uploaded_document">
</telerik:GridHyperLinkColumn>

and here is my code behind were am saving the data to a file, but i need to access it and view it on a new web browser

protected void btnSaveDoc_Click(object sender, EventArgs e)
        {

            SqlConnection connarch = new SqlConnection("Data Source=localhost;Initial Catalog=NafArchive_db;Integrated Security=True");
            {
                // Check File is selected into the file uploaad
                if (FUploadDocFile.HasFile)
                {

                    //byte[] docName = System.IO.File.ReadAllBytes(FUploadDocFile);
                    string extension = System.IO.Path.GetExtension(FUploadDocFile.FileName);

                    if (extension == ".pdf" || extension == ".jpg" || extension == ".docx" || extension == ".dot" || extension == ".mp4" || extension == ".wmv" || extension == ".ppt" || extension == ".pptx" || extension == ".docx" || extension == ".xlsx" || extension == ".xls")
                    {
                        // Get the folder path
                        string path = Server.MapPath("files\\");

                        string docName = guid + FUploadDocFile.FileName;
                        //Save Image
                        FUploadDocFile.SaveAs(path + docName);
                        LabelUploadChecker.Text = "File successfully saved...";
                        //SqlCommand cmd = new SqlCommand("sp_InsertFile", connarch);
                        SqlCommand cmdarch = new SqlCommand("Insert Into Documents(doc_number, doc_subject, doc_classification, doc_date, uploaded_document) VALUES(@doc_number, @doc_subject, @doc_classification, @doc_date, @uploaded_document)", connarch);

                        cmdarch.CommandType = CommandType.Text;
                        cmdarch.Parameters.AddWithValue("@doc_number", txtDocumentNo.Text);
                        cmdarch.Parameters.AddWithValue("@doc_subject", txtDocSubject.Text);
                        cmdarch.Parameters.AddWithValue("@doc_classification", ddlDocSyClass.Text);
                        cmdarch.Parameters.AddWithValue("@doc_date", txtDocDate.SelectedDate);
                        cmdarch.Parameters.AddWithValue("@uploaded_document", docName);
                        //cmd.CommandType = CommandType.StoredProcedure;

                        connarch.Open();
                        cmdarch.ExecuteNonQuery();

                        int result = cmdarch.ExecuteNonQuery();

                        if (result > 0)
                        {
                            LabelUploadChecker.Text = "Image uploaded to database...";
                        }

                        connarch.Close();

                        //txtDocSource.Text = "";
                        //txtDocSubject.Text = "";
                        //txtDocType.Text = "";
                        //txtDocumentNo.Text = "";
                        //txtDocVolume.Text = "";

                    }
                        else
                        {
                            LabelUploadChecker.Text = "File not in the required format...";
                        }
                    }
                    else
                    {
                        LabelUploadChecker.Text = "Please select document to be uploaded";
                    }

                }

            }

Thank you