I am uploading about 70000 records in through excel sheet in the database.Its taking lots of time and session gets timeout of db. Please tell me is there any way to improve the perfomance of excel upload and please provide me the links or site to refer that.
Niraj001
Posts
-
Perfomance improvement on excel upload -
how to read the string and get the src of image in whole stringSuppose I am having html and in that images tags are used I want to read that tags and get the src i.e file name until the image tag is finished.
-
Getting error : System.Web.HttpRequestValidationException: A potentially dangerous Request.Form value was detected from the clientThis is my code html = Server.HtmlEncode(FreeTextBox1.Text) I have done validaterequest=false in the page then also its throwing error.I searched on google but all are saying same thing what i have done.I think it works for v1.1 and v2.0. I have targetframework=4.0.So please provide any idea to solve this error in .net 4.0.
-
Email sent to client notification and tracking the linkThanks for above answer.One more question is that how I will know what links on the email sent the customer had clicked and how many time.
-
Email sent to client notification and tracking the linkI want only the idea how I will check that what links the customer had clicked from the eshot sent to him and how many time.And the email opened notification to me.
-
Email sent to client notification and tracking the linkCan anyone tell me with code in vb.net how to get email notification when client has opened the email sent to him and which client and on which link and how many time he had clicked in the email sent to him
-
Email sent to client notification and tracking the linkCan anyone tell me with code in vb.net how to get email notification when client has opened the email sent to him and which client and on which link and how many time he had clicked in the email sent to him
-
How to pass '&' in the querystring with valueI have function where I get name of the manufacturer in datatable.These manufacturer name comes as link in my usercontrol list.When I click it, it get passed in querystring for search result. Example: http://xyz.com/productlist.aspx?Section=Terminals&Manufacturer=Lenovo pc but in list I have Lenovo pc & NetStation My request is passes as
<% If Manufacturer = "" Then%>
<h2 class="subheading">
Manufacturers</h2>
<ul>
<% While Manufacturers.Read()
'Response.Write("<li><a href='/ProductList/" & Section & "/" & Manufacturers(0) & "/" & MinPrice & "/" & MaxPrice & "/" & Search & "'>" & Manufacturers(0) & "</a>(" & Manufacturers(1) & ")</li>")
Response.Write("<li><a href='/productlist.aspx?Section=" & Section & "&Manufacturer=" & Manufacturers(0) & "&MinPrice=" & MinPrice & "&MaxPrice=" & MaxPrice & "&Search=" & Search & "'>" & Manufacturers(0) & "</a>(" & Manufacturers(1) & ")</li>")
End While%>
</ul>
<% Else%>
<h2 class="subheading">
Manufacturers</h2>
<ul>
<%--<% Response.Write("<li><a href='/ProductList/" & Section & "/NULL/" & MinPrice & "/" & MaxPrice & "/" & Search & "'>" & Manufacturer & "- Remove Selection</a></li>")
%>--%>
<% Response.Write("<li><a href='/productlist.aspx?Section=" & Section & "&MinPrice=" & MinPrice & "&MaxPrice=" & MaxPrice & "&Search=" & Search & "'>" & Manufacturer & "- Remove Selection</a></li>")
%></ul> <%End If%>
in above url I want http://xyz.com/productlist.aspx?Section=Terminals&Manufacturer=Lenovo pc & NetStaions