|
|
Respected Gurus
I have an excel file which may contains more than 250000 records.I have to dump those reords in my database.I am able to do it,but its very very slow.
I have to optimize it.
For that i want to filter the records from excel file on the basis of a particular date.
I want to give the user flexibility of choosing the date,for which he wants to dump the data.How can i do this??
My sample code is:----
Dim StrReportdate As String
StrReportdate = Trim(txtDate.Value)
If StrReportdate <> "" Then
Dim culture = New CultureInfo("fr-FR", True)
dtreportdate = DateTime.Parse(StrReportdate, culture, DateTimeStyles.None)
End If
Dim strConnectionString As String = String.Empty
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePath + ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
Dim cnCSV As New OleDbConnection(strConnectionString)
cnCSV.Open()
Dim cmdSelect As New OleDbCommand("SELECT * FROM [sheet1$] where F2=" & dtreportdate, cnCSV)
'Dim cmdSelect As New OleDbCommand("SELECT * FROM [Sheet2$]", cnCSV)
Dim daCSV As New OleDbDataAdapter
daCSV.SelectCommand = cmdSelect
Dim ds As New DataSet
daCSV.Fill(ds)
|
|
|
|
|
Hello to Every one,
There are two panel each containing a text box and and a button.
Panel1 including textbox1 and button1 & Panel2 including textbox2 and button2.
Now i want that after page_load if i select the textbox1 then entire panel2 should not be visible or vice-versa...
Can this is possible without using javascript as i donn't know it...
If not,could you give me The entire code in javascript for doing the above..
Suggest me....
Thank you.
|
|
|
|
|
|
i have given solution on this and you again posting the same
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
hi,
i designed a login page in asp.net with vb.net. In that form i want to keep password strength meter, i dont have idea about that, i am new to .net
so, please help.I want the detail coding of it. plz help.
thanks
jai prakash
|
|
|
|
|
The Article by Roger Chapman here[^] will hekp you.
Regards,
Satips. ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
hi,
it is not working send me some other link
jai prakash
|
|
|
|
|
it works fine for me.
What error it says?
Regards,
Satips.
|
|
|
|
|
<google:passwordstrength id="PS" targetcontrolid="txtPassword" cssclass="password" runat="server">
hi,
this tag is not avilable in my html form because i am using asp.net 1.1
thanks
jai prakash
|
|
|
|
|
Hi All,
I am getting the following error whenever i try to throw an error in my web application. I have specified customErrors in web.config file like as follows:
<configuration>
<system.web>
<customErrors mode="On" defaultRedirect="CustomError.aspx"/>
<error statusCode="404" redirect="CustomError.aspx"/>
</system.web>
</configuration><pre><code>
Error:
<h2> Runtime Error </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed.
<br>
Details: To enable the details of this specific error message to be viewable on the local server machine, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "RemoteOnly". To enable the details to be viewable on remote machines, please set "mode" to "Off".<br><br>
<pre>
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly"/>
</system.web>
</configuration>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="On" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
Please let me know the solution.
Prakash G, Software Engineer
Iridium Interactive Limited,
SriNagar Colony
Road #3 Banjara Hills
Hyderabad - 500035
mail me @ prakash.se@indiatimes.com
call me @ +91 9866833523
|
|
|
|
|
Try this: (I am just doing hit and trial)
in the internet explorer, go to Tools --> Internet options -->Advanced:
Then untick the option for "Show friendly http error messages"
|
|
|
|
|
hi,
thank you. but i already tried the option u suggested. Even its not working. I restarted the IIS also. Still its showing the same error.
Let me know, if u find any other solution/way to solve the problem.
thank u once again
Prakash G, Software Engineer
Iridium Interactive Limited,
SriNagar Colony
Road #3 Banjara Hills
Hyderabad - 500035
mail me @ prakash.se@indiatimes.com
call me @ +91 9866833523
|
|
|
|
|
I think I remember, Go to the folder in Inetpub\wwwroot and give Network Service \ Asp.Net user permissions. Try this.
|
|
|
|
|
Hello,
I m also having the same runtime error but for only https:// pages, all other .aspx pages are working fine. Can any body guide me about how to use host server's Shared SSL certificate. What are the settings to be done for IIS of host server?
I have my web.config file as,
<securewebpages mode="On" maintainpath="True">
<files>
<add path="frmCustomerInfo.aspx" secure="Secure">
<add path="purchase.aspx" secure="Secure">
<add path="frmPayment.aspx" secure="Secure">
<add path="frmRegLogin.aspx" secure="Secure">
<add path="frmUsersInfo.aspx" secure="Secure">
<add path="frmDownload.aspx" secure="Secure">
here
secureWebPages mode="On" works as cutomerrors & I tried by doing it "Off" & "Remoteonly" also, but it is still giving error.
Thanks in advance.
by ULZ
|
|
|
|
|
Instead of using a .aspx page as the error page try having an html page as the error page.It might work.
Just try out..
I was born dumb!!
 Programming made me laugh !!!
--sid--
|
|
|
|
|
Good morning,
I created class to send email. I use to send username in mail. I used _MailMessage.BodyFormat = MailFormat.Html
and body text is created through code containing html table for formatting purpose ex.
(" Name:txtname.text")
It is working fine......I can send mail with table format.
PROBLEM
but if I use
(" Name:Server.HtmlEncode(txtname.text)")
It gives error "object reference not set to an insatance of an object"
can I use Server.HtmlEncode in class file?
Anybody has any solution plz disscuss with me....
Thanks,
Nagraj
|
|
|
|
|
Hi,
I find out the solution......
I just replace "<" with "<" and ">" with ">" and remove Server.HtmlEncode
(" Name:ReplaceFunction(txtname.text)")
I hope this will help to solve same problem to somebody else..
Thanks....
Nagraj
|
|
|
|
|
Hi friends
i have button below in username.if i click the button the popup window appear
i have two button and one textbox in that popup window page
buttons are
1.check avilability
2.make this is my username
if i click the check avilability button that time check avilability button is disappear at that time make this is my username button appear vice versa
i write the code in codebehind using
check avilability.visible=true
make this is my username.visible=false
but page refreshed
i need the page did not refresh
how can i achive this
regards
saravanan
|
|
|
|
|
Dear saravanan,
you can use javascript instead of tht code in the code behind file
select a particular element and then you can set visible =false.
its like
document.getElementById('element_id').visible=false;
All The Best
Sathesh Pandian
|
|
|
|
|
when will session get start for HTML and ASP.NET?
D.Willington
|
|
|
|
|
A session starts every time a user without a session id cookie requests a page, unless of course the page is session-less.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi, I have read an article by Kelum Ganegoda on reading blobs. In his article he showed how to display images that were stored in blobs using the ExecuteScalar() method of the SqlCommand class which returns an object. So we cast it and store in a byte array like this.
byte[] _buf = (byte[]) _cmd.ExecuteScalar();
Then, stream it back to the HTTP response. The problem is that his article shows how to display images not text files. I'd like to display text files in the same format as the original files prior to being sent to the database. How would I go about doing that? Thank you in advance for your help.
-- modified at 23:18 Thursday 21st June, 2007
|
|
|
|
|
Exactly the same way, except that you use a different content type.
---
single minded; short sighted; long gone;
|
|
|
|
|
What about the format of the file, how do I get the format of the displayed file to be the same as the original file? Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
