|
|
hi guys i just wanna ask some question about the database my asp is connected to.
i now have a ms excel form whihc have over 900++ records !!!!
i am trying to find if there is a way to convert the excel database into my sql database.
pls suggest or tell me how i can do this.
i really dont want to type out 900++ records haha >.<
|
|
|
|
|
use DTS or BCP or import utility. All come with sql server....
Amit
|
|
|
|
|
Hi!
Does any one knows of any toolbar web part, this toolbar will contain a list of web sites and sub sites. I need to hook this sort of web part into my share point portal.
Your help is highly appreciated.
Thank you.
happy coding!
|
|
|
|
|
hi all
the question is more related to architecture and practices and I'll appreciate any opinion
i work with asp net 1/2 few years and with any project we developing we meet performance issues
maybe the problems is our methods or maybe we do not do the right things but it seems that view state and heavy page model really make performance bad
also, when you work with asp.net it very easy to start building your site component-oriented with many levels of nested controls that every one is data-driven and make a db call that altogether cause bad database performance
we recently did code review for other companies products and i see that every-one do that mistake with component-oriented design cause it so simple and fun to make smart controls with public properties and reuse them everywhere
also, i did a production application with MonoRail (MVS framework based on asp.net but using different light page-model and no viewstate) and it just lot faster
i will welcome any examples of how you guys build ASP.Net site that fast and easy to scale, also, any links to good resources are welcome
if you suggest to switch to PHP or Ruby on Rails i promise to consider that
Thanks much
EV
and may the source be with you
|
|
|
|
|
There is nothing wrong with the ASP.NET architecture.
As with every powerful tool you have to keep an eye on what's happening, or it can really get messy.
The Web controls that come with ASP.NET is convenient for easily putting together a working form, but the view state easily grows quite a bit. The view state can be disabled for controls where you don't need it, or you might consider using the Html controls instead. You have to do more of the work yourself, but it still is no more work than if the Web controls didn't exist at all. If a Web control give you more thouble than it's worth, just don't use it.
If you have a lot of components in a page that is performance critical, they shouldn't be database driven, they should be data bound. That means that you still feed them the data from the page, they don't fetch it themselves.
---
b { font-weight: normal; }
|
|
|
|
|
agree with you that it easy to get messy with powerful tools
but it seems to me that switching viewstate on/off and keeping an eye with on components to use data access smartly is just non enough to make an application to perform fine
what i really want to find is practices and guidelines to build performance-oriented applications ,
there is a lot of articles with tips like :
- use stored procedures
- prevent round-trips to database
- disable view state where you do not needed etc
etc...
but with all the googling i cant find something more about strategy and architecture of scalable and fast application
Thanks for your reply
|
|
|
|
|
If you're having performance problems have you tried implementing Caching. ASP.NET from what I can gather has very powerful Caching capabilities.
For instance, you can cache the raw HTML output from the aspx page for a certain duration (10 mins say) so that the page is only being drawn every 10 mins, requests in between are just grabbing the raw HTML output will no database access etc. It's also possible to cache different versions of the same page based on a querystring parameter say (eg. showProducts.aspx?productID=5 ).
Also set Cache dependancies (data expires on certain conditions - database change etc), set timeouts, set delegates that fire when Cache is removed etc. There's loads of stuff you go do with it, too much to list here.
The Cache object can be accessed from almost anywhere it seems, Cache propety from an ASPX page, Context.Cache from the Global.asax, or from the HostingEnvironment class (ASP.NET 2.0 only) from anywhere else, making it extreme flexible to use.
Sunday Ironfoot
www.dominicpettifer.co.uk (work in progress)
|
|
|
|
|
Caching with asp.net is fun, but i actually looking for methods to write fast sites without uing of cache. you always can add caching on optimization phase but it can't help you everywhere when your site is higly personalized and each page is different according to user logged in
Thanks for your reply
and may the source be with you
|
|
|
|
|
We are upgrading our intranet's main page from classic asp to .Net 2.0. Currently there are all three type of web apps on the server, .Net 2.0, 1.1 & asp. The asp classic main page currently uses techniques similar to http://www.eggheadcafe.com/articles/20021207.asp which has worked for a couple of years now. Now we are upgrading the main page to .Net 2.0 and I am having problems finding any solution that works, much less an elegant one that will require minimal change throughout the applications.
Currently I have tried the following with out success:
http://www.asp101.com/articles/sidney/sharingsessionstate/default.asp[^]
which should work and possibly does using .Net 1.1 but not with .Net 2.0.
Microsoft solution, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/converttoaspnet.asp[^], fails to work in .Net 2.0 either.
I glanced at this one http://searchvb.techtarget.com/tip/1,289483,sid8_gci951935,00.html[^] but I think it would have the same issue as the previous ones.
With the asp101 & Microsoft's solution, I am unable to transfer any session information from any .Net 2.0 app to another .Net 2.0 or .Net 1.1 app. I am not sure why. I think it might be because I am running on XP and there is no option for application pooling in IIS. I know in IIS on server 2003 you have to create a new pool for .Net 2.0 apps. The actual Session will transfer with both techniques it is just getting the session to the intermediate page, SessionTransfer.aspx.
Process Flow:
ASP.Net page => SessionTransfer.aspx => SessionTransfer.asp => asp page
The trouble I am finding is the ASP.Net to the SessionTransfer.aspx page. The Session.Count value in the SessionTransfer.aspx page is 0.
Any help or link would be much appreciated and resolving this Session issue.
Thanks,
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
What is wrong with this Regex for e-mail?Thank you
Regex emailRegex=new Regex(@"^*@*.*$");
|
|
|
|
|
\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*
only two letters away from being an asset
|
|
|
|
|
|
How to access textbox control that is placed inside the Iframe control using javascript.
kamalnath
|
|
|
|
|
I have two small queries and hop some one can guide me in right direction
What is the difference between in below two approaches?
1) Get Data Reader and populate the data into data table and close data reader
2) Get data set and use table (0) etc…
I can understand
a) In first case, we have connected environment and not a best approach when having huge data. On the other hand in second case we had disconnected environment.
But if you observe SQL server sp_who, in both cases it keep connection live for sometime. Is it because of Garbage collector mechanism?
Amit
|
|
|
|
|
First off, are you closing your connection.
Secondly, the connection pool will remained cached but the connection itself should not. The datareader should be used where ever possible as it is more efficient then using the dataAdapter to generate a dataset. Check out this article for more information.
http://aspnet.4guysfromrolla.com/articles/050405-1.aspx
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
You must always open and close any connection you make to a database.
Use DataReader when you only want to 'read' from the database, eg select query.
Dataset is used as a 'collector' for information, in memory. By that. A dataset can have more then one table(it's called a DataTable) assigned to it to store information. In ASP.net 2.0 you now get a list object, that replaces the dataset, however you can still use a dataset.
Have a look here:
Dataset vs datareader
|
|
|
|
|
If you are using 2.0 you can have a disconnected reader.
only two letters away from being an asset
|
|
|
|
|
Hi,
I have a master datagrid in an asp.net page. Selecting a record in the master datagrid loads the details datagrid. This worked fine as long as I had both the datagrids on the same asp.net page.
Now I moved the details datagrid to a seperate asp.net page that I included in an IFRAME element in the asp.net page that contains the master datagrid. On doing this I have taken care that when a record is selected on the master datagrid the id is passed to the details datagrid in the IFRAME.
So selecting a record is now properly loading the data in the details datagrid in the IFRAME page.
Both the Master and the Details datagrid have paging enabled.
Now after using the IFRAME I am facing the following problems:
1>
I select the record in the Master datagrid and the Details datagrid loads with paging in the IFRAME. If I click on any of the pages of the Master datagrid, paging has stopped working properly : the postback takes place but the next page is not loaded for the datagrid.
2>
If I click on any page no. of the Details datagrid in the IFRAME I get the following exceptiion:
Invalid CurrentPageIndex value. It must be >= 0 and < the PageCount.
The paging for the Master Datagrid works fine if I do not have the IFRAME element
The paging for the Details datagrid works fine if I independently load the page with the required params passed.
In case if anyone has faced such a problem before and knows the solution please let me know
Thanks in advance
Sid
|
|
|
|
|
The Iframe's view state will not be maintained. Why do you have to use an Iframe? If you need to refresh only part of the page then use AJAX via the Atlas toolkit or other method. I would stay away from the iframe unless you like headaches.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
hi....i m not understanding wht is happening in these lines....plz help....
<br />
<Script Runat="Server"><br />
<br />
Sub Button_Click(S as Object, e as EventArgs)<br />
enteries.innerHtml=& username.Value & comments.Value & entries.innerHtml<br />
End Sub<br />
<br />
</Script><br />
i m not understanding whts that "enteries.innerHtml".....plz help...right now its like
Regards
Geetika Munjal
-- modified at 8:37 Thursday 14th September, 2006
|
|
|
|
|
|
hey thanks for the reply
i have got my answer
thanks
regards:
Geetika
|
|
|
|
|
Thats Nice.
Regards,
Jay
|
|
|
|
|
Hi
I need to run website on FULL SCREEN. To make it done i wrote a javacript in the First Page (Default.aspx).
<br />
if (window.opener == undefined)<br />
{<br />
window.opener = 'self';<br />
window.open("Default.aspx","","fullscreen,scrollbars");<br />
window.close();<br />
}<br />
This works fine in IE. But fail to run in Full screen for MOZILLA and Netscape.
How to solve it ?
|
|
|
|