Click here to Skip to main content
15,902,032 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Drop Down List Selected Value Problem Pin
Unknown Ajanabi7-Nov-07 19:21
Unknown Ajanabi7-Nov-07 19:21 
GeneralRe: Drop Down List Selected Value Problem Pin
Kurian_Kurian7-Nov-07 19:54
Kurian_Kurian7-Nov-07 19:54 
GeneralRe: Drop Down List Selected Value Problem Pin
Nitin19817-Nov-07 20:12
Nitin19817-Nov-07 20:12 
AnswerRe: Drop Down List Selected Value Problem Pin
Unknown Ajanabi7-Nov-07 20:12
Unknown Ajanabi7-Nov-07 20:12 
AnswerRe: Drop Down List Selected Value Problem Pin
N a v a n e e t h7-Nov-07 21:52
N a v a n e e t h7-Nov-07 21:52 
QuestionFile System Browsing in ASP.NET - Need Code Help Pin
cadracing7-Nov-07 17:56
cadracing7-Nov-07 17:56 
AnswerRe: File System Browsing in ASP.NET - Need Code Help Pin
Christian Graus7-Nov-07 19:21
protectorChristian Graus7-Nov-07 19:21 
QuestionData Blues Pin
BezerkRogue7-Nov-07 15:56
BezerkRogue7-Nov-07 15:56 
I have tried till my eyes bled to get a gridview to work so I have resorted to going back to the traditional asp recordset. I still have nothing showing up. Please help, this thing has been stomping me for a week. (FYI I am new to development in general...please have mercy Smile | :) )
Here is my code:
<%
Dim strShift, strType, strDate, objRS, strSQL, objConn, strConn, strShiftPull, strTypePull, rShift, rType

strDate = Request.QueryString("OccDate")

strShiftPull = Request.QueryString("pShift")
strTypePull = Request.QueryString("pType")

'Set shift query variables.
If strShiftPull = "IP1" Then
rShift = "1"
End If
If strShiftPull = "IP2" Then
rShift = "2"
End If
If strShiftPull = "IP3" Then
rShift = "3"
End If
If strShiftPull = "IP Supplier" Then
rShift = "8"
End If
If strShiftPull = "CMA1" Then
rShift = "4"
End If
If strShiftPull = "CMA2" Then
rShift = "5"
End If
If strShiftPull = "CMA3" Then
rShift = "6"
End If
If strShiftPull = "CMA Supplier" Then
rShift = "7"
End If

'Set incident type query variables
If strTypePull = "Lost Time Accident" Then
rType = "1"
End If
If strTypePull = "Recordable" Then
rType = "2"
End If
If strTypePull = "Incident" Then
rType = "3"
End If
strShift = rShift
strType = rType


objConn = Server.CreateObject("ADODB.Connection")
objRS = Server.CreateObject("ADODB.Recordset")
strConn = "DSN=XXXX; driver={SQL Server}; UID=XXXX; PWD=XXXX;"
strSQL = "Select * from Safety_Data where Shift_ID = '" & strShift & "' and Xref_ID = '" & strType & "'"
objConn.open(strConn)
objRS.ActiveConnection = objConn

objRS.open(strSQL)

If Not objRS.EOF Then

Do While Not objRS.EOF
%>
<%
objRS.Fields("RID").value.ToString()
%>
<%
objRS.Fields("Notes").value.ToString()
%>
<%
objRS.MoveNext()
Loop
Else
Response.Redirect("NoIncRepFound.aspx")
End If
%>



Enter Record Number:<asp:textbox id="txtSelect" runat="server">
<asp:button id="cmdSubmit" runat="server" text="Submit">

AnswerRe: Data Blues Pin
Christian Graus7-Nov-07 17:42
protectorChristian Graus7-Nov-07 17:42 
Questionoracle conncetion error Pin
uowzd017-Nov-07 15:03
uowzd017-Nov-07 15:03 
QuestionRepeater within update panel - slow Pin
debbie_cruz7-Nov-07 13:37
debbie_cruz7-Nov-07 13:37 
QuestionASP .NET 2.0 Login Control Pin
kenexcelon7-Nov-07 10:39
kenexcelon7-Nov-07 10:39 
AnswerRe: ASP .NET 2.0 Login Control Pin
Pete O'Hanlon7-Nov-07 11:39
mvePete O'Hanlon7-Nov-07 11:39 
GeneralRe: ASP .NET 2.0 Login Control Pin
kenexcelon8-Nov-07 9:04
kenexcelon8-Nov-07 9:04 
GeneralRe: ASP .NET 2.0 Login Control Pin
Pete O'Hanlon8-Nov-07 9:28
mvePete O'Hanlon8-Nov-07 9:28 
QuestionLoading image at run time in a custom control used in a page. How to code this? Pin
Frankidoze7-Nov-07 8:41
Frankidoze7-Nov-07 8:41 
AnswerRe: Loading image at run time in a custom control used in a page. How to code this? Pin
pmarfleet7-Nov-07 9:44
pmarfleet7-Nov-07 9:44 
GeneralRe: Loading image at run time in a custom control used in a page. How to code this? Pin
Frankidoze7-Nov-07 10:00
Frankidoze7-Nov-07 10:00 
GeneralRe: Loading image at run time in a custom control used in a page. How to code this? Pin
pmarfleet7-Nov-07 10:11
pmarfleet7-Nov-07 10:11 
GeneralRe: Loading image at run time in a custom control used in a page. How to code this? Pin
Frankidoze7-Nov-07 10:55
Frankidoze7-Nov-07 10:55 
GeneralRe: Loading image at run time in a custom control used in a page. How to code this? Pin
ahmet.ureten8-Nov-07 10:11
ahmet.ureten8-Nov-07 10:11 
AnswerRe: Loading image at run time in a custom control used in a page. How to code this? Pin
Guffa7-Nov-07 10:12
Guffa7-Nov-07 10:12 
GeneralRe: Loading image at run time in a custom control used in a page. How to code this? Pin
Frankidoze7-Nov-07 10:46
Frankidoze7-Nov-07 10:46 
AnswerI found the solution...Probably will write a paper about it Pin
Frankidoze7-Nov-07 12:05
Frankidoze7-Nov-07 12:05 
AnswerSolution Pin
Frankidoze7-Nov-07 12:34
Frankidoze7-Nov-07 12:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.