Extracting number from nvarchar

The HtmlAgilityPack is a powerful library that makes screen scraping in asp.net a breeze. This is the second in a continuing series where I demonstrate a way for you to extract all the links from a snippet of HTML

How do I restrict the number of input fields in the form to match the size of the columns?

Table Columns Reads:

state: Type Char; Length: 2
zip: Type: char; Length: 5   
Phone: Type: char; Length: 12    
Fax: Type: char; Length: 12     
Email: Type: nvarchar; Length: 256 

BoundField Reads:

<asp:BoundField DataField="state" HeaderText="State:" SortExpression="state" />

<asp:BoundField DataField="zip" HeaderText="Zip Code:" SortExpression="zip" DataFormatString="{0:#####}" />

<asp:BoundField DataField="phone" HeaderText="Phone Number:" SortExpression="phone" DataFormatString="{0:(###) ###-####}" />

<asp:BoundField DataField="fax" HeaderText="Fax Number:" SortExpression="fax" DataFormatString="{0:(###) ###-####}" />

<asp:BoundField DataField="email" HeaderText="Email Address:" SortExpression="email" DataFormatString="&lt;a href=mailto:{0}&gt;{0}&lt;/a&gt"

 

I knwo how to capture a line number from en exception error...but I have a need to capture the line number that certain things occur wihtout having excpetion thrown.  I guess one way would be to force an exception to occur and then trap the line number but I dont really want to do that because that seems clumsy to me. 

What woudl be nice is if there were some way to just say "what line of code is this?" programmatically.

so that regarldess of any code changes when I need that information to be grabbed it alwasy grabs the right value.

I'm trying to use an objectdatasource and populate it with a query that has "or" in its where statement.  eg: select * from customers where customer_id = "34" or "35" or "36"
The problem is... I don't know ahead of time how many of these "or" conditions there will be - the user can choose as many or as few as they want.  It seems that if I want to use an objectdatasource tied to a tableadpater I'm forced to know the number of parameters ahead of time so that I can build the objectdatasource's input parameters in advance.  I apologize if this is not clear, but could use any help.  I need to add parameters and condition them as "or"... any help would be greatly appreciated.

e.inputparameters.add doesn't work, because the key (in this case "id") is the same for each parameter because the where statment has "or"s....

I have almost 100 website that will update in a condition, I have a winzip archive that contains the files that replaces those websites. I want to know that

1. I can extract that files in a folder and then copy them to all 100 websites folders
2. I can extract the archive directly to 100 websites folders

which one is better in performance and less prone to errors

Hi,

When a new Task is created, WORKFLOW  should automatically assign task to the  user who is having a least number of task in TASK List.

Using out of box feature ( Sharepoint Designer WF) how can  I do ?

thanks

Bhoja

 

 

Hi,

I have a listbox with items selected from a list which holds numbers with decimal points. I should convert this to Integer

 

I tried using Convert.ToInt32 but it is giving error as it is expecting only whole numbers.

 

How to convert the decimal numbered string to a proper Integer...? Please help

 

 

Hello All,
I need to find a solution to record number of visits to a site ( SPWeb ). I need to do this for a intranet web site. Better if I can see unique visits and visits by individual users. I am planning to use "Web Analytics" feature in SharePoint 2010. But the only problem I see is that its not give a real time value.

Anybody has a better solution ?

---

Shail

Dear All,

I have a created a workflow based application having a concept of Master-details (Header-detail). Its an purchase order application. An order number is created with with atleast 1 line and maximum can be any number. One order once its created attached with a workflow instance ID which helps us to find out the different states/phases.

My question is, can we have workflow based on each lines of order? if yes then how will it work and what will be the pros and cons of it.

For example: A purchase order is created with 2 lines, one is product which is less than 100 in value and the other line is the product which is greated than 100, what i want is line 1 will create one workflow instance id and send to person A for approval and line 2 will create another workflow instance id which and send to person B, overall these two lines are a part of order number which is already attached to workflow instance ID.

In simple words, if I summarize, will it be possible to have a workflow based on order lines and if it is then how would it work.

Please I need your help, inputs and suggestions.

Regards,

Asim.

---

AZ