.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

Exporting records from database to xml

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :.NET Framework
 

Hi Frens,

I have a huge data like 2,00,000 records in my sql server database i need to export all the data to my xml file in a single shot...with using data table and it should be splited in to equal parts of xml files( for example if there is 15000 records it should be splited into 5000*3 records in 3 xml files )please help me out of this problem....

 

Thanks in advance


Sarath Sannadi Sharepoint Dev at Saksoft


View Complete Post


More Related Resource Links

How to save records with autogenerated html links in Sql database?

  

Hi I would like to create a database where users can search for multiple fields. For example: if the record is personal details info like name, address, phone number and email id i would like to generate link for this automatically with the fields using stored procedure.. Is that possible.? If so can anybody provide me with the line of code or guideline on how to do that?

Any help much appreciated. Thanks


insert new records in tables from dataset to database

  

I have 2 tables in SqlServer 2008.

Table1: T1id, SomeData

Table2: T2id, T1id, SomeData


I am using DataAdapter.FillSchema to create shema of tables in DataSet. I created DataRelation on columns T1id in both tables.

Now when i try to Update Sql Database T1id in Table2 remains 0 and not the value of T1id in Table1.


I can successfully update Sql Database if i fill DataSet with records first (Using DataAdapter.Fill), but that's not what i want to do. I don't need "old" records in my dataset. I want to use dataset just to store all imputs from user until the proccess is done and then insert all those records "at the same time".


I think i'm getting it wrong with ForeignKeyConstraints, maybe UpdateRule is not set to cascade, i just don't know.

I have been trying to work this out for 6 days now and i'm about to break something on half.

Can someone please guide me to right direction, maybe post some sample, anything.... please!


My old post regarding this:

How to update Sql Server related tables from Dataset(SchemaFill)

SqlDataAdapter.Update related tables


How to save records with autogenerated html links in Sql database?

  
Hi I would like to create a database where users can search for multiple fields. For example: if the record is personal details info like name, address, phone number and email id i would like to generate link for this automatically with the fields using stored procedure.. Is that possible.? If so can anybody provide me with the line of code or guideline on how to do that? Any help much appreciated. Thanks

Display records in bold coming from mysql database

  
hi,I have Mysql database.In that some records status is New.now,I bind database table to Listview(asp) control.What's my problem is,the New status records(from Mysql database) text in Listview(after binding) is visible in bold format.how to do this??Thanks in advance.

why two records are inserting in database using Entity Framework??

  

Hello,

i am using entity framework to access the database to insert/fetch data from database.

consider i am having two tables "AssetCheckList" and "TaskRecheckDetails"

AssetChecklist  Table

AssetChecklistID

AssetName

 

TaskRecheckDetails

TaskRecheckDetailsID

ParentAssetChecklistiID - Forigen Key of AssetCheckListID

RecheckAssetChecklistID -  Forigen Key of AssetCheckListID

 

when inserting the data in TaskRecheckDetails table two records are inserted with same details.

why and how to resolve it.

 

please help.

 

Thanks!

 


Getting the total number of records in a database table?

  

How could I get the total number of records present in a database table through asp.net in VB? I know about setting up and opening a connection. I wanted to loop through records, so wanted to know the number of records present. How could that be done? 

Also, I used statements like 'Update' and 'Insert Into' to to change the data in my data source. Like I updated a certain field like this:

ds.Tables("tblUsers").Rows(2)(3) = "xyzzzz" 

and then I executed an sql statement on the same field like this: 

objCmd.UpdateCommand = new OleDbCommand

objCmd.UpdateCommand.CommandText = "Update tblUsers " & _

"SET City='xyzzzz' WHERE UserID=3"  

objCmd.UpdateCommand.Connection = Conn

objcmd.update(ds,"tblusers")

(where objcmd is an instance of oledbdataadapter object)


What should I do to delete a record or a field in a data source through asp.net?


Published Access 2010 Database to Sharepoint 2010. You do not have permission to view the records.

  

I have published an Access 2010 database to Sharepoint 2010.  It is pretty basic and essentially it is just used for teachers to enter lesson plans.  When viewing the site there is a form that has several dropdown menus.  The user should be able to choose their name, date, etc. from these dropdown menus.  The problem is that when I click on a dropdown menu the menu just shows a message that says "This service isn't available right now".  I also get a message that pops up which says "You do not have permission to view the records.  To obtain permission contact your site administrator."

The weird thing is that when I was testing this at one point I clicked the dropdown menu and it did work.  I clicked off the dropdown menu and went right back to it again and it didn't work.

I have anonymous access enabled for this site.  However, I have tried it with an anonymous user as well as with the user account that installed Sharepoint and published the database to Sharepoint and it doesn't work either way.

Is this a permission issue on the site or something else?  Any help is greatly appreciated.


Export millions of records from database (Oracle) to excel

  

Hey guys, I'm running a query that brings millions of records and makes the server run out of memory. I'm thinking I should get the data in chunks. So I was wondering if someone could shed some light on this or point me to another place where I can read further.

Currently, I just implemented "paging". I can now pass a "page index" parameter and "page size". So I could call 1,000 times the stored procedure with a page size of 1,000 (for 1 million records). This might be an option, but I wanted to hear someone else's opinion on how to "stream" records from oracle to the web server and then to a file.

Thanks!


Suggestion about exporting data into Access database from sql server 2008 without Linked Server

  

Hello,

    We have a website that was using Sql server 2005. There was a option in Website where when a user clicks a button, Some tables data will be exported to an access database. To achieve this, we have setup a linked server to Access database. We have moved from sql server 2005 to 2008 (64bit). We did not want to use that option of having a linked server now. I am looking for different ways to achieve the task. We also donot want to use OPENROWSET and OPENDATASOURCE .

 

Can someone  give some insight about this?

 

Thanks,

Nag


database mirroring "log records from bulk-logged operations cannot be sent to mirror database"?

  

does this mean only when bulk recovery model or apply to full recovery model as well? if applys to full recovery model, how the mirror database be synchronized after bulk operation?


How to create a web service that read each records in a database

  

Hi there,

I would like to create a web service that reads each record in MSSQL and display it in a web control, any suggestions?


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