Can anyone advice of the best way to clean an input string from characters that will cause SQL Update error? For instance:
Dim sText as string = 'this is line to a break <br> before the end.'
Dim SQLString as string = "update sometable set somefield='"
& sText & "'"
Executing SQLString will fail because of the <br> it contains. how to filter out all possible characters that will cause the update query to fail?
I have a string with 100 characters and it is for me too long in one line. I want to make NewLine after each 25 characters. For example:
Instead: "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua."
I would like to transform an html input to xml. But the input will have as part of its content an "&", e.g. Texas A&M. But calling XslCompliledTransform.Transform(htmldocument, xmlwriter) causes an xmlexception to be thrown.
View 4 RepliesI want to show just a part of a string for example:
Instead: "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua."
Just a: "Lorem ipsum dolor sit amet, consetetur sadipscing..."
Which method can I use to do that?
How do I achieve this:-When user types character like 'abcd' and then '>'(an invalid character for my application), I want to set the text back to 'abcd'. Better if we can cancel the input itself as we do in winforms application. This should happen when user is typing and not on a click of button.I want this to be applied on all text boxes in my web page. This will be easy if the solution is jQuery based. May be something which will start like this.$("input[type='text']")SOLUTIONI used both of the answer provided by @jAndy and @Iacopo (Sorry, couldn't mark as answer to both) as below.
$(document).ready(function() {
//makes sure that user cannot enter < or > sign in text boxes.
$("input:text").keyup(purgeInvalidChars)
[code]...
Here is the style sheet.
body
{
width:
100px;
text-transform:capitalize;
}
Only the first input character was automatically converted to uppercase. The rest inputs are not converted. Do you know what changes I need to make it work?
I'm trying to update a db record via a business object, based on a users input.
In my button event handler, I check for a null or empty value like this before I set the object properties:
[Code]....
But if the textbox is empty, I get the "System.FormatException:
Input string was not in a correct format." in the line:
[Code]....
How can this be?
 //Read string contents using stream reader and convert html to parsed conent var parsedHtmlElements = HTMLWorker.ParseToList(new StringReader(contents), null); Â
//Get each array values from parsed elements and add to the PDF document foreach (var htmlElement in parsedHtmlElements) pdfDoc.Add(htmlElement as IElement); Â
//Close your PDFÂ pdfDoc.Close();Â Â Response.ContentType = "application/pdf";Â Â
//Set default file Name as current datetime Response.AddHeader("content-disposition",
[Code] ....
Error: Input string was not in a correct format. Contents in html file giving error ...
i have my own DLL (for the data access layer),,i use escaping characters technique to avoid the user input errors ,, but recently i decided to enhance my classes and using parametrized query to prevent all possible errors,Is the modification will be easy or difficult ??how to convert this way to use the parametrized query ..
View 1 RepliesI have a simple ASP.net page:
<form id="form1" runat="server">
<p><asp:TextBox id="input_box" runat="server"></asp:TextBox>
<asp:Button Text="OK" runat="server" OnClick="run" /></p>
</form>
I want to send input from input_box to a query string, and then keep this input in the input_box when the page reloads.
That's the code behind page:
protected void Page_Load(object sender, EventArgs e)
{
input_box.Text = Request.QueryString["input"];
}
protected void run(object sender, EventArgs e)
{
string url = string.Format("?input={0}", input_box.Text);
Response.Redirect(Request.Url.AbsolutePath + url);
}
Problem is that when query string is not empty, string from input_box cannot be passed to query string. How to correct it?
I have a 15 digit string to encrypt.
I have tried using .NET's various encryption functions but all my encrypted strings are at least 24, 28 or 32 in length.
I have heard of CipherMode.CTS with Padding = None that produces the same length output as the input length but I can't seem to get the same result. I have toyed with the block-size, key-size and salt size.
I don't mind adding a digit to my input string to make it 16 in length.
How do you make SMO release it's connections?
I have this code:
[Code]....
For every call I make to this index method a connection is spun up - and is not released again.
So after 20 calls to the page, I have 20 of the connections awaiting command. This eventually ends up with an exception, when I cannot make new connections, because the connection pool is full.
What do I need to avoid this happening? I cannot seem to find a method on the SMO Server object like Dispose, close or similar.
On using jQuery ajax on ASP.Net, we are required to pass the DATA through a string-ed json on the parameters needed. My only concern with this is with strings that has single & double quotes. I tried doing a replace on these and insert escape characters but unfortunately it just doesn't work.
UPDATE
var relativeName = $('#<%= txtRelativeName.ClientID %>').val().replace("'", "'");
$.ajax({ data: "{ relativeName: '" + relativeName + "'" });
i have string
Dim str As String = "C#app_wiod_200"
i want to remove characters from wiod in string which one is the best string function to do this.
I've got a program that in a nutshell reads values from a SQL database and writes them to a tab-delimited text file.
The issue is that some of the values in the database have special characters (TM, dash, ellipsis, etc.) When written to the text file, the formatting is lost and they come across as junk "â„¢ or â€" etc"
When the value is viewed in the immediate window, before it is written to the txt file, everything looks fine. My guess is that this is an issue of encoding. But, I'm not real sure how to proceed, where to look, or what to look for.
Is this ASCII or UTF-8? If it's one of those how do I correct it before it's written to the text file.
Here's how I build the text file (where feedStr is a StringBuilder)
objReader = New StreamWriter(filePath)
objReader.Write(feedStr)
objReader.Close()
i have a string and want to remove text up to the last forward slash, e.g
/images/UserThumbnails/22.jpg
Should now be
22.jpg
How do i go about doing this?
I'm currently working on this application that records a users email.
I was wondering if there was a function that would read the last 7 digits of the inputted user email and store it in a variable? Is there any way to do this?
I need to be able to sort by a product title and then by a products price, which is simple but I only want the title sorted on the first 3 or 4 characters. My client wants to add the brand name to the beginning of the product title and have them automatically sorted. I can a new field in the database called brand and sort by that, but wanted to know if this is possible. I've posted what I though might work but it doesn't
[Code]....
I guess this is probably possible with a lambda expression, but I've no experience with Lambda expressions at all.
I want to display description of product in gridview, but i want to display only 15 characters on one line, I want to break it after 15 characters, I have written countchar function as follows:
public int CountChars(string value)
{
bool lastWasSpace = false;
foreach (char c in value)
{
result++;
lastWasSpace = false;
}
return result;
}
and called function as:
string description="sdfsdfsd sdfsdf sdfsdf asdfsa dfsda safsaf sdfdf sdfs sdfsdf sdff sdf ";
CountChars(description);
And i want to check:
if(result>15)
{
after every 15 characters i want to break the line.
}
I have users emails in my database and when i retrieve those usernames, i want to remove every charecter after the @ charecter in the email for example, i have myname@domain.com i want to cut that to myname.
View 3 Repliesusing vb.net/asp.net 2005 and sql server 2005. I'm querying the database and returning text which I am then adding to a string. I'm creating a crystal report with the text however this is not a crystal report question, its about the string data. what I"m noticing is that when I show the string on the pdf that there are some strange characters at the end of the string. I am both trimming the string and taking out null characters however the strange text shows up like this:
strangeText>
SÙÇ
TÙçy|Ü
DÙÇ
$ÛÇ
</strangeText>
does anyone know what these characters are and how to get rid of them?
i want to display values in dropdownlist using querystring[which is successfully happening] but the problem is when id passed in querystring is 7.17 then in dropdownlist it is displaying values as 7 . 1 7....but i want to display it as 7 and 17...
here is a part of the code
string imageid;
string logoid;
string id1;
string id2;
String Name;
protected void Page_Load(object sender, EventArgs e)...
string="/?UPID=1000001&One=1&Two=2"
UPID is always equal to 7 digits. I want to remove "UPID=(any 7 digits)".
I'd like the output to be:
string="/?One=1&Two=2"
Or if no query strings
string="/"
Im looking to strip out non-numeric characters in a string in ASP.NET C#
So i.e 40,595 p.a.
would end up with 40595
I am getting a string in the following format in the query string:
"Arnstung%20Chew(20)"
I want to convert it to just "Arnstung Chew". How do I do it?
Also how do I make sure that the user is not passing a script or anything harmful in the query string?