Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: henslecd
  • Content: Threads
  • Order by date
  1. henslecd

    Dropdown parameters not required

    SQL 2005 RS I have 5 dropdown parameters, of which only one is required. All 5 are populated by a dataset. I have checked allow nulls and blanks for the 4 that are not required. The SP that I wrote is written in dynamic sql, so it tests for null values for all params, and only includes...
  2. henslecd

    XML reader writer

    I am looking for a good tutorial on reading, writing and modifying XML in C#. This is the approach I think I should use. Read the XML file and put it in a dataset. Manipulate the dataset as needed, and write it back out to the XML file. I guess I am suppose to blow away the entire XML...
  3. henslecd

    1 person gets Login Failed for user Null using Windows Auth

    We have set up SQL 2000 to use Windows Authentication. There is one person who gets Login Failed for user Null when they try to connect, whether it be Query Analyzer or setting up an ODBC connection. There are 19 of us that have no problems. However, there was one difference. He had mapped...
  4. henslecd

    ASP.net recurring billing for memberships

    I have a client that has a membership only website. The user would pay for either monthly or yearly subscription and this would be recurring. I am open to all gateways (paypal, auth.net, verisign etc). This site will have 1000+ users. I also want the solution to integrate into the current...
  5. henslecd

    Datagrid logic problem

    I have 3 tables, data_row, data_col and data. data_row fields are row_id and row_text. data_col fields are col_id and col_text. data fields are row_id_fk and col_id_fk and value. Is it possible to create a datagrid where col_text is displayed horizontally across the top for each column, and...
  6. henslecd

    Excel Cell Fill Color

    My excel sheets do not allow me to see when I fill in a background color for a cell. It is visible when I go to print preview, but not when I am editing the page. I don't have templates and I have tried resetting any default options. Any ideas? Thanks, Chad
  7. henslecd

    Passing arguments with single quotes

    I am trying to get the following line of code to work. sSagList = "('31Z','32Z','31R','32R')" document.write('<td class="list" style="padding-left:2px; font-weight:bold; border-right:0px solid #eeeeee"> <img style="cursor: default" onclick="AddRow(this,\'' + sSagList + '\');" alt="Insert...
  8. henslecd

    Write and Retrieve text file to/from Database

    I have a multiline textbox that will hold paragraphs of information. I think that I have to write the data to a text file and save the text file to the database, because it doesn't save all of the data when I use the usual request.form("txtArticle") . Does anyone know of a good article that...
  9. henslecd

    Multiple Web.Config Files

    I have a site where I want to allow different groups access certain areas. I have my main web.config, and a web.config in the subdirectory that I want to redirect to a login page. This is my Main web.config 1<system.web> 2 3<authentication mode="Forms"> 4 <forms name="yourAuthCookie" 5...
  10. henslecd

    Change root folder for upload

    How can I force the root folder that a user starts with when they hit the browse button on a file upload? Thanks Chad
  11. henslecd

    setting up sql 2000 and iis on diff servers

    Here is the environment. IIS 5.0 on one server. The web site uses a security certificate. Windows Integrate Auth is checked. Anonymous is unchecked. We must use windows auth and not anonymous because I need to collect server variables. Basic also cannot be used. SQL 2000 on another server...
  12. henslecd

    Datagrid Column Hiding and Datagrid Resizing

    Here is some code that would be useful for reports where your user would like to choose the columns of the datagrid that he or she wants to see. I use a checkboxlist with a checkbox for each column of my datagrid. To make it easy for the user I suggest setting the value of the ListItems to the...
  13. henslecd

    table rows on the fly

    Last week I posted this thread. http://www.tek-tips.com/viewthread.cfm?SQID=817445&SPID=855&newpid=855&page=1 I got a great answer and everything works well. My current problem is when I need to have 2 sets of tablerows on the fly. I.e. I have 2 dropdowns that each have values 1 through...
  14. henslecd

    export datagrid to pdf

    Does anyone know how to export a datagrid to pdf? Thanks
  15. henslecd

    controls and tablerows on the fly

    Is there any way to create tablerows based on the value of a dropdownlist? I.e dropdown contains values 1 through 10. User selects 5. 5 Tablerows are created. I was thinking something along the lines of i=dropdown.selectedvalue so i=5... For x = 1 to i <TR> <TD> <asp:dropdownlist...
  16. henslecd

    Cast from type 'Field' to type 'String' is not valid.

    I am converting an asp page to asp.net and I am one section away from getting it to work. Here is what I have... Do Until rs.EOF HttpContext.Current.Response.Write(&quot;<option value=&quot;&quot;&quot; & rs(0) & &quot;&quot;&quot;>&quot; & rs(1) & &quot;</option>&quot; &...
  17. henslecd

    retrieve value from record in a dataset

    If I have a dataset that has field1 and field2, how do I retrieve just field1's value? I have a count of the number of records in the dataset (recordcount). I want to loop through them like this. For i = 0 to recordcount if string = &quot;dataset.table.field1(i)&quot; <-- this is where I am...
  18. henslecd

    client-side validation

    Is there a good way to validate a textbox entry by the user against a dataset? I.e Dataset: VENDORS - Cisco, Dell, Microsoft I would like the string entered in the textbox (txtVendor) to be searched for in the dataset, and if found, thrown an error saying that the Vendor already exists. I...
  19. henslecd

    dropdown value

    I have a dropdown box... <asp:DropDownList id=&quot;ddVendor&quot; runat=&quot;server&quot; Width=&quot;226px&quot; DataTextField=&quot;VENDOR&quot; DataValueField=&quot;PK_VENDOR_ID&quot;></asp:DropDownList> I have this in the button_click event... Dim vendorID as integer vendorID =...
  20. henslecd

    dropdown value

    I have a dropdown box... <asp:DropDownList id=&quot;ddVendor&quot; runat=&quot;server&quot; Width=&quot;226px&quot; DataTextField=&quot;VENDOR&quot; DataValueField=&quot;PK_VENDOR_ID&quot;></asp:DropDownList> I have this in the button_click event... Dim vendorID as integer vendorID =...

Part and Inventory Search

Back
Top