Does anyone have links to good tutorial on how to programatically (using vb) connect to a remote site to download and save xml files to local server? Thank you very much. The remote site is using REST and queues but I do not think that should matter or?
View 13 RepliesI am following this tutorial [URL]and would like to know if somebody can provide the CSS used in the example.
View 2 RepliesI have a remote xml file like [URL]
I would like to write a program to download it to local with progress bar.
I'm trying to download remote file using C# (ASP.NET). The problem is when I browse to the file download URL - it downloads perfectly. When I try the WebClient.DownloadData(url) I get "no data to show" response.
If I browse using the built-in VS2010 browser I still get this "error" message.
The file link is: [URL](CSV file)
i want to download file from other website to on my location and i used code below
Dim wc As New System.Net.WebClient
wc.DownloadFile(pathUrl, fileName)
PathUrl,fileName both are correct m 100% sure.
after execution of these 2 line my browser progress-bar goes in to wait state like something is retrieving.but file not download any where.what should i do next?
The below code works fine for downloading a file from a current pc.plz suggest me how to download it from remote server using ip address or any method
protected void Button1_Click(object sender, EventArgs e)
{
const string fName = @"C:ITFSPDFbillsFebruaryAA.pdf";
FileInfo fi = new FileInfo(fName);
long sz = fi.Length;
Response.ClearContent();
Response.ContentType = MimeType(Path.GetExtension(fName));
Response.AddHeader("Content-Disposition", string.Format("attachment; filename = {0}", System.IO.Path.GetFileName(fName)));
Response.AddHeader("Content-Length", sz.ToString("F0"));
Response.TransmitFile(fName);
Response.End();
}
public static string MimeType(string Extension)
{
string mime = "application/octetstream";
if (string.IsNullOrEmpty(Extension))
return mime;
string ext = Extension.ToLower();
Microsoft.Win32.RegistryKey rk = Microsoft.Win32.Registry.ClassesRoot.OpenSubKey(ext);
if (rk != null && rk.GetValue("Content Type") != null)
mime = rk.GetValue("Content Type").ToString();
return mime;
}
I have an off-line project. User uses a laptop to input data off line into local SQL server express. Once connected to domain (on line), local data will sync with remote SQL server using sync framework. (It is done, works fine)
One job left:
Since another user used another program to update some tables in remote SQL server, such as CUSTOMER, SHIPINFO, my off-line program need to update these new data once connect to domain.
Here is what I design in Pseudo code: (take CUSTOMER as example)
1) In remote SQL server, create a store procedure (sp_customer) to select all CUSTOMERS
2) In application, create a dataset (dst_customer) based on sp_customer
3) Insert all customers data which is in remote SQL server but not in local SQL server based on CUSTOMER_ID
I do not think this a smart way to do it.
We need to download multiple files from remote servers. It is a process that would take few hours to complete, since we are talking about images ~50kb each and more than 250.000 in total. Each images will downloaded, resized and then imported to SQL.DB, so we do not need to write files to the disk. Also the applications need to use network credentials, since it is behind ISA.
From your experience, what is the best method to implement this? Should we use WebClient or HttpSockets? Should we use Async methods or Threads ? How can we implement for example 5 simultaneously download to achieve better speed, since we may getting files from many different servers at once?
I am trying to access a remote network share from a C# program in asp.net. What I need is something like
function download(dirname)
{
file = (This is the part I don't know how to do)
for file in directory:
copyfile(file);
}
On remote server i have shared folder. If there any way to download file from this shared folder on local machine? Without using ftp. Server dont have iis or something like this,just have shared folder.
View 1 RepliesCan we upload and download files from remote servers through code without using FTP?
View 2 RepliesI have created my asp.net website using database ASPNETDB.MDF but when I try to host my site on server ...
The SQL Server 2005 hosting provider issue me the
database name dobriyalji
server ip : 69.112.222.220
database username : XXXX
database password : XXXX
I have imported all of my ASPNETDB.MDF tables to my server database dobriyalji ...
And I empty the Appdata.mdf and aspnetdb.log file from App_Data Folder ...
When I try to run my site the following error occurs ...
An attempt to attach an auto-named database for file UsersAshish DobriyalDocumentsVisual Studio 2008WebSitesVOLVOApp_DataASPNETDB.MDF
failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
MY LOCALHOST CONNECTION STRING :
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
MY REMOTE HOST CONNECTION STRING :
<connectionStrings>
<add name="vbi_india2kConnectionString" connectionString="Data Source=69.112.222.220;Initial Catalog=dobriyalji;Persist Security Info=True;User ID=XXXX;Password=XXXX" providerName="System.Data.SqlClient"/>
</connectionStrings>
My asp.net 2.0 is deployed in web hosting.. now here in my server i have configure a static ip.. so how to access my ms sql database all over the world.. i need to know is that i need to write directly connection string in a webconfig of my static ip.. or i need to create a instance of my static ip to ms sql server 2005 to access the database..
View 7 RepliesWe have a web application that I've just enhanced (and gotten rid of the MsgBox in it , too!) It runs on our production web server. I have the solution loaded in VS2005 on my PC. It's been deployed before, but this is the first time I am deploying it and I want to make sure I know what I'm doing. So I will choose Publish from the Build menu, and I think I want to say Remote Site - is that what will plop all my new stuff over the old? And is the value that I supply for Remote Site the URL, or would I use the IP
View 21 RepliesI am not able to debug a Remote web project (Where the project files are located in another server which is in the same network). I am getting the below error message:
Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters) at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder,
Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Excel.Range.get__Default(Object RowIndex, Object ColumnIndex) at InventoryADD.Button1_Click(Object sender, EventArgs e) in
\10.38.23.228q1uatassettrackInventoryADD.aspx.cs:line 670
It works fine when i try to access the website through IIS. Shud i do some setting changes on VS 2005?
I've tried with
<trust
level="Full"
originUrl="" />
i am new to asp.net development and create my website using asp.net 2.0 and sqlserver2005express edition how can i upload the database on remote server i m using plesk acount. and what changes are require in web.config.
View 1 RepliesI use visual studio 2008 to create a new site at local IIS. I dragged login,loginview,loginstatus controls from toolbox and dropped to the page as well as set up the security from administrative tool. It's working fine locally however when I published it to the remote hosting site, I can't even see the page, only error instead. It's using VS builtin DB and I can't see the connection string in web.config.
View 1 RepliesI am trying to create a small app that will stream read a remote web page (specified by user input)find all images within the page (using regular expressions)stream read these imagesadd them as LinkedResource 's to a HTML emailI have got it working fine when the images and defined using absolute urls but not when they are relative - How can I can webRequest / streamReader to behave like a web browser does and locate the images based on their relative location.I have thought about manipulating the main web url and prefixing it to the source of the image, but I am not sure how I would deal with am image source such as
[Code]....
Local machine visual studio day and month are normal in format dd/mm/yyyy. But after deployed to remote web site, saved Excel using C#, less than day 12, become mm/dd/yyyy.
Actually the code is to get data into Excel from stored procedure which do pivot table The way i save date to cell is oSheet.Cells[currentline, i + 1] = String.Format("{0:dd-MM-yyyy}", Convert.ToDateTime(reader[i].ToString()));
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
if (reader[i] != System.DBNull.Value)
{
if (i == 0)
{
oSheet.Cells[currentline, i + 1] = String.Format("{0:dd-MM-yyyy}", Convert.ToDateTime(reader[i].ToString()));
}
else
oSheet.Cells[currentline, i + 1] = reader[i].ToString();
}
}
currentline = currentline + 1;
}
reader.Close();
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
</dependentAssembly>
</assemblyBinding>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.Office.Interop.Excel"
publicKeyToken="71e9bce111e9429c"
culture="neutral" />
<publisherPolicy apply="yes" />
<bindingRedirect oldVersion="12.0.0.0"
newVersion="11.0.0.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
I have a remote website form which sends variables to a page of my asp website. This is a standard form with http post. How do I access the url which sent the request to the page? Is this an environment variable? Http_referrer?
View 3 RepliesI'm still trying to deploy this site, but with every problem I solve, another arises. Anyways - I've set up the database at my hosting to allow remote connections, and it is running Sql Server 2005. On my development machine, I am working with Sql Server 2008.
I've installed the asp.net schema on my hosted database, and have created several users from the ASP.NET web administration interface, as well as tested that the login works. Running the application locally with the remote connection string nets the same results. However - I'm able to run my scripts and generate my tables and stored procedures without errors - but when the site is run I get the following error on all of my .aspx pages that try to access a stored procedure:
Server Error in '/' Application. Incorrect syntax near 'LoadProfileData'. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'LoadProfileData'.
Source Error:
Line 62: adapter.SelectCommand.Parameters.Add("@ProfessionalName", SqlDbType.VarChar).Value = professionalName;
Line 63: DataSet profile = new DataSet();
Line 64: adapter.Fill(profile, "Profile");
Line 65: return profile;
Line 66: }
Is this a possible Sql 2005 vs 2008 issue? I'm hoping someone else has seen this issue in a similar scenario and can point me in the right direction. The server is running asp.net 2.0, 3.0 and 3.5 and IIS 7.0.
Yesterday I added a custom MembershipProvider to an ASP.NET web application, but when I deployed the application to its remote host server, it failed. I know I had the login info correct, and I also know that for nearly any exception in the login process, the Login control displays the standard error message, "Your login failed", so I assume something is wrong in the code/config.
What can I do to diagnose what is wrong on the server?
BTW: This weekend I only have FTP access to the server, so no event log, and CustomErrors is already set to Off.
THE END: I was an idiot, and using the wrong query window to check if the my login actually existed on the server.
I have a website that was originally written in webforms to which I have added MVC functionality. When debugging locally it works fine, however, once published and uploaded to my host the routes do not work and return a 404. I am pretty sure that I have uploaded all the correct files. Would just appear that routing is not working.
(the site will still serve normal aspx pages fine)
I think the problem may be related to http://stackoverflow.com/questions/1772975/mixing-asp-net-mvc-into-asp-net-webforms
But I cant see from that thread what the solution was. It looks like it might be something to do with the app_pool mode - but I am running in integrated mode, which is right AFAIK
UPDATE 2
So I think I have routing working. I basically created a new MVC app and went through theweb config file line by line and made sure I have everything I needed. Funnily, none of the tutorials online mention the correct additions you need to make. I have have another issue mind you... When i load my mvc page I am greeted with the message: The SessionStateTempDataProvider requires SessionState to be enabled.
I've added a line to web.config to enable sessions (wasn't aware they were off) and it still doesnt work.
UPDATE I created a new asp.net MVC project and ended up going through web.config line by line and ensuring that everything that related to MVC was included in my hybrid app. Suffice to say that none of the guides mention all the settings that are required (i was using the book professional asp.net mvc 1.0). I then included the global.asax file which is not published and set up a route so that a request for / was not being caught by MVC. I also had to enable sessions in web.config.
how to download a file at a url programmatically on the server side without any user interaction?
View 4 RepliesWhere can you download Northwind for SQLServer 2005? I tried this but there is no Northwind after the install... [URL]
View 1 Replies