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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Convert My DataBase into XML

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server
 
Is there a way to convert my database to XML File?


View Complete Post


More Related Resource Links

Upsize Your Database: Convert Your Microsoft Access Application to Take Advantage of SQL Server 7.0

  

What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.

Michael McManus

MSDN Magazine June 2000


Convert Q&A database (symantec) to SSIS supported database?

  
Hi Guys, What are the possible ways of converting Q&A  database (symantec) to SSIS supported database? Any clue will be of great help~Technology Analyst~

Convert Database ANSI To UNICODE

  
Hi Friends, I Have DB in 2008 And Now i want That table to convert To SQL 2000. So Can anybody tel how we can convert Data from ANSI to UNICODE and vice a versa. Thanks . 

convert date to mmddyy format before submit to database

  
Dear all,   Could anyone pls guide me on how to convert date in textbox which is in format(dd/mm/yy) to mmddyy before submit to database.    

convert string to int before updating database table?

  

I have a form in which I display data from a database table, change the data and then update the database table. The form consists of textboxes, so all data displayed in the form is string. However - one data is int in the database table (the rest is varchar), so I need to convert it from string to int when I update the database table. How do I do it?


protected void SaveProd_Click(object sender, EventArgs e)
    {
        string BildID = TextBoxProdPictID.Text;
        string namn = TextBoxProdName.Text;
        string kategori = TextBoxProdCategory.Text;
        string stl = TextBoxProdSize.Text;
        string pris = TextBoxProdPrice.Text;
        string iLager = TextBoxProdNumberOf.Text; //this is int in the database table

        SqlConnection conn = new SqlConnection(config);
      //  conn.Open();
        string sql = "UPDATE Produkter SET kategori ='" + kategori + "', namn ='" + namn + "', stl ='" + stl + "', pris ='" + pris + "', iLager ='" + iLager + "' WHERE ID ='" + ID + "'";
        SqlCommand comm = new SqlCommand(sql, conn);//Conversion failed when converting the varchar value '__Page' to data type int.
        SqlDataReader dr = comm.ExecuteReader(); 

        //message
        //clear t

Convert user.config to database storage via my custom settings provider

  

Hi,

I've created my own custom settings provider to save user settings (formerly in the user.config) to a database. To point the particular settings that are to be saved to the database I specified

[SettingsProvider(typeof(BlobSettingsProvider))]
for each property to point to the BlobSettingsProvider instead of allowing them to default to the LocalFileSettingsProvider.
Now I need to convert existing user.configs to save to the database on the fly - a one time conversion. Because I've now specified the properties to use the BlobSettings provider they can no longer access the local user.config.
Does anyone have any thoughts on how best to accomplish this conversion (i.e. read the local user.config and populate the BlobSettingsProvider). The app can be run as a ClickOnce installed app or as a simple .net app - finding the correct local user.config looks to be a problem.
Thoughts, ideas,...?
Thanks,
Glenn

Glenn

How to convert XML documents to Mysql database?

  

Hello Everyone,

Am using searcharoo.NET for ma application. Now i need to store  the XML contents in ma database. How can i convert ma XML contents to Mysql Database? Please help me.

Any help will be appreciated. 

Thanks.


How to convert image class object to byte type in order to insert database

  

I am trying to resize images after uploading and than inserting them into my database.


Dim newMainImage As System.IO.Stream = System.IO.Stream.Null
resizedMainImage.Save(newMainImage, jgpEncoder, myEncoderParameters)
Dim newMain As Image = Image.FromStream(newMainImage)


I was able to resize it however I couldnt find a way to convert image object to byte() in order to

I need something like

Dim ImageContent(newMain.ContentLength - 1) As Byte

newMain.InputStream.Read(ImageContent, 0 , newMain.ContentLength)


I need to convert image object to a file type in order to get its contentlenght and use .inputStream.Read function. Or is there any other way?




Cannot convert English data base into Marathi database in SQL server

  

I am going to design an application software using VB.NET as a Front end and SQL server as Back end. When we run this application it ask for select a language i.e. Marathi or English. If user select English language then all interface and database of that application is shown in English language and if we select Marathi Language then all things are in Marathi. For this application software I want to use single database.

So how can I use the single database for English as well as for Marathi language.


Cannot convert English data base into Marathi database in SQL server

  

I am going to design an application software using VB.NET as a Front end and SQL server as Back end. When we run this application it ask for select a language i.e. Marathi or English. If user select English language then all interface and database of that application is shown in English language and if we select Marathi Language then all things are in Marathi. For this application software I want to use only one database.

So how can I use the single database for English as well as for Marathi language.


How to convert Access database to SQL Compact?

  

I know how to convert an Access database to a regular SQL database using the Upsize Wizard in Access. Can I use this SQL database (as is) with the SQL Compact server?

If not, how do I convert an Access db to an SQL Compact db?

Many thanks.



Multiple database support with Entity Framework

  
One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

  
If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Adding Rows in GridView without using a Database

  
This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

  
This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.
Categories: 
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