Sql 2000 Upload To A 2005 Sql DB?

Jun 5, 2008

Hi all, I am using ixwebhosting.com for a host and they say they are using sql 2005 servers, well any ways I have sql 2005 express edition, and sql 2000, I am able to export data from my
sql2005 express using my 2000, but am having issues tryig to upoad the data to the 2005 sql server on the web host company. Any ideas on how to fix this or a workaround would be nice.
Thanks All

Jonny

View 6 Replies


ADVERTISEMENT

SQL Server 2000 File Upload

Oct 9, 2007

hi
i am using VS2003 and .net 1.1. i need to upload a cert file into sql server 2000. code is as follows, i am not sure if this code is working or not, its not giving any error nor throwing any exception. in this function i am only converting ther .cer file to byte array. and in other function i am passing this byte to a stored procedure. in stored procedure i have declare a parameter as "@cert binary". i cant see the binary data in sql server 2000, its only showin <binary> in that column. i need to download this file now, how can i do that. Dim selectedCert As HttpPostedFile
Dim certLength As Integer
Dim isValid As Boolean = False
'Dim imageType As String
'Dim fileUpload As System.Web.UI.HtmlControls.HtmlInputFile = .FindControl("fileUpload")
selectedCert = fileUpload.PostedFile
certLength = selectedCert.ContentLength
'imageType = selectedCert.ContentType
Session.Add("isDefaultLogo", 0) ' To check if default logo is used
If fileUpload.PostedFile.ContentLength = 0 Then
' DO NOTHING
ElseReDim binaryCert(certLength - 1)
'check if there a certificate file or not
If (selectedCert.ContentLength = 0) Then
' DO SOMETHING
Else
selectedCert.InputStream.Position = 0
selectedCert.InputStream.Read(binaryCert, 0, certLength - 1)
Response.Write(selectedCert.ContentType.ToString)
If (selectedCert.ContentType.ToLower <> "application/x-x509-ca-cert") Then
lblMsg.Visible = True
lblMsg.Text = "Only Certificate (*.cer) files are allowed."
isValid = True
Return False
End If
End If
End If
If isValid Then
TryDim strm As IO.FileStream = System.IO.File.Open(System.IO.Path.GetFullPath(fileUpload.PostedFile.FileName), IO.FileMode.Open, IO.FileAccess.Read, IO.FileShare.ReadWrite)ReDim binaryCert(strm.Length - 1)
strm.Read(binaryCert, 0, strm.Length)
strm.Close()Catch ex As Exception
Return False
End Try
End If
 
thnx in advance
cheers

View 3 Replies View Related

How To Upload An Image Into SQL Server 2000 Per T-SQL

Feb 11, 2008

Hi,

SQL Server 2008 on its way. 2005 should be standard. But sometimes you have SQL Server 2000.
How can I upload an image into the SQL Server 2000 with an T-SQL Statement?

In SQL Server 2005 I would write something like this:
Code Snippet
INSERT INTO ReportingImages
(Name, Img)
SELECT 'UploadTest',
BulkColumn FROM OPENROWSET(
Bulk 'C:ds9.png', SINGLE_BLOB) AS BLOB

That doesnt work under 2000.

What about uploading to the SQL Server 2000 and an Image-Datatype?

Is it even possible in T-SQL without a Web-Service or C#/VB-written tool?

-------------------------------
Update: Thank you all for your answers. We'll use a tool then.

View 5 Replies View Related

Multilingual Data Upload To SQL Server 2000

Dec 16, 2004

I need to store the data from a web page having different controls to SQL Server 2000 database. The columns were created as of type "NVARCHAR", but when I enter any mixed data for example (sunder??) in two or more languages, only english characters are stored and other language characters are stored as ????. How can I solve this? Please help me out. Is it possible to store such multilingual content in a single column.

View 2 Replies View Related

Upload File - Pass Variable - Fire DTS Sql Server 2000

Jul 31, 2006

Hi All,
I am looking to do the following:
1) Upload a text file via a website to a server with sql server 2000.
2) Fire a DTS package on that file so it appends the contents to a table in the database.
3) Choose a variable via a dropdown list on the website
4) Run a different DTS Package that uses an update sql statement that uses that Variable.
Any help or suggestions would be greatly appreciated.
Thanls,
Doug
 

View 6 Replies View Related

How To Upload Excel To Sql Server 2000,plz Give Me Sample Code

Apr 16, 2007

hi
 
How to upload excel data to sql server 2000 thorugh .net application.
I want like one upload button should be there,we have to browese corresponding excel file and then we need to upload to database.
before uploading it has to ask appending or replace everything in table.
both options appending and replacing shoulb be there.
How to upload ?
any sample code is there plz give me.
 
Please help me.
Thanks.

View 1 Replies View Related

Why Is SSIS Upload From FoxPro Way Slower That A Upload Using DTS?

Oct 20, 2006

I am rewritting our DTS that upload tables in FoxPro to SQL Server using SSIS. I am finding the that SSIS is way slower. My uploads using DTS take just 7 minutes where doing the same thing in SSIS is taking 1 hour 15 minutes.

View 2 Replies View Related

2005 SQL How To Upload New Table

Apr 21, 2008



I use to have Enterprise Manager and had no problem uploading new table.

But I downloaded 2005 SQL Server Management Studio Express adn I can't figure out how to upload...
How do you upload new tables to my database using 2005 SQL?

Thanks

View 1 Replies View Related

SQL 2005 Express Database Upload(help!)

Feb 15, 2007

Hi, how are you! I'm a beginner of database. I have some really "novice" questions here. Currently I'm trying to upload my database to a share windows host server. I have problems uploading my database files. I'm using Visual Studio 2005 and SQL 2005 express version. I was told that in order to upload my database, I need to have.bak file of my database.
The problems are:
 1. under my visual studio server explorer, it seems I have two databases, one is ASPNETDB.MDF, another one is (mycomputername)sqlexpress.(databasename).dbo. I dont know from which one I can create the .bak file, and how?
2. I can not find where the phsyical location of my files (such as tables or stored procedures) from my (mycomputername)sqlexpress.(databasename).dbo database. Anyone can help? thank you!

View 3 Replies View Related

Ms Access Upload To SQL Server 2005 BE && Sharepoint FE

Jun 21, 2006

I have about 20 Ms Access Databases to need to be upload onto a SQL Server2005.Currently the are on a network/server residing on a specific drive. The goalis to keep the user face the same (ms access) and put all of the tables ontoa SQL Server 2005 BE, and yet make those databases accessible to open/viewthrough Ms Sharepoint.What is the simple (properties) way to grab all of those db's = 20 and uploadto server?With out having to write code.Pull all db's over to SQL then store the Ms Access databases on Sharepointwhere the user face remains the same and the tables are on the server and thedb's are accessible now through the company Intranet.--Message posted via http://www.sqlmonster.com

View 2 Replies View Related

Upload Data From ACCESS To Sql Server 2005

Apr 5, 2007



I want to upload data from ACCESS database( contains more than 60 tables) to SQL server 2005 database( same table structure).

If I use the method of copying table by table and Recordset to Recordset, It takes TOO long ( like 8 hrs).



Could you pls suggest me the efficient way of doing this task. I heard something like DTS for this.But I never

used this.. help me



Thanks

Goldie

View 1 Replies View Related

How Do I Upload To And Download From A Shared SQL Server 2005 Database?

Dec 13, 2006

My hosting gives me ASP.NET 2.0 and a shared SQL Server 2005 package.
I have Visual Studio 2005 on my machine - which installs SQL Server 2005 Express. I have also installed SQL Server 2005 Management Studio Express.
I wish to develop my database locally (mdf file) as I won't always have internet access (and therefore can't always work directly with the remote shared database).
My question is, how do I upload my database info from my local machine to my remote shared database?
Also I shall wish to download my remote database to my local machine in order to work on the database (and then be able to re-upload it) sometimes.
Please can somebody tell me how I can do this?
Will SQL Server 2005 Management Studio Express permit me to do this and if so how?
If I need the full version of SQL Server 2005 Management Studio then I do have SQL Server 2005 and this install with it (but it all looks a bit complicated to install for me).
Many thanks for all help given,
Graham
 

View 1 Replies View Related

Can I Upload A Report From Reporting Services 2008 Into SQL Server 2005?

Jan 28, 2008

Would that be compatible or do I need SQL Server 2008 to display the report?

Thanks,
Steven

View 5 Replies View Related

Install Sql 2005 Instance With Reporting Service 2005 On Sql 2000 With RS 2000 Server

Aug 18, 2006

Hi

We would like to install Sql 2005 Enterprise Edition (including database engine, reporting service, integration service and analysis service) as a sepearte instance on a server which already has Sql 2000 with reporting services and analysis services. We do not want to disturb the existing sql 2000 setup.

If we do that then what will happen to my earlier sql 2000 reporting service? Will it be upgraded to sql 2005 reporting service? I heard that reporting services are instance unaware application. Where will be the default reporting service database available?

Please help us.

Regards,

Sankar N

View 1 Replies View Related

SQL 2005 Thinks A SQL 2000 Backup Is Corrupt, But SQL 2000 Restores Just Fine

Jul 19, 2007

I am attempting to move some SQL 2000 databases to SQL 2005. My main production database does not seem to want to move. When I use the SQL 2005 GUI the .bak backup file is marked 'Incomplete'. When I attempt to restore the backup file I get a 'RESTORE detected an error on page (0:0) in database' message. I saw a thread in the SQL Express forum suggesting trying to restore from the T-SQL level to get the GUI out of the picture and I get the same 'error on page (0:0)' message. However when I take the same file and use SQL 2000 Enterprise Manager it restores with no problems.

Any ideas?

Thanks
Mike Mattix

View 8 Replies View Related

Bit-data From SQL Server 2000 (2005 Working, 2000 Doesn't)

May 19, 2008

 Hi, I am trying to edit some data from a SQL2000-datasource in ASP.NET 2.0 and have a problem with a column that has bit-data and is used for selection. SQL2005 works fine when declaring             <SelectParameters>                <asp:Parameter DefaultValue="TRUE" Name="APL" Type="boolean" />            </SelectParameters>When running this code with SQL2000, there are no error-msgs, but after editing a record the "APL"-column looses its value of 1 and is set to 0. Looks like an issue with type-conversion, we've hit incompatibilities between SQL200 and 2005 with bit/boolean several times before. So, how is this done correctly with SQL2000?  (I've tried setting the Type to "int16" -> err. Also setting Defval="1" gave an err) ThanksMichael   

View 2 Replies View Related

Problems With SQL 2000 And 2005 On Same Machine - Can't Connect On 2000

Mar 13, 2006

Hi,i have SQL 2000 and 2005 on same machine(with different intance names,of course), my laptop - XP with SP2. The 2005 works fine but i can'tconnect on SQL 2000. All the the SQL services are started.Any idea? Have i to reinstall 2000?Tks,Lourival

View 1 Replies View Related

Merging 2000 And 2005 Databases, Save As 2000

Apr 30, 2008

I have to merge the data from two databases, one is in SQL Server 2005 format, one is in 2000. The merged data will then reside on a SQL Server 2000 platform. Is there an easy way to do this through Management Studio or Enterprise Manager? Or will we have to export the data from the 2005 database to a flat file and import it into a new 2000 database. And then do the merge?

TIA

View 4 Replies View Related

Log Shipping From 2005 In 2000 Compatibility Mode --&&> 2000 Can I Do This?

Dec 18, 2007

I am in the process of migrating from Sql Server 2000 to 2005. Part of my plan is to move some database's to 2005, but use the 2000 compatibility mode for the short term. My issue is this, our DR boxes are still on SQL Server 2000, would I still be able to use our log shipping processes? Or would I be better off in starting with migrating the DR boxes to 2005 first?


Thanks in advance.

View 3 Replies View Related

SQL 2000 To SQL 2005 Works For One 2000 Server But Not The Next

Jun 15, 2006



I have several SQL 2000 servers I need to setup transactional (non updatable) replication with. The structure is:

SQL Server 2000 as Publisher/Distributor

SQL Server 2005 Standard as Subscriber

The connection is via the Internet with snapshots using FTP.

I setup the first set (2 databases at location A). They work wonderfully. I created the publication and then subscribed using MGMT Studio for 2K5.

II am setting up the same scenario for location B. Here is my problem:

In MGMT Studio I connect to the publisher (SANDRA). I right-click a publication and choose New Subscriptions..., the publication is already selected. I click next - Run each agent at its Subscriber is selected and the only option (this is desired), I click Next

HERE IS THE PROBLEM:

On the Subscriber's screen there are no Subscribers listed. When setting up location A the subscribing server was listed and I could choose a database. The Next button is greyed out and there is no way to create/add one.

I tried setting up the subscription by right-clicking the subcribing server's Replication folder in MGMT Studio but I get the same result (except that I have to authenticate with the publishing server which works fine).

WHAT'S DIFFERENT:

Location A is SQL Server Standard (SP3) running on SBS2K3. It is obviously on a domain and so SQL Server and the SQL Agent are running under domain accounts. Location B is a Windows XP SP2 machine running SQL Server Personal Edition (it actually says Development Edition in the properties window).

The databases are the same strucutre, different data. At location A the firewall is set to allow 1433->*any* and *any*->1433 where *any* is 1024 or higher. On the XP machine the firewall is set to allow port 1433. I don't think this is the issue because I've turned the firewall off on the XP machine and I get the same result.

ANY IDEAS?

View 5 Replies View Related

Sql 2005 Sql 2000 DB Diagrams, Re-install Sql 2000, Need Help.....

Jan 19, 2007

Most of our sql servers ar still sql 2000. Our programmers created many sql 2000 database diagrams using EM. But they can not access them under sql 2005. (They now have only sql 2005 tools installed on their boxes.)

Question: can we reinstall the sql 2000 client tools on their boxes without affecting the current sql 2005 install on their boxes?

Question: is there any workaround negating the need to ihstall the sql 2000 client?

TIA,



barkingdog







View 1 Replies View Related

VS 2005/SQL Server2005 - Direct Connection From Win Mobile Emulator To Desktop SQL Server 2000 Or 2005

Aug 10, 2007

Hello Everyone,

I'm trying to connect to Desktop SQL Server 2000 from Windows mobile PC Emulator (VS 2005). I need a direct connection using connection string to SQL Server 2000 through local wireless network without IIS.

Bellow is the code that I use. After executing this code I get an error on line Conn.Open(). Error says SQL Server does not exist or access denied.
SQL is un and running, and I can log in using SA username from the desktop. Even if I chance IP for another SQL server in my connection string I still get the same error. There is no firewall of any kind running.


Dim connectionSTR As String = "Persist Security Info=False;Integrated Security=False;Server=192.168.0.202,1433;initial catalog=MyDB;user id=sa;password=;"

Dim Conn As SqlConnection

Conn = New SqlConnection(connectionSTR)

Conn.Open()


If Conn.State = ConnectionState.Open Then
MessageBox.Show("Open")
End If


About my environment: SQL Server 2000 is running on Desktop PC with Windows XP SP2. Application which I need to connect to SQL Server is in Visual Studio 2005. I execute the application in Windows Mobile PC Emulator and try to connect to SQL Server from emulator.

Your advice and help is very appreciated

Thank you

Ika


View 3 Replies View Related

Load Backup From 2000 To 2005 Or Recreate Structure On 2005?

Apr 23, 2008

Hello,

I would like to ask you if there is better to recreate database structure on 2005 from 2000 and move data or to just load
2000 backup.

Currently I loaded the backup, but I am wondering if there might be slightly better performance on 2005 when recreating structure on 2005 to loading 2000 backup?

Does loading 2000 backup create 2005 binary structure?

Thanks for help in advance

View 5 Replies View Related

How Do SQL 2000 Service Packs Play A Role In Upgrading?i.e.Can SQL 2000 Standard With No SP Be Upgraded To SQL 2005 Standard

Aug 2, 2006

How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack??

View 1 Replies View Related

Can I Install VS.net 2005 / VS.net 2002 / SQL 2005 / SQL 2000 In One PC Win2000 Sp4?

Dec 1, 2005

P4 2.8G Hz, 512 M RAM.thanks.

View 3 Replies View Related

What Will Going From Latin1_General_Bin To Latin1_General_Bin2 In SQL 2005 Do To Replication From 2000 To 2005?

Aug 3, 2006

If we changed the sort order from BIN to BIN2 but kept everything else the same will it have any effect on replication? So in SQL 2005 if I were to change my default collation from Latin1_General_Bin to Latin1_General_Bin2, would that cause replication to break? I suspect that it will not be an issue since it is just sort order that is changing and the code page stays the same.

BTW, this is transactional replication.  Sorry, I left that out of my original post.

Thanks,
Grant

View 1 Replies View Related

Upload Doc

Mar 9, 2004

Hi Guys,

I have one question, must be simple for you guys. I want to upload .pdf document into the SQL server database.

I have one question, that which data type I should use. Should I use TEXT or IMAGE.

Could you please tell me which data type I should use and why?

Thanks for your help in advance.

View 2 Replies View Related

Upload

Jun 24, 2008

how to upload data from excel sheet to table in sql server is there any command for that

View 1 Replies View Related

Upload An Image ....?!

Dec 24, 2006

I used upload image feature and below is the code that I used. The image is stored in a folder. I want to save the image in sql database. I create the database which is “database�, and I create a table which is “user�. User table has auto “id� field and “image� field. I want to save the image in the image field. I need your help to do the other codes.
 
I am using asp.net with VB
 
This is what I did so far:
============================
Partial Class upload
    Inherits System.Web.UI.Page
    Dim strFileName As String
 
    Protected Sub btnupload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnupload.Click
        UploadImage()
    End Sub
    Sub UploadImage()
 
        If Not (fileupload1.PostedFile Is Nothing) Then 'Check to make sure we actually have a file to upload
 
            Dim strLongFilePath As String = fileupload1.PostedFile.FileName
            Dim intFileNameLength As Integer = InStr(1, StrReverse(strLongFilePath), "")
            strFileName = Mid(strLongFilePath, (Len(strLongFilePath) - intFileNameLength) + 2)
 
            Select Case fileupload1.PostedFile.ContentType
                Case "image/pjpeg", "image/jpeg" 'Make sure we are getting a valid JPG image
                    FileUpload1.PostedFile.SaveAs(Server.MapPath(" estimages") & strFileName)
                    lbstatus.Text = strFileName & " was uploaded successfully to: " & Server.MapPath(" estimages") & strFileName
 
                Case Else
                    'Not a valid jpeg image
                    lbstatus.Text = "Not a valid jpeg image"
            End Select
 
            InsertToDatabase()
        End If
 
 
    End Sub

End class

View 1 Replies View Related

Trying To Upload A Picture To Sql

Sep 23, 2007

I am using the article, "
Storing Binary Files Directly in the Database Using ASP.NET 2.0 By Scott Mitchell "
 
http://aspnet.4guysfromrolla.com/articles/120606-1.aspx
I have tried to modify the code and my datatable to replicate the function, but I am getting an error, "MIMEType" is not a SQL Parameter
 
An SqlParameter with ParameterName 'Type' is not contained by this SqlParameterCollection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IndexOutOfRangeException: An SqlParameter with ParameterName 'Type' is not contained by this SqlParameterCollection.Source Error:



Line 53:
Line 54: 'Specify the values for the MIMEType and ImageData parameters
Line 55: e.Command.Parameters("Type").Value = MIMEType
Line 56:
Line 57: 'Load FileUpload's InputStream into Byte arraySource File: E:homeDefaultetances.ushtdocshomeadminaddNews.aspx    Line: 55
Code: Protected Sub AddNewsBut_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If Page.IsValid Then
InsertDs.Insert()
Response.Redirect("~/news/default.aspx")
End If

End Sub

Protected Sub InsertDs_Inserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEventArgs)
'Reference the FileUpload control


'Make sure a file has been successfully uploaded
If UploadedFile.PostedFile Is Nothing OrElse String.IsNullOrEmpty(UploadedFile.PostedFile.FileName) OrElse UploadedFile.PostedFile.InputStream Is Nothing Then
Label1.Text = "If there is no photo of this event, please use a stock photo if you have none available. Else, please upload a photo of the event."
e.Cancel = True
Exit Sub
End If

'Make sure we are dealing with a JPG or GIF file
Dim extension As String = Path.GetExtension(UploadedFile.PostedFile.FileName).ToLower()
Dim MIMEType As String = Nothing

Select Case extension
Case ".gif"
MIMEType = "image/gif"
Case ".jpg", ".jpeg", ".jpe"
MIMEType = "image/jpeg"
Case ".png"
MIMEType = "image/png"

Case Else
'Invalid file type uploaded
Label1.Text = "Please use the correct file type: .jpg, .jpe, .gif, or .png."
e.Cancel = True
Exit Sub
End Select

'Specify the values for the MIMEType and ImageData parameters
e.Command.Parameters("Type").Value = MIMEType

'Load FileUpload's InputStream into Byte array
Dim imageBytes(UploadedFile.PostedFile.InputStream.Length) As Byte
UploadedFile.PostedFile.InputStream.Read(imageBytes, 0, imageBytes.Length)
e.Command.Parameters("Photo").Value = imageBytes

End Sub Please help.

View 1 Replies View Related

Upload Database

Oct 22, 2007

I created a website a year ago. I remember I need to download something from Microsoft (some kind of sql admin thing), which allows me to convert my database in the Express Visual Web developer to sql file, then I can copy those sql commands into my web hosting company's sql admin window to upload the database online. I forgot what things I should download from Microsoft? Please help.

View 1 Replies View Related

Upload Pictures

Oct 22, 2007

I am building this project and for all the data i put in to the DB Title,Author, etc.... ineed to also add a picture of the book.  I terms on space what is the best way to do this?  In the DB? Or ref a folder?  If so does anyone have sample code for each.
ThanksMike

View 23 Replies View Related

File Upload Help

Dec 11, 2007

Hi, I am trying to upload a file to database.
I have used the following code, every loads good to the database apart from the image, does it go anywhere?
I have created a column in the table called 'FileUploadAdvert' and made it an image?
Any ideas where I'm going wrong?
ThanksGordon 
Protected Sub btnAdvertSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdvertSubmit.ClickDim dashDataSource As New SqlDataSource()dashDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("DashConnectionString1").ToString()
dashDataSource.InsertCommandType = SqlDataSourceCommandType.Text
dashDataSource.InsertCommand = "INSERT INTO tblAdvert (AdvertOwner, AdvertName, TopLeftH, TopLeftV, Height, Width, ToolTip, WebLink, AcceptTerms, DateTimeStamp, IPAddress) VALUES (@AdvertOwner, @AdvertName, @TopLeftH, @TopLeftV, @Height, @Width, @ToolTip, @WebLink, @AcceptTerms, @DateTimeStamp, @IPAddress)"dashDataSource.InsertParameters.Add("AdvertOwner", txtName.Text)
dashDataSource.InsertParameters.Add("AdvertName", txtCompName.Text)dashDataSource.InsertParameters.Add("TopLeftH", DropDownAccross.Text)
dashDataSource.InsertParameters.Add("TopLeftV", DropDownDown.Text)dashDataSource.InsertParameters.Add("Height", DropDownHeight.Text)
dashDataSource.InsertParameters.Add("Width", DropDownWidth.Text)dashDataSource.InsertParameters.Add("ToolTip", txtOver.Text)
dashDataSource.InsertParameters.Add("Weblink", txtURL.Text)dashDataSource.InsertParameters.Add("AcceptTerms", CheckBoxAgree.Checked)
dashDataSource.InsertParameters.Add("IPAddress", Request.UserHostAddress.ToString)dashDataSource.InsertParameters.Add("DateTimeStamp", DateTime.Now)
If Not FileUploadAdvert.PostedFile Is Nothing ThenDim filepath As String = FileUploadAdvert.PostedFile.FileName
Dim pat As String = "\(?:.+)\(.+).(.+)"Dim r As Regex = New Regex(pat)
'runDim m As Match = r.Match(filepath)
Dim file_ext As String = m.Groups(2).Captures(0).ToString()Dim filename As String = m.Groups(1).Captures(0).ToString()
Dim file As String = filename & "." & file_ext
'save the file to the server FileUploadAdvert.PostedFile.SaveAs(Server.MapPath(".") & file)
lblStatus.Text = "File Saved to: " & Server.MapPath(".") & fileEnd If
 Dim rowsAffected As Integer = 0
Try
rowsAffected = dashDataSource.Insert()Catch ex As Exception
Server.Transfer("Register_Fail.aspx")
Finally
dashDataSource = Nothing
End Try
If rowsAffected <> 1 ThenServer.Transfer("Register_Fail.aspx")
ElseServer.Transfer("Register_Complete.aspx")
End If
End Sub

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved