Im 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 RepliesHow do I import this XML: [URL] into MSSQL?
View 5 RepliesI 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 have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 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].....
I 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 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.
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 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 RepliesI have import .xls file data into sql server 2000 .
but in my pc i have installed excel 2007 .
which content type is use when i export data from gridview to excel .
I have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.
View 5 RepliesI 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 RepliesIn 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 RepliesUsing sql server 2000,How to create the dts packages that runs the stored procedure to output the results in excel sheet?
View 3 RepliesSQL query optimation for SQL Server 2000?
[Code]....
What is the best way to move SQL 2000 to 2008 completely? Please let me know if real life problem generally occurs.
View 4 Replies