DataSource Controls :: Import XML Into MSSQL?
Apr 11, 2010How do I import this XML: [URL] into MSSQL?
View 5 RepliesHow do I import this XML: [URL] into MSSQL?
View 5 RepliesIm trying to import a semiolon seperated file into mssql db 2000 table and I need your help.I can read the file and present the content in a for loop, but I would like to extract values at certain possions.Like "Fel Beskrivning;Konktakt förare; and so on.
View 2 RepliesThis may not the best place for this question, but I'm going to give it a shot. I have a large (3GB) file that contains maybe 100 fields, CSV. ALL FIELDS are surrounded by double quotes, a standard CSV file. So, it looks like this:
"12345678", "SMITH", "JOHN", "GARLAND, TEXAS", "75043","","","","37" (and so on)
I need to import this into SQL server but have been unable to find any simple way of doing so using the BULK INSERT. I could obviously do it with some coding [a lot, given the number of fields] but one would think a product like MSSQL would have this most basic of functionality built in.
I am pretty good with HTML, PHP & MYSQL but this is my first go at working with a windows host and an ASP script. I recently purchased a script that matches my clients needs and when i have opened the folder to view the files its all double dutch to me apart from one css files which makes perfect sense to me!
Im stuck with is the database file included in the template, i ave been unable to import it into MSSQL using 'My Little Admin' which is the control panel provided by my hosting provider. Looking through the file with notepad it seems to contain the information for several tables but i cannot figure out for the life of me how i import it with 'My Little Admin'
I am about to get my sites hosted with a local host company. They are offering me their lowest cost MSSQL server, which is the web edition. So my question is what is the difference between that and 2008 express edition? Can express edition be used for a full fledge in production website? And does Web implies that I will be interacting with it via the web correct. Lastly, if the web version is not chosen what is the typical protocol for uploading and maintaining a site when you have a dedicated server. Do you normally have to go to the data center or is there like a web portal that can be used. I will be asking the guys at the company these questions as well, but I want to make sure I get another opinion on the issue.
View 1 RepliesI asked plesk the following question:I've been through the documentation and scoured various forums, but I can't find a defintive guide to uploading an mssql db (contained in a app_data folder) to the server and conecting it via the Plesk control panel. I've created a db and user via the panel but how do I get the actual db to the server and get it to work?"and they replied:"For database restoration please upload your database backup file ( i.e. .bak ) under your hosting space and update us the exact path where you place this file + your database login details ( i.e. database name , database user name and password ). So we restore this database for you. "
View 3 RepliesI was wondering what you guys thinks is the most efficient way to select data from a msSQL database.. I tend to use a sqldatareader, but is this really the best way? - It is particularly impractical if one also must take into account, that the table may be "Null"?:
[Code]....
[Code]....
On the internet we bought/hired a CRM product. When we enter a new project this datarecord (on their MSSQL DB) is transferd to our local MSSQL DB.
Internally we got a seperate application that uses the project information.
So after an insert project on the CRM side (on the internet) the data is transferred to our DB. When i check the internal application I see the project. All nice and sweet.
BUT when I alter (UPDATE) a project in the CRM internet application this data is pushed to our DB and i see the data in the table. But it doesnt show up in the internal webapplication. When i restart the website in IIS it still doesnt. Only when i restart the entire IIS the data is updated in my internal application.
Used techniques:
.NET 3.5MSSQL 2005LINQ to SQL The only thing i can imagine is that LINQ to SQL has a own cache or something. If so... how to disable it
How can I select a random row and then update or delete it? I've found how to get a random row, using SELECT TOP 1 column FROM table ORDER BY NEWID() do I have to make another select using this result in order to update the row, or it can be done more efficiently?
View 10 Repliesusing c#, i have an array where i want to test every single line of this array if it is already contained in a table of a database. if not, i do an insert. the test if the line is already in the table is performed using update, if update fails i insert the line. this works BUT the table contains 100000 entries, the arrays i want to compare/insert contain appr. 5000 entries. so, i is really slow and takes minutes.
View 7 Repliesi was trying to upload from an .xls file to microsoft sql server.What i did was i upload the file to a folder in server and pick the record from the folder. This work on development machine but on getting to a iis server to test the application i got an error that was saying the root folder for the www root for the folder was not found. Below is the code.
<pre lang="msil">protected void btnUpload_Click(object sender, EventArgs e)
{
string FileName = FileUpload1.PostedFile.FileName;
string saveDir = @"";
string appPath = Request.ApplicationPath;
[Code].....
In remote db, I can be able to connect ms sql db as localhost in my connection string like below,
<
add
name="ConnectionString"
connectionString="Data
Source=localhost;Initial Catalog=DBServer;Persist Security Info=True;User ID=sa;Password=*****"
providerName="System.Data.SqlClient"
/>
This is running in server and its working fine.
If i want to make any changes in db structure or need to modify any data values, i have to login remotely to my server and has to open sql server management studio do db change or value editing stuffs. Its really getting iritating when the remote machine looks slow.
I just want to know how to configure the db hostname like dbname.domainname.com or mssql.domainname.com in server, so that we can open the server db in local using sql server management studio.
The application installed in windows server 2008 and using IIS 7.0 & SQL Server 2008
I have only little knowledge in server.
I'm an experienced PHP programmer that is new to ASP.net (C#). I'm trying to figure out how to do a manual echo of a specific field from an SQL database and was wondering how you do an if condition in case the field would meet certain criteria ?
What I want the script to do is check in the database if a certain condition is activated, then the html page should echo a windows media player object with the source of the video coming from the database itself ( $line[Video], and if the condition isn't active then either don't echo the player or just echo an old video (in the script I'm just printing a message).
in PHP:
[Code]....
I use a calendar to pick a date that I want to store in my MSSQL Database. I use the form format, like 2010-01-27 (european date format) with no time info. What MS SQL Date-type should I store this date in?
View 4 RepliesI just want to ask how to import a .dat file to sql table in ASP.net. The .dat file is the report comes from our Biometrics Device (fingerscan)
View 6 RepliesI'm trying to import a file. It's been importing from VFP just fine but just yesterday, it stopped working and I'm getting the following error message. If this is referring to my registry, there is no such entry in my registry. Do I need to re-install?
Error 0xc002f210: Preparation SQL Task 1: Executing the query "" failed with the following error: "Retrieving the COM class factory for component with CLSID {19E353EF-DAF4-45D8-9A04-FB7F7798DCA7} failed due to the following error: 80040154.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. (SQL Server Import and Export Wizard)
There is an Excel document that is being updated and stored in a Sharepoint list. I am using the Import wizard in MS SQL to import the Excel data. Since the file is in a list in Sharepoint can I get access to it? I can see the file in Explorer in a web folder, but this file will not import. I have been able to import the file from my hard drive. What is the best solution for this? Should I import the Excel into Sharepoint? How can I get the data stored in the Excel file in Sharepoint into MS SQL?
View 1 RepliesI try to import Excel files to sqlserver problem is that the number and the titles of columns are dynamic.How can i do that by code?
View 5 Repliesis the SQL SSMS creates.I want to NOT import the data where Category = 'xxx', 'xxx'How can I do that? Is that possible? My SQL is very limited at this point!
CREATE TABLE [dbo].['Working DB edits$'] (
[Comments/Notes] nvarchar(255),
[Category] nvarchar(255),
[Sub-Category] nvarchar(255),
[Sub-Cat2] nvarchar(255),
[Course No] nvarchar(255),
[Course Title] nvarchar(255),
[Curricula] nvarchar(255),
[Certification] nvarchar(255),
[Cert Exp] nvarchar(255),
[Delivery Type] nvarchar(255),
[Owner] nvarchar(255),
[Learning Rqst Mgr] nvarchar(255),
[PreReq#] nvarchar(255),
[Duration (hrs)] float,
[Min Attendance] nvarchar(255),
[Max Attendance] nvarchar(255),
[Objectives] nvarchar(255),
[Description] nvarchar(max),
[Competencies] nvarchar(255),
[Target Audience] nvarchar(255),
[Equivalents] nvarchar(255),
[Expiration] nvarchar(255),
[Evidence of Training] nvarchar(255),
[Refer# Matls] nvarchar(255),
[Price] float,
[Instructor] nvarchar(255),
)
I have a project where an Excel file is dumped out in a specific format. I can't change how it's dumped. I need to make a website with .NET & C# where I can look for the Excel file (will always be in the same location - probably same name with .xls extension), dynamically get the sheetnames and import each sheet into 1 sql database.
I just need the user to go to a webpage and click "Import" button, or something like that and everything happens behind the scenes.
I was going to do it in SSIS but there were problems with dynamic sheet names and it wouldn't catch all the columns ..
I am trying to explode some data from an ntext field into a cvs for import, here is what i have so far,
DECLARE @XML as XML
DECLARE @hDoc as INT
SET @XML = (SELECT billaddress FROM order WHERE id=7 )
exec sp_xml_prepairedocument @hDoc OUTPUT, @XML
SELECT firstname
FROM OPENXML (@hDoc, '//')
WITH (type text './type/@text',
FirstName text './FirstName/@text')
exec sp_xml_removedocument @hDoc OUTPUT
here is the errors:
Msg 2812, Level 16, State 62, Line 4
Could not find stored procedure 'sp_xml_prepairedocument'.
Msg 8179, Level 16, State 5, Line 6
Could not find prepared statement with handle 0.
Msg 6607, Level 16, State 3, Procedure sp_xml_removedocument, Line 1
sp_xml_removedocument: The value supplied for parameter number 1 is invalid.
i have excel sheet i need it to be imported entire sheet into sql server 2005 i need the query to complete the task..
View 3 RepliesI got data retrieved from Sql DB in a 3 different dataset. I need to get all data from
View 7 Repliesi have different tables for product details, images, category mapping
is there any way to import/export products by excel file in database along with category mappying and pictures in one go rather that importing just the products and then categorizing each product and adding image one by one ?
I'm writing my web application in VB. Is there any way to allow the user to import data from a .CSV file at runtime - that is dynamically? I intend to have the table structures in place, then just have it such that they can append or replace the data that currently exists in the system.
View 2 Replies