Recent content by dodge20

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"...

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...

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 =...

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...

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

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

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

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

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

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

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

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

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

Glad it worked out for you. Dodge20

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...