Search results for query: *

let me add that the reason i ask is because my coworker and i are working on different pieces of the same project and just copying our pages up isn't working. we both named our projects the same but obviously i guess we can't include both of our dlls. should we name our projects different and...

if I make changes to a page and copy only the affected page up to the server, it doesn't use the new copy. do i have to copy the bin directory too?

I feel crazy asking this, but I'm not exactly clear on how to run a "query" against a dataset. In other words, I have loaded a whole group table into a dataset and need to query for a specific groupid. I have queried the active directory for a list of groups that a specific user is in. I need...

at most it would be 6. thanks for reminding me about how they could fail. i'll use a transaction, thanks!!

I have queried Active Directory for a list of groups a particular user belongs to (comes back in an array). First, I need to loop through the array looking to see if any of 6 particular groups exist. Then, if any of them do exist, i need to update a table with this information. I am basically...

hey I never knew about the split method, that's great!! thanks!!

If I have a string value equal to "Firstname Lastname" and I want to separate the two into their own separate variables, how can i do that? i think i will need to use an instr to find the " " but I'm not sure what to do after that. I'm using the faq on access the active directory to get the...

I'm not sure if the control has built in caching, i looked in there help file and couldn't find anything. Here's my code: If Not IsPostBack Then SqlConn.ConnectionString = ConfigurationSettings.AppSettings("SqlConn") 'Populate Calendar Dim daGetTitle As...

I forgot to mention that when I debug this, it almost seems to be cached somehow. I say this because when I stop and restart the project, it will show up with duplicate entries on first page load.

thanks i wasn't sure if i needed another primary key for the usergroup table. how do i designate both of those fields as the primary key for the usergroup table?

I am using a control I purchased called calendar.net. I have some code in my page load event that populates that calendar with items. I currently have the code in an if not ispostback statement. I realize now that when a user navigates away from the page and then goes back to it, that code...

For instance, I have a table for users, and a table for groups. A user can belong to more than one group, and a group can have multiple users in it. So I made a UserGroup table that contains the following fields: UserGroupID (pkey), UserID (fkey), GroupID (fkey). Then I made a one to many...

Thanks ThatRickGuy, that was it.

I have a many to many relationship which I have designed as two tables each with a one to many relationship to a junction table (with the id fields from each of the other two tables). When I do an insert to the two "regular" tables, what is the best way to get the id values into the junction...

It seems to be cached or something, I change it's properties but it throws and error "too many arguments specified". if i change it to a different sqlcommand object it works fine...

I would like to declare one sqlcommand object in a module that I can use across my project. Is there a way to "clear" a sqlcommand object so that I can use it again for a different stored procedure?

Ignore what I said about it repeating records, i was looking at it icorrectly. This is great! The only thing left is the ordering.

ok i tried putting sum(calc) in which is the field i need the sum on. It kind of worked. It didn't order them in order of most expensive and it repeats some of the records? sorry, advanced scripts are new to me!! thanks!!

is the sum(...) literal or am I supposed to put sum(project, maincategory, itemid) in there?

I'm working on a report for my boss. I am grabbing info from a table that has the following fields: ItemID Item ItemAmt Quantity Total (which is a calculated value of itemamt * quantity) MainCategoryID ProjectID Notes Deleted (a bit field indicating whether the record is "deleted")(users here...