how is this possible in ASP.NET? I am providing 'pseudocode' since I didn't manage to do anything codewise:When logged in through LoginView:
If that User Belongs to Role "Person" then
connect to a DB and check a table row (i know how to do this)
If this row = "0" then
[code]...
When a user selects an item from an asp:checkboxlist, I would like for that item to show up in a "Selected: " area. Here is a link to a webpage [URL] that has the same functionality that I'd like for my page. Each time an item is selected, it shows up in the (for example, from the included link) "Selected Catagories" area (or is removed when an item is deselected). I would like this functionality to work for each one of my checkboxlists (I have three separate checkboxlists). The users can select as many (possibly all), or as few, items from each checkboxlist as they want.
View 6 RepliesI have this webform with few fieldsin the search criteria,I added a new dropdownlist named "Company",I populated it with the data from the database, now when I click search choosing this criteria it doent work.
public partial class List : PrintablePage
{
private string CNUM;
private string CNAM;
private string CEL;
private string SD;
private string SDE;........
I'll try to specify my problem as simple as possible! I have a problem comunicating between 2 pages; Products.aspx and ProductDetail.aspx. On Products.aspx i have about 15 DDL's on the left side (all set to autopostback), and 1 ListView ond the right side. Results in my ListView control are based on selcted items from DLL's on the left. Every single result in Products.aspx has a dynamical hyperlink to the ProductDetail.aspx. Now when I click on specific product in ListView I'm redirected to ProductDetail.aspx page, and everything works fine! If I click on the Back button in IE or FF it works also fine because it returns me to the previous Products.aspx page and all my results based on selected items in DDL's are still there!
The problem comes when causing some more autopostback's in ProductDetail.aspx page, because every autopostback is counted as a new page request and therefore i have to click Back button in IE or FF for more then 1 time to come back to the previous Products.aspx page.
I tried to implement code BELOW in ProductDetail.aspx.vb but it does not completly fulfill my expectations, becase all my searching criteria are lost when returned to the previous page (Products.aspx)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
ViewState("ReferrerUrl") = Request.UrlReferrer.ToString
End If
End Sub
Protected Sub BACK_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BACK.Click
Response.Redirect(ViewState("ReferrerUrl").ToString)
End Sub
Does anybody knows any other solution how to come Back to previous page with only ONE CLICK without loosing searching criteria?
Requirements call for the ability to save search values so that they can select them at later times to return the results without having to re-enter the values. They have the ability to search on 4 different types of data (Date, Time and Lat/Long), so they would like to capture what was entered and ONLY if they chose to save those values, it will be saved and next time they login, if they are searching, they can pick an old search and submit it again.
Im thinking that i add a checkbox next to each button, if they check it, it saves the data into a table with there values and username. Next time they login and go tothe search page, if there are any records for them in the table, i present them with a link that displays all the values stored and if they select one, it will run the search again and present them with the results. does that sound like the right way to handle this request?
I am creating a form that has several fields at the top such as date range, area, etc, the user can change and click a submit button to view all the rows that match in a gridview below these fields. I need to know how to change the "Where" condition based on the user input on the datasource bound to the gridview.
View 4 Repliessearch form!Have no idea how to do it.Hope the example says much about how it should operate!Profile search where the result will come out in a list view.theusers should be able to filter between firstname, lastname, age, gender.right now I have this!Search page
[Code]....
Search result page
[Code]....
[Code]....
I have a dropdownbox which I want to use to search records based on a timescale. The gridview populates results based from that search.
So here is how I want to work this;
If a user selects "today" - a list of records input today are populated. If "this week" is selected, a list of all records added within that week from todays date is populated.
I created a forum on this issue previously but to no avail whatsoever. How do I work around this problem?
How would one go about filtering rows based on a certain criteria on a Gridview?
View 3 RepliesI have gridview that I am filling with records from SQL database. However, I want to populate the gridview with records that match text search criteria. In other words, I want to be able to key in a word like "network" in a text box, pick up the text, read records and pick up on the records that match that criteria. I am doing fine with building the gridview but I am a bit new to this and I don't know what I do to do text search.
View 3 RepliesI have a problem with Response.Redirect to specific error page.
so far i have something like :
protected void Page_Load(object sender, EventArgs e)
{
if ((Request.QueryString["UbytovaniePrispevokID"].ToString()) == "")[code]......
What i want to do is.. I have one main page with new posts Each subject of the new post is the link to Another page where is Specific post and coments and user can leave a coment.
What I want is when the Request.QueryString["UbytovaniePrispevokID"].ToString()) == "" or null I want to redirect to error page ...
Duplicated post
View 1 Repliesim trying to write a query. for my ui ,i have 3 text boxes for firstname,flightno,sequencenumber.
i input search value on particular textbox it has to be searched on particular column of my db in a single stored procedure.
im using this procedure but it retrives only one column at atime. so like this i need to write three procedures.
but i have only one GO button.
ALTER PROCEDURE [dbo].[spp_searchUsers3]
@lastname nvarchar(50),
@Value varchar(50)
AS
DECLARE @SQL nvarchar(500)
SET @SQL = 'SELECT firstname,flightnumber,lastname,status FROM tbl_pregister WHERE '
+ @lastname + ' LIKE ''%' + @Value + '%'''
I have a GridView control (GridView1) on a page which is reading from a database. I already have a CSS style applied to the GridView and all I want to do is change the background image applied in the style depending on if a certain cell has data in it or not.
The way I'm trying to handle this change is updating the CSS class applied to each row through C#. I have the code below doing this:
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
GridViewRow row = e.Row;
string s = row.Cells[7].Text;
if (s.Length > 0)
{
row.CssClass = "newRowBackground";........
It seems as if the top piece of code is always returning the string with a value greater than 0, but when I check the database the fields are all null (except for my test record of "Smith").
I'm probably doing something very simple that's wrong here, but I can't see what. Like I said, I'm still very new to this. One thing I have tried is changing the argument in the if statement to things like: if (s != null), if (s != "") and if (s == string.empty) all with no luck.
Whats The wrong With This Code
Data type mismatch in criteria expression
Public Class Class1
Dim str As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsMasterMindsMy DocumentsVisual Studio 2008ProjectsWebApplication1WebApplication1indb1.mdb"
Dim con As New OleDb.OleDbConnection(str)
Public Sub insert(ByVal Nationalty As String, ByVal NationalID As Single, ByVal StNameA As String, ByVal Gender As String, ByVal BirthDate As Date, ByVal Address As String, ByVal TawjehiAvg As Integer, ByVal alfera As String, ByVal Phone As Integer, ByVal
Specialization As String, ByVal Period As String)
If con.State = ConnectionState.Closed Then
con.Open()
End If
Dim adp As New OleDb.OleDbCommand("insert into stinfo values (" & getmaxid() & ",'" & Nationalty & "'," & NationalID & ",'" & StNameA & "','" & Gender & "','" & BirthDate & "','" & Address & "'," & TawjehiAvg & ",'" & alfera & "'," & Phone & ",'" &
Specialization & "','" & Period & "')", con)
adp.ExecuteNonQuery()
con.Close()
End Sub
Public Function getmaxid() As Integer
Dim z As Integer = 1
If con.State = ConnectionState.Closed Then
con.Open()
End If
Dim adp As New OleDb.OleDbCommand("select max(Stnum) from stinfo", con)
Try
z = adp.ExecuteScalar
Return z + 1
Catch ex As Exception
Return z
End Try
End Function
Dim x As New Class1
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
x.insert(DropDownList5.Text, TextBox1.Text, TextBox2.Text, DropDownList1.Text, TextBox5.Text, TextBox6.Text, TextBox7.Text, TextBox8.Text, TextBox9.Text, DropDownList3.Text, DropDownList4.Text)
End Sub
I am working on a project for a market research company that needs to select and have it displayed to my gridview. I need a select statement that will randomly put on my gridview the following:
Recruitment Goal 21 people and out of those people 10 people have to be male, 11 people female, 9 of them white, 9 of them black, 2 of them hispanic. Is there a way I could do that? I was thinking of doing a stored procedure and doing something like
Select TOP 10 * from Canidates where sex = 'Male' order by newid() Into #tmp
Select TOP 11 * from Canidates where sex = 'Female' order by newid() Into #tmp
Etc... and then just selecting from the Temp Table.
I am importing data from an Excel worksheet. The columns are labelled aa, ab, ac .... in row1 and the rows are labelled with integers in col aa. Although I can import the entire worksheet (so long as it isn't too big), when I add a WHERE clause to import only a single row I get a type mismatch which I have not been able to isolate. How can I make progress.
Protected Function SetsConnection(ByVal n_cust As Integer) As OleDbCommand
'
' Create the connection string for the EXCEL file containing the filename and Provider settings.
'
Dim rope As String
[Code]....
What is the best approach for keeping a user's search criteria saved in case they navigate back to the search page in MVC 2?
I was thinking of ViewData or creating a model that would keep that type of data.
I am having a table in which i have certain columns along with a non unique column values of voucher No.
The Voucher No is appearing multiple times i.e multiple rows can contain a single voucher no
I want to colorize rows having similar voucher no
I'm trying to make a search that would list results in an access database which is newer than the date given in the textbox. When i run my sql query and it tries to fill the dataset, i get that data type mismatch error. This is the exact error:
Data type mismatch in criteria expression.
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.OleDb.OleDbException: Data type mismatch in criteria expression.
Source Error:
Line 176: OleDbConnection MyConn = new OleDbConnection(ConfigurationSettings.AppSettings["strConn"]);//Luodaan yhteys
Line 177: objCommand = new OleDbDataAdapter(strSQL, MyConn);
Line 178: objCommand.Fill(DataSet1, "Testi"); //Täytetään dataset (fill on DataAdapterin komento), "Testi" on datatablen nimi
Line 179: DataSet1.Tables["Testi"].Columns[0].ReadOnly = true; //Asetetaan ID sarake vain-luku muotoon, ettei avainta pääse muuttamaan
Line 180: DataGrid1.DataSource=DataSet1.Tables["Testi"].DefaultView; //Asetetaan DataSourceksi Datasetin datatable "Testi" johon tiedot on haettu
Source File: c:inetpubwwwrootphoenixsearch.aspx.cs Line: 178
In the access database the date field is of datetime type. The dates are in european DD.MM.YYYY format which i transform using datetime variable and convert function. The sql query runs fine in access database but when i run it thru my oledb connection in my asp.net page it gives me errors. How should i modify my query, or make adjustments to my code, to not get this error? Do i need to send the datetime as a parameter? And how do i do that? Here is the code for the search event:
[Code]....
Can any one let me know about the below issue. I have a page which has three labels, say startdate,enddate and username. My issue is if the user doesnot select any of the above three then a message gets displayed as "Please select one search criteria" or if the user doesnot enter the date in correct format then i dispaly "Please enter date in mm/dd/yy" format. But what is happening is first time if the user doesnot select any then "Please select one search criteria" is getting displayed and after this message gets displayed if the user enters wrong format of date then both the messages are displayed.
View 5 RepliesI have Template fields configured for Gridview. The gridview is using an objectdatabsource to bind itself. I have the gridview configured to use Templatefields which then contain tables to display the information. This works fine.
My question is, is it possible to change the text of the label if certain criteria is reached. If "NumberOfDwellings" is 1 then change the label to read, "1 Dwelling". Where-as if NumberOfDwellings has more than one then it's "3 Dwellings".
<asp:Label ID="lbl_NumberOfDwellings" runat="server" Text='<%# Eval("NumberOfDwellings") & " Dwelling(s)" %> '></asp:Label>
Last night I started working on an NHibernate provider. I'm creating a criteria that several records will match, however I only want to return the most recent record (the record with the largest Id). I thought UniqueResult() would do this it cannot be used if a list would be returned otherwise.
I could theoretically select the full list and then return the desired record, but I believe there is a better way.
I want to select data from a table where the user can search by 3 options; date, keyword, and type. The date will always be either today or a user chosen date. The keyword can be null or something the user inputs. The type will be chosen from a drop down and can be all or a specific category. I know how to search the date, but the other two create complications. I have created a stored procedure trying to figure this out:
[Code]....
Is there a way to say if the keyword is null then don't use it as a search criteria. If that is possible then type can use that same logic I suppose.
[Code]....
<%@ Page Language="VB" AutoEventWireup="true" Debug="true" %>