DataSource Controls :: Parsing Text In A Query?
Apr 14, 2010
I have 2 tables A and B. Table A has a text field, fundIDs with comma delimited values like 23,44,55 etc. I would like to select all the records in table B whose ID matches the values in the fundIDs field from only one record in Table A. So, I need a function which first gets 1 table A record and uses the fundIDs field values to query and return all the matching records from Table B. I don't know how to parse and query in sql
[code]....
View 9 Replies
Similar Messages:
Aug 22, 2010
I have the a text box into which I paste the following text:
England has 80 skyscrapers, 2405 houses, 0 spaceships
I want to parse the contents of this textbox and extract the integers to variables eg:
[Code]....
I tried the following regex but It doesn't work:
Dim skyscraper As
New
Regex("/([0-9,]+) skyscrapers/")
Any pointers as to what I should be doing?
View 7 Replies
May 31, 2010
how to get sql query output in text file?
View 1 Replies
Feb 24, 2010
I'm looking to parse the cs(Referer) column in one of log files for the following data found intween the followingbolded URL parameters and was wondering what commands in a select statement would be the best way for doing this.[URL]Example - I would be able to parse the "2" found after "start=" and the data "castle%2bshore" inbetween "%3Fq%3D" and "%26"
View 1 Replies
Aug 25, 2010
I'm developing my own forum, and now I've come to the task of replacing text with smileys (such as colon and left parethesis to a smiling ball). this works well with the Replace function, such as
dim smile as string = "<img alt=""smiling"" src= ... "
txt = txt.Replace(":)", smile)
myLabel.Text = txt
However, I'm worried about speed, because this approach means running Replace on every message a bunch of times (each for each emoticon, quote amrking etc). Is there a smarter way to do this, or is this the reason why forums are, in eneral, so slow?
View 6 Replies
Aug 22, 2010
1. I have a GridView on my page and it uses sqldatasource with parameterized query. What I want to do is, on page load (where nothing has been selected so no parameter supplied), I want it to query everything (something like SELECT * FROM [this_table]) but since my SelectCommand is something like
SELECT * FROM [this_table] WHERE [this_column] = @someParameters AND [that_column] = @someParameters.
Can I play around with default value to achieve something like that but how ? Now, when the page loads, it doesn't show anything (No Gridview).
2. On my page, I made something like (username, gender, address, and more) and one single search button. That means, no single control enable auto postback. What I am trying to accomplish is building dynamic query
(if username specifed -> SELECT * FROM [this_table] WHERE [username] LIKE @username).
If both username and gender are specified (SELECT * FROM [this_table] WHERE [username] LIKE @username AND [gender] = @gender) and you know the rest. How can I do this using GridView and SqlDataSource ? To my knowledge, I can only specify one SELECT statement in a sqldatasource.
View 11 Replies
Feb 1, 2011
I am trying to add some widget-functionality to the CKEditor using custom plugins.. Does anyone have any experience parsing the resulting html or getting the job done in another way?
What I am looking for is to add something like a news-block at a user specified place in the text, like an ordinary image..
I have thought of several options, like just adding an iframe that takes care of the content automatically (from the src url in the iframe), but that way I loose the text formatting/css.. I have also thought of adding the content dynamically with some ajax onload, but that way I might loose some viewers..
Finally I have come to the conclusion that using custom tags like <something options="..." /> or even <div class="something" options="..."></div> and then replacing them with usercontrols is the best solution.. But how to accomplish this? I know how to add controls to other servercontrols, but how to add them easily in some random text? It could be something like putting the text prior to the widget and after into a placeholder and adding the widget-control in between..
View 1 Replies
Jan 15, 2010
[code]...
This query works perfectly on the query analyser.
But when configuring the Table adapter ,I try executing the query and i get 0 rows affected.
What could I be getting wrong in this case.
NB:Existing GalleryID has been supplied.
View 1 Replies
May 17, 2010
By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
View 10 Replies
Mar 10, 2010
select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid
View 5 Replies
Jan 21, 2010
I've got a query such as
Dim MediaQuery =
From m
In dB.DOWNLOADS _Where m.ID = id _Select
which returns a record from the database. One of the fields in the record is a FK to another table. I need to read this value to be able to set a dropdown based on the ID but I can't work out how to access it. For a standard record I can just do the following txtTitle.Text = MediaQuery.FirstOrDefault().TITLE
However with the foreign key it doesn't work like that. I've tried drpGroup.SelectedIndex = MediaQuery.FirstOrDefault().DOWNLOAD_GROUPS.ID where DOWNLOAD_GROUPS is the FK field but it returns Object reference not set to an instance of an object. If you're simply wanting to read some values from a single db record in the entitiy framework and one is a foreign key how should I go about getting the value?
View 2 Replies
Apr 14, 2010
SqlDataSource1.SelectCommand = "select * from [xw] where [CustName] Like '" + TextBox2.Text +
"%'"
How Can I make two textboxt1.text and texbox2.text ?
SqlDataSource.selectCommand = "Select* from [xw] Where [Country]= textbox1.text and [CustName] Like '"+Textbox2.text+"%"
View 7 Replies
Feb 23, 2011
i've currently got a registration form that works fully however i've run into a problem getting the validation text to appear. basically i want the form to present the following message "Congrats you are now registered and can login using the login page" only if all the fields in it are filled in. However with what i have coded below it always presents the message, i am using asp.net 2.0 with webmatrix.
[Code]....
View 7 Replies
Sep 2, 2010
I want to have a gridview which first column is a link to another page. For that I want to create a
link text through a SQL query!
I have the following piece of SQL code, to create the first column of the gridview:
[Code]....
View 2 Replies
Jul 21, 2010
I have this code:
SqlDataSource1.SelectCommand = "Select (AttributeName +'|'+ Value) DisplayTextField tbl_PaymentDetails FROM WHERE AttributeName =" Credit card number ';
[code]...
DropDownList3 click on some text.
Example:
dropdownlist3 ... Test1 (Read in the table)
dropdownlist3 ... Test2 (read from table)
dropdownlist3 ... Test3 (read from table)
[code]...
View 23 Replies
Apr 21, 2010
I am using Querystring "ddl4" to pass on value of a drop down list to the next page where I am using that value in the WHERE clause of a SQL command. I also need to check whether ddl4 is blank or not which I do using If Else in SQL command. I am not able to run the query where the Querystring ddl4 IS NULL
This is the sample link with the Querystring ddl4 carrying a blank value:
[code]....
View 2 Replies
Sep 19, 2010
I'm tyring to write a simple DetailsView only used for inserting new records that will pre-fill a textbox with a query string value. Here's the DetailsView:
[code]....
All I want to do is set VenueID_FK.Text to = the "VenueID" querry string. I also want the user to be able to see the VenueID number as they are filling out GridView1.
I know this is probably a simple thing, but I am very new to asp.net. I thought I could handle this in the page load event, but when I try something like this
TextBox VenueID_FK = (TextBox)DetailsView1.FindControl("VenueID_FK");
And then follow by setting the Text property programitically. I've accomplished something similar to this on a different page using a FormView, but only for ReadOnly mode and it was handled in the databound event on that page.
I get the error "The name 'DetailsView1' doesn't exist in the current context." when trying to do the above mentioned. When trying the same line in the databound event here, I get the same error.
View 1 Replies
Feb 13, 2010
How 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 Replies
Apr 13, 2010
I have one query in my project (saved in folder SQLQueryes, Query.sql) and i need to execute it. Also, i have one parameter in script and i need to include him also. How?
View 8 Replies
Feb 18, 2010
SQL Query with IF and Select
View 2 Replies
Jun 10, 2010
if there is no relation bettwenn two tables why do i need union for example like below Please
can u inform me
SELECT categoryId
FROM categories
UNION
SELECT shipperId
FROM shippers
View 3 Replies
Jun 25, 2010
I´m using Linq to Sql in my asp.net application, but the problem is:I have a query like this:
[Code]....
My query is not returning anything, how do I do to get this?my problem is with this interval I need to have.
View 2 Replies
May 13, 2010
i want to know that should first name and last should be kept as sperate field or merged into single attribute. The Basic problem i am facing to keep first name and last name in seperate fields is that i cannot effectively use like query for searching a record by name
View 7 Replies
Mar 15, 2010
I have table in database with xml field and data like below
[Code]....
there are no records found
View 1 Replies
May 26, 2010
How do I use a Parentheses in an SQL query, example:
SET [myrow] = 'New Value' WHERE [myrow] = 'my (old) value'
View 2 Replies