DataSource Controls :: Some Text Is Converted To Question Mark?
Jun 12, 2010
I have a problem with the text when I save them to sql server 2005.
At first, I post some news to web page. The text showed normal on home page, but after one day when I visit that web page again, I saws all text in the article part was converted to question mark. Ex: "Khó đánh giá theo thị trường" (vietnamese)-->"Khó d?nh giá theo th? tr?ng"
In the other part or the page, the text is still normal. I don't know why.
Scenario: I am creating a custom gridview control which has a custom CheckBoxTemplateField column (deriving from TemplateField class). This template field column has custom Checkboxheadertemplate (implementing ITemplate) and CheckboxItemTemplate (also implementing ITemplate). In InstantiateIn method of both templates (header as well as Item template), I am adding a checkbox control which has Autopostback = true.
My requirement is: I want to mark all the values in the binding column of datasource if checkbox in headertemplate is checked. I dont want to mark only rows visible on grid. I WANT TO MARK ALL ROWS IN DATASOURCE. I want to do this in _CheckedChanged event of checkbox in header template.
Problem I am facing: When I check/uncheck the checkbox in header, it postbacks. so in OnCheckedChanged event, gridview's datasource is null. Secondly, in any event of gridview, I could access only those rows of datasource for which corresponding rows are visible in gridview through Gridviewrow.DataItem property. But I want to set it for all rows in datasource.
How we can avoid the saving of watermark text of a textbox while saving? In my application, I have one textbox which has a watermark text like enter value(by using ajax textbox watermark extender). when i save the form, the text box returns the value of some white space corresponding the letters of the water mark text. And i used to trim(). but it is saving as old manner.
i am creating a web from, i am a fresher, how can i create a water mark, i mean if we are going to enter our first name means, if our customer place the mouse cursor in that field means, it will automaticaly shows in the otherhand side like enter your first name and it should be with in 15 letters like a watermark or content box, can you people understand my question.
Im using LINQ2SQL and i have an object called Article. Its has 2 properties FinishText and SwedishText. The idea is to let the user choose language. Swedish is default.
I bind the objects to a listView and there is a label that takes the swedish language. When the user presses the Finish flag button i want the objects to reload and the finish text to show instead of the swedish. The problem is that the text label is bound to the SwedishText property in the mark up like this:
I can think of some ways to solve this, and i have one that doesnt work that well. My question is, what would be a good way to solve this? Im not so experienced so i know that there are lots of you out there that know how to do this much better.
Another problem i dont like my solution to is when i have an object that has a association with my Article object, like ArticleCategory. The ArticleCategoryId of my Article is, lets say 31, which is corresponds to the category "Movies". I dont want to display the category id but rather the name of the category itself (Movies).
So this is what i do: <%#GetCategoryNameFromId(DataBinder.Eval(Container.DataItem, "Article_Id"))%>
I call a method that recreates the artice object and from there creates the ArticleCategory and gets the name from it. Its a horrible solution cause it involves lots of trips to the Database. Especially since i do similar things with other properties.
Just wanted to hear what is a proper and good way to deal with these common but for me new tasks.
I have this error "The given value of type String from the data source cannot be converted to type datetime of the specified target column." when I used sqlbulkcopy to do the transaction
I have taken a DataTable control and have added colums to it. Now i want to add rows to that DataTable but when i am trying to create a DataRow of DataTable, an error is generated, showing "Value of type 'System.Data.DataRow' cannot be converted to 'dataRow'".
The sites that I've got are still in classic ASP. I know this is a good reason to move to .net but I don't want to have to redo all the sites yet.
So here is the problem:
[Code]....
When I have "On Error Resume Next" no erros get posted and everything runs just fine, the pulls from the database work perfectly. But as soon as we take On error resume next we start getting the following erros: err#424err desc:Object requiredsql:SELECT Name,URL,Title FROM tblMenu WHERE Parent_ID=1 AND Deleted=0 ORDER BY SortOrderScript Name: /index2.asp
I need to insert 5'5 in the height column but access db does not allow it. How can I be albe to insert this data with a quotation mark in the database.
I am getting int values from the stored procedure. But when i bind this datasource with the gridview i am seeing the values being converted into float. i am using Text='<% # Bind("Quantity") %' I wanna that to be displayed as int, with out zero'seg: let the value be 233, when i bind that its getting displayed as 233.00
How i can make the normal search string to sql server full text search parse, because when we are user enyer search text "how to run windows schedule in C#", in database we have article to to this, but data not returning and sometime is say error in key word and etc.
I have a Gridview in the markup and I add an ObjectDataSource to the mark up which will be the gridviews data source. Is this a redundant way of binding controls? I believe using this method is good for small sites with little customisation etc. but, for large sites (multi lingual, hundreds of pages etc) I have been taught to create the controls in the mark up or code behind, then bind the controls on PreRender in the code behind. My new boss thinks this method is old school and the current way of using an objectdatasource in the mark up is the best way to do it.
I want To update Mark and i convert it to template Field ,When I press Update I get the Old value not the Newest One of The Mark and nothing were Updated Except The Date Value in each DataBase and Grid
I have a vs 2008 project that I converted to vs 2010. I added a label to my aspx page but I couldn't get it be recognized in the c sharp until I realized that it wasn't added to the designer.cs file. I added it to that file like this:
[Code]....
and it worked fine. Why would I have to add something to the designer.cs file though? Shouldn't this have been created automatically when I built the project?
In my website there is 1 module in which i m fetching data(Student name, Roll no.) of students from the student master table into gridview... and in that gridview there is 1 checkbox column...
I want that when i will check the checkbox of those students who are present...dat checked students and name should be get entered into another table in database where there wil be present written in front of checked students and absent written in front of unchecked students.....
I tried a lot but I am not getting it.....
From the above table(student info) i wil fetch data in gridview and will mark attendance in the gridview
In the above sample gridview in the student name column the name of the students is fetched from student info table, when I will check the checkbox and select the date and click on the button the students who are checked will be stored with a status present and those who are unchecked are stored as absent in another table
The following is the table(example) is where the data is to be stored in the same manner. It means that total two tables are there in the database.
From 1 table i fetch data of students info in gridview and in another table i wil save the attendance marked in gridview....
I have a field called IsAdmin in my user database which is a bit and i have used a checkbox for entering its value in my forms...but i get an error
Conversion failed when converting the varchar value 'System.Web.UI.WebControls.CheckBox' to data type bit. How do i sort out this error....and i want IsAdmin to be either 1 or 0 in my database
I have MS SQL Server 2008 and I would like to store formatted text from a rich textbox. Formatted in the sense that I want to store a multiple choice question's formatting, an example would be like this:What is 2 + 2?
4 6 2 8
Then when I retrieve it from the SQL database it saves its formatting.
I have 2 tables A and B. Table A has a text field, fundIDs with comma delimited values like 23,44,55 etc. I would like to select all the records in table B whose ID matches the values in the fundIDs field from only one record in Table A. So, I need a function which first gets 1 table A record and uses the fundIDs field values to query and return all the matching records from Table B. I don't know how to parse and query in sql
