Visual Studio :: VWD - Database Search Results On Different Page
Apr 2, 2010
Using Visual Web Developer I have created a page (Search.aspx) with a Text Box(SourcingIC) and Search Button. I do not want data (Gridview) displayed on the Search.aspx page, just the Text Box and Search Button.
A user inserts name in the text box(SourcingIC), presses the search button and then is directed to a new page (SearchResults.aspx) that displays the records found for SourcingIC. What coding is needed to make this happen? Can you provide me with what actual coding would need to be added?
I am trying to develop a page where I am trying to search a database (MyQSL) and display the data in a table format. Some of the database entries, like category, is stored as integer values, but I want to display the category name in the search result (not the corresponding integer value). I have also another issue, every time I change the dropdown list values (which are having "auto postback" enabled) the <EmptyDataTemplate> is returned. At this moment I am using GridView. But I am ready to change this to any other method, like repeater or whatever...
I am new at this VB/Microsoft Visual Web Developer 2010 Express thing. I am amaze that I even got this far and thatI manages to make this search page work. Below is the code and picture for this search page. It's working. However I want to transfer the result/the gridview onto a second page Result.aspx. But I tries all kind of thing and it just doesn't seem to want to cooperate with me. If anyone can give me some hint/some sample codes on how I might be able to transfer controlfrom one page onto another. I just have to learn it from a class extra credit project. Also in the picture above I am using a direct connection to an Access database not the ObjectDataSource. I was just playing around with it to see which is better. But I ended up going with direct connection to Access database.
<%@ Page Language="VB" ClassName="SenderClass" EnableSessionState="True" %> <head> <script runat="server"> Sub closeSite(ByVal sender As Object, ByVal e As EventArgs) Response.Write(" <script language='javascript'> { window.close(); }") End Sub Sub Page_Transfer(ByVal sender As Object, ByVal e As EventArgs) 'Storing in Context Session("SearchBox") = SearchBox.Text Session("ListBox") = ListBox1.Text Session("DropDownList") = DropDownList.DataTextFormatString 'Context.Items("DropDownList") = DropDownList.Text 'Server.Transfer("SearchResult.aspx") End Sub Sub Page_Transfer2(ByVal sender As Object, ByVal e As EventArgs) Dim field1 As String = ("SearchBox") Dim field2 As String = ("ListBox") Dim field3 As String = ("DropDownList") 'Dim TestString As String = ("SELECT * FROM [Books] WHERE (([Title] = ?) AND ([Category] = ?))") End Sub Sub Test(ByVal sender As Object, ByVal e As EventArgs) AccessDataSource1.SelectCommand = "SELECT * FROM BOOKS WHERE " If DropDownList.SelectedIndex = 0 Then AccessDataSource1.SelectCommand += String.Format(" ((Category = @Category OR 'Computer' ") AccessDataSource1.SelectCommand += String.Format(" OR 'Literature & Fiction' OR 'Reference'") AccessDataSource1.SelectCommand += String.Format(" OR 'Romance' OR 'Science'") AccessDataSource1.SelectCommand += String.Format(" OR 'Home Design' OR 'Accounting & Finance'") AccessDataSource1.SelectCommand += String.Format(" OR 'Horror' OR 'Refernce'))") Else AccessDataSource1.SelectCommand += String.Format("(( Category = @Category ))") End If For Each Item As ListItem In ListBox1.Items If Item.Selected = 0 Then AccessDataSource1.SelectCommand += String.Format(" AND ((Title Like @Search + '%'", Item.Text) AccessDataSource1.SelectCommand += String.Format(" OR [Author(s)] Like @Search + '%'", Item.Text) AccessDataSource1.SelectCommand += String.Format(" OR Publisher Like @Search + '%'", Item.Text) AccessDataSource1.SelectCommand += String.Format(" OR ISBN Like @Search + '%'", Item.Text) AccessDataSource1.SelectCommand += String.Format(" OR Price Like @Search + '%'", Item.Text) AccessDataSource1.SelectCommand += String.Format(" OR Category Like @Search + '%'", Item.Text) AccessDataSource1.SelectCommand += String.Format(" OR Year Like @Search + '%' ))", Item.Text) End If If Item.Selected = 1 Then AccessDataSource1.SelectCommand += String.Format(" AND (Title Like @Search + '%' )", Item.Text) End If If Item.Selected = 2 Then AccessDataSource1.SelectCommand += String.Format(" AND ([Author(s)] Like @Search + '%' )", Item.Text) End If If Item.Selected = 3 Then AccessDataSource1.SelectCommand += String.Format(" AND (Publisher Like @Search + '%' )", Item.Text) End If If Item.Selected = 4 Then AccessDataSource1.SelectCommand += String.Format(" AND (ISBN Like @Search + '%' )", Item.Text) End If If Item.Selected = 5 Then AccessDataSource1.SelectCommand += String.Format(" AND (Price Like @Search + '%' )", Item.Text) End If If Item.Selected = 6 Then AccessDataSource1.SelectCommand += String.Format(" AND (Category Like @Search + '%' )", Item.Text) End If If Item.Selected = 7 Then AccessDataSource1.SelectCommand += String.Format(" AND (Year Like @Search + '%' )", Item.Text) End If Next Dim KeywordCom As String = AccessDataSource1.SelectCommand.ToString Context.Items("Test") = KeywordCom.ToString Server.Transfer("Result.aspx") End Sub </script> </head> <html> <body> <a href="Default.aspx">Home</a> <a href="About.aspx">About.aspx</a><a href="SearchResult.aspx">SearchResult.aspx</a> <form id="form1" runat="server"> <h3> Search for: <asp:TextBox ID="SearchBox" runat="server" Width="219px" /> <asp:Button ID="Button1" Text="Search" Width="146px" AccessKey="S" runat="server" Enabled="True" Onclick="Test" height="26px" style="position: relative"/> </h3> <h3> Search In:<asp:ListBox ID="ListBox1" runat="server" style="margin-left: 6px" Width="221px"> <asp:ListItem>Keyword Anywhere</asp:ListItem> <asp:ListItem>Title</asp:ListItem> <asp:ListItem>Author(s)</asp:ListItem> <asp:ListItem>Publisher</asp:ListItem> <asp:ListItem>ISBN</asp:ListItem> <asp:ListItem>Price</asp:ListItem> <asp:ListItem>Category</asp:ListItem> <asp:ListItem>Year</asp:ListItem> </asp:ListBox> </h3> <h3> Category: <asp:DropDownList ID="DropDownList" runat="server" Height="16px" Width="162px"> <asp:ListItem>All Categories</asp:ListItem> <asp:ListItem>Computer</asp:ListItem> <asp:ListItem>Literature & Fiction</asp:ListItem> <asp:ListItem>Reference</asp:ListItem> <asp:ListItem>Romance</asp:ListItem> <asp:ListItem>Science</asp:ListItem> <asp:ListItem>Home Design</asp:ListItem> <asp:ListItem>Accounting & Finance</asp:ListItem> <asp:ListItem>Horror</asp:ListItem> </asp:DropDownList> <asp:Button ID="Button3" runat="server" Text="Exit Store" Width="146px" height="26px" /> </h3> <p> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="AccessDataSource1" > <Columns> <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" /> <asp:BoundField DataField="ISBN" HeaderText="ISBN" SortExpression="ISBN" /> <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" /> <asp:BoundField DataField="Author(s)" HeaderText="Author(s)" SortExpression="Author(s)" /> <asp:BoundField DataField="Publisher" HeaderText="Publisher" SortExpression="Publisher" /> <asp:BoundField DataField="Year" HeaderText="Year" SortExpression="Year" /> <asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" /> <asp:BoundField DataField="Category" HeaderText="Category" SortExpression="Category" /> <asp:ButtonField ButtonType="Button" CommandName="Select" HeaderText="Select" ShowHeader="True" Text="Select" runat="server" /> </Columns> </asp:GridView> <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/Books.accdb" > <SelectParameters> <asp:ControlParameter Name="Category" ControlID="DropDownList" PropertyName="SelectedValue" /> <asp:ControlParameter Name="Search" ControlID="SearchBox" PropertyName="Text" /> <asp:ControlParameter Name="InColumn" ControlID="ListBox1" PropertyName="SelectedValue" /> </SelectParameters> </asp:AccessDataSource> </p> <p> </p> <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label> </form> </body> </html>
I have Visual Studio 2005 and 2008 installed on my machine. When I bring up the Find and Replace box in 2008 in any project the 'Look at these file types:' option is blank however in 2005 it keeps defaulting to the file type of RemoveFile. If I don't remember to clear it then it causes my search to fail. Does any one know how do I reset this value or remove this default option so the file type is not set and it looks at every file type when I search for a word.
I am trying to create a search page, this allows the admin to search through the entries in the database by certain criteria, such as province (like state but diff country)
Here is the code I have so far. The problem is that I am not getting any errors. But I am also not getting any results. The page just posts back and returns to the blank search page. The GridView does not display any results.
here is my code as it stands:
Imports System.Data Imports System.Data.SqlClient Imports System.Web.Configuration Partial Class administration_Search Inherits System.Web.UI.Page Protected Sub ProvinceButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ProvinceButton.Click 'get the search string from text box Dim Search As String Search = ("%" & ProvinceButton.Text & "%") 'if the string has value then continue with search If Len(Trim(Search)) > 0 Then Dim con As String = WebConfigurationManager.ConnectionStrings("fubar").ToString() 'build sql string Dim s As String s = ("SELECT id, surname, name FROM orders WHERE province like @strSearch") 'declar connection Dim c As SqlConnection = New SqlConnection(con) 'add command Dim x As New SqlCommand(s, c) 'add parameter x.Parameters.AddWithValue("@strSearch", strSearch) c.Open() Dim r As SqlDataReader = x.ExecuteReader GV.DataSource = r GV.DataBind() c.Close() Else Province.Text = ("Please enter search terms") End If End Sub End Class
On the .aspx page I have a textbox (id: province) and a button (id:submit)
I want to search record based on Name, ID, Date, Report Type. from same table with one textbox. I can do search with one column how can do it with multiple column ...
protected void Button2_Click(object sender, EventArgs e) { DateTime dt = Convert.ToDateTime(TextBox1.Text); SqlCommand cmd = new SqlCommand("SELECT * FROM Transactions where report_type = @report_type "); cmd.Connection = con;
I need a query to fetch records from data from database based on partial text entered in textbox like search data from College table based on College Name entered in text box. I want that all record containing that College name displayed in grid view.
I would like to show the results from the search in another page. How do I show the results of the search in another page when the user press the button?
Anyone can help providing some code/suggestion on how to implement Search and displaying results on same page using MVC and simple way to implement paging with Ajax.
Below are the search parameters(search Page looks like below) i need to pass to db to get results. We are using MVC2 with entity framework.
I've an ASP.NET page with a textbox and a option from user of the following choices: Wikipedia, Google, Dictionary.com, Flickr, Google images.The user enters a word(s) in the textbox and selects a choice among the following.
Depending on the choice select by the user I wish to return the following.
Wikipedia: Return the content and link to the page corresponding to the topic about the word.
Google: Return the top 10 results of google search for this word.
Flickr: Return a few images atmost 10 images from flickr search
GoogleImage: Return a few images from google image search.
when i attach to process results an error..plz help mewebdev.webserver.exe has stopped working.Stopped workingProblem signature:Problem Event Name: CLR20r3Problem Signature 01: webdev.webserver.exeroblem Signature 02: 9.0.0.0ignature 07: 2c9 cid=0x0409
I have created a search page using Visual Web Developer and Access as the database. Instead of displaying the results from the search in Gridview on the same page what would be the coding to pass the results to a new page titled "Search Results".
I'm developing a search page that will display the results in a gridview. The codebehind (in VB.NET) uses a SQL command to fill the gridview.
The gridview does have paging and sorting enabled. Once the search button is clicked the initial results are displayed, if the user clicks on a sorted column or wants to advance a page the gridview disappears. Enable Sorting And Paging Callbacks is set to True. Enable ViewState is also set to True.
how to implement Search and displaying results on same page using ASP.net webform and simple way to implement paging with Ajax. The top of the page should have the search criteria and once button clicked, it should display the result below with checkbox so that user can select and delete any / all of the search result.
So I have a website that I recently made changes to, and one of the changes was removing a page from the site. I deleted the page, it doesn't exist anymore.
However, when you search for my site, one of the results is the page that I deleted. People are clicking on the page and getting an error.
How do I remove that page from the search results?
I will explain this as best I can. When a user types in a search field (ASP Textbox field) and presses enter a list of search results are displayed if there is a match. The search results display in the second half of the page. A video will play in the top half of the page but not until a querystring is passed to the page. The querystring value comes from the list of displayed search results. When a user clicks on results from the search (ASP Hyperlink) the querystring value is passed to the same page he/she is on and a video starts playing. My major problem is when I pass the querystring value I do not want to lose the list of search results. It looks like in ASP.net the page refreshes each time you pass a new value. It's not optional to make the user click the back button to see the orginal search results. I'm assuming it has something to do with maintaining session state but I am no expert. YouTube and many other sites do this similar functionality so I figure it must be possible in ASP.Net.
So basically, I want the image that I searched for to continue to display even as I select them and pass there videoID to the SQLDataSource that is expecting the QueryString. All values are being pulled from a SQL 2008 database. When the QueryString value is passed a video will play based on the value that was passed. Currently I have this working but the problem is when I pass the querystring my displayed search results are gone or disappeared. I was thinking that maybe if I could pass the querystring value and the search results value it would work. It would mean reposting the data again but I guess that's a work-around. So for instance if a user typed 'biceps' in the orginal search some kind of way I would store biceps somewhere and pass it again along with the querystring for the video. It doesn't seem like the most eficient way to do it but if someone on here suggest that's the best way I will also need help with that syntax. I am using ASP.Net 4 and VB instead of C#.
I am trying to debug a project, suddenly I'm running into an issue where enumerating any object collections results in a timeout if I try to view it.If I run the program normally I have no issues. If I try to view any collection, such as a list, I get a timeout error and the whole thing bombs out.I thought something might be going on with one of my more complex collections so I tried creating just a normal list of strings as follows...
List<string> blah = new List<string>{"fsdf","fsdg","Gt","gsersg","ser","gersgxdrsd"};
I know both these software are old and that I can update to newer version. But I need to do it with those software in particular.I have Visual Studio 2005 and Visual SourceSafe 6 installed on my computer. When I try to open Visual SourceSafe 6 database using Visual SourceSafe 6 directly, I have no problem at all.Then I try to open a project solution I took from SourceSafe using Visual Studio 2005. Right away I receive this messageThe solution appears to be under source control, but its binding information cannot be found. It is possible that the MSSCCPRJ.SCC file or another item that holds the source control settings for the solution, has been deleted. Because it is not possible to recover this missing information automatically, the projects whose bindings are missing will be treated as not under source control.
Then an invite to chose a SourceSafe Database open. I click on BROWSE. First thing I noticed : The SourceSafe available databases list is empty (while I remind, it's not in SourceSafe 6. I can see there the COMMON database and the VSS database which is located on a different server on our network. Before that, I went in TOOLS->OPTIONS->SOURCE CONTROL, and make sure Visual Source Safe was selected as the Plug-in to use for a Source Control).So I click again on Browse, and locate my srcsafe.ini file. Everything is OK. It evens confirm me that my database path is \dev2k3programmationVSS and that my database name is indeed VSS. So it found it. I then click on OK.
But when I do, the Database is not added to my available list, at all. The result, I can never select a source control, ever, which end in me not being able to work connected to the main source control of our network. Everything is working fine on every other computer in our company. Only this one have problem.Did I give enough description to my problem? I really need help on this one, because working disconnected from Source Safe can give a lot of pain to our team. Can anyone give me an hand? If you need any more info, just ask.
As a newbie coming from a Java background with tag libraries I wonder if there is a simple possibility to render areas depending on backend values.For example if I have search form I do not want to render the table for the search results as long as the user hasn't pressed the search button. Of course I can iterate over the model containing an empty list but this does not allow to suppress rendering the whole table.Using web forms I would just control the visibility of the affected tag(s) in the code behind file but how do I do this with ASP.NET MVC?Can I use a partital view for a case like this? But I think I would have the same problem. How can I determine if a partial view is rendered (e.g. the whole result table with header)?
i have some text boxs in a page and in the same page there will be a table 'grid' like for holding the search result.When the user start editing and of the textbox above, the search must start by sending all textboxs values to the server 'ajax', and get back with the results to fill the below grid.
Notes:This grid should support paging, sorting by clicking on headers and it will contains some controls beside the results such as checkboxs for boolean values and links for opening details in another page.
I know many ways to do this some of them are:1- updatepanel around all of these controls and thats it "fast dirty solution"
2- send the search criteria using ajax request using JQuery post function for example and get back the JSON result, and using a template will draw the grid "clean but will take time to finish and will be harder to edit later".
3- ....My question is:What do you think will be the best choice to implement this scenario? because i face this scenario too much, and want to know which implementation will be better regarding performance, optimization, and time to finish.
I have to refactor really huge project with a lot of user controls where each has a lot of element sometimes with no unique id. I mean that in one page Image element has ID="img" as well as DevExpress popup control (containig image) in another page. When I try to search concrete ID, I found many of them in code behind files (.cs) but I need only these which I can find in *.ascx files. Can I do such thing?
