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!

Recent content by dodge20

  1. dodge20

    Concat dropdownlist values into a comma separted string

    I have a gridview that has a dropdown list in each row. The dropdowns are named ur1,url2,url3 etc. I would like to combine the selected values of all those dropdowns into a comma separted list and store it in a hidden field. <asp:GridView ID="GridView1" runat="server"...
  2. dodge20

    Getting Value from llistview

    The ultimate goal is to insert the data from an excel file into the listview. Then map the columns using a dropdownlist, then generate a sql statement to insert into a sql table. (I know the values in the dropdown don't make sense - i just filled it with data for testing). I got the above code...
  3. dodge20

    Getting Value from llistview

    I am trying to get value from listview to insert into a database. However I can't seem to grab the value. It says subitems is not a member of system.web.ui.webcontrols.listviewitem. Here is what I am attempting. For Each lvItem As ListViewItem In ListView1.Items strSQL =...
  4. dodge20

    Install Reporting Services 2008 without SSL

    Is it possible to install reporting services without SSL enabled? currently after each install I have to go into the reportserver.config file and change value of the secureconnectionlevel from a 2 to a 0. Then I have to go into the rsconfigtool and remove the ssl entries from the url's of the...
  5. dodge20

    convert excel function to sql command

    Thanks for your help. I was able to create a function that does this. Dodge20
  6. dodge20

    convert excel function to sql command

    Can anyone help convert this function to a sql statement. MOD(10-(SUM(CEILING(MOD(MID(@checkdigit,{1,2,3,4,5,6,7,8,9},1)*{2,1,2,1,2,1,2,1,2},9.5),1))),10) Dodge20
  7. dodge20

    Remove already selected values from a dropdownlist

    Thanks jbenson001 I think you are right, javascript probably is the way to go. I am brand new to asp.net and was just curious if it was possible. Dodge20
  8. dodge20

    Remove already selected values from a dropdownlist

    Darn I was hoping something like this would work. Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged DropDownList2.Items.Remove(DropDownList1.SelectedItem) End Sub Dodge20
  9. dodge20

    Remove already selected values from a dropdownlist

    I have a page with 10 dropdownlists each populated with the same data from a database. When a value is selected from the first dropdownlist, I don't want to see that value as an option in the remaining dropdownlists. Can you point me in the right direction? Thanks Dodge20
  10. dodge20

    Parameter Values

    WHERE convert(varchar(10), YOUDATEFIELD, 101) between @startdate and @enddate Dodge20
  11. dodge20

    How do I add a column to one dataset from another?

    I would create a variable to store the data. You can write an expression that will populate the variable with your rsid, then it can be used anywhere within the package. Dodge20
  12. dodge20

    syntax question

    What field are you counting? Do you want the count > 0, count less than 0 doesn't make sense. If you want a condition using count you need to use a group by with a having clause. select field1, count(field2) from table group by field1 having count(field2) > 0. Dodge20
  13. dodge20

    Truncate database

    When I do this I do it exactly as SQL Sister suggested. Dodge20
  14. dodge20

    Adding Fields In SQL by Increments

    Glad it worked out for you. Dodge20
  15. dodge20

    Adding Fields In SQL by Increments

    You need some way to distinguish the records, so i would set an id column in a temp table. select personnum, timeinseconds, wageamount, applydate, startdtm, enddtm, IDCol = IDENTITY(INT,1,1) into #temp from vp_totals where personnum = '103786' and applydate >= '2008-11-30 00:00:00.000' and...

Part and Inventory Search

Back
Top