I m reading Name as string. When I m reading, I want my name like this
Last First MI
Johnny Travis M.
If it is like this. Johnny Travis M paul. It contains more than 3 data fields. I want to throw error.
If it is like this Johnny Travis M. It contains more than 1 space after last name. I want to throw error.
My users will enter a city/station where an incident occured, and the date. The trigger below does work, but it will occasionally put spaces between the citystation and the date. I think this happens when the citystaion name is not very long, but not sure.
(ex: city____08242010)
How can I make sure that if the incidentid is going to have spaces, that sql deletes those spaces? I need the id to be space free.
ALTER
AS
TRIGGER [dbo].[tr_AddID1]
ON [dbo].[tblIncidents]
INSTEAD
OF
INSERT..........
if there are two consecutive apostrophe or two consecutive hyphens or two consecutive comma or two consecutive spaces or two consecutive periods or two consecutive periods..I want to display those particular error.
and One more thing is if there are any of the above combinations like apostrophe+hyphen or apostrophe+space or hyphen+space, I want to throw that specific error.
I'm having an issue in my ASP.NET web app where intentionally consecutive backslashes are being removed from the request url.
I'll request something like:
localhost/Page/A//C
But when the request hits the page, the raw url is:
localhost/Page/A/C
Not sure if this is the culprit, but I do have a Url Rewite regex in place, here's the rule:
<system.webServer>
<rewrite>
<rules>[code]...
So, after the rewrite, the querystring is coming out as Page.aspx?1=A&2=C&3= When it should be Page.aspx?1=A&2=&3=C
My Question is as follows:Using ASP.NET syntax for the RegularExpressionValidator control, how do you specify restriction of two consecutive characters, say character 'x'?
View 4 RepliesI have a button on my web page and i would like to know if its possible to aviod consecutive clicks. Lets say i have a submit button or another button which inserts into db. And i figured out that there are two records in the db. So i would like to avoid consecutive button clicks.
View 3 RepliesI have a textbox and button in my child page it inherits a master page.the textbox should allow to key in only alphabets,comma,dot,space,single quote. And also consecutive comma dot single quote should not be allowed to key in. first and last character should be alphabets.
I have a javascript but it does not check for consecutive comma,dot,single quote...
I am want to develop a quiz site using MVC 2. A single page will display only one question. The examinee will select or type the answer and press Next button to proceed.
My business logic on the server side will record the time elapsed between two consecutive page requests. This time elapsed must not be tempered by any means to make a reliable diagnostic report.
Need a regular expression to replace the following sequence
Before : abbbccdd After : abcd
And also if numeric data is present instead of alphabets i would like to remove the duplicates and display
I have a sql data souce that returns several columns of data, and they are displayed in a DetailsView on a pretty simple vb.net page. I'm stuggling with one field though for the details view.
It's a template field, and if ClientType=1 (this value is determined else where on the page), then the label in the template field should have Text='<%# Bind("ClientName") %>', but if the ClientType = 0, then the label in the template field should have Text='<%# Bind("ClientTemporaryName") %>'
How do I tell the details view to set the text for ClientName to one or the other?
[Code]....
I have a relatively complex dataset (numerous tables, some with multiple records) generated from reading in an XML file. I need to connect said dataset fields to an ASP form. At the moment I'm assigning them manually, like so in the pageload:
txt_first_init.Text = formData.ds.Tables["phrmHdrKey"].Rows[0]["first_init"].ToString();
txt_last_name.Text = formData.ds.Tables["phrmHdrKey"].Rows[0]["last_name"].ToString();
ddl_pregnancy_flag.SelectedValue = formData.ds.Tables["pPhrm"].Rows[0]["pregnancy_flag"].ToString();
And conversely when it's time to submit.
formData.ds.Tables["phrmHdrKey"].Rows[0]["first_init"] = txt_first_init.Text;
formData.ds.Tables["phrmHdrKey"].Rows[0]["last_name"] = txt_last_name.Text;
formData.ds.Tables["pPhrm"].Rows[0]["pregnancy_flag"] = ddl_pregnancy_flag.SelectedValue.ToString();
I did some looking into binding the textboxes (and dropdownlists, and checkboxes, and and and...) directly, but it seemed to be too many formats to use.
So this works fine, but as the number of fields increases, those load and unload lists are going to get unwieldy.
I am using TempleteFields for all columns in my GridView. In that columns I am using only some fields for customization but not all.
Is there any performance issue with Databound Fields vs Templete Fields in a GridView...?
Do I need to replace the remaining columns with Databound Columns instead of TempletField columns...?
I am working on Crystal Reports 8.5 and SQL Server 2000 as backend. I have a stored procedure which has been added to the Crystal Report. So that fields are visible in the Fields object section from where i can drag and drop the fields on the report and display it. But now as they want more fields i have written two select statements for displaying required fields. But these newly added fields are not visible in the Fields object section in the Crystal Reports. I have done verify database, removed and again attached the SP but the problem is not solved.
View 1 RepliesQ1: I have an Asp.net page , one textarea there the user can enter all his details like name age gender; how do get the get name, age, gender in seperate fields(text fields). how can i split?
Q:
dawn barric 25 male
answer:
text1: dawn barric
text2: 25
text3: male
I have a requirement to display text with spaces before like the one below.
<asp:Label Text=" LabelValue" runat="server" ID="lbl"></asp:Label>
But after the code gets rendered, the displayed text is like "LabelValue" and not as " LabelValue".
How to get " LabelValue" this text to be displayed.
I've finally figured out an issue I'm have with a zip code field being entered in a text box of a details view in edit mode. I'm trying to understand why i have the issue though. I don't understand why it keeps occurring.his what happens with the zip code field. I've been able to make it reoccur numerous times. If the details view is put in edit mode and the record is updated with the original 5 digit zip code, unaltered in any way, my regular expression validator catches it and doesn't let the update happen. If I change the replace the 5 digit zip code with a new one the update goes through fine. This new value can be a different or the same 5 digits and the update will work. If I don't change the value at all though the update will not go through.
View 8 RepliesI would like to use a regular expression in C# to turn any two or more spaces into non-breaking spaces. I would like to leave single spaces alone.
Sample Sample
Would produce
Sample Sample
But
Sample Sample
Wouldn't be affected.
I have a GridView, and I want Column1 to be equal to datatable data (filled by a SqlDataAdapter). Then I have two other fields by the SqlDataAdapter (first name, last name), and I want to have those two fields combined to form Column2. I have a TemplateField for my GridView that combines the first name and last name with Eval()'s, but the GridView places this combined field TemplateField and puts it as the first column.
How can I do this so that TemplateField can go in between fields that are databound?
I'm not sure why this is, basically when I insert a row using the following function:
[code]....
The field 'Password' ends up having white spaces in it (as in "Password "). So whatever the password is it's trailed by white spaces.
The strange thing is this doesn't happen to the field 'UserName', both are of type char(50).
How can I make this regex not accept spaces?: [0-9a-zA-Z' ']{3,}
Everything I'm reading says to put a * or a + after the [] , but I get an invalid expression error when I do. The end result I'm looking for is a string of letters and numbers only - no spaces inbetween.
I am attempting to pass a small xml doc as a string to an affiliate's classic asp page. Here is how I am doing it:
[Code]....
However, when they receive this info the spaces are stripped out of the xml tag causing it to not parse and be invalid. Here is what it looks like when it arrives:
<?xmlversion="1.0"encoding="utf-8"?><test_ping><id>123456789</id><zipcode>99998</zipcode><income>3200</income><dob></dob><source>affiliate1</source></test_ping>
I have a textbox where email addresses are displayed at the click of a button. There is one problem, before the first email address there are two empty spaces. Is there any way of getting rid of them? The result looks like this: " emailaddress; emailaddress; emailaddress;"
Here's my button click:
[Code]....
The GridView in ASP.NET 2.0 is trimming the leading spaces from data coming from a SQLServer database. I have yet to find a way to keep it from doing that. The data in this particular view is being edited to remove such spaces, but only upon editing the row can any leading spaces be seen, meaning, at present, each row will have to be touched. With 12,000+ rows, that's a little much.
What little I've found on Google has mainly be concerned with trimming leading spaces. Is there a way to force GridView to show the data exactly as it is in the database, leading spaces and all?
I am trying to add white-spacess before showing my hyperlink.
Data
{space} {space}HyperLink1
{space} {space}HyperLink1
[Code]....
I am getting data straight from the database into a data source. The data is binded in a repeater with link buttons.
The problem I am having is that the data in the database might have multiple spaces in the middle of the string however when being displayed on the front end only space is being shown. After thinking about it this is standard HTML behavior to remove spaces, I would have assumed that asp.net would have handled this with the rendering of the webpage. What is also happening is that when reports are exported to excel it only has 1 space instead of two.
Example:
2 spaces: "South Africa - Cape Town"
single spaces: "South Africa - Cape Town"
This is an irrelevant example but my data has real use for multiple spaces.