I want to simply search a database for a certain string, how can i accomplish this using linq and EF (if using these tools for it are not practical). I just want to take a string and search my usernames, the search should be able to handle things only parts of the username (using some sort of 'contains' function)
View 1 RepliesI have urls like this in my application: [URL]
Iphone, Ericsson, LG, HTCDesire are simple products and that is fine. It is the tabid/61/Default.aspx
I'd like to get rid of so that urls would look like these instead: [URL]
what kind of coding needs to be done here because I have a .Net open source CRMsystem that is native with these tabid/61/Default.asp but I'd like to override it with added VB.net code
Is there an easy way to search all the columns in the database?
I was the user to input a search word in a textbox and then search all of my database. I then want an array full of the primary keys of all of the records that had the search word contained somewhere in the record (i.e in any of the record fields).
This sounds really simple to me but I can't figure out how to do this and can't find examples online.
I am new here, I was thinking about using a text box to function as a search box. For example, I key in the ID, the value will be searched in the SQL database and return other values in the same row. I was thinking of combining this with GRIDVIEW.
View 2 RepliesI am trying to write a simple search form for our site. Here is my delima... I am trying to figure out that if there is nothing to search for in one textbox then search in the next textbox. The problem is that I dont know how to format my search string: For Example:
[code]....
I want to know how can I build a simple search engine which search from specific websites, for example it should search codeplex and msdn only and show the result on my page?
View 1 RepliesI need to create something which is like an Add friend function in my website which works like this:
1) User types in name of the person he wants to search in the search field and clicks enter
2) on the same page, the search result will come out with an "add friend" button beside every name
3) when the user clicks the "add friend" button, he will be brought to another page (or pop up with a message box?) with a text message field to send to the friend, and a submit button to submit the friend request.
4) over at the Friend's page, he will be able to view the add friend request and decide whether to accept or deny the friend request.
I want to display records based on the Prod ID entered by the user in the text box. Where can I find a tutorial to do that?
I can't find a simple one. I am completely new to .NET, and hardly know anything about grid view, SQL connections and stuff.
I need a step-by-step tutorial that explains how to do it. I want to learn about all of this.
Oh, BTW, I did establish an SQL connection and was successful in displaying my table on the web page. I want to learn how to search from that table and display records.
I have Visual Basic Studio Express 2013, is it even possible to create a website with this software, because I clicked on file and I don't see the option for a new website.
View 1 Replies now have tried to locate and find anything about how to make a
TEXTBOX and A Button "Search"
Problem is that I have made this "bellow" and when I then enter a "value" into texbox2 and hit enter on the button it wont show me the "emnenummer" that I have requested.
im not even sure this is the correct way to do a "search"
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><asp:Button ID="Button1"
runat="server" Text="Button" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"[code]....
i'm a begineer and i'm now learning how to develop a web page with asp.net in c# language.can anyone teach or show me a sample of login function which can put in my web page together with the page and database code.p/s: i do not use the MS sql server express in MS VS instead i using MS sql server 2005 as my database.
View 2 RepliesI have a simple js function that counts down the characters in a text box, and it works in every browser EXCEPT Firefox (3.6.6). I've tried changing some syntax, but nothing has worked so far.
[Code]....
I have an Ajax function called from JQuery that goes to a webservice to return a value. I need a SIMPLE example on how I can do this. I've been going nuts with serializing and every other aspect of this topic. I need to return either an ArrayList with ONE string field or a DataTable of some kind. Either way, I'm populating it into a DropDownList. I'm willing to consider alternatives to this idea. (Background info - I get a value from a textbox and I need to run it through a DB to get an associated value or set of values). I'm being really general so that someone can show a simple example.
View 15 Repliesi want make the search box for my website same like google have for it's site(ajax search box).i want as soon as i type something in my search box the realted link's of my site should be availble for the user.
View 2 RepliesI have a user control with a datalist. I just want to do some simple binding but keep getting an object reference not set to an instance of an object error. The following is the code, I am sure I am just missing something simple:
Dim dc As Forms.DataClassesDataContext = New Forms.DataClassesDataContext
Dim formQuery = From fq In dc.v_form_questions _
Where fq.FormTypeID = FormTypeID _
[code]...
When I debug, I see values for the formQuery; I am also able to loop through the formQuery and response.write a field out, however every time I try to bind it to a databound control, I get the Object reference not set to an instance of an object error.I initally was using a simple LinqDataSource object, but needed to set the where parameter to the FormTypeID property of this usercontrol. I had a Where condition defined on Page Init, but started getting the object reference error.
have this site that has an api that can provide city name if I send my zip code as a parameter. http://www.postnummersok.se/api?q=16447the result is returned as a json object. Now i just want to read the result in my js function.I have tried the following but it always returns null:
function postnr() {
I have records with and without a email entered in the field called 'email'.
This one works:
Return From p In db.myTable _
Where p.Email.Length > 0 _
Select New With {.p.Name, p.Email}
but this doesn't
Return From p In db.myTable _
Where p.Email.Length = 0 _ ( nor does Where NOT p.Email.Length > 0 )
Select New With {.p.Name, p.Email}
Am I missing something?
I am new at json, I want to make jquery ajax call to a asp.net webmethod to get back simple JSON object using string builder
[WebMethod]
public static string GetmyJSON()
{
[Code]....
But My alert message showing undefined instead of Manas why, Where I am doing wrong isn't possible to return a json object using string builder ? if possible how to write it.
I have used querystrings in many webpages. When user click hyperlink then it moves to next page but there is a very long string is being displayed in the Address bar of the browser.
I just want to show like this:
[URL]
Not like this:
[URL]
I have a query which need to search on account table where search criteria looks at either partial name(string column) or partial accountid (integer column).
Linq doesn't allow tostring on integer column to find partial search. The example would be search account number which begins with 124. There might be account numbers like: 1247, 1249 etc which need to be returned. On the name side, searching for string that begins with joh would return john, johk, johp etc.
FYI: The query should return Account table records not annonymous types.
[Code]....
I need some guidance for an application I am working on. I have searched the web and the forum and found parts that answer my questions but I want to do this correctly. My solution uses LINQ to SQL to model the db and I have a repository that is querying my db everytime a controller needs to get some data for the view. I am initially anticipating a maximum of only about a few hundreds hits per day (if that). The website is a directory, with listings and requires a search functionality.
1. What options should I consider to avoid having my repository query the db everytime
2. The site contains a 'search' option, how can I implement this against my repository?
I guess I'm really looking for someone to point me in the right direction. So far I've looked at 'caching' the LINQ to SQL model and Lucene.NET but both seem overkill or am I missing the point?
what I'm looking to do is to get a web site search function where I can enter the URLs and body text myself rather than running a spider unless the spider can handle my url querystring structure. Obviously, something automatic would be best but I'm not too choosy as long as it is free.
View 2 RepliesI'm on training in a company and i'm making a web application with an SQL server database..Now I created everything but i need to know how to program a search function..t's the point that when I search to a computer it'll put all the pc's with the matching word into the dropdownlist..Like when you search for "A" I get all the pc's wich has an 'A' in their name, I made everything, in the query builder I made a parameter with the textbox but i need not EXACT the value I typed but verything wich has it in it.
View 6 Repliesi am newer to asp.net and i am trying to make a search engine for my site like this one [URL]. i am able to get the SEO friendly URL like this with the keyword and redirected to the Search.aspx.
Now how can i get result like this, i need some assistance to start. i have used contain attribute in LINQ query and get results. but i want to split the search term and i don't know how and then want to search the each word using contain attribute and then want to get results like this guy. you can reffer me anything tutorial or any componenet which is made for asp.net c#.
I have two submit buttons on the page, one a login (top of the page) and the other a search box (half-way down).
When entering text in the search box and then clicking submit the login box validation method is called (javascript popup).
How can I make the search box submit instead of the login?