Search results for query: *

Hi this is what i have so far, i would like to skip the first two items in the datalist, prevent them from displaying, how can one go from here: thanks protected void dlRisksDataBound(object sender, DataListItemEventArgs e) { HyperLink tmpLnk =...

Hi i'm trying to count the number of radio groups on a page and if less than 80% do not have a selection then disable the submit button, other wise enable it. I'm putting an onclick on each radio to call the function, plus a window.lonad event to call the same function. This is the function i...

How can one loop thru the read to check is any of the reader string values (all are stings) are not null. If the read return all null then i need to increment: io++ This is kinda what i mean: foreach (string val in rdr2.) { if (rdr2[val].ToString().Length > 0) { io++; } } thanks

Hi i have 10 tables that all have an int, no relationships, column called MemberID. I would like to add memberID from 1 to 2000 in all 10 tables. Is there a way to do this while loop based for all tables of type 'user' ? thanks

Hi, i've confused with triggers, still trying to wrap my head around the logic syntax, belowis what i have wich isn't working. when clientportal db table [_Info] gets an insert to take the autoIncrementing MemberID and insert it into db clientportalforms.dbo.mcpage1 in a column called MemberID...

Hi with a page the user triggers a sFTP action, getting file from another server. I'm stuck on a useability issue and was wondering if it can be handles in a global way, like using global.asax When the user initiates the ftp process, it can take upto 20 seconds for the process to conclude, if...

Hi I have procedure that has a few joins and at the end of the statement after the where clause i have for xml auto. In QA (sql2k) i ran the proc and returned only part of the xml: <TestDB.dbo.polls><Question>Do you...

I con't figure this simpleton out, any thoughts, string Equ = "<0.6"; if (Equ.IndexOf("<") < 0 || Equ.IndexOf(">") < 0) { // it gets here, don't want it to get here ? } Thanks

Hi I created a simple Proc called "feedback" i cannot find the procedure? I've looked in the master as well teh db that i created it in. I have refreshed the db to no avail, plus when i try to create a new one with the same name i'm informed that one already exists. I feel dumb, any...

Hi i have a strange problem, never seen this before. i created a stored procedure in the sql2k db (have many procedures already, all working) Gave the Proc the same security credentials as usual. and am running this code, this result catches on the fact that the connection cannot find the...

Hi i'm grabbing a column value "[Date of Birth]" but i only would like the year of it, is there a way to somehow truncate the return of the 'datetime' field ? something like: Convert(getDate(YYYY), [Date of Birth]) as dob Thanks

Hi the data return by a procedure has many GoalTypeIDs and i would like to display the unique GoalTypeIDs only. so i'm thinking that i will have to array the types and check to see if they have been used.... i am not having success with this, any suggestions ? protected void...

Hi, i crated a stored procedure that connects to a linked server; SQL 2k has a linked server: Access. I can run the query in QueryAnalyser and all is well. When i call the stroedProc from c# i;m getting error: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed...

Hi i have an access database linked to the sql2k as a linked server. I would like to get the column names from the table "clients" in the access db from sql. How is that accomplished? Thanks again

Hi there is a column called "ReviewDate" data in this column is of the following format: 2/18/2008 7:26:16 AM This column has multiple years. I am writing a stored procedure and would like to grab records where ReviewDate is 5 days earlier than todays date How would one do this? thanks

Hi i'm using sql 2k. I would like to write a storedProcedure in 2k db, that will read data from a table in an access database based on a mutual id. Is this possible and if so, how would one go about it, thanks!

hi, i was wondering what the most effecient method of getting the url and setting a string to the page name? here would be a sample url (all have a queryString) http://company.com/this/member/resources/default.aspx?nav=re

Hi applying permissions to a table for a user, when would one choose With Grant over Grant or vice versa, thanks

how whould one get the first 2 characters of a string? thanks var d = "asdfasdfasdfasdf"; if (d.length>2) { get first 2 characters here }

Hi was wondering if possible to use session.timeout = 60; in global.asax, like: protected void Session_Start(Object sender, EventArgs e) { Session.Timeout = 150; ......... } thanks!