.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Dump Structure + Data to Screen

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :ASP.Net

Short version:

I'm looking for a simple way to, using asp, to dump an SQL DB (structure and data) to the screen so I can save it.

Here's the long version:

We have a client who gives us very limited access to their server. We are able to drop files on their server and publish them to a WIP environemnt for testing using Web Publisher(awful), and that's about it. One of the sites we've been tasked to work on has a DB that was implemented before we came on board. The only way I can interface with it is via ASP. The client has now asked us for a list of people in the DB and their associated info. As they are a huge corporation and everything has to go through IT, and for various other political reasons on their end, interfacing with them to get a dump will take a ridiculously long time. So basically I was hoping there was a solution already out there that I could drop onto the server that would just spit out the entire DB, so I could save it and then get what I need.

Thanks in advance,


View Complete Post

More Related Resource Links

Import and Export Data (32-bit) Wizard to Dump Data to Excel


I am trying to export some data from a simple three-column table on my SQL 2008 R2 instance to Excel 2007 (also happens in Excel 2003). Our data has a lot of foreign (Hebrew) characters on it and although the copy works ok, the data as it appears in Excel is gibberish.

The source table in SQL contains three columns:

  • smallint - numbers
  • varchar(30) - hebrew text
  • varchar(50) - hebrew text
  • varchar(15) - hebrew text

When I fire up the Import-Export wizard I see the following: http://img524.imageshack.us/img524/1830/sqltable.png. When I click on the yellow warning for a conversion problem, I see this: http://img375.imageshack.us/img375/4255/conversion.png.

Do I need to modify the core SQL or change the data type? I already tried modifying the destination datatype to be varchar instead of LongText but that didn't help.

Any assistance would be fantastic!


Help me design this data structure system of multi-toggle buttons?


Lets say you  have three buttons, button1, button2, and button3.  Three buttons, have 2^3+1 = 9 possible binary states.


Each state will pull and retrieve data from a database based on the combination toggle states of the button.  However, not all data exists for every combination.  For example:

000 - exists


010 - not exist

011 - not exist

100 - exists

101 - exists

110 -not exist

111 - exists

So now the problem is, how do I design the system so that when a user clicks a toggle button, the remaining possible buttons are either disabled or enabled?  I've thought about using a three-dimensional array but the problem is, when I have to add 30 toggle buttons, this looping becomes tediouis as each time a toggle button is clicked, the software  has to iterate through every possible combination again to check whether the truth table for that combination exist.

lets say from the above example, the user toggle button 1, which is 001.  His next possible choices are 101 and 111.  He can NOT choose 011 but the problem is 111 exists but to get to 111 he has to click button3 first, then button2, to get to state 111.  Because if he clicks button 2 first, his state becomes 011 and no data will be retrieved. 


Copying a database structure (with or without data)


I designed a database on my local machine (cert.mdf), and attached it to SQL Server Mgmt Studio.  I signed up with a db hosting company and copied it to their site (using "script database as / create to") and got it set up out there.  Since then I've made further changes to the design, but only to the web-based version.

Now I'd like to bring the web-based design back to my local cert.mdf so I can do some further development & testing but I can't seem to find a way to do that.  (I don't mind being destructive on my local machine).  If I try the same thing but in reverse, I get a 'metadata unreadable' error.  If I just try a copy (via mgmt studio) I get a message about 'unable to connect to local server'.


Loading rtf with image gives "Unrecognized structure in data format 'Rich Text Format'.\r\nParamet


I'm trying to load this rtf into a RichTextBox:

{\rtf1\ansi\ansicpg1252\uc1\htmautsp\deff2{\fonttbl{\f0\fcharset0 Times New Roman;}{\f2\fcharset0 Segoe UI;}}{\colortbl\red0\green0\blue0;\red255\green255\blue255;}\loch\hich\dbch\pard\plain\ltrpar\itap0{\lang1033\fs18\f2\cf0 \cf0\ql{\f2 {\ltrch >> -----------------------------------------------------}{\ltrch \line }{\ltrch >> 19-10-2010 11:22}{\ltrch \line }{\ltrch >> -----------------------------------------------------}{\ltrch \line }\li0\ri0\sa0\sb0\fi0\ql\par}
{\f2 {\ltrch {\*\shppict{\pict\picwgoal1020\pichgoal1035\pngblip

How to extract data from screen or picture


Hi Guys,

I'm thinking of a way to extract data (e.g. the data displayed in a flash game in IE, I want to extract user's level/HP, etc). Is it possible to make it only from analyzing the data displayed on the screen without writing network injecting code to get the data?

Cause I want to do it with a legal way, guess this can be related with some graphic technology.

If it's possible, can someone give more guidance about this? Great if can be found in .Net.

Thanks a lot. 



creating a data structure from an image



i want to convert an image to a data structure(graph) can any one has an idea how to do this


Display data on a TV screen

I have a need to display a data array on a Tv screen. The screen data is from a VB 2010 form that is developed durimh program running. The array is generated from data entered into an Access database, so the form needs to close after sending data so the program can continue to run. My question is what is the best way to provide this data to the external TV? Is there an external device other than a second PC that can hold the data and refresh the screen? Any help will be appreciated.
David Lethert

Data structure to automatically sync data between windows application and Microsoft SQL Server



I dont know whether I am posting this question in the right forum, please move it if needed. I have a windows application that shows data from a SQL table. I cannot use DataGridView in the application, I have a custom form to display the data. I need a datastructure to hold the table data and I display it using my custom windows form. Which data structure should I use to automatically sync data between windows application and SQL Server? I don't want to manually write Update queries. Any help would be appreciated.

Reportviewer 2010 is coming with blank screen. Data exists on the page but not showing on the screen


17 hours, 7 minutes ago

Error when building a Data Mining Structure with nested tables on cubes


Apparently there is a bug in Analysis Services (2008R2) when building a Data Mining Structure (Time Series model) with nested tables on cubes. If the dimension key has a column name, AS becomes confused and gives an error that do not allow to process the structure.

"Error (Data mining): The data type specified for the  'xxxxx' column of the 'nnnnnn' OLAP mining structure is not compatible with its source attribute ('xxxxx' in the 'dddddd' cube dimension")

 Everything is solved by removing the name column, in the attribute of the dimension used. This bug was already reported for SQL2005 in: http://social.msdn.microsoft.com

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Snap It! - How to take screen shot using .Net

We all would have used snap shots (screen shots) to illustrate bugs or behavior or something that others could understand by seeing them. For taking snap shots we just hit the "Print Screen" key and copy it to Ms Paint and save it. Ever wondered how to programmatically take a snap shot? Then this article is for you.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Dynamic Data Templates in GridView ASP.NET 3.5

At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend