I have an arraylist (eg: h1) contain some urls. eg: http://www.google.com,http://www.yahoo.com,http://www.xyz.com,.....
How can i put hyperlinks to each elements in that arraylist in c# ? Means by clicking on that url it should navigate to corresponding website.Can you give an example?? Also, how can i use 'Hyperlink' keyword in c# ?
I have the following hyperlink code that opens a new browser window to display a page. The page (browser) opens not full size (maybe something like 500x500). How can I modify this code to make the new browser window open full-size?
I would like to add a column in my datagridview that takes the value from the database and asigns it to the text of a linkbutton or make it a hyperlink. i know how to handle getting the value from the row but dont know how to make a value a link, or set the text to a link button
how to "discover" hyperlink in some text and convert that hyperlink in html hyperlink with asp.net (or javascript). For example, if a user enter this text:
You found it at [URL]
How can i found and convert in html like :
You found it at <a href='http://www.foo.com'>http....</a>
I would like to set up a keyword search with and/or wildcards which searches across a rather large tables with around 10,000 rows and growing.What would be the best to set this up ? I heard a lot about indexing etc, im using a SQL2005 DB.And I do not wish to purchase 3rd party software.
Possible Duplicate: When do you use the “this” keyword? In programming you can use the this keyword this.Textbox or just Textbox What is the best practice? Some benefits I can see is that using this makes it easier to see in intellisense and makes it easier to understand that it is a property. Currently I don't use this... I read in some article somewhere that the guy removed all the references, but I don't remember why.
My site (ASP.NET + C#) has FAQ data pull from another site's web service in XML format. The data size is pretty small (just about 50 faqs). I want to implement a keyword search for the FAQ and highlight the search keyword. What could be a fast and easy approach to do this?
My first thought is just using a C# string search or any XML search method. I know this is not scalable. But consider the FAQ is little, it may not need to index the FAQ. I could be wrong.
In one of my column have a comma separated list of keywords.I have to build a query that will return the matching rows whenever user enters the keyword.for ex.if my keywords are java,.net,sql,php,ajax then on search of java OR java,sql OR php,java should return the above row.
I am searching for products out of my database: AND (CONTAINS(P.name, @contains_key) OR CONTAINS(P.description, @contains_key) OR P.sku like '%' + @Keywords + '%')
As you can see I'm using the CONTAINS statement and searching against the name and description fields.I would like to give the results a weight (or score) based on how often the word shows up and in what field.Example:if the word shows up in the name field -- give it 2 points every time the words appears.if the word shows up in the description field -- give it 1 point every appearance.Then ORDER the query based on the Score. And, perhaps add a where clause that the Score > 1 or some value.I realize, I will probably have to re-write my query and this "point" system may not be possible, but I know there is a way to weight results, but can't find any help online. I would also assume, this would be done in temp tables and select statements and directly in the where clause.
I googled this problem and the solution for it was having a malformed connection string where the "provider" was being specified when it shouldn't have. Example conn string:Provider=SQLOLEDB.1;Integrated Security=SSPI;DATABASE=APInquiry;SERVER=SqlServer I'm not specifying the Provider so I think I have a different problem...???
I'm trying to "move" a LinqDataSource control to code behind to better control the query parameters. Problem I'm having is how does the "It" keyword translate to Linq To SQL syntax (not sure if I'm getting the terminology right here, but I think you get my meaning).
I was wondering how I would go about setting up the CASE keyword in SQL from my Web app. I have a table where I need to update anywhere between 20 and 300 rows with different values. My table looks like this
ID EventID SeatType SeatCount Status Comments
On my page, these rows are listed in a table with a textarea to add comments. So when I click a button I need to update All the comments for all the users of a certain "EventID".I think my SQL Statement should go something Like this:
UPDATE Events SET Comments = CASE [code]....
Is that correct? I would be getting the ID and comment from each row of the table. Also (using C#) what would be the most efficient way to get this information into the query? I was thinking to use a for statement but I hear many string concatenations requires lots of processing?
When I use single text box for date it work fine but when a'm check between two dates it gives error this is my code
Dim adp As New SqlDataAdapter("select EmplID='" + TextBox1.SelectedValue + "', date between ='" & TextBox2.Text & "' and '" & TextBox3.Text & "' ,RESULT = CASE WHEN exists(select * from AtdRecord where RecDate between ='" & TextBox2.Text & "' and '" & TextBox3.Text & "' Â and EmplID='" + TextBox1.SelectedValue + "') THEN ('P')ELSE ('A ' ) END,ResultType= CASE WHEN exists (select * from AtdRecLeave where StDate between = '" + TextBox2.Text & "'and '" & TextBox3.Text & "' and EmplID='" + TextBox1.SelectedValue + "') THEN (SELECT ResultType FROM AtdRecLeave WHERE EmplID='" + TextBox1.SelectedValue + "' and stDate between = '" + TextBox2.Text & "' and '" & TextBox3.Text & "') else ('-') END", con)eror=
Incorrect syntax near the keyword 'between'.Incorrect syntax near '='.Incorrect syntax near '='.Incorrect syntax near '='.
In SQL Query Analyzer I run this statement and I don't get anny error:
string select = "SELECT " + "aanvrager.werknemersnaam AS melder , hd_aanvragen.aanvraag_titel, " + "hd_aanvragen.aanvraag_omschrijving, hd_aanvraag_fase.fase_datum, " + "hd_melding_niveau_1.niveau_omschrijving AS 'Niveau 1', " + "hd_melding_niveau_2.niveau_omschrijving AS 'Niveau 2', " + "hd_aanvragen.outlook_id" + "FROM hd_aanvragen " + "INNER JOIN hd_meldingen ON hd_meldingen.melding_id = hd_aanvragen.melding_id " + "INNER JOIN hd_melding_niveau_1 ON hd_melding_niveau_1.niveau1_id = hd_meldingen.niveau1_id " + "INNER JOIN hd_melding_niveau_2 ON hd_melding_niveau_2.niveau2_id = hd_meldingen.niveau2_id " + "INNER JOIN hd_aanvraag_fase ON hd_aanvraag_fase.aanvraag_id = hd_aanvragen.aanvraag_id " + "INNER JOIN hd_statussen ON hd_statussen.status_id = hd_aanvraag_fase.status_id " + "INNER JOIN hd_werknemers AS oplosser ON oplosser.werknemer_Id = hd_aanvraag_fase.werknemer_Id " + "INNER JOIN hd_werknemers AS aanvrager ON aanvrager.werknemer_Id = hd_aanvragen.werknemer_Id " + "WHERE hd_statussen.status_id = 16";
But if I run this select-statement here: MyDataSource.SelectCommand = select; I get this error: Incorrect syntax near the keyword 'INNER'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'INNER'.
i have a sql server database which has a table name tourheader.in this there are some fields named as follows--Id, name, city, description, tourcode. on the page i have two text box destination and keyword. I want to search the database according to the destination and keyword. in the tourheader the fields contain description and keyword are name and city.
i have make aquery---- string queryString = "SELECT Id , name " + "FROM TourHeader WHERE name like'%" + key + "%'AND city like'%" + key + "%' AND city like'%" + destin + "%'AND name like'%" + destin + "%'";
I'm Using Entity Framework in my ASP.NET Web Application and I added Procedure tom my Model and Create Function for it which will return ObjectResult ... i want to add Include Keyword to that object Result ... so how can i get childs for that object result