.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Problem in binding special characters in gridview

Posted By:      Posted Date: November 16, 2010    Points: 0   Category :ASP.Net

Hi, I am facing problem while binding special characters to gridview. Whenever I try to bindthe characters <? the string truncates from there. eg: if I enter Employee<?1 in the Add employee textbox and save, the Employee list gridview displays only Employee. if I enter  Empl<?oyee1 the result is Empl
The database saves the correct value. Only while displaying in the gridview this problem occurs.
Any pointers to this?
The code to bind gridview is:
  <asp:TemplateField HeaderText="Employee Name">

View Complete Post

More Related Resource Links

Problem Binding DropdownList in a gridView to a datasource

I have a Dropdownlist in an itemTemplate in a gridview. My gridView binds to dataTable1 (from which the selected value for dropdown comes from) and dropDown binds to dataTable2 (i need to get DataValueField and DataTextField from here).<asp:TemplateField HeaderText="Category"> <ItemTemplate> <asp:DropDownList ID="Cat" runat="server" SelectedValue='<%#Bind("CATEGORY") %>' > </asp:DropDownList> </ItemTemplate> <FooterStyle BorderStyle="None" /> <HeaderStyle BorderStyle="None" /> <ItemStyle BorderStyle="None" /> </asp:TemplateField>How do I do that? thanks in advance!

GridView column/row data binding problem

Hi All, I have a table with the following structure: Attribute------------- AttributeIdWeekNoDayNoAttribute1Attribute2Attribute3Attribute4Attribute5 ........ likewise. I want to display these data in a gridview in the following manner                                  Sunday    Monday Tuesday ............ (till Saturday) - should be gridview columns, I can retrieve this using dayno Attribute 1 Attribute 2 Attribute 3 Attribute 4 .......... like wise attributes should be taken in to rows.Is this possible in a gridview, if so how can I do that?

Problem in binding List<> object to Gridview



We I bind a list<> object to a gridview it calls an error like this:

Error: DataBinding: 'Default2+JobsList' does not contain a property with the name 'JobId'

Hear is my markup Codes:

<asp:GridView ID="GridView1" runat="server" DataKeyNames="JobId" AutoGenerateColumns="False"
                                <asp:BoundField DataField="JobName" .../>
                                <asp:BoundField DataField="JobExplain" .../>
                                <asp:ButtonField CommandName="DeleteJob" .../>

and Code behind:

public struct JobsList
        public int JobId;
        public string JobName, JobExplain;
        public JobsList(int id, string name, string explain)
            JobId = id;
            JobName = name;
            JobExplain = explain;

List<JobsList> list = new List<JobsList>();


list.Add(new JobsList(Approperiate Attributes..));
GridView1.DataSource = list;

Problem with upload a file with special characters for the contribute permission users



I have a problem when a user with contribute permission try to upload a file with special characters, it gives a access denied error.

Is there a way to solve this problem?


Binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Here is the code for binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

Gridview Enable Selection Problem



I have a gridview with Enable selection and Enable Paging equals to TRUE.

I also set the PageSize of my gridview to 4 so that I only displays 4 rows per page.

The problem is when I click the pager in the bottom of my gridview, my gridview is disappearing and no records appear.

Here is code behind of my gridview:

If e.Row.RowType = DataControlRowType.DataRow Then
                e.Row.Attributes("style") = "cursor:pointer"

                e.Row.Cells(2).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(3).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(4).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(5).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(6).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))

Binding GridView with SqlDataSource at runtime?


Hi, I want to create a generic page which contains a gridview and sqldatasource. I want to put these two controls on .aspx (C#) page but bind them at runtime. It should have selectcommand, updatecommand, deletecommand and insertcommand. Stored procedures are created for that. Help is needed to make it. Please post some link or code. Regards, ap.

Configure Datasource using gridview problem


Hi i  have one asp.net textbox control..

and one dropdownlist inside gridview itemtemplate textbox..

what my problem..?

A Textbox36 has values some thing like this A1','A2','A3

i wirte this below query in sqldatasource1 and this sqldarasource1 is binded to gridview ItemTemplate Dropdownlist..

Select ItemName from Table1 where code in (@C)

Here @C im refering to Textbox36..

It show me the record if it has one value if its multiple like A1','A2','A3 it not showing/filtering ItemName data..

Whatz the probel?

Problem Cleaning Illegal Characters out of an XML String



I'm trying to strip illegal characters out of an XML string before I send it off to a public web service.  The xml will look something like this:

<field name="first_name">George</field>
<field name="last_name">Harrison</field>
<field name="notes">This is a note.  Any character could appear here</field>

I need to pull out any ampercand (&) charachters in the any of the fields, as well as any < or > characters, which would make the XML unreadable.

I've tried it like this:

Private Shared Function cleanQuery(ByVal queryNode As String) As String 
    Dim root As XElement = XElement.Parse(queryNode) 
    For Each x As XElement In root.Elements 
        x.Value = x.Value.Replace("&", "&").Replace("<", "<").Replace(">", ">") 
    Return root.ToString() 
End Function


That doesn't work so well.  I get the error stating:

     There are multiple root elements. Line 1, position 15.

I tried wrapping the XML in a single root element, like this:

Private Shared Function cleanQuery2(ByVal q

Problems Rendering Special Characters


Good afternoon ASP programmers,

I am creating an application that creates math problems for students.  I wish to use a special character for negation to differentiate it from the minus sign.  I am using the Unicode character U02c9. 


This is a composite screen shot of two problems. The top one is rendered in Fire Fox and the bottom one in IE.  I'd like to know how to change my JavaScript so that IE is rendered like Fire Fox.  I have created variables that I use for my special characters.

var symMul= "×";
var symDiv= "÷";
var symNeg= "?";

Both IE & Fire Fox correctly render the symDiv and symMul symbols. Any suggestion would be greatly appreciated.




problem...i want a list item to populate all data in gridview!!!


i have a dropdownbox and a gridview

what I want is to have a list item which populates all data in a gridview.

I have tried using list item selected value=0 but to no avail.

what is the easiest way to achieve this?

Excel-like experience - gridview focus problem



I'm creating a page where people can order several items from a list without having to press "edit" and "save" in between like you normally would in a gridview. The user writes down the quantity, and finally presses a "submit" button that saves the order.

I want the user to have a windows form (or excel) like eperience, so once the user puts in the quantity and moves on to the next item, either by TAB or by clicking on the TextBox, i make some calculations without the user beeing bothered with a full refresh or having to press a buton to execute the event, so I place the controls inside an UpdatePanel and use TextBox.TextChanged. The event runs code that calculates the sum for the row (price * quantity) and shows that in a column called "Sum", and updates a label in a fixed position with the new order total ("Total").

Any ideas on how to achieve this?

Right now I use a GridView with a templatefield for the Quantity and set the TextBox.TextChanged event to fire to make the calculations. The problem is that the focus then changes.

By using SmartNavigation or the ScriptManager.SetFocus I manage to retain focus on the TextBox that executed the Postback, but the user might have moved on to a textbox far down the gridview (thus causing the postback by leaving the previo

DropDownList FindByText with Special Characters...?


I have a dropdownlist which I dynamically select a list item using findbytext as long as there are no special characters.  One entry in the list starts with a percent symbol which I have been unable to dyncamically select.  I have confirmed that there are no spaces in the list item and have hard coded the query with the string to try to find the problem.  FindByText("% Increase")    I believe it has something to do with the special character but have been unable to identify a method to work around this.  Any help would be appreciated.


If Not ddlColumns1.Items.FindByText(strDefault) Is Nothing Then 
    ddlColumns1.Items.FindByText(strDefault).Selected =
End If

GridView Problem


I've been asked to change an ASP.NET project to MVP Architecture - which may have something to do with what is going wrong.

I make the call through the architecture to the database which returns a dataset which I've verified is correct, (using dataset.writeXML() ) just before databinding  to the gridview.

On one page everything works as expected (plus any post backs). Another page the Page_Load works correct and the gridview is populated, but any postbacks do not work- it retains the Page_Load's data. Then on the third page the GridView never shows though databinded. In all these cases I've checked that the Dataset is good data, and made sure to DataBind().

All three use the exact same logic. Any ideas or suggestions are greatly appreicated.

Thank you for your help.

public partial class UI_Admin_manageFirms : System.Web.UI.Page, IManageFirms_Pres
    static ManageFirms_Pres presentation;

    protected void Page_Load(object sender, EventArgs e)
        if (!Page.IsPostBack)
            presentation = new ManageFirms_Pres(this);

    protected void btnSearch_Click(object sender, EventArgs e)
        string firmName = (txtFirmName.Text != string.Empty) ? txtFirmName.Text : null;

Need some help BINDING to Gridview


Here is how I set this up....Still not working.

  •     Dim cs As ConnectionStringSettings   
  •     cs = ConfigurationManager.ConnectionStrings("ConnectionStringVendors")   
  •     Dim connString As String = cs.ConnectionString   
  •     Dim dbConnection As New SqlConnection(connString)   
  •     Dim query As String  
  •     Dim query1 As String  
  •     query = "SELECT keyID, projectNum, projectDescripti
  • Binding xml data (which is return from Url) to gridview


    I have used Yahoo BOSS API for internal search. This API return string and i want to bind it with gridview. How can i achieve this following is the code

    string AppId = "sRP_q9bV34HI_zNyuahPFBGnf1SHyBaIKCtvEjB89EuiNJI6fcfSwAFbwAFSsCV_";
    //string Query = "site:way2k.com engineering colleges in pune";
    string Query = "colleges in pune"; int NumResults = 10;
         int NumResults = 10;
    System.Net.WebClient webClient = new System.Net.WebClient(); request = string.Format( "http://boss.yahooapis.com/ysearch/web/v1/{1}?appid={0}&format=xml&results={2}", AppId, Query, NumResults); byte[] response = webClient.DownloadData(request); string responseXML = System.Text.UTF8Encoding.UTF8.GetString(response); return responseXML;

    this code returns result in xml format, how can i bind this XML to gridview so that it looks like search result

    ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
    Sql Server  SharePoint  Silverlight  Others  All   

    Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend