Hello:
I have a form that is used to update user's profile. The user can have multiple roles that I'm trying to display using a CheckBoxList.
When initially selecting a user the code below works. If I select another user, the checkboxes in my form are not filled out (all are unselected). Additionally, if I update a user and then select another user, the checkboxes are filled correctly.
Below is the code I am...
billybob206
Last Activity: Jul 29 '14, 06:14 PM
Joined: Jun 25 '09
Location:
-
VB.NET Selecting Items In CheckBoxList
-
I was off this issue for a week due to other projects' deadlines, but I was back on it today.
With Rabbit's suggestions, using a cursor and temp table I was able to find a solution.
Basically, the cursor grabs all the column names in the order I want and the IF help fill my temp table with DISTINCT column headings. From there the pivot table uses my temp table for it's column headings.
Just remember the text... -
So there would be no way to do an Order By Priority then, correct?...Leave a comment:
-
Distinct Columns In Pivot Table Order By
Hello:
I created a pivot table that I need to order the distinct columns by a Priority field in a view.
Normally it could come after my Where in @cols (Order By Priority) but I get an error saying it can't do that because of the DISTICT.
The code below is the procedure I call to create the pivot table.
Thanks in advance for the help.
...Code:BEGIN SET NOCOUNT ON;
-
Crystal Reports Query Question
Hello all.
I'm just trying to find some leads to my issue.
I have a 2008 Crystal Report added to my asp.net project. I did create the report using a wizard.
Now, on a webpage I have a button that will redirect the user to the report and I want to feed the report a custom query that I will provide.
How would I start coding this?
Thanks in advance for your help. -
Sorry. This is actually a ASP.NET issue. Not ASP classic.Leave a comment:
-
String Validation
Hello:
I am trying to validate the length of a string in a text box.
I just need the string to be between 1 - 50.
I have tried RangeValidation and RegularExpressi onValidation and everytime I go to test the Validator fires even though the string is in the acceptable range.
Below is the code for my check, both Range and Reg. Ex.
Thanks in advance for your help.
... -
Got it.
Code:Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim lblDummy As Label lblDummy = (object).FindControl("X") lblDummy.Text = Session("Y") End SubLeave a comment:
-
Thanks for the reply.
The code behind is in VB.NET
In the code is in the Page_Load in the code-behind.Last edited by Frinavale; Jun 14 '11, 08:43 PM.Leave a comment:
-
Formview and Labels
Hi.
I'm trying to make the text of a label that of a session variable.
Here's an attempt I have tried for the code-behind, which does not work.
Can anybody help me with this?Code:Dim lblDummyLabel As Label lblDummyLabel = DirectCast(fvAddRate.FindControl("lblUserEval"), LABEL) lblDummyLabel.Text = Session("User")
Thanks in advance....Last edited by Frinavale; Jun 14 '11, 02:08 PM. Reason: Formatted code so that it is easier to read. -
SQL Facited Search Tools
Are there any facited search tools that search a SQL server that is NOT programmed in Java? (Ex: Solr) -
Noise Words And Symbols
Hello:
I am using a SQL statement using ContainsTable. Below is an example of the SQL code that I'm using.
The results come back with everything with Steele and mail. (leaving out the e-)Code:Select x.F1,x.F2,c.Rank From TableX x JOIN ContainsTable c (Z,Text, "Steel" AND "e- mail") AS c ON c.Key = x.F1 Order By c.Rank
Issue:... -
Sorry. The solution was obvious (in my view). Just go into the Events property section of the gridview and then select the function (or procedure) that fills the gridview in the PageIndexChange d and Sorted fields.Leave a comment:
-
Is that done in the GridViewSortEve ntHandler?Leave a comment:
-
Disappearing Gridview
Hello:
I'm developing a search page that will display the results in a gridview. The codebehind (in VB.NET) uses a SQL command to fill the gridview.
The gridview does have paging and sorting enabled. Once the search button is clicked the initial results are displayed, if the user clicks on a sorted column or wants to advance a page the gridview disappears. Enable Sorting And Paging Callbacks is set to True. Enable ViewState... -
Found it
Under "Behavior" in Properties there is an option called "Default Mode." You can start the form in Edit or Insert.Leave a comment:
-
Visual Studio ASP.NET FormView Insert Item Templete Question
Howdy,
Is there a way to make the Insert Item Templete in the FormView in VS ASP.Net the default view of a webpage.
(The purpose is I'm trying to create a new user page without having to search for an ID 1st.)
Thanks in advance for your help. -
Found a work-around the alises to fix this issue.
SELECT DISTINCT REPLACE(HOME_PH ONE,'-','')
FROM X
WHERE HOME_PHONE IS NOT NULL AND DO_NOT_CALL IN ('Y','X','1') AND REPLACE(HOME_PH ONE,'-','') NOT IN
(SELECT DISTINCT PHONENUMBER FROM X WHERE PHONENUMBER IS NOT NULL)Leave a comment:
-
No. HOME_PHONE is the field. PHONE is the alises I'm using in the SELECT statement.
I can explain alittle more. The reason for the REPLACE function is that in the 1st table some of the phone numbers have -'s in them where in the 2nd table (in my sub-query) they do not.Leave a comment:
-
Using an alises in the WHERE clause
Hi,
I'm working in a SQL Server 2008 enviroment trying to get the code below to work.
The error I get is "Invalid column name 'PHONE'."
Thanks in advance for your help.
SELECT DISTINCT TOP 5 REPLACE(HOME_PH ONE,'-','') AS PHONE
FROM X
WHERE HOME_PHONE IS NOT NULL AND DO_NOT_CALL IN ('Y','X','1') AND PHONE NOT IN
(SELECT DISTINCT PHONENUMBER FROM X WHERE PHONENUMBER...
No activity results to display
Leave a comment: