You searched for the word(s): userid:795528

More Search Options

RSS Available

• Help Combining two stored procedures into one, so rows selected in first stored procedure are inserted into another table...

  I have a vb.net page that has a dropdown list with all of our Departments. The form prompts users to select a department, and then when they click add, each EmployeeID that belongs to that department should be inserted into another table. I have two separate stored procedures (see below) that I don't know how to combine. The first one gets all the employees that belong to the selected department. The second one should take all the employees listed from the first stored procedure and insert them

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by funluckykitty on 12/9/2009

• Re: How to apply server.transfer to all pages in a specific folder?

  No, I haven't tried the loginurl attribute. Let me back up and add a couple more details. I grab the users login id based on their network login. So, once they are on our network, I can see who they are. Then, if their network login is in a short list of users, they are the only users who should be able to view the pages in the admin folder. So, everyone using the site is essentially "logged in".. and then, if their login is in the short list of users (which is in another table), THEN

  Posted to Security (Forum) by funluckykitty on 12/2/2009

• Re: How to apply server.transfer to all pages in a specific folder?

  This sounds like what I want to do... I have their session value and have checked it, it's the determining if the page is in the admin subfolder that is confusing. How do I check if the URL they browsed to is in the admin folder? If it isn't, they can browse and look at data.. it's just those super secret pages in the admin folder they aren't supposed to get too. Note, there are several other subfolders too, but all those are ok too..

  Posted to Security (Forum) by funluckykitty on 12/2/2009

• Help with a datatype that will accept a decimel

  I'm branching out from using varchar for most of my datatypes. I want to store some data in a sql 2000 table as currency. I'm using the compare validator in my .net page to ensure I get the values as 0,000,000.00 . I set the datatype in my table equal to decimel (18.2), but when I do my insert thru a stored procedure, it errors if there is a comma in the dollar value. So, what datatype should I have my column in sql set as and how do I set that in my insert stored procedure?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by funluckykitty on 12/2/2009

• Re: How to select everything to the right of '-' in sql 2000?

  Here's how I ended up getting the data... Select......, CAST ( SUBSTRING ( matter . mmatter , CHARINDEX ( '-' , matter . mmatter ) + 1 , LEN ( matter . mmatter )) AS int ) AS MatterNumber ,.....

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by funluckykitty on 11/23/2009

• Can an editable details view control the databinding of gridview once update is clicked?

  I have a gridview that allows you to select a row, and then display the details view. The details view is editable. In the details view, the user has the option to change the records status to "Remove". If that happens, I need for the initial gridview to "refresh" so that this record with a status of "Remove" is no longer included. How do I get a button in my editable details view to control the databinding of the initial gridview that is populated by a sqldatasourceID

  Posted to Data Presentation Controls (Forum) by funluckykitty on 11/23/2009

• Can data in a column of a gridview be "selectable" (so it acts like a select button)

  I have a gridview and a details view. The users would like for the a column in the gridview to be a clickable link that when clicked, displays the details for the row of data, instead of there being a "Select" button in the gridview. Is this possible?

  Posted to Data Presentation Controls (Forum) by funluckykitty on 11/23/2009

• Re: Can data in a column of a gridview be "selectable" (so it acts like a select button)

  No, I want to not have the word "Select" be the link... instead, I want it to be the name of the record that is selectable. So, it would have a list of employees by last name, and the employyes names would be "selectable" not the word "Select"

  Posted to Data Presentation Controls (Forum) by funluckykitty on 11/23/2009

• Re: Can data in a column of a gridview be "selectable" (so it acts like a select button)

  Ahhh.. now I get it! Makes perfect sense... and easy to do! Thank You PeteNet

  Posted to Data Presentation Controls (Forum) by funluckykitty on 11/23/2009

• Re: Change text box of details view to a bound radiobutton list?

  Found a good sample online, http://aspnet.4guysfromrolla.com/articles/080807-1.aspx but I'm getting an error when I click Edit because the value in the database is null (in other words, the user hasn't submitted it yet). Below is the error I get... How do I deal with the possibility of a NULL Value in the DB? Exception Details: System.ArgumentOutOfRangeException: 'ReleaseName' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value

  Posted to Data Presentation Controls (Forum) by funluckykitty on 11/20/2009