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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Unable to enter apostrophe ( ' ) in the textbox (Asp.net C#)

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :ASP.Net
Hi friends , Im unable to enter apostrophe(') in the textbox as got error message as per below . How to solve this ? Pls help .thanks     Server Error in '/' Application. ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Agriculture, forestry and fishing(cultivation of land or animals).',''','Mr','',' at line 1 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Agriculture, forestry and fishing(cultivation of land or animals).',''','Mr','',' at line 1Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [OdbcException (0x80131937): ERROR [42000] [MySQL][OD

View Complete Post

More Related Resource Links

Unable to enter the product key in the Convert License Type page (textbox is read-only)

We installed both WSS and MOSS SP2 and had planned to follow the manual fix for the known issue that the patch unexpectedly activates a trial expiration.  However, the textbox to enter the product key is read-only.  We have tried accessing this page using the normal administrator credentials as well as the farm account; no success.The SP2 issue and manual fix is detailed here, http://support.microsoft.com/default.aspx/kb/971620We were able to experience this problem on a farm running the Feb 2007 cummulative patch (version so it's not related to the SP.  But running the SP increasing the need to find the fix.Any help is appreciated,J. Aqui

Textbox in ItemTemplate inside Gridview, unable to get the value


Hi. I have a itemtemplate inside a gridview.

<asp:TemplateField HeaderText="Enter OTP">
                            <asp:Label ID="Label2" runat="server"
                                style="font-family: Arial, Helvetica, sans-serif; font-size: x-small"
                                Text="PIN Num:"></asp:Label>
                            &nbsp;<asp:TextBox ID="txtPIN" runat="server" Height="21px" Width="100px"></asp:TextBox>

Enter the date on the WPF DatePicker input textbox instead

When i type in the date on the date picker and check it on an lostfocus event and i try to read the text or selecteddate its blank?  Am i missing something.  I assumed typing in 5/11/2010 on the input box would either show up on the controls Text or the SelectedDate, but i may be missing something   Thanks

Unable to fetch text from a textbox with numeric up-down extender

I have a textbox with numeric updown extender.I want the text of the textbox.I have written code in code file is String a=txtHour.Text//  Source FIle COde<asp:TextBox ID="txtHour" runat="server" ReadOnly="True" Width="45"                     Style="text-align:center" Height="20px"></asp:TextBox>                                       <cc1:NumericUpDownExtender ID="NumericUpDownExtenderHr" runat="server"                     Enabled="True"                     Minimum="00" Maximum="23"                    TargetControlID="txtHour" Width="40">                </cc1:NumericUpDownExtender>

Unable Set Value of TextBox In FormView

I need to set the value of TextBox in a FormView when the mode changes to Insert. But when I was trying to get it to work, neither one of the code blocks below worked. The value was not set, despite the TextBox being found. Furthermore, the 'test' label text wasn't being set. I know for certain that both events are firing. I had added the test label to disploay the mode or newmode of the FormView but the label wasn't being set at all. Protected Sub FormViewMessageDetail_ModeChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewModeEventArgs) Handles FormViewMessageDetail.ModeChanging 'If FormViewMessageDetail.CurrentMode = FormViewMode.Insert Then Dim TextBoxMessageDateTime As TextBox = CType(FormViewMessageDetail.FindControl("TextBoxMessageDateTime1"), TextBox) TextBoxMessageDateTime.Text = Now.ToString 'End If Dim Test As Label = CType(FormViewMessageDetail.FindControl("Test"), Label) Test.Text = Now.ToString End Sub Protected Sub FormViewMessageDetail_ModeChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormViewMessageDetail.ModeChanged 'If FormViewMessageDetail.CurrentMode = FormViewMode.Insert Then Dim TextBoxMessageDateTime As TextBox = CType(FormViewMessageDetail.FindControl("TextBoxMessageDateTime

Unable to change textbox values after manual assignment



In my webapp, I have a DropDownList_OnSelectedIndexChanged that assigns values for a number of <asp:textbox'es depending on which entry is selected...

       public void ModifyProjectIDBox_SelectedIndexChanged(object sender, EventArgs e)


            int tempJobID = Get_Selected_Report();

            dbCommandString = "SELECT Name, Address, State, Awarded, StartDate, EndDate, HomeLocal FROM dbo.ProjectInfo WHERE ProjID = " + tempJobID;

            dbComm.CommandText = dbCommandString;


            dbReader = dbComm.ExecuteReader();


                ModifyProjectNameBox.Text = dbReader[0].ToString();


            ModifyProjectAddrBox.Text = dbReader[1].ToString();

            ModifyProjectStateBox.Text = dbReader[2].ToString();


What wouldbe the best approach to accomplish validation as you enter into textbox


Here is what im wanting to do, i believe i have seen it done, but cant remember if it was while you were typing or at validation. But i think at validation would be fine.

We have a form that will allow you to enter an IP address. In the table, that is the primary key. I would like to validate either during the entry or upon submission if that value is already in the table, if it is, then they cannot submit.

Would it be best to use a compare validator and compare the entered value with a list of values returned from the table?

Any suggestions on how to accomplish would be great. 

textbox enter press




how can I set the textbox function to do something on "Enter" button press ?

Keypress doesnt work Sad



Button clicked event on hitting enter in any textbox




I have a WPF form with some element on it (textbox, datagrid, button...). I have an "OK" button which will handle the form when I click on it. How could I call that event handler on every "Enter"? I mean if I hit enter key in any of the form element I want to process everything like when I clicked on "OK" button.




Using Enter Key with Textbox


I have a series of textboxes, and want to use Enter key to move from one to the next.  It seems I have to check for the Enter key using the textbox keydown event, and check for the Enter key.

Question 1.  Isn't there a better way to have Enter function as a Tab?

Question 2.  When I trap the Enter via KeyDown and change focus to next textbox, I get audio 'ding'.  That's usually a cue indicating an error.  Is there a way to suppress this 'ding'?


Unable to get value from the textbox.



I want to get the value of the textbox on code behind. The textbox value is changed by using some javascript stuff. For disabling enter text into the textbox i use Readonly=true or another is Enabled=false. The javascript change the value properly. suppose the javascript set the texbox content is 123. When submit the button i am unale to get the value. Please tell me how to solve this small issue Undecided.


How to set focus on next textbox on Enter Key using jQuery

Normally, tab key is used to move to next text box and by default, when Enter key is pressed, the form gets submitted or it calls the default button click event. But it would be a nice feature for end-user to give him ability to move to next textbox using Enter key.

Textbox Editable GridView in ASP.NET

This article describes how I made a fully editable gridview in C# using ASP.NET 2. The idea is that the GridView looks and works like an Excel spreadsheet. You see all the cells in the table, and you can edit any of the cells you like, and they are automatically updated (i.e. saved to the database). This is very often how people expect data tables to work in web pages, and I've often seen people clicking in vain on un-editable gridview cells, somehow expecting to edit them, and not understanding that they need to click an Edit button at the end of the row.

Highlighting Rows with TextBox OnFocus

In another article I explained that how you can make the rows of the GridView control clickable and highlight them when they are clicked. In this article I will explain that how you can highlight the GridView rows when you focus on the TextBox which is contained inside the GridView control.

Custom Editing Behavior for DataGridView TextBox Columns

For various reasons I'm using a DataGridView instead of a ListView, and while configuring the DataGridView to look like a ListView wasn't much of a problem, there's one thing that got on my nerves, which is the behavior of textbox cells in edit mode: It is much too easy to leave the edit mode accidentally, simply by pressing the cursor keys at the wrong time. For example when the text caret is positioned behind the last character of the textbox cell content, and you press the right arrow key

Editable Gridview with Textbox, CheckBox, Radio Button and DropDown List

This is an example of an editable gridview containing different ASP.NET controls. When user wants to edit values in gridview, she/he can use these controls to edit existing values in Gridview Edit Mode.

Using the Code

watermark textbox using Ajax control

This is pretty simple compared to jquery. Since we need refer a dll only. we dont want any script for this. we just include that reference into our website.
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