Comments by CARisk3 - CodeProject

CARisk3 20-Jun-13 14:48pm View

Then the last question hearAbout they can check more than one answer and four of them can cause a specify input box to come up. This means I could have an extra four rows at the end of my dataset that I don't have for each grouping.

Since I didn't get any answers right away, I started trying to code it like this:

If ds.Tables(0).Rows.Count() > (11 + rowValue) Then
If ds.Tables(0).Rows.Count() > (11 + rowValue) Then
For i = (11 + rowValue) To ds.Tables(0).Rows.Count()
If ds.Tables(0).Rows(i).Item("DynamicQuestionID") = GUID Then
specifyOther += " Name: " & ds.Tables(0).Rows(i).Item("response")
ElseIf ds.Tables(0).Rows(i).Item("DynamicQuestionID") = GUID Then
specifyOther += " Search: " & ds.Tables(0).Rows(i).Item("response")
ElseIf ds.Tables(0).Rows(i).Item("DynamicQuestionID") = GUID Then
specifyOther = "Referrer: " & ds.Tables(0).Rows(i).Item("response")
ElseIf ds.Tables(0).Rows(i).Item("DynamicQuestionID") = GUID Then
specifyOther = " Other: " & ds.Tables(0).Rows(i).Item("response")
Else
specifyOther = " Specify: " & ds.Tables(0).Rows(i).Item("response")
End If

Next
End If

Would there be a more efficient way to do this? The issue is I have to capture all the rows but don't know how many there will be.

CARisk3 20-Jun-13 14:39pm View

Okay for a form there are 8 questions that need answered. For question 4 and 8 they are actually check a box to answer with being allowed to check more than one box. For answer 4 only one answer will cause the specify other box to come up so I coded it this way so I could capture the sequential answers without having to write different processes:

dim rowValue as integer = 1

Dim type As String = "Event Type: " & ds.Tables(0).Rows(3).Item("response")

If type = "Other" Or ds.Tables(0).Rows(3).Item("DynamicQuestionID") = GUIID Then
Dim eventOther As String = "Specify: " & ds.Tables(0).Rows(4).Item("response")
rowValue = 1
End If

Dim eLoc As String = "Location: " & ds.Tables(0).Rows(4 + rowValue).Item("response")
Dim eDate As DateTime = "Date: " & ds.Tables(0).Rows(6 + rowValue).Item("response")
Dim eTime As String = "Time of Day: " & ds.Tables(0).Rows(7 + rowValue).Item("response")
Dim eBudget As String = "Expected Budget: " & ds.Tables(0).Rows(9 + rowValue).Item("response")
Dim hearAbout As String = "Heard About Us:" & ds.Tables(0).Rows(10 + rowValue).Item("response")

CARisk3 13-Feb-12 13:00pm View

Okay. I guess I should have been more specific in the background information. We don't own this information or the system that the information is stored on. It's PHI (personal health information) data and it's not store in an sql database. It's stored in an application specific storage. The connection string not only contains user name and password but also the location of the stored data.

CARisk3 16-Jun-11 15:24pm View

Okay, I found some articles on the different types of Session State and I'm going to try using the SQL Server one. I'll post how things go and if the solution works. For information on what I'm trying look at the following articles:
http://msdn.microsoft.com/en-us/library/ms972429.aspx[^] Very in depth article from MSDN

Couple of articles on Code Project
ASP.NET Session Management Internals[^]

Exploring Session in ASP.Net[^]

CARisk3 12-Apr-11 16:33pm View

I usually do but because this one is using the same control field I'm not worried about it. And the system automatically turned them into questions marks. It seems like when I try to change them it ends up with an error. So it's working for now and I'm leaving it alone.

Carolyn

CARisk3 12-Apr-11 16:03pm View

Well this time I did get it fixed and I feel really stupid. I was working with the wrong connection string. That's why it wasn't showing the values. The first one I came up with works but I do need two parameters. I forgot I ended up creating a view because I needed to filter the records based on a value in another table's field.

The final connection string looks like the following:

<asp:SqlDataSource ID="sdsUnresolvedList" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"

SelectCommand="SELECT vw_UnresovedList.* FROM vw_UnresolvedList WHERE (Name = 'ads\' + ?) OR (Name LIKE '%BUILTIN\%') AND (Path LIKE '%' + ? + '\%') ORDER BY Skipped">
<SelectParameters>
<asp:ControlParameter ControlID="lblUserName" Name="?" PropertyName="Text" />
<asp:ControlParameter ControlID="lblUserName" Name="?" PropertyName="Text" />
</SelectParameters>

Yeah :). And Thanks for all you suggestions.

Carolyn

CARisk3 12-Apr-11 15:42pm View

Well that still didn't work. I tested it in the server explorer and it worked but when I run it on the aspx page it still only evaluates the first where clause. Really getting frustrated with this. But still thanks for your help.

CARisk3 12-Apr-11 15:33pm View

I figured this out. The data getting saved to the control has the domain name in front of the name. I need to strip this and then it works.

Thanks so much for you help though.

Carolyn

CARisk3 12-Apr-11 14:26pm View

No they are not because the name for those two records is admin and not the data in the control. They are two different records from the original 66 returned which is why I'm trying to accomplish this because I need to give the user the completed list of 68 not just the original 66.

CARisk3 12-Apr-11 14:21pm View

Yes, it returns 2 rows. And the first portion returns 66 rows. When my data is returned to the grid there are only 66 rows and the 2 rows that should be returned for the second where condition are not listed. I know what path should be showing up for those two records and they are not in the grid.

CARisk3 12-Apr-11 14:10pm View

No, it's still only evaluating the first where condition.

CARisk3 12-Apr-11 14:03pm View

If I do that it says I can only have one parameter with the name.

Carolyn

CARisk3 12-Apr-11 13:59pm View

I need to know if the Name field contains the same data as the control, if not I then need to check if the name field is like Admin and if the path field contains the same data as the control.

Neither of the above solutions work within the aspx page. It's only evaluating the first where statement.

CARisk3 12-Apr-11 13:52pm View

That doesn't work. And the "Or" really needs to be grouped as I originally had it as I'm looking for the name only or I'm looking for where the name is like admin and the path as the name in it.

Thanks,
Carolyn

CARisk3 12-Apr-11 13:31pm View

If I run the query with each individual where condition I get the results I expect. When I try to return it as one result with an "OR" or "Union" then I don't get what I expect. I even run the sql statement with the "OR" statement to figure out how many records it should be returning and it ran fine.

Carolyn

CARisk3 11-Mar-11 17:25pm View

I'm already addicted. I'm on here almost every day Monday - Friday. And I usually spend about 1/2 an hour reading through the lounge post. I'm was thinking about writing up my solution for a very compact way to pass information between listboxes. I have 4 - 6 listboxes on one page and used two routines to handle on the moving of selected items back and forth. I thought it was very sleek and compact. But I'm coming from 2002/2003 into 2010 so maybe what I did was pretty standard for 2010.

CARisk3 11-Mar-11 16:48pm View

I'm quite familiar with him. I've been on this board for about 2-3 years as what everyone would probably call a lurker. I take things in and only respond when I absolutely feel the need to. I get a lot of amusement and information from this board and enjoy the camaraderie between everyone.

When I'm really stuck and can't find an answer here or on google then I post a question.

CARisk3 18-Aug-10 15:26pm View

Thank you for your assistance. I'll try this. I looked on google and wasn't having any luck finding what I needed so I really appreciate the link.

Thanks,
Carolyn

Comments by CARisk3 (Top 18 by date)