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:
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 + "
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.
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.
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.
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.
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?
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?
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.
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.
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.
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?
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:
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?
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.
