Click here to Skip to main content
15,885,141 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Creating HTML Page with XSLT and XML Pin
Abhishek Sur3-Dec-09 23:38
professionalAbhishek Sur3-Dec-09 23:38 
GeneralRe: Creating HTML Page with XSLT and XML Pin
FJJCENTU4-Dec-09 5:17
FJJCENTU4-Dec-09 5:17 
GeneralRe: Creating HTML Page with XSLT and XML Pin
Abhishek Sur6-Dec-09 20:52
professionalAbhishek Sur6-Dec-09 20:52 
Questiondoesn't exist in the current context. Pin
FEMDEV3-Dec-09 6:29
FEMDEV3-Dec-09 6:29 
AnswerRe: doesn't exist in the current context. Pin
Gamzun3-Dec-09 8:20
Gamzun3-Dec-09 8:20 
AnswerRe: doesn't exist in the current context. Pin
Abhishek Sur3-Dec-09 11:16
professionalAbhishek Sur3-Dec-09 11:16 
GeneralRe: doesn't exist in the current context. Pin
FEMDEV3-Dec-09 22:37
FEMDEV3-Dec-09 22:37 
QuestionGet the first and last row for each child row Pin
AsianRogueOne3-Dec-09 6:12
AsianRogueOne3-Dec-09 6:12 
Hi All,

I am a newbie to ASP.NET and in need of you help, basically, I have a gridview that binded from two functions (type datatable). One function is parent which I past one parameter ("DeptID") while loading this table I also called the child funtion which get the parameter from the parent function ("FolderID"). The grid bind fine, but my tast is to place a down arrow at the first child row under the parent and an a up arrow at the last child row and the process repeated for each parent that have one or more rows.

This is where I have been banging head head trying to get this work but has no success.

Parent row data1
Down arrow Child row data - first row
up/down arrow Child row data
up/down arrow Child row data
up/down arrow Child row data
up arrow Child row data - last row

Parent row data2
Down arrow Child row data - first row
up/down arrow Child row data
up/down arrow Child row data
up arrow Child row data - last row

Parent row data3
Down arrow Child row data - first row
up/down arrow Child row data
up arrow Child row data - last row
Parent row data4
Child row data - first row


Any assistance is greatly apprecaited. please provide codes example.

Thanks
DocHoliday.

Here are my codes behind VB:

Protected Sub DisplayParentGV()
Dim Conn As New SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings("mConn").ToString)
Dim SQLCmd As New SqlCommand("Get_Links_Name", conn)
Dim SQLDBDataReader As SqlClient.SqlDataReader
Dim dt As New DataTable()

Try
If conn.State = ConnectionState.Closed Then
conn.Open()
End If
SQLCmd.CommandType = CommandType.StoredProcedure
SQLCmd.Connection = conn
SQLCmd.Parameters.Add("@DeptID", SqlDbType.Int, 60).Value = Convert.ToInt32(Session("Dept_id"))

dt.Columns.Add(New DataColumn("FolderID", GetType(String)))
dt.Columns.Add(New DataColumn("FolderFileID", GetType(String)))
dt.Columns.Add(New DataColumn("ImageType", GetType(String)))
dt.Columns.Add(New DataColumn("Page", GetType(String)))
dt.Columns.Add(New DataColumn("FolderOrder", GetType(String)))
dt.Columns.Add(New DataColumn("Link_FileOrder", GetType(String)))

SQLDBDataReader = SQLCmd.ExecuteReader()

While SQLDBDataReader.Read()
Dim dr As DataRow = dt.NewRow()
Dim Pid As Integer = Convert.ToInt32(SQLDBDataReader("FolderID"))

dr("FolderID") = (SQLDBDataReader("FolderID"))
dr("FolderFileID") = Nothing
dr("ImageType") = Nothing
dr("Page") = (SQLDBDataReader("Foldername"))
dr("FolderOrder") = (SQLDBDataReader("FolderOrder"))
dr("Link_FileOrder") = Nothing
Session("ParentBottonRow") = dt.Rows.Count
dt.Rows.Add(dr)
Dim ChildTable As DataTable = DisplayChildGV(Pid.ToString())
For Each dro As DataRow In ChildTable.Rows

Dim dr2 As DataRow = dt.NewRow()
dr2("FolderFileID") = dro("FolderFileID")
dr2("ImageType") = dro("ImageType")
dr2("Page") = dro("Link_FileName")
dr2("Link_FileOrder") = dro("Link_FileOrder")
dt.Rows.Add(dr2)

Next
End While

SQLDBDataReader.Close()

Catch ex As Exception
Throw
Finally
SQLCmd.Dispose()
gvParent.DataSource = dt
gvParent.DataBind()
conn.Close()
End Try
End Sub

Protected Function DisplayChildGV(ByVal FolderID As String) As DataTable
Dim Con As New SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings("mConn").ToString)
Dim dt As New DataTable()

dt.Columns.Add(New DataColumn("FolderFileID", GetType(String)))
dt.Columns.Add(New DataColumn("ImageType", GetType(String)))
dt.Columns.Add(New DataColumn("Link_FileName", GetType(String)))
dt.Columns.Add(New DataColumn("Link_FileOrder", GetType(String)))

Dim SQLCmd2 As New SqlCommand("Get_Links_Folder_Name", Con)

Try
If Con.State = ConnectionState.Closed Then
Con.Open()
End If
SQLCmd2.CommandType = CommandType.StoredProcedure
SQLCmd2.Connection = Con
SQLCmd2.Parameters.Add("@FolderID", SqlDbType.Int, 60).Value = Convert.ToInt32(FolderID)
Dim SQLDBDataReader2 As SqlClient.SqlDataReader = SQLCmd2.ExecuteReader()
'SQLDBDataReader2 = SQLCmd2.ExecuteReader()

While SQLDBDataReader2.Read()
Dim dr2 As DataRow = dt.NewRow()
dr2("FolderFileID") = SQLDBDataReader2("FolderFileID")
If Not IsDBNull(SQLDBDataReader2("LinkURL")) Then
dr2("ImageType") = ResolveUrl("~/Images/icon-ie.gif")
Else
Select Case Mid(SQLDBDataReader2("Link_FileName"), InStrRev(SQLDBDataReader2("Link_FileName"), "."))
Case ".xls"
dr2("ImageType") = ResolveUrl("~/Images/icon-xls.gif")
Case ".doc"
dr2("ImageType") = ResolveUrl("~/Images/icon-doc.gif")
Case ".pdf"
dr2("ImageType") = ResolveUrl("~/Images/icon-pdf.gif")
Case ".ppt"
dr2("ImageType") = ResolveUrl("~/Images/icon-ppt.gif")
Case ".txt"
dr2("ImageType") = ResolveUrl("~/Images/icon-text.gif")
End Select
End If
dr2("Link_FileName") = SQLDBDataReader2("Link_FileName")
dr2("Link_FileName") = SQLDBDataReader2("Link_FileName")
dr2("Link_FileOrder") = SQLDBDataReader2("Link_FileOrder")
Session("ChildBottonRowBolean") = SQLDBDataReader2.Read().ToString
dt.Rows.Add(dr2)

End While
Return dt
Catch ex As Exception
Throw
Finally
SQLCmd2.Dispose()
'gvParent.DataSource = dt
'gvParent.DataBind()
Con.Close()
End Try
End Function
AnswerRe: Get the first and last row for each child row Pin
Abhishek Sur3-Dec-09 11:05
professionalAbhishek Sur3-Dec-09 11:05 
GeneralRe: Get the first and last row for each child row Pin
AsianRogueOne4-Dec-09 4:46
AsianRogueOne4-Dec-09 4:46 
GeneralRe: Get the first and last row for each child row Pin
AsianRogueOne4-Dec-09 5:07
AsianRogueOne4-Dec-09 5:07 
GeneralRe: Get the first and last row for each child row Pin
Abhishek Sur6-Dec-09 21:06
professionalAbhishek Sur6-Dec-09 21:06 
AnswerRe: Get the first and last row for each child row Pin
AsianRogueOne10-Dec-09 6:56
AsianRogueOne10-Dec-09 6:56 
QuestionHow to Trace variables ? [modified] Pin
alaminfad3-Dec-09 5:14
alaminfad3-Dec-09 5:14 
AnswerRe: How to Trace variables ? Pin
Gamzun3-Dec-09 8:14
Gamzun3-Dec-09 8:14 
QuestionHiding AJAX extender icon Pin
dptalt3-Dec-09 2:14
dptalt3-Dec-09 2:14 
AnswerRe: Hiding AJAX extender icon Pin
Abhishek Sur3-Dec-09 2:29
professionalAbhishek Sur3-Dec-09 2:29 
Questionusing javascript to check validation in aspx page Pin
Member 47041433-Dec-09 0:07
Member 47041433-Dec-09 0:07 
AnswerRe: using javascript to check validation in aspx page Pin
Abhijit Jana3-Dec-09 0:21
professionalAbhijit Jana3-Dec-09 0:21 
GeneralRe: using javascript to check validation in aspx page Pin
Anurag Gandhi3-Dec-09 0:27
professionalAnurag Gandhi3-Dec-09 0:27 
GeneralRe: using javascript to check validation in aspx page Pin
Member 47041433-Dec-09 0:30
Member 47041433-Dec-09 0:30 
GeneralRe: using javascript to check validation in aspx page Pin
Abhijit Jana3-Dec-09 0:50
professionalAbhijit Jana3-Dec-09 0:50 
GeneralRe: using javascript to check validation in aspx page Pin
Abhishek Sur3-Dec-09 0:57
professionalAbhishek Sur3-Dec-09 0:57 
GeneralRe: using javascript to check validation in aspx page Pin
Abhijit Jana3-Dec-09 1:06
professionalAbhijit Jana3-Dec-09 1:06 
GeneralRe: using javascript to check validation in aspx page Pin
Abhishek Sur3-Dec-09 1:07
professionalAbhishek Sur3-Dec-09 1:07 

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.