Forms Data Controls :: Clause On UserID Together With Other Parameters Does Not Work?
May 4, 2010
Iīm a newbie at .NET and Iīm trying to solve how to run a datagrid with parameters. I know how to do where clauses with controls and today I managed to solve how to have a where clause at UserID within a SelectingEvent.BUT, I canīt run them both in the same time. I want to run a query based on the month in a dropdownlist and the UserID. Each one individually works.Why canīt this be done? Is the onselect statement ignoring the other parameter? I donīt get any errors.The ASPX (in VB.net) code is:
<%@ Page Title="" Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="false" CodeFile="IndividuellBonus.aspx.vb" Inherits="Income_IndividuellBonus" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
[code]...
View 4 Replies
Similar Messages:
May 2, 2010
I'm using asp.net login on a SQL Database.
I have 12 users in my User tabel - one of the user I don't want to have in my select (the user is an admin).
I tried this:
[Code]....
I also tried:
WHERE (dbo.aspnet_Roles.RoleName <> 'Administrators')
Both time it took the user into the table....
If I instead try this
WHERE (dbo.aspnet_Roles.RoleName = 'Administrators')
I get only one row (as expected).
What is wrong with the above sql statement - why can't I get 11 users and not them all (12 users)?
View 3 Replies
Apr 6, 2010
i have created this function with a parameter offset and i want to access the database using stored procedure but the code and stored procedure i have written below is not working...what is the right way to do it??
public bool isoffsetexist(int offset)
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_offset1";
SqlDataReader dr = cmd.ExecuteReader();
int i = 0;
while (dr.Read())
{
i++;
}
if (i == 1)
{
conn.Close();
return true;
}
else
{
conn.Close();
return false;
}
}
my stored procedure "sp_offset1" is
CREATE PROCEDURE [dbo].[sp_offset1]
@offset numeric,
@appname varchar(20),
@os varchar(20)
AS
select * from tb_offset
where @offset=" + offset + "
View 2 Replies
May 15, 2010
I am fairly new to Visual Web Developer so I hope this makes sense.I have a page with a GridView (code below). When a person clicks on the Select Link, I would like it to direct them to a page with a FormView of the selected row so that it can be edited. I feel that this should be fairly basic but am having trouble finding the means to make it happen.
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
DataSourceID="SqlDataSource1" Height="230px" Width="829px"
AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" [code]....
View 3 Replies
Dec 30, 2010
I am trying to populate a gridview that returns only the logged in users' records. Specifically, I am getting a blank page when I load the page. To clarify, I get the blank page after successfully logging in to the ASP.Net Membership and do have data to return from the requested table.
I am reaching out to the online community after numerous failed attempts to research the solution and successfully return the desired results through trial and error variations.
ASPX Page
[Code]....
ASPX.vb CodeBehind
[Code]....
<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false"
View 4 Replies
Feb 17, 2011
I created a column named InputUserId for the purpose of saving the user's id upon inputing data using formview(so I know who inputed). I would like the user's id to be saved in the table (column InputUserId) and the table's Id (RId) to be saved in the user's profile.
View 8 Replies
Dec 20, 2010
1st i start from the SQL Table design, i created a table which contain
RegisterID(for eg. id=1000123), Username, pasword,
Full Name & etc
using a store procedure but i didnt include 'RegisterID' in there becuz i used
'identity' method for auto increment of RegID.
my question is that, i created a login & Welcome page (in C#).
its work properly, but now i want a way, when a user login into the website,
his RegisterID(for eg. id=1000123) will appear in Browser's Address bar
for eg. (http://www.mysite.com/welcome.aspx?id=1000123).
what command i have to give, to appear this ID.
i used Response.Redirect("newuserinfo.aspx?" + "username=" + username_txt.Text);
the username coming on the address bar, but i donno how to show RegisterID.
View 7 Replies
Jul 28, 2010
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
View 8 Replies
Feb 23, 2011
i have 10 columns, diffrence user insert (rows)many time, i want to display in page lick this :select Sum where userid=user.identity datetime =date.now and send sum of each columm to 10 labels on page.
View 4 Replies
Jul 17, 2010
I have Gridview1 that brings up the columns Resorts, Seasons, Seasons_ID, Resorts_ID, and User_ID
The three ID's are all foreign keys from related tables, and they are together a combined primary key of the table being accessed (they were defined that way to prevent duplicate entries for any User/Resort/Season combination).
Now the problem: I want to use the selected row from that gridview in the WHERE clause of a SQLDatasource by setting the WHERE clause up like:
WHERE (([Resort_ID] = @Resort_ID) AND ([Season_ID] = @Season_ID) AND ([User_ID] = @User_ID)) , with the parameters each coming from statements like
Gridview1.SelectedValue
When I select a row in the Gridview, I get the following error:
Operand type clash: uniqueidentifier is incompatible with int
I am pretty sure this has to do with the User_ID being in the WHERE clause.
So I have tried something like this to access the selected index:
Gridview1.DataKeys(Gridview1.SelectedIndex).Value
This does not work, as it seems to return only the first key (of three) in the DataKeyNames list.
So the question: How can I use the SelectedIndex of that gridview for such a purpose when the key contains a UserID?
View 8 Replies
Feb 6, 2011
It sounds pretty simple, but I can't find a way to make it work. I have a FormView with a InsertTemplate where it inserts the current logged in user's UserId and content from a HTMLeditor, and a EditTemplate where it retreives the current logged in UserId and shows content from database in the HTMLeditor.
How can I get it to show EditTemplate if the userId exist in the table, and InsertTemplate if the UserId does not exist in the table?
View 4 Replies
Mar 31, 2011
I have a confusing question, I have a user table and it stores all the usual data for a user that you would expect but im trying to figure out how a user could add another user?
Sounds strange but each user in the User table has his own UI which is UserID how could I add another table where UserID can have a relationship with another UserID?
i.e how would I right the syntax for the above question if I wanted to display all the UserIDs friends on a page. How would I add a friend.
View 4 Replies
Oct 21, 2015
Default.aspx**
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="admno"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="admno" HeaderText="admno" ReadOnly="True" SortExpression="admno" />
<asp:BoundField DataField="bcode" HeaderText="bcode" SortExpression="bcode" />
[Code] ......
View 1 Replies
Dec 29, 2013
How to view the created id password in asp.net configuration
View 1 Replies
Mar 11, 2011
I have a page with a partialview on it which is a list of items. I have a button on it which shows the next 5 items.
This is done via ajax:-
[code]...
My question is that I need the 'page' variable to increment each time someone presses the form button which is contained within the partialview.
How do I keep track of that variable?
View 1 Replies
Sep 24, 2010
After upgrading our project to the .net 4.0 framework (from 3.5), we facing some problems with ajax calls with html in the parameters. As soon as the user enters some html in a text area the ajax call isn't executed anymore. If the user enters plain text only, there is no problem.
[code]...
View 2 Replies
Jun 8, 2010
although I've searched already, but here is the thing:I have a ModalPopup wich have a Textbox, a Button and a GridView inside. The Gridview is binded to a SQLDatasource object, and the Select query is something like "SELECT field_1, field_2, field_3, field_4 FROM Table_Name WHERE field_1 LIKE '%@Parameter_2%'".This ModalPopup is used (or gonna be used) to search for a field, so the parameters received by the Query is the text inside the Textbox, I've linked thid inside the SQLDataSource Wizard.The problem is that everything works perfectly fine... inside the panel WITHOUT the ModalPopup Extender, but whe I add the Extender the filter function doesn't work.Here is my code:
[Code]....
Notes: I have a ScriptManager inside the MasterPage, so I don't have to insert one in every page. Also I've tested the code in a new page (the one I use for testing), and it works fine, it filters and everything, the problem is when I add a ModalPopup to the panel.
View 3 Replies
Jul 22, 2010
I moved some of my old asp pages to new aspx website. In all of the old pages i used (for file example.asp):
Response.Status = "301 Moved Permanently";
Response.AddHeader("Location","http://www.domain.com/example.aspx");
The problem is that when the page domain.com/example.asp?param=value¶m2=value2 is requested - the redirect ain't working...
View 1 Replies
Feb 20, 2010
How can I set update parameters from GridView's Row_Updating()?
View 3 Replies
Dec 11, 2010
I have a ListView displaying data from Table A using a SqlDataSource.
I want to take the displayed data (and these are just the standard columns representing fields in Table A) and store them in Table B using a Stored Procedure
(The scenario is much more complex but I've left out anything not relating to this exact problem).
I've added a Button to the ListViews ItemTemplate and I'm using OnItemCommand to create a Sub for its "Click" in the Code Behind.
This is a simplified chunk of the SQL I'm using to insert the ListView's fields into Table B using the Stored Procedure "InsertCart":
[Code]....
Where I've highlighted "Description" in the last line. In a GridView, this would be enough. Description is a Column name in Table A and B and iy's an Item in the ListView. But I'm realising that, with ListView's, the data binding is not as "automatic" as a GridView. Just using the columnname is not enough.
What do I use instead of the word Description to reference this column in the Parameter?
View 2 Replies
Feb 13, 2011
I have a gridview and I have an edit template for one control. I have a drop down box in this edit template so that you can select a value from it and then when you hit 'Update' the value from the drop down box is committed to the updated record. Unfortunately when I do hit the update button I get a fault that the "Status" field cannot be null.
Here is the code that picks the value from the drop down value and assigns it to the new values list:
[Code]....
View 4 Replies
Mar 15, 2011
I have big filter coming from database by using storedprocedure. This stored procedure contains about 12 parameters. In asp.net page I select these values and after doing that I want to pass these values to SqlDataSourec which is bound to gridview. How can I pass these values to SqlDataSource, manually in codebehind?
View 8 Replies
Sep 2, 2010
I am working on a form that I would like to display a dropdownlist or textbox to insert data into the same field.
Currently it is setup where the end user can use one or the other but not both. I am running into a problem getting with the insert parameters for the secondary control. In this case the textbox.
Is it possible to use and Or statment in my Insert Query? I have tried to no avail.
[Code]....
View 3 Replies
Oct 9, 2010
How specify input parameters to UpdateCommand
View 3 Replies
May 16, 2010
I can't seem to use thFilterExpression to filter using more then one parameter
I've tried this with no success:
FilterExpression="ProductName LIKE '{0}%' OR ComputerName LIKE '{1}%'"
with just the one parameter it works fine.
View 6 Replies
