|
Why don't you use the VS Tools for Office? They have all the code needed to open/manipulate/save Excel files 9and the resulting code would certainly be much cleaner than trying to do it with data adapters.
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997
|
|
|
|
|
I haven't used VS Tools for office before. Can you please provide me some samples related to this.
Thanks,
Suchita
suchita
|
|
|
|
|
I would also suggest what John said. If for some reason you have to use OleDbConnection , you can use the GetOleDbSchemaTable method. Take a look at this
MSDN[^] link and this article[^].
|
|
|
|
|
I face this problem for a few day, after searching on google is still not help. Anyone help fix it. my fileupload control is not placed in updatepanel but it' hasFile properties still alway return false.
modified on Monday, April 18, 2011 12:03 PM
|
|
|
|
|
which version of Visual Studio you r using??
Some times textbox value and Fileupload value gets blank in Visual Studio 2008.
try to use
FileUp.Attribute.Add("Value",FileUp.PostedFile);
Hope this can help you.
|
|
|
|
|
hi Prasanta,
thanks for your response but i think problem is I'm using DarrenJohnst 's ASP.net FILEUPLOAD (http://darrenjohnstone.net/category/aspnet-file-uploads/) and i added some code in web.config and global
In Web.config :
<configuration>
<configSections>
<section name="uploadSettings" type="darrenjohnstone.net.FileUpload.UploadConfigurationSection, fileuploadlibrary, Version=2.0.0.0, Culture=neutral, PublicKeyToken=af961ece0b692dfb"/>
</configSections>
<system.web>
<httpRuntime executionTimeout="3600" maxRequestLength="40960" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="5000" enableKernelOutputCache="true" enableVersionHeader="true" requireRootedSaveAsPath="true" enable="true" shutdownTimeout="90" delayNotificationTimeout="5" waitChangeNotification="0" maxWaitChangeNotification="0" enableHeaderChecking="true" sendCacheControlHeader="true" apartmentThreading="false"/>
<httpModules>
<add name="upload_module" type="darrenjohnstone.net.FileUpload.UploadModule, fileuploadlibrary, Version=2.0.0.0, Culture=neutral, PublicKeyToken=af961ece0b692dfb"/>
</httpModules>
</system.web>
<system.webServer>
<security>
<requestFiltering>
<requestLimits maxAllowedContentLength="1073741824">
</requestLimits>
</requestFiltering>
</security>
<validation validateIntegratedModeConfiguration="false"/>
<modules runAllManagedModulesForAllRequests="true">
<remove name="ScriptModule"/>
<add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<remove name="upload_module"/>
<add name="upload_module" type="darrenjohnstone.net.FileUpload.UploadModule, fileuploadlibrary, Version=2.0.0.0, Culture=neutral, PublicKeyToken=af961ece0b692dfb"/>
</modules>
<handlers>
<remove name="WebServiceHandlerFactory-Integrated"/>
<remove name="ScriptHandlerFactory"/>
<remove name="ScriptHandlerFactoryAppServices"/>
<remove name="ScriptResource"/>
<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add name="UploadProgress" verb="GET" type="darrenjohnstone.net.FileUpload.UploadProgressHandler, fileuploadlibrary, Version=2.0.0.0, Culture=neutral, PublicKeyToken=af961ece0b692dfb" path="UploadProgress.ashx"/>
<add name="FileDownload" verb="GET" type="darrenjohnstone.net.FileUpload.SQLFileDownloadHandler, fileuploadlibrary, Version=2.0.0.0, Culture=neutral, PublicKeyToken=af961ece0b692dfb" path="DownloadFile.ashx"/>
</handlers>
</system.webServer>
</configuration>
and Here is My Global code :
void Application_Start(object sender, EventArgs e)
{
darrenjohnstone.net.FileUpload.UploadManager.Instance.ProcessorType = typeof(darrenjohnstone.net.FileUpload.DummyProcessor);
darrenjohnstone.net.FileUpload.UploadManager.Instance.ProcessorInit += new darrenjohnstone.net.FileUpload.FileProcessorInitEventHandler(Processor_Init);
}
void Processor_Init(object sender, darrenjohnstone.net.FileUpload.FileProcessorInitEventArgs args)
{
}
void Application_End(object sender, EventArgs e)
{
}
void Application_Error(object sender, EventArgs e)
{
}
void Session_Start(object sender, EventArgs e)
{
}
void Session_End(object sender, EventArgs e)
{
}
anyone give some solution to fix it thanks.
|
|
|
|
|
i have to import xml document having size more than 10GB in Sql Server database. i also have to do XSD Validation before Processing and maintain transaction. Please suggest me the best way to do the same. should i use SSIS packege? is it capable of Processing such large document? or Do i have to use c# coding to accomplish this task?
modified on Monday, April 18, 2011 6:12 AM
|
|
|
|
|
man! you have also posted this in C# as well as database forums. do not post it again everywhere.
♫ 99 little bugs in the code,
99 bugs in the code
We fix a bug, compile it again
101 little bugs in the code ♫
|
|
|
|
|
This has absolutely nothing to do with ASP.NET
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi All,
I am working in VS 2005 and sql server 2005.
I installed VS 2010 Professional and after installing when I try to connect my local sql server 2005
It prompting error message "This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)".
Please let me know whether I need to install any patches..
Thanks in advance..
Ramkumar
("When you build bridges you can keep crossing them. ")
http://ramkumarishere.blogspot.com
|
|
|
|
|
Looks like Visual Studio installed a newer version of SQL server and removed the old one?
|
|
|
|
|
|
May be because of instalation problem. Its better if u reinstal the database.
|
|
|
|
|
Dear Sir
i m sending some data through a URL like http://XX.XX.YY.YY:8080/newlink?nois=99999999&book=kk.
But i want to call this URL After every 5 second automatically.how can i do it
naval
|
|
|
|
|
|
You can use javascript setTimeOut function to call a functiopn at specific time interval. In function code open window with some 'window name'.
♫ 99 little bugs in the code,
99 bugs in the code
We fix a bug, compile it again
101 little bugs in the code ♫
|
|
|
|
|
I have more than one machine in a place. Here we cant implement IP. We have to do with Client Machine ID or Name. So How I can get Client machine ID?
|
|
|
|
|
|
My project is web based actually a website. and most of the attributes and method to get client machine id will not work after publish.
modified on Thursday, April 21, 2011 8:40 AM
|
|
|
|
|
Well, of course the code must be run under a user account the posses the required rights to access such information. Look up impersonation.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
I use $.ajax() method to call the Add() function like this:
function Click(param) {
$.ajax({
type: "POST",
contentType: "application/json",
url: "gongxuan.aspx/Add",
data: "{arg:param}"});
}
the browser shows:unknown methow "Add"
how to solve it??
|
|
|
|
|
gongxuan.aspx/Add is not a valid url
Perhaps this is want you want to do
gongxuan.aspx?method=Add<br />
gongxuan.aspx?method=Subtract
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
<asp:Button ID="btnHide" Runat="server" Text="Hide" />
<asp:Button ID="btnShow" Runat="server" Text="Show" />
<script language="javascript" type="text/javascript">
function hideButton() {
document.getElementById("divAbc").style.visibility = "hidden";
return false;
}
function showButton() {
document.getElementById("divAbc").style.visibility = "";
return false;
}
</script>
<div id="divAbc">
<table><tr><td style="width: 200px; height: 100px; background-color: red"></td></tr></table>
</div>
------------------------------------------------------------------------------------------------
.cs codebehind page_load
---------------------------
protected void Page_Load(object sender, EventArgs e)
{
btnHide.Attributes.Add("onclick", "return hideButton()");
btnShow.Attributes.Add("onclick", "return ShowButton()");
}
|
|
|
|
|
Hi All,
I am just updating my previous question...
I have created project in asp.net and deployed in client server Machine (Internet),However
If we do any modification ... we want to give it as .exe or some other format so that client can easily update.
Now our client is finding difficult to deploy if we give deploy project...
Please help me with this...
Ramkumar
("When you build bridges you can keep crossing them. ")
http://ramkumarishere.blogspot.com
|
|
|
|
|
Please do not re-post after couple of days. Rather, reply to answers answered to you and ask for clarification. Also, first Try something on your own.
♫ 99 little bugs in the code,
99 bugs in the code
We fix a bug, compile it again
101 little bugs in the code ♫
|
|
|
|