.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

Split the integer value form text

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :ASP.Net

 I have a @message parameter in SP, user sends an Integer value in that message.
For Ex: @message = 'This is, a Test message 500000 and the message ends.'
Now i want to get only that 500000 value from this @message param. There is no delimiters for identifying the integer value and in that param contains only one integer value

create procedure st_test (@message varchar (4000), @result int output)
//LOGIC for get the interger value

View Complete Post

More Related Resource Links

How to read a column of a sharepoint list to a text string field of infopath form?

My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

Change Text of Sharepoint Form Dialog title Bar

Hi, I am having Sharepoint 2010 RTM Trial on Windows Server 2008 SP2. I have published custom infopath form to sharepoint List. I have two views in that form, One is called AddItem and The other one is called EditItem. I have use the infopath rule to switch views depending on some condition and it is working fine. But when the view is switched to EditItem, I want to Customize the Title bar of Form Dialog to my custom text.... Can anybody have an answer ? Regards

How to create a SSIS package to import records form SQl Server 2008 tables to text files

I am a newbie to SSIS and would like to create a package to accomplish the task referenced in the above title. Will appreciate any links and pointers in the right direction.   Thanksakoranteng

Print Form View and expanding text fields?

The form i'm editing has a small text field with a scroll bar that users enter quite a bit of data.  I'm wondering how to create a print view for the form that will expand that field to match the size of the content text. Does that make sense?

Can't paste text into an Infopath form and see it with print preview

I have a user who says that they can't view any of their text that they cut and paste into the fields of a form when they choose Print Preview, in the forms library.  They're using IE8 to access the SharePoint site. When I access the same form in the same library from any browser from my computer, I can view pasted text in any field when I click Print Preview. Anyone see this before and can help me?? Thanks!    

convert Label text to integer

Hi, I want to convert Label text into Integer datatype.  I tried by giving Convert.Int32(Label1.Text) and int.Parse(Label1.Text)  but I couldn't do Type casting . I am getting error at runtime.    I searched in web I couldn't get the solution. Please help me....

.mdb and C# form question for a Rich Text Box

Ok heres my question. I have a program that i am writing that uses a .mdb database file. All the fields are set to Memo in the database for the size. My problem is i have a Rich Text Box that is used to gather info before it gets saved to the .mdb file. I narrowed it down to a maximum size problem with the RTB. Is there any way to increase the maximum data size of the RTB so that saving more then 3 sentences won't crash the program and will actually save the 3 sentences +. ?  Or is there some trick to get around that that i am not getting at the moment? So to restate my problem. I can't save anything over roughly 3 sentences from my C# form to a .mdb file without the program kicking out an exception, And the .mdb fields are already set to Memo. Thanks for any help/input in advance. This has been bugging me for a while and i haven't found anything online yet but i will keep searching.

Infopath browser form - odd behaviour on auto expanding multi line text boxes




I have a browser form with a multi line text box. The height is set to be AUTO. Within the client all is fine. When opened as an administrator approved form the text box automatically adds a new line for every 20 characters you type.


So if you type 40 characters without pressing enter you get 2 blank lines appear under you text that you CANNOT remove.


I have tested this on a new form with various multi line text boxes. The width setting is unimportant, the spell check setting is unimportant.


If i fix the height then the issue goes away but this is not any good.


I cannot use rich text boxes as i have around 40 text boxes on the form and if they are rich text they take around 10 minutes to load in the browser (this is another issue i have)


Thanks in advance



Split query result to text


Dear Friends,

I Have problem with query result with split from sql server,

ex:   select * from RefCustType

in the table RefCustType:

code name location telp


in the query result in text file I want this ersult like:

"code","name","location","telp"               <- field name

"111","ucok","rusia","622192356"           <- record

"222","fery","depok","6235145"              <- record


thank's B4 for your help.

sorry my english is not very well.

Problem with InfoPath 2007 Form opened with InfoPath 2010 - whole number integer not coming into dat


I found an issue when testing existing InfoPath 2007 forms via the Infopath 2010 Designer client.  Integer fields in the form template are publishing to a SharePoint Forms Library and show in the default view.  However, if that library is then used as a Data Connection in another or same form template those integer fields are not displaying or available for selection. 

This is not a problem using the InfoPath 2007 client.  It is not an option to convert the field to text as it could affect existing forms in existing libraries.  Also, existing integer fields are no longer appearing in previously defined SharePoint-based secondary data connections.  Only the ID field still appears.  But, those existing fields still work in the form and are selectable for functions, etc.

Is there a solution to this?

Thanks much!  Mike - www.ProgramNetInc.com


How should an SQL statement refer to a Text field value on a Windows Form Application?


In a WindowsFormApplication, I have a form that contains an MS Office Spreadsheet (an Office Web component).  The data source of the spreadsheet is  an Oracle table which is referenced in an SQL statement  - for example, the following works fine: 


I've now added a Text field (TextBox1) to the form and would like to have the SQL statement refer to the value of this field.  I've tried various syntaxes, including the following::


This generates an error (ORA00904: "HOST: invalid identifier)

I've also tried the following: 


This generates an error (ORA00904: "FORM1"."TEXTBOX1"."VALUE": invalid identifier)

I'd appreciate any ideas on what the correct syntax should be in referring to the Text field or whether or not this is even possible.


Applying changes to a text box within a form (edit mode)



I'm using the free text editor (http://freetextbox.com) and set a property (DesignModeCSS) to the text box based on the theme being used at the time. The following code works just fine:

TextBox_Home.DesignModeCss = "App_Themes/" + GetCurrentTheme() + "/BackOfficeTextStyles.css"; 

What I've since done is to add the text box control into a FormView (edit mode), and I'm now not sure how to access the text control to apply the code above.

Any help is much appreciated.


Boilerplate text on back of Purchase Order form



Can anyone suggest a way I can automaticaly print boilerplate disclaimer text on the back of a Purchase Order form?  The form has a header (with account number and address info and the like) and footer (signature line and bill-to address) which must appear on the front of each page; a single PO can span multiple pages.  I tried playing with embedding text and/or line breaks in the footer (which cause the footer not to print at all), and to turn off the header/footer for the last page (they don't print, but SSRS leaves a blank space where the header and footer would be if they were visible; the resultant body is too small to fit all the boilerplate text).


I'm working in SSRS 2005; perhaps there a way to do this in 2008?


Sorry if this has already been asked and answered; I couldn't find anything searching the forum.

Ho to Change the Search Form text



Is there any way I can change the text in the search form in SharePoint 2010?

It now says "Search this site..." and I would like to change that to a my custom text.



How to access the Parent form Text box in Third iframe


i have 3 iframe how to access the paten(t textbox value=1) in the 3rd iframe

Form Services 2010 - potential bug in plain text - multi-line boxes



Just wondering if anyone else has found the following and perhaps a resolution.  (Blog post with image examples here: Click)


An InfoPath Form created in Microsoft InfoPath Designer 2010 and is installed as an Administrator approved template.

  • Form Control: Text Box


  • Read-only – No
  • Enable spelling checker – Yes
  • Enable AutoComplete – Yes
  • Multi-line – Yes


  • Height: Auto

Compatibility Settings:

  • Form Type: Web Browser Form (2010)


  • Browser: Internet Explorer 7, 8, Google Chrome

When running the Form in the web and a user types into the multi-line text box; after 20 characters the text box gets bigger by 1 row.

On evaluation using the IE8 development toolbar.  It would appear that the control is rendered as a <textarea> HTML element and JavaScript runs on the 22<sup>nd</sup> character and adds 1 to the “rows” attribute of the <textarea> element.

For example:

Restrict text box value as integer


<input id="age" type="text" name="age"/>

If there is a way to restrict the value entered to be integer?

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