in my colum values like: ,2, 1,,3 1,2,3 1 , ,3 i want to show some text instead of these number .... here is my code Report Category: ---------------------------------------------------- public string reportcategory(object check) { string[] report_type = check.ToString().Split(','); foreach (string rtk in report_type) { if (Array.IndexOf(report_type, rtk) != -1) { if (rtk == "1") { string value = "Weekly"; return value; } else if (rtk == "2") { string value = "Daily"; return value; } else { string value = "Monthly"; return value; } } } } i have also confusion here suppose i have 1,2 then how to write code to show text like "weekely,Daily
I am making the asp.net application which consist of 6 form n based on user id pass want to show form e.g.: for admin all form appear for finance only 2 form appear when he enter his login id pass how can I?
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ī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 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 web user control with DataList control in it. In my .aspx page, I have a report header, an empty panel as a place holder, a report footer.In my .aspx.vb file, I'll loop through a list of departments. Within each department, I'll load a label to display the department name and the user control for the data, and add both the label and user control to the panel. So there are two variables: the number of departments and the number of records in a user control.
Now I need to display the current page number and the total page number in the report footer. Is it doable? How? I'm thinking of this approach: declare a page variable count, count the number of department name labels and the number of records in a user control. When the total count reaches a number, such as 20, I'll break the page. This way, I can get the the page current number and the total number of pages. But how to add a page break to an asp.net page?
 i want datalist to show only 6-8items ,as these datalist is connected to datasource which has more than 20 items..
like in facebook,we have lots of friends but in friend box only 6 friends is shown and when we click that we go to next page which display all list of friends...
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.
