ParentID points to the ID field so that ID 2 is the child of ID 1.
Unfortunately, the order of the db elements is not guaranteed but what I'd like to do is have the information displayed sort of like in windows explorer with the children directly underneath the parents.
I've done something similar in the past with nested gridviews (ugh!), but it didn't point to itself and I knew how many children (additional db tables) there would be in advance. I'm basically trying to re-create that setup but make it much more flexible by making it point to itself.
Pseudo Coding I'd do something like:
Setup the html table and table headers Go through the DB from the top and search for the row with ParentID = 0 Add that row to the table Go through the db and find the row where ParentID = ID of Step 2)Add that row to the table Recursive magic go back to 4 Keep going deeper inception style ^^ Recursive magic go back to 2
I just have no idea how to even begin doing something like this!
This has nothing to do with my problem, but so you know where I'm going with this: after I get the table/gridview setup in the correct order, I plan on using jquery to hide all the non 0 parentID rows and make the rows clickable so that the child rows expand out underneath the parent row.
Weird Sunday morning question: I routinely drag files into my projects from Windows Explorer. But I just created a new project and I get the slashed circle every time I try to drag in a file from Windows Explorer. I closed the project and opened another one just to confirm that I wasn't having a foggy Sunday morning problem but I _am_ able to drag files into the this other project. Trying to drag the same file into my new project won't work. What's up with this?!
i have table something like this on click of export to excel i need to save that or export that to excel file .can u plz help me how i can do this.one more thing how i can desing and build that big html table into excel is there any simple way i can do the same
I am exporting HTML table/Repeater to excel, its not working on Windows server 2008, however same working on Windows Server 2003 and local machine
[Code]....
I have debug on Windows Server 2008, I am getting the same string that is on my local machineResponse.Write(sw.ToString()); but nothing wrote on my file and not getting any errorI have tried hard but not able to figure out the issue
the possible options to get the dynamic web pages. Existing application: We have windows application to desing the "Screen designer templates". The end user uses this application to make his own screen templates, save the information in xml and get the screen in run time. This works fine for windows based application. Current Problem: Its difficult to provide such screen designer application in web. I mean Drag & drop the controls in web page during the run time. So we are planning to use windows application to design the template. And during the run time user should get his own designed template on web page. We are trying to display the similar web form like as windows form with matching controls. let me know what are the options available to solve this problem.
Anyone know of a skinnable audio player (or something similar to Windows Vista audio control in task bar) that i can embed in my website?
A player that can be customized to use a 'speaker' icon instead of a 'play' icon. When the speaker is clicked, the volume can be adjusted or turned off. The option of being able to autoplay and set the default volume level.
We have a Web Role that we are hosting in Windows Azure that uses an old ASMX based Web Reference to contact an external system. The Web Reference proxy code is big enough that instantiating it the first time has a significant cost.
We'd like to be able to have this run when the Web Role starts instead of on the first request.
I know IIS 7.5 has an Application Warm-Up module that would allow us to achieve this, but I'm having trouble figuring out if something similar exists with hosting on Windows Azure.
I would like to create a webpage that collects a users search criteria. Then when they click a button, send the parameters to the Windows Explorer Search utility and run it. Can this be done? If so, how? I am using asp.net to create my webpages.
I have a question regarding a situation that occurs with GridView, ObjectDataSource in ASP .NET application. The GridView is linked to the ObjectDataSource and both are included within an UpdatePanel letting the GridView to fill in an asynchronous way from a form in the same page so it gets more rows as the user enters the data:
I start the project with Visual Studio 2008, fill the form and it works correctly. Then I stop the execution: rerun again and the data I entered in the previous run is in the GridView. Is like some sort of cache saved the data from the session before. I checked that EnableCaching property is set to false for the ObjectDataSource. If I Rebuild Web Site in Visual Studio (not just Build) then it works corretly leaving the GridView empty. Is this caused just becuase of Visual Studio? Can it be turned off? And will it happen in the final IIS it will run on?
I have a piece of sql code that selects the top 10% of a table. See below a sample of the database table
And this is my code
[Code]....
So what this code does is add up all the points in the points table, (also works out what percentage of the points each user has) and then displays the top 10%, which in this case will give me "John" and "Dave"
So what I need the sql to do is check if any other records in that table have the same number of points ast the last selected record, and to select it to.
Two machines. One a little faster than the other. The slow one runs windows xp, visual webdeveloper express 2010, sql server 2008. The fast one runs windows server 2008, visual wev developer express 2010, sql server 2008.The code in queston involves an automatically generated update function in one of the table adapters, called 'adapter'. Our C# code generates a data table called 'table', with which we update our 'datatable' in the table adapter.
The table has about 100 entries.We then update our datatable in the .xsd file by calling.
int rowsaffected = adapater.Update(table);//this is the line that takes long on fast computer return rowsaffected > 0;//since function returns a bool On the slow machine this line of code takes a few milliseconds.One the fast machine it takes 5 seconds.These results are consistent. It has nothing to do with one machine being busy, the other idle.
What could be the reason and how could it be solved? How can the same code, on the same platform, on a faster machine take 500 times longer than on a slower machine?
I am using ShDocVW.InternetExplorer class to spawn a new internet explorer object and to do some form filling stuffs(for some sharepoint works).It works fine in my own machine which has Windows 7 as the OS. But when I deployed the same thing in windows server 2003 machine, it does not pop up the internet explorer window. When I check the Task Manager, I could see a new iexplore process, but with Session ID = 0 (but session ID = 1 in windows 7). So, I see this is something regarding IIS Session isolation.So, is it possible to assign a ShDocVW.InternetExplorer instance to kind of a new System.Diagnostics.Process and achieve this task? Or can we start a new ShDocVW.InternetExplorer instance with session ID = 1?
I've been doing this project at work on a little app that we use for building and deploying websites to different customers. It works quite well, and we actually only have to press two buttons to have our DataProviders and DataRecords generated from sql and having our dll's compiled and everything sent to the customers ftp as a zip file, ready to unpack and use.
Now the problem is that since I've upgraded to Windows 7 (was XP) our compiler (either csc.exe or the msbuild.exe) seems to be messing with the codepage of our generated files. Resulting in æøå and characters alike are being converted to what seems to be ANSI encoding (this doesn't happen when running on XP).
I've been searching the net to find a viable solution to our problem and the only thing I have come upon is that the .NET framework version 4 has a parameter for codepage. Since we are using webdeploy build files on the 2.0 framework (and don't have time to roll our projects on to the next version framework) I would like to know if anyone has a quick remedy to resolve our problems with codepage.
I`ve dropped the Bairro table and I`ve created a new table with one more column, with data from the original one. However, I am not seeing anymore the table in the object explorer, in Sql Management Studio 2005.
When I open the Database Diagram the software shows a message box saying that the have been dropped or that I don`t have enough privileges for the table.
What can I do to see the table in the Object Explorer?
I am the dbo owner of the database and the schema dbo.
I have been design a site it is started nice in explorer but it is not nice I mean it different from IE (borders and alignments) in opera and some other browser. How I can set my site to load by all browser ? I use asp.net to design pages. net framwork 4.0
I have seen multiple posts and websites regarding this issue, yet none of the solutions / workarounds posted have worked for me. I am trying to load an ASP.NET report into an iFrame. The iFrame will load correctly (across all browsers), but when I run the report, Internet Explorer only will show the following error:
ASP.NET session has expired I have tried to use an HTML form to POST and target the iframe, as the workaround suggests here: [URL]I have also tried adding the following to the web.config file of the report application:
I have selected the tables using the wizard, but for some reason CR doesn't display all the fields in the tables, so there are some tables in Field Explorer that lack some fields. The fields that aren't shown are both int, and varchar, some of them allow nulls and some of them don't, I can't seem to find a pattern as why some fields aren't loaded into Field Explorer.
I added a DateTime column to a table in my database through the Server Explorer. Because the team lead for this project wasn't savvy on nullable types, one of the requirements was that there be no null values in the database. This requires me to program all sorts of useless code into the system, but that's another story. My problem arises when assigning a default value to this column. I typed the following into the cell for the "Default Value or Binding":
1/1/1753 12:00:00 AM
When I went to inspect the content of the table, I found that all of the dates had been populated with:
With jquery quicksearch in gridview i can able to search the data.But the searched data ie. the filtered data how to export the searched or filtered data from gridview to excel .I tried it but i am getting only gridview first loaded data not the searched data.
I have a table with lots of fields. To display every record that has lots of columns on a web browser will inconveniently force the users to drag the scrollbar to the right.
Is it possible to divide each record to two or three inner rows in gridview?
e.g. My table has these fields: - UPC - Description - AdType_Week1 - AdType_Week2 - AdType_Week3 - AdType_Week4 - AdType_Week5 - Price_Week1 - Price_Week2 - Price_Week3 - Price_Week4 - Price_Week5 - OrderStatus_Week1 - OrderStatus_Week2 - OrderStatus_Week3 - OrderStatus_Week4 - OrderStatus_Week5
Instead of showing everything in one header like this:
|-UPC-|-Description-|-AdType_Week1------|-AdType_Week2------|-AdType_Week3------| 01 banana type abc type def type feg |-Price_Week1-------|-Price_Week2-------|-Price_Week3-------| $97.51 $78.48 $41.45
