After use regular expression to get html code and put into string variable as :
dim s as string ="<table><tr><td>abc</td></tr>....................</table>
Number of rows in above table in s variable may changed,because i get html from other site. So i want to ask : have best way to continue parse rows in table which i get "abc" string.
I have not been able to create a function to take a long nvarchar (8000) with a delimeter to return the results in a table . I have a script version that works as a query. I plan to use the Function in a Select * FROM table WHERE FirstName IN dbo.ListOfItem(@InputList) Is the following posible in SQL Server 2005?What is wrong with syntax? Is there a better solution?
[Code]....
I have a String that contains the following: ?workarea=London+&+Home+Counties+Ltd&sub=fs&&&FASh*5which resembles a URI query string. What is the best way to parse the elements of this string (workarea and sub) without messing about with string manipulation?If I use HttpUtility.ParseQueryString is gets stuck as both elements include &. However if I encode the whole thing first I lose the seperations of the elements. Ideally the output would be:workarea = London & Home Counties Ltdsub = fs&&&FASh*5
View 4 RepliesIs there a way to easily split a comma delimited string into variables (or table fields), example:
PHP Code:Feed.SmulocV2.Equipment,CAT,,DFT08783,2567,Hours,2010-02-07 06:37:41,Lat:38.025921,Lng:-88.776733
I have, somehow, this string available "20100205 162206". This is a date and time without any delimiter char. I need this back as a DateTime in C#. What is the best way?
View 1 RepliesGiven a string like:
Token A^*!%~Token B^*!%~Token C^*!%~Token D^*!%~Token E
Write a method that parses the string into a series of substrings where the delimiter between the substrings is ^*!%~ and then reassembles the strings and delimiters into a single new string where each of the substrings is in the reverse order from the original string. The method must return the final string. The expected output would be:
Token E^*!%~Token D^*!%~Token C^*!%~Token B^*!%~Token A
If I have a file in a path lke this:
C:demo estfile.txt
I can a split function and split on the backslash character to get the pieces. But if my directory could change this wouldn't work. So how would I instead parse out the last backslash and get the filename that way so that it wouldn't matter if the path changed?
How can i display the string variable data "234,345,567,678" into a listbox? i wish to parse the delimited string as seperate items.
View 4 Repliesi wrote a webservice method. i am using it with ajax jquery. method returns string[] array. ho can i read array's values using ajax jquery.
View 3 RepliesI need to read a html page and parse the contents of a table in that. I am using ASP.NET.Could anyone tell me how to do this.
View 2 RepliesI am having a table which holds the following columns, questionID, subjectID, question I want to select 30 rows randomly. I am using the following query.
[Code]....
Its working fine. I have created as SP for that as follows,
[Code]....
Its parsing successfully. But when I am executing that SP by exec spTest '1,5,6' I am getting an error
[Code]....
how to resolve this. I want to parse that parameter(@subjects) as string(Combination of subjectID) only.
i have a table that has some columns and rows i want this table to have borders that are visible inside it i want every column an row to be closed in borders how can i do that?
View 1 RepliesI have an asp:Table and around the mid point of the table there is a DDL with values 2-5. What I want to do is add the selected amount of rows using AJAX right after the table row that has the DDL in it. I know how to dynamicly crate the rows, the info in the rows, and how to use AJAX to make things. Problem is I can not put the ContentTemplate tag inbetween the asp:TableRow which would mark the location I want the dynamic rows to start being added. I did some searching on here but most posts I find start with making the table from code and not the asp:Table tag
View 2 RepliesI have one table named 'dbo.ac_Products' Within this table there is a column named 'ProductId' There is also another table named 'dbo.ac_CatalogNodes' Within this table there is a column named 'CatalogNodeId' and a column named 'CatalogNodeType'
I need to delete all the rows from 'dbo.ac_Products' and 'dbo.ac_CatalogNodes' where 'ProductId' = 'CatalogNodeId' and 'CatalogNodeType' = 1
how do create 10 cloumns and 10 rows in the table. The rows will came a1,a2....a10.
View 4 RepliesI am trying to generate a dynamic table andd add rows to a ASP.Net table control on my UI. My problem is as I add a new row from MyTable, in to another table the table I am copying from, will loose one row. Here is the code:
Table
myTable = new
Table
();
[Code]....
am just reading one row in every loop and add that row in to another table object, why is 'myTable' loosing loosing one row in each loop?
I am trying to delete or add rows in a table but since the table is in an update panel,upon deletion the row goes away and then comes back.I have tried using return false but it does not seem to work in IE or FF.
I am using the following code:
$(document).ready(function () {
$(.table).click (function ()}
(this).parent().remove();
[code]...
Basically I need a way to disable the postback.
I have table a and would like update table a whose values from table b, but not update all rows at table a. Only update record ID in table a match record ID in tableC.
Here is my query
update a
set a.Desc = b.Desc,
a.Value = b.Value
from TableA a, TableB b
where a.name = b.name
and a.ID = b.ID
and a.ID in ( select ID from TableC)
I only have 12 a.ID match TableC, but above query update whole TableA.
How to only update 12 record at TableA from TableB?
I am using Entity Framework to contact my data base. as part of my web code I am using Linq to entities, and I want to determine the number of elements in an anonymous type list. I can't get it to work, I get the exception: "LINQ to Entities does not recognize the method 'Int32 Parse(System.String)' method, and this method cannot be translated into a store expression."
var questItem = from chapters in context.TestChapter
from questions in context.Question
where chapters.ID == int.Parse(Request.QueryString["id"])
where questions.TestChapterID == chapters.ID
select questions.ID;
int numOfSteps = questItem.Count();
how can I get it to work?
obj.From = DateTime.Parse(txtFrom.Text, ci);
And it will give error String was not recognized as a valid DateTime. How it can be solved..
I have two possible header rows for a DataTable that I build dynamically. Setting the value of a cell works fine. Adding the cell to a TableRow works fine. The problem comes in where I have to build a second possible header row that uses the same cell.
An example is below.
trHead1 = New TableRow
trHead2 = New TableRow
tcCalc = New TableCell
tcCalc.Text = "Rates"
trHead1.Cells.Add(tcCalc)
trHead2.Cells.Add(tcCalc)
As soon as I make the second row add the cell, the cell disappears from the first row. This really doesn't make sense to me but that seems to be the way it is. If there is a work around other than duplicating the lines;
tcCalc = New TableCell
tcCalc.Text = "Rates"
I 'm curious to know how I could hide rows in my <table> in logical cases where, for instance, I have a list of radio buttons and depending on whether the user selects "Yes", the row below it appears for them to fill in some information.
View 9 RepliesHow i can make the normal search string to sql server full text search parse, because when we are user enyer search text "how to run windows schedule in C#", in database we have article to to this, but data not returning and sometime is say error in key word and etc.
View 1 RepliesI am doing a data warehouse project.I have two tables tblA (id, type) and tblB(city, no_crimes, type).I want to create (insert) a number of rows based on the value of no_crimes.For Example, in tblB(Leeds, 2000, murder). SO, I need to insert 2000 rows into tblA by a single INSERT statement (not 2000 statements).
View 3 RepliesI want to insert a table with 60 rows or more. When I do it, an error pop out.
[Code]....
How can I reset this default size?