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
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"
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?
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.
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..
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.
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?
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.
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)
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:
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
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.
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.
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?
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
