hope you guys are doing well! I have a question and no answer yet how to do it. Right now i can have 1 dropdownlist and when i press on my search button its show the result of the query the user ask
but how to do it with two seperates dropdownlist ? isnt it with inner join ? also if the value is null what to do ?
here is my sample little code for a sample search
[Code]....
I created 3 product table . A,B and c.
I show product of table in different gridview.
Now I am using one search box. but how to search product name with image in one query all of three table....
Simple how to search product from multiple table and show result...
I have a textbox and a gridview which is bound to a table what I want to achieve is a solution where lets say there are two records - e.g. "1. Book and 2. Red", i want a user to type in those words and the gridview shows the results as followed;
1. Book
2. Red
I have set up the sql data source and everything and my like operator is this.
LIKE '%' + @record + '%'
how can I solve this problem?
how to use a multiline text box that i could copy data into. Lets say addresses one on each line and then click submit and have it display those records in the database (SQL) in a gridview?
View 7 RepliesI hope somebody can guide me to overcome below challenge.
My form has three dropdownlist controls and one listview. Everything works fine if I don't try to pass multiple querystrings to get different URL on the same page. But challenge comes when I try to pass multiple querystrings to show different URL's for SEO.
Following are the ID's:
1. DropDownList1= Country
2. DropDownList2= State
3. DropDownList3= City
4. Listview1= Resturants (I am not including Code .....yet)
With my code DropDownList1 holds the state and passes the value to URL OK .When I try to select
different value in DropDownList2 or DropDownList3 are able to
pass the vaule to URL but in the form they stay on the first item and doesn't change and so does Listview1.
Here is my code:
<%@ Page Language="C#" AutoEventWireup="true" %>
<%@ Import Namespace="System.Data" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (false == IsPostBack)
{
if (Request.QueryString["Brand"]!= null)
{DropDownList1.SelectedValue = Request.QueryString["Country"].ToString();}
if (Request.QueryString["Gender"]!= null)
{DropDownList2.SelectedValue = Request.QueryString["State"].ToString();}
if (Request.QueryString["Category"]!= null)
{DropDownList3.SelectedValue = Request.QueryString["City"].ToString();}
}
}
protected void DropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
Response.Redirect("/resturants.aspx?State=" + DropDownList1.SelectedValue + "&State=" + DropDownList2.SelectedValue + "&City=" + DropDownList3.SelectedValue);
}
</script>
<head></head>
<body><form id="form1" runat="server">
<asp:DropDownList id="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource2" DataTextField="Country" DataValueField="Country" ForeColor="#808080" OnSelectedIndexChanged="DropDownList_SelectedIndexChanged" >
</asp:DropDownList>
<asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="../database.mdb" SelectCommand="SELECT DISTINCT [Country] FROM [Country] ORDER BY [Country]">
</asp:AccessDataSource>
<asp:DropDownList id="DropDownList2" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource3" DataTextField="State" DataValueField="State" ForeColor="#808080" OnSelectedIndexChanged="DropDownList_SelectedIndexChanged" >
</asp:DropDownList>
<asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="../database.mdb" SelectCommand="SELECT DISTINCT [State] FROM [table] WHERE ([Restuarant NAME] LIKE '%' + ? + '%')">
<SelectParameters>
<asp:controlparameter ControlID="DropDownList1" Name="Restuarant_NAME]" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:DropDownList id="DropDownList3" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource4" DataTextField="City" DataValueField="City" ForeColor="#808080" OnSelectedIndexChanged="DropDownList_SelectedIndexChanged" >
</asp:DropDownList>
<asp:AccessDataSource ID="AccessDataSource4" runat="server" DataFile="../database.mdb" SelectCommand="SELECT DISTINCT [City] FROM [table] WHERE (([State] = ?) AND ([Resturant NAME] LIKE '%' + ? + '%'))">
<SelectParameters>
<asp:controlparameter ControlID="DropDownList2" Name="State" PropertyName="SelectedValue" Type="String" />
<asp:controlparameter ControlID="DropDownList1" Name="Resturant_NAME" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
Please refer the link. [URL] ....
My question is how can I search GridView with multiple TextBoxes and pass multiple parameters to this sql command.
SqlCommand cmd = new SqlCommand(query + id);
in asp.net i want to create a button to serach from in two textbox. there are 2 possibilities;
1-only one textbox entering value (name)
2-both of textbox entering value (surname)
how can i do this? (by the way i am novice in asp.net)
I am stored date in "smalldatetime" datatype as in databse.How can i particular textbox entered date(dd-mm-yyyy) used to fetch the row information from databse and shown in a gridview.
View 1 RepliesI have a problem i have a string with multiple customerid which is seperatd by ,
the problem is if if split the string by comma, i want to fetch customername from customerprofile table on the basis of these customerid.
I have been trying to make this work for a while, but I have not been yet able to figure this put. I am using VS 2008 and mysql database. I wrote a query and checked to see if it works in database. It does.
I have a gridview, whose select command is that query. But for some reason, I just get all the rows from one table only. I rechecked my datasource and it is ok. I read on some discussions that it is NOT possible to have data from two tables in a gridview. Is that true? If that is not true, how can I have data from multiple tables in a gridview? Or any other web control for that matter.
I have one textbox and one button when i enter values in textbox separated by comma and click on button it should display details of all the numbers from database in gridview. the values are cid nos such as 12001,12002 when i enter both values by giving comma it should display details of both numbers from database.
View 1 RepliesI tried out another article (Search GridView with Paging on TextBox KeyPress using jQuery in ASP.Net ). Need to add more search text boxes to that gridview with Paging?
View 1 RepliesI want make a search by which want find data and display in gridview.
View 1 RepliesI've created a filter textbox for searching my data in gridview..
ex: i've 3 columns in gridview : ID, NAME, DATE
I ask, how to create a dynamic search for 3 columns in gridview using a textbox?
without writing a query repeatedly :(ID like '%" + search + "%') OR (NAME like '%" + search + "%') OR (DATE like '%" + search + "%')
protected void btnCariConnStrSubmit_Click(object sender, EventArgs e) {
string search = ((TextBox)GridView1.HeaderRow.FindControl("txtCariConnStr")).Text;
string sql = "select * from report where (ID like '%" + search + "%') OR (NAME like '%" + search + "%') OR (DATE like '%" + search + "%') ";
reader = mda.GetData(sql, connStr).CreateDataReader();
if (reader.Read()) { dt = mda.GetData(sql, connStr).Tables[0]; BindGridView(dt); lblRecordNotFound.Visible = false; }
else { Bindemptydt(); lblRecordNotFound.Visible = true; }
((TextBox)GridView1.HeaderRow.FindControl("txtCariConnStr")).Text = search;
}
I have a gridview with textbox and that textbox is for searching. My question is do you know how to search with all fields in gridview.For example: I have a gridview contains, FIRST NAME, MIDDLE NAME, and LAST NAME, and if I type in the textbox the gridview will automatically get what I've inout in textbox.
View 1 RepliesI want to filter my gridview using two parameters that come from Dropdownlists. I bind these drops with two linq queries and next I would like to filter my gridview with query that has two parameters that comes from selected values from those drops. Everything is inserted in UpdatePanel. Here is my code:
asp:UpdatePanel
ID="UpdatePanel1"
runat="server"
>
[Code]....
I don't know how to get selectedvalues from dropdownlist and pass them to Bind() function which binds grid view
I have a gridview that is currently showing 20 lines per page. Each line has several fields in it, three of which are dropdownlists. These dropdownlists are populated with a SQLDataSource and then the selected value is bound to one of the gridview datalements.
The problem I'm running into is that the page is very slow to load. I believe this is because of the large dropdownlists (and possibly because there are roughly 60 of them, each of which is executing a SQL query to populate the list of available values). The file size that is being transmitted over the web is just over 1.25MB in size, again from the large amounts of data in the dropdownlists.
Is anyone aware of a technique by which I could only execute the query from the SQLDataSources that populate the dropdownlists' available values once and then reuse the results of that query to populate the relevant dropdowns? Ideally I would do this on the client side so it would also limit the amount of text being transmitted to the client browser.
I have a gridview with 4 dropdownlists and 1 label in each row. Suppose , text fields of each dropdownlists are a,b,c and value fields are 1,2,3 respectively.
In each row,label text is the sum of value fields of selected text fields of 4 dropdownlist.
For example,If selected text of 4 dropdownlists of a row are-b,a,b,c.
Then the label text of that row will be 8.(value field of b=2,a=1,c=3 , so b+a+b+c=8)
Whenever the selected text of any dropdownlist changes,corresponding label field also will change.
How can we do this in asp.net with C#?
On one of my pages I display a Gridview. This contains a list of questions generated by a SQLDataSource, with a dropdownlist on each row containing the answers for that question. The answer values can be different depending on the question, so I populate them in the RowDataBound event for the gridview, using question information.
As the list of questions is longer than the page I have placed the gridview within a Div which allows me to use scrollbars to navigate the gridview. I also use some methods to preserve the location of the last question answered - so that on answering a question, the gridview does not reset to show the first part of the gridview.
This works fine for IE7, which is what I have been using for the development, and which part of my customer base uses. However, the other part of my customer base uses IE6, which causes a problem.
When an IE6 user attempts to answer some questions, they run into issues. Should they scroll down the gridview, when they select a value from a dropdownlist (Effectively, when they answer a question), there is a postback and all of the visible (i.e. onscreen) dropdownlists appear to be cleared. However, on mousing over any of the dropdownlists, their value is then shown. On using either the scrollbar, or on using the mousewheel to scroll the gridview, all the dropdownlists are 'refreshed' and their values are shown.
At no point does the application appear to lose the data, it is just not showing it until there is a mouseover or the gridview is refreshed. Another odd aspect of this is that this does not apply to the first 5 rows of the Gridview. Any of these can be altered without there being this display issue. Should the gridview be scrolled enough to show some of the first 5 rows and some subsequent rows, only the subsequent rows will have this display issue.
I have tried various things to correct this - originally I called my retrievescrollposition method on the SelectedIndexChanged event of the dropdownlist, but have since moved it to Page_Load as the Else branch of if (!IsPostBack). I tried rebinding the DropDownlist in the SelectedIndexChanged event, but this only helped with the Question I was answering - the display of any other onscreen questions was still affected.
I want to be able to make a query from three dropdownlists but not all three have to be selected to create results. This is what I have so far :
sub getdata (src as object, e as eventargs)
dim strsql as string
dim myconnection as oledbconnection
dim mycommand as oledbcommand
myconnection = new oledbconnection(ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_csrdb"))
strsql ="SELECT tbl_case.Case_id, tbl_case.Title, tbl_case.Description, Tbl_Country.Country_Name, tbl_principle.Principle_Name," _
& "tbl_keyword.Keyword FROM tbl_keyword INNER JOIN ((tbl_principle INNER JOIN (Tbl_Country INNER JOIN tbl_case ON Tbl_Country.Country_Id
tbl_case.country) ON tbl_principle.Principle_ID = tbl_case.Principle) INNER JOIN tbl_Usedkeywords ON tbl_case.Case_id
= tbl_Usedkeywords.case) ON tbl_keyword.Keyword_id = tbl_Usedkeywords.keyword " _
& "WHERE "
if DLPrinciple.selectedindex=0 then
strsql = strsql & "((tbl_principle.Principle_Name) like '%')"
else
if DLCountry.Selectedindex=0 then
strsql = strsql & "((tbl_country.country_Name) like '%')"
else
if DLKeyword.selectedindex=0 then
strsql = strsql & "((tbl_keyword.Keyword) like '%')"
else
strsql = strsql & "((tbl_principle.principle_Name) = '" & session("infoprinciple") & "')" + "((tbl_country.country_Name) = '" & session("infoland") & "')" + "((tbl_keyword.keyword) = '" & session("infokeyword") & "')"
end if
end if
end if
This is working perfectly with only one dropdownlist but I can not figure out how to make it work with several.
I have got 2 Drop Down Lists on my Form and 1 GridView. I want GridView to display the data according to selection from the Drop Down Lists.
For Example, One Drop Down List contains Names and other contains Dates. Both the Drop Down Lists can post back. So if i select a name from 1st Drop Down list, the Grid View should show all the results according to that Name. Similarly if i select the Date from the other Drop Down List , the Grid View should show the results according to the dates. But i cant figure out as how to bind Grid View to respond to 2 Drop Down List.
BTW i am binding both the Drop Down Lists and the Grid View to the DataSource Objects, which is getting data from the database.
I am filling a gridview with data.
column 1 is a dropdownlist <ddlGrade>
column 2 is a checkbox <cbxNeverAttended> not visible
column 3 is a textbox <tbxLastDate> not visible
in the 'GridView_RowDataBound'
i determine if a ddlGrade value already exists and if so, make it selected in the dropdownlist
also, if the value of ddlGrade is a "U" I make cbxNeverAttended and tbxLastDate visible
However, if cbxNeverAttended or tbxLastDate are both empty strings (and ddlGrade has the value "U"), I want to disable all instances of ddlGrade in the gridview (essentially forcing the user to enter a value for cbxNeverAttended or tbxLastDate before moving on to enter another ddlGrade).
But I have been unable to figure out a way to accomplish this on the 'Gridview_RowDataBound',
This is more of an SQL issue (I think) rather than .net, but I still think it's relevant area.
I have two dropdowns; first one called categoryID which has a series of numbers, the second called userID - again with a series of numbers.
If I select from the dropdowns: categoryID 4 and UserID 5 I end with the correct search result, however I need an option to show all records.
E.g. Select all from the category dropdown combined with UserID 5 that would display all records from UserID 5 (or vice versa).
Note - I am using MS Access and the numbers are classed as integers not text.
How to Bind three GridView on same page in asp.net,there are three buttons, onclick one button show only one gridview at a time.
View 1 RepliesI have two dropdown lists that I am using to filter a gridview. I gridview is populating based on a query
select [AnnotationNumber],[AnnotationBy],[AnnotationType],[BusinessUnit] as Unit,[ErrorType],[ActualAgencyError],AnnotationComments,[sgkComments],[ActualAgencyError],Cust from vw_GridviewSource where Name = '"+@Name+"' and AnnotationDate = '"+@Stage+"'";
SqlCommand cmd = new SqlCommand(query);
gvSummary.DataSource = GetData(cmd);
The @Name and @Stage variables are the selected values of the dropdownlist. When I start I get the two drop down lists on my webform. When I select the values from the dropdownlists, nothing happens. I get no gridview. I added onselecedindexchange event both dropdownlists and even after both are selected nothing. I debugged the code and found that there is a point where the value is correct, but I still don't see the gridview. I have alsochecked the query associated with the databind and it works perfectly when I check it in SQL. I am enclosing all the code from the aspx.cs and aspx.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Trakker.aspx.cs" Inherits="AnnoTracker.WebForm1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
[CODE]..