Solved

categories and subcategories display in the dropdown/gridview (part 2)

Posted on 2012-04-02
42
388 Views
Last Modified: 2012-05-09
0
Comment
Question by:bsarahim
  • 22
  • 20
42 Comments
 
LVL 42

Accepted Solution

by:
sedgwick earned 500 total points
ID: 37795025
1. it goes in to unended loop and the webpage goes on requesting ... but never display anything.

2..for your earlier drop down solution im getting the following error..

Private Sub list_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles listBox1.SelectedIndexChanged



        Dim curItem As String = Listbox1.SelectedItem.Value





        Dim list As New List(Of Integer)()
        Dim tokens = curItem.Split(New String() {"->"}, StringSplitOptions.RemoveEmptyEntries)

        ' Response.Write(tokens.ToString)

        'Response.End()

        For Each item In tokens
            list.Add(Integer.Parse(item))
        Next

        If list.Count > 1 Then
            Dim parentCatId As Integer = list(list.Count - 2)
            Response.Write(parentCatId)
        Else

        End If



    End Sub



Error details:

Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:


Line 161:
Line 162:        For Each item In tokens
Line 163:            list.Add(Integer.Parse(item))
Line 164:        Next
Line 165:
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37795029
when the SelectedIndexChanged is triggered, what are the values in the list?

>>Input string was not in a correct format. -> this exception occurs because the item cannot be converted to integer.
so what is the value of the item when the exception rises?
0
 

Author Comment

by:bsarahim
ID: 37796655
any of the item it is giving a error..
0
 

Author Comment

by:bsarahim
ID: 37801562
waiting for you reply.. thanks
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37801659
when the SelectedIndexChanged is triggered, what are the values in the Listbox1?
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37801749
the listbox1 should contain items like the following:
1->2->6
2->5->8
3->6

in the values in the listbox are not in this format, none of the code will work.
0
 

Author Comment

by:bsarahim
ID: 37802523
thanks..

Pls see the image, which has the details.. thanks
picture.png
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37804771
so instead of list we need dictionary to map category id to name.
can u post the full code?, i'll make the change on that
0
 

Author Comment

by:bsarahim
ID: 37804780
Here is the full code.. thanks

 Private Sub list_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles listBox1.SelectedIndexChanged



        Dim curItem As String = Listbox1.SelectedItem.Value





        Dim list As New List(Of Integer)()
        Dim tokens = curItem.Split(New String() {"->"}, StringSplitOptions.RemoveEmptyEntries)

        ' Response.Write(tokens.ToString)

        'Response.End()

        For Each item In tokens
            list.Add(Integer.Parse(item))
        Next

        If list.Count > 1 Then
            Dim parentCatId As Integer = list(list.Count - 2)
            Response.Write(parentCatId)
        Else

        End If



    End Sub

-------------------------------------
page_onload


        If Not (Page.IsPostBack) Then



            Dim sqlConn As New SqlConnection
            Dim strConn As String

            Dim cmd As New SqlClient.SqlCommand

            strConn = System.Configuration.ConfigurationManager.ConnectionStrings("JC").ConnectionString
            sqlConn = New SqlConnection(strConn)
            'Dim reader1, reader As SqlDataReader

            cmd.Connection = sqlConn

            sqlConn.Open()
            Dim adapter As SqlDataAdapter = New SqlDataAdapter("SELECT [Id] ,[Name] ,[ParentCategoryId]  FROM [nopCommerce].[dbo].[Category]", sqlConn)


            Dim dataSet As DataSet = New DataSet()
            adapter.Fill(dataSet, "Ordersvariant")


            Dim dt As DataTable = dataSet.Tables(0)

            Dim parentId As Integer = 0
            ' Dim list As New List(Of String)()
            Dim rows = dt.Rows.Cast(Of DataRow)()
            Dim item As DataRow

            For Each item In rows

                parentId = CInt(item("parentcategoryid"))
                Dim name As String = item("Name").ToString()

                While parentId > 0
                    Dim row = rows.Where(Function(n) CInt(n("Id")) = parentId).FirstOrDefault()

                    If row IsNot Nothing Then
                        parentId = CInt(row("parentcategoryid"))
                        name = String.Format("{0}->{1}", row("Name"), name)
                    End If
                End While
                Listbox1.Items.Add(name)

           
            Next





        End If
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37804873
create a member in your page class:
Dim MapCategory As New Dictionary(Of String, Integer)

--page_onload


        If Not (Page.IsPostBack) Then



            Dim sqlConn As New SqlConnection
            Dim strConn As String

            Dim cmd As New SqlClient.SqlCommand

            strConn = System.Configuration.ConfigurationManager.ConnectionStrings("JC").ConnectionString
            sqlConn = New SqlConnection(strConn)
            'Dim reader1, reader As SqlDataReader

            cmd.Connection = sqlConn

            sqlConn.Open()
            Dim adapter As SqlDataAdapter = New SqlDataAdapter("SELECT [Id] ,[Name] ,[ParentCategoryId]  FROM [nopCommerce].[dbo].[Category]", sqlConn)


            Dim dataSet As DataSet = New DataSet()
            adapter.Fill(dataSet, "Ordersvariant")


            Dim dt As DataTable = dataSet.Tables(0)

            Dim parentId As Integer = 0
            ' Dim list As New List(Of String)()
            Dim rows = dt.Rows.Cast(Of DataRow)()
            Dim item As DataRow

            For Each item In rows

                parentId = CInt(item("parentcategoryid"))
                Dim name As String = item("Name").ToString()

                While parentId > 0
                    Dim row = rows.Where(Function(n) CInt(n("Id")) = parentId).FirstOrDefault()

                    If row IsNot Nothing Then
                        parentId = CInt(row("parentcategoryid"))
                        name = String.Format("{0}->{1}", row("Name"), name)
                    End If
                End While
MapCategory.Add(name, parentId)
                Listbox1.Items.Add(name)

           
            Next

        End If

Open in new window


in your SelectedIndexChanged:
 Private Sub list_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles listBox1.SelectedIndexChanged

        Dim curItem As String = Listbox1.SelectedItem.Value

--get parentid of selected item
            Dim parentCatId As Integer = MapCategory(curItem))
            Response.Write(parentCatId)

        End If

    End Sub

Open in new window

0
 

Author Comment

by:bsarahim
ID: 37804893
thanks

im getting the following error in any of the selection of the dropdownlist


The given key was not present in the dictionary.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

Source Error:


Line 154:
Line 155:        '--get parentid of selected item
Line 156:        Dim parentCatId As Integer = MapCategory(curItem)
Line 157:        Response.Write(parentCatId)
Line 158:
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37805011
on line 156, what is the value of curItem when the exception occurs>?
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37805210
found a bug in the for each (line 34).
replace it with:

            For Each item In rows
dim orgParentId as Integer
                orgParentId =parentId = CInt(item("parentcategoryid"))
                Dim name As String = item("Name").ToString()

                While parentId > 0
                    Dim row = rows.Where(Function(n) CInt(n("Id")) = parentId).FirstOrDefault()

                    If row IsNot Nothing Then
                        parentId = CInt(row("parentcategoryid"))
                        name = String.Format("{0}->{1}", row("Name"), name)
                    End If
                End While
MapCategory.Add(name, orgParentId )
                Listbox1.Items.Add(name)

           
            Next

Open in new window


now, the map contains the following:
key:                         value:
A->B->C                  2

while 2 is the parentid of A which is the id of B.

so each the selectedIndex change event will take the current select item from the list and using the map get its parent id.
0
 

Author Comment

by:bsarahim
ID: 37805286
Apparel & Shoes->Apparel accessories
testing11

etc.,

  Dim curItem As String = Listbox1.SelectedItem.Value
        Response.Write(curItem)
        Response.End()


        '--get parentid of selected item
        Dim parentCatId As Integer = MapCategory(curItem)
        Response.Write(parentCatId)
0
 

Author Comment

by:bsarahim
ID: 37805294
i have noticed all the values are 00000000000000000000
when i write   Response.Write(parentId)


 While parentId > 0
                    Dim row = rows.Where(Function(n) CInt(n("Id")) = parentId).FirstOrDefault()

                    If row IsNot Nothing Then
                        parentId = CInt(row("parentcategoryid"))
                        name = String.Format("{0}->{1}", row("Name"), name)
                    End If
                End While
                MapCategory.Add(name, parentId)
                Response.Write(parentId)
                Listbox1.Items.Add(name)


                'List.Items(parentId).Text = name
            Next
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37805298
did u update the code according to my last comment?
0
 

Author Comment

by:bsarahim
ID: 37805486
yes.. the whole code is again..

 If Not (Page.IsPostBack) Then



            Dim sqlConn As New SqlConnection
            Dim strConn As String

            Dim cmd As New SqlClient.SqlCommand

            strConn = System.Configuration.ConfigurationManager.ConnectionStrings("JC").ConnectionString
            sqlConn = New SqlConnection(strConn)
            'Dim reader1, reader As SqlDataReader

            cmd.Connection = sqlConn

            sqlConn.Open()
            Dim adapter As SqlDataAdapter = New SqlDataAdapter("SELECT [Id] ,[Name] ,[ParentCategoryId]  FROM [nopCommerce].[dbo].[Category]", sqlConn)


            Dim dataSet As DataSet = New DataSet()
            adapter.Fill(dataSet, "Ordersvariant")


            Dim dt As DataTable = dataSet.Tables(0)

            Dim parentId As Integer = 0
            ' Dim list As New List(Of String)()
            Dim rows = dt.Rows.Cast(Of DataRow)()
            Dim item As DataRow

            For Each item In rows

                parentId = CInt(item("parentcategoryid"))
                Dim name As String = item("Name").ToString()
                Response.Write(parentId)
                While parentId > 0
                    Dim row = rows.Where(Function(n) CInt(n("Id")) = parentId).FirstOrDefault()

                    If row IsNot Nothing Then
                        parentId = CInt(row("parentcategoryid"))
                        name = String.Format("{0}->{1}", row("Name"), name)
                    End If
                End While
                MapCategory.Add(name, parentId)
                Response.Write("<BR>" & parentId)
                Listbox1.Items.Add(name)
             
            Next

        End If


---------------
 Private Sub list_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles listBox1.SelectedIndexChanged





        Dim curItem As String = Listbox1.SelectedItem.Value


        Response.Write(curItem)

        Response.End()


        '--get parentid of selected item
        Dim parentCatId As Integer = MapCategory(curItem)
        Response.Write(parentCatId)
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37805648
u didn't replace the for each loop with the code i've posted:

If Not (Page.IsPostBack) Then



            Dim sqlConn As New SqlConnection
            Dim strConn As String

            Dim cmd As New SqlClient.SqlCommand

            strConn = System.Configuration.ConfigurationManager.ConnectionStrings("JC").ConnectionString
            sqlConn = New SqlConnection(strConn)
            'Dim reader1, reader As SqlDataReader

            cmd.Connection = sqlConn

            sqlConn.Open()
            Dim adapter As SqlDataAdapter = New SqlDataAdapter("SELECT [Id] ,[Name] ,[ParentCategoryId]  FROM [nopCommerce].[dbo].[Category]", sqlConn)


            Dim dataSet As DataSet = New DataSet()
            adapter.Fill(dataSet, "Ordersvariant")


            Dim dt As DataTable = dataSet.Tables(0)

            Dim parentId As Integer = 0
            ' Dim list As New List(Of String)()
            Dim rows = dt.Rows.Cast(Of DataRow)()
            Dim item As DataRow

            For Each item In rows

Dim orgParentId as Integer
                orgParentId =parentId = CInt(item("parentcategoryid"))
                Dim name As String = item("Name").ToString()

                While parentId > 0
                    Dim row = rows.Where(Function(n) CInt(n("Id")) = parentId).FirstOrDefault()

                    If row IsNot Nothing Then
                        parentId = CInt(row("parentcategoryid"))
                        name = String.Format("{0}->{1}", row("Name"), name)
                    End If
                End While
MapCategory.Add(name, orgParentId )
Response.Write("<BR>" & parentId)
                Listbox1.Items.Add(name)

           
            Next
                                            

        End If

Open in new window

0
 

Author Comment

by:bsarahim
ID: 37805669
Based on your code, the dropdown will display like this

pls see the image
Untitled-picture1.png
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37805752
change:
Response.Write("<BR>" & parentId)

with:
Response.Write("<BR>" & parentId)
Response.Write("<BR>" & name)

what is printed?
0
 

Author Comment

by:bsarahim
ID: 37809764
thanks.. it is printing like this below

0
Books
0
Computers
0
Desktops
0
Notebooks
0
Accessories
0
Software
0
Games
0
Electronics
0
Camera, photo
0
Cell phones
0
Apparel & Shoes
0
Shirts
0
Jeans
0
Shoes
0
Apparel accessories
0
Digital downloads
0
Jewelry
0
Gift Cards
0
Battery
0
testing11
0
tsting12
0
tsting12ww
0
tsting12wwee
0
tsting12wwees
0
battery23232
0
3rd
0
testing2323
0
Hello Group
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 42

Expert Comment

by:sedgwick
ID: 37809789
i reviewd the code few times i dont understand whats wrong.

under this line:
 While parentId > 0

add:
Response.Write("<BR>" & name)

and remove the other Response.Write() lines.
what is it printing?
0
 

Author Comment

by:bsarahim
ID: 37809807
I have added the below  after While parentId > 0, but I feel. nothing is getting display..

 While parentId > 0

                    Response.Write("<BR>jjjj" & name)

thanks
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37809984
that means parentId is always 0 for all rows.
check  line 34:
orgParentId =parentId = CInt(item("parentcategoryid"))

parentId is always 0 which means the datatable has wrong values for parentcategoryid.
i'd check  in DB that parentcategoryid is not 0 for all rows.
then run the query in your DB and see that the results are correct.

add those lines:
Dim ids = String.Join(",", dt.Rows.Cast(Of DataRow)().[Select](Function(n) n("ParentCategoryId")).ToArray())
Response.Write("<BR>ids: " & ids )

Open in new window


under
 
Dim dt As DataTable = dataSet.Tables(0)

Open in new window

0
 

Author Comment

by:bsarahim
ID: 37809994
Im getting the values

ids: 0,0,2,2,2,2,2,0,8,8,0,11,11,11,11,0,0,0,0,0,0,0,0,0,20,25,19,27



----------------------------------------------
The full code is

If Not (Page.IsPostBack) Then



            Dim sqlConn As New SqlConnection
            Dim strConn As String

            Dim cmd As New SqlClient.SqlCommand

            strConn = System.Configuration.ConfigurationManager.ConnectionStrings("JC").ConnectionString
            sqlConn = New SqlConnection(strConn)
            'Dim reader1, reader As SqlDataReader

            cmd.Connection = sqlConn

            sqlConn.Open()
            Dim adapter As SqlDataAdapter = New SqlDataAdapter("SELECT [Id] ,[Name] ,[ParentCategoryId]  FROM [nopCommerce].[dbo].[Category]", sqlConn)


            Dim dataSet As DataSet = New DataSet()
            adapter.Fill(dataSet, "Ordersvariant")


            Dim dt As DataTable = dataSet.Tables(0)

            Dim ids = String.Join(",", dt.Rows.Cast(Of DataRow)().[Select](Function(n) n("ParentCategoryId")).ToArray())
            Response.Write("<BR>ids: " & ids)


            Dim parentId As Integer = 0
            ' Dim list As New List(Of String)()
            Dim rows = dt.Rows.Cast(Of DataRow)()
            Dim item As DataRow

            For Each item In rows

                Dim orgParentId As Integer
                orgParentId = parentId = CInt(item("parentcategoryid"))
                Dim name As String = item("Name").ToString()

                While parentId > 0

                    Response.Write("<BR>jjjj" & name)


                    Dim row = rows.Where(Function(n) CInt(n("Id")) = parentId).FirstOrDefault()

                    If row IsNot Nothing Then
                        parentId = CInt(row("parentcategoryid"))
                        name = String.Format("{0}->{1}", row("Name"), name)
                    End If
                End While
                MapCategory.Add(name, orgParentId)
                'Response.Write("<BR>" & parentId)
                'Response.Write("<BR>" & name)


                Listbox1.Items.Add(name)


            Next


        End If
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37810191
ok so datatable is fine.

under             For Each item In rows
put  Response.Write("<BR>" & CInt(item("ParentCategoryId")))
0
 

Author Comment

by:bsarahim
ID: 37811840
im getting this values.. thanks

0
0
0
0
0
0
0
0
20
25
19
27
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37811880
so maybe it's case sensitive, change
orgParentId = parentId = CInt(item("parentcategoryid"))

to
orgParentId = parentId = CInt(item("ParentCategoryId"))
0
 

Author Comment

by:bsarahim
ID: 37811896
after copy paste, here is the full code..

but still the drop down values are plainvalues



 If Not (Page.IsPostBack) Then



            Dim sqlConn As New SqlConnection
            Dim strConn As String

            Dim cmd As New SqlClient.SqlCommand

            strConn = System.Configuration.ConfigurationManager.ConnectionStrings("JC").ConnectionString
            sqlConn = New SqlConnection(strConn)
            'Dim reader1, reader As SqlDataReader

            cmd.Connection = sqlConn

            sqlConn.Open()
            Dim adapter As SqlDataAdapter = New SqlDataAdapter("SELECT [Id] ,[Name] ,[ParentCategoryId]  FROM [nopCommerce].[dbo].[Category]", sqlConn)


            Dim dataSet As DataSet = New DataSet()
            adapter.Fill(dataSet, "Ordersvariant")


            Dim dt As DataTable = dataSet.Tables(0)

            Dim ids = String.Join(",", dt.Rows.Cast(Of DataRow)().[Select](Function(n) n("ParentCategoryId")).ToArray())
            'Response.Write("<BR>ids: " & ids)


            Dim parentId As Integer = 0
            ' Dim list As New List(Of String)()
            Dim rows = dt.Rows.Cast(Of DataRow)()
            Dim item As DataRow

            For Each item In rows
                ' Response.Write("<BR>" & CInt(item("ParentCategoryId")))

                Dim orgParentId As Integer
                orgParentId = parentId = CInt(item("ParentCategoryId"))
                Dim name As String = item("Name").ToString()

                While parentId > 0

                    '   Response.Write("<BR>jjjj" & name)


                    Dim row = rows.Where(Function(n) CInt(n("Id")) = parentId).FirstOrDefault()

                    If row IsNot Nothing Then
                        parentId = CInt(row("parentcategoryid"))
                        name = String.Format("{0}->{1}", row("Name"), name)
                    End If
                End While
                MapCategory.Add(name, orgParentId)
                'Response.Write("<BR>" & parentId)
                'Response.Write("<BR>" & name)


                Listbox1.Items.Add(name)


            Next


        End If
Untitled-picture1.png
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37811914
change:
    If row IsNot Nothing Then
                        parentId = CInt(row("parentcategoryid"))
                        name = String.Format("{0}->{1}", row("Name"), name)
                    End If

to

    If row IsNot Nothing Then
                        parentId = CInt(row("ParentCategoryId"))
                        name = String.Format("{0}->{1}", row("Name"), name)
                    End If
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37811931
    For Each item In rows

                Dim orgParentId As Integer
                orgParentId = parentId = CInt(item("ParentCategoryId"))
                Dim name As String = item("Name").ToString()

                While parentId > 0

                    Dim row = rows.Where(Function(n) CInt(n("Id")) = parentId).FirstOrDefault()

                    If row IsNot Nothing Then
                        parentId = CInt(row("ParentCategoryId"))
                        name = String.Format("{0}->{1}", row("Name"), name)
                        Response.Write("<BR>" &  name & parentId)

                    End If
                End While
                MapCategory.Add(name, orgParentId)

                Listbox1.Items.Add(name)

            Next

Open in new window

0
 

Author Comment

by:bsarahim
ID: 37811945
still the same plain dropdown values instead of ->

and when i click the selected index event

Server Error in '/' Application.
--------------------------------------------------------------------------------

The given key was not present in the dictionary.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

Source Error:


Line 221:
Line 222:        '--get parentid of selected item
Line 223:        Dim parentCatId As Integer = MapCategory(curItem)
Line 224:        Response.Write(parentCatId)
Line 225:
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37811981
this is .net so u should be able to debug your code.
i run this on my app few times and i couldn't figure out what's the problem.
in my last post i cleaned up all the response.write() besides the on on line 14.

 Response.Write("<BR>" &  name & parentId)

put breakpoint there and check if the name is being concatenated with the parent names.
the logic is that for each row we take the id and we look for the row of its parent using the ParentCategoryId (line 9), untill parentid equals 0.
then we move to the next row.
while doing so we concatenate the name and the parent name separated by -> (line 13)
0
 

Author Comment

by:bsarahim
ID: 37812042
ok .. no issues.. I will debug and come back to you on this..

1. totally differnt query: I want to display categroy, subcategories,.. in the treeview..
2.
. i want to dispaly the data in the gridview based on the Id, is being fetched on the data row..event

Dim adapter As SqlDataAdapter = New SqlDataAdapter("SELECT [Id] ,[Name] ,[ParentCategoryId]  FROM [nopCommerce].[dbo].[Category] where id=" & e.Row.Cells(0).Text, sqlConn)
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37812584
asp treeview?
0
 

Author Comment

by:bsarahim
ID: 37812759
asp.net 2/3.5 treeview.. yes..
0
 

Author Comment

by:bsarahim
ID: 37924935
still waiting for your solution.. thanks
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37925687
Please close this thread and open new question about the treeview
10x
0
 

Assisted Solution

by:bsarahim
bsarahim earned 0 total points
ID: 37930880
I've requested that this question be closed as follows:

Accepted answer: 0 points for bsarahim's comment #37812042
Assisted answer: 500 points for sedgwick's comment #37925687

for the following reason:

very helpful resource! Keep it up!
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37930881
u forgot to reward the points, 10x
0
 
LVL 42

Expert Comment

by:sedgwick
ID: 37930884
10x again for the points.
0
 

Author Closing Comment

by:bsarahim
ID: 37946031
good support
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now