Are there any controls or 3rd party tools allowing a user to build on-demand reports from asp.net during runtime? My client is looking to somehow bypass SQL Server Reporting, and instead allow them to use a wizard within the website that will help them build reports. The reports are not necessarily tabular...they could contain group by information, etc... They would also like to save the reports and be able to launch them. I tried telerik.com but there product doesn't have this feature. I tend to think there isn't such a control out there that escapes the reporting designer that SSRS provides. The idea is to minimize the tight coupling of a report with the web application. If we decide to create reports #4, 5, and 6, (assume each report has their own parameters that they can accept), we wouldn't have to recompile the source code of the website. Thanks

Under Tools, options, Project Solutions, General, there is a check box for "Prompt for symbolic renaming when renaming files". What does this do? Does it simply rename a control (e.g. button, textbox) for every instance I happen to reference the renamed control? What should happen when renaming a class file? Thanks,

When starting a new project, is it recommended to store the sln and suo file within the same directory as the rest of the aspx, and cs files, or should we keep the default path under C:\Documents and Settings\\My Documents\Visual Studio 2008\Projects\<websitename>? What are the advantages/disadvantages of having the suo and sln in a different directory than the project? The reason I ask is, I'd like to transfer my whole project on a usb drive or zip, from work to home machine each night. It's hard to open all of the associated files for the solution when I go home, b/c it cannot find the sln. Thank you

Hello, In my pageInit I have mSesID=Session.SessionID.ToString(); Each time a postback occurs, I receive a new sessionID #. Is this correct? Shouldn't the session be the same session value even during postbacks for the same user? I assumed it would always be the same value, but I'm probably wrong. Thanks

Hmmm, I tried that but I still receive the same error message when I postback? The session.sessionID.ToString() produces a different value each time I postback...thus displaying the same error message.

[Message Deleted]

Any thoughts how to prevent displaying querystring value information...e.g. abc.aspx?userid=103? If someone wants they can type in userid=101 or 102 to display information for the other records by typing in the URL. I've heard folks use GUIDs when passing ID's in URLS. When you see a large value of 889EA536-0B32-3345-B124-F44141C50CB7 would make it complicated to guess the next record. My guess they'd use an INT as the PK, but meanwhile have a GUID column for each user record? Thoughts on that practice? Thanks

I've noticed that some of the aspnet_ tables for security (e.g. aspnet_Roles) uses a primary key of a uniqueidentifer data type which is a very long number. When should someone use a primary key, where the datatype is a uniqueidentifier as opposed to int and set IsIdentity=Yes? Thanks

I'm reading up on the ajax documentaiton and had a question on partial page updates... 1) So do partial page updates only target controls that reside within an Update Panel? 2) Even if a partial page update occurs, isn't a postback really truely occurring behind the scenes? Your browser doesn't appear to do a full postback and blink, but I'm guessing it is still doing a postback. Thanks

I'm reviewing the procs in http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=FileSpaceMon&referringTitle=Home, and have a couple question at the sql statement below: 1) where is the tempdb..sysobjects in sqlserver manager? I see a tempdb under the 'master' db...is that created by default? I don't understand why they have two periods (dot dot) in the tempdb..sysobjects. I do not see a sysobjects table within the tempdb. 2) Can someone explain the '#' in the LIKE '#FileSpaceStats%'. The % is the wildcard, but what is the leading # used for? IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE name LIKE '#FileSpaceStats%') BEGIN DROP TABLE #FileSpaceStats END Thanks

Great..thanks for all your help!

Wow...you've definitely provided great examples! 1) Should the base set of scripts (Create_xxx) pretty much create the 'version 1.0' db? Then, I imagine I would run my alter scripts to get it updated to the current version? 2) Should I create one or multiple ALTER scripts for each release? For example, if my project has 8 releases, I probably should have 8 alter scripts right? Or should I simply have one version for my ALTER script and place everything in that one script. 3) Is there a way I can take my existing db and script it out within SQL Server mgr? THanks!

Can anyone offer their thoughts/suggestions on how to best breakup scripts for managing a db? For instance, I'm starting a new project, and have already used SQL Server Manager to create the tables, pk's, indexes and the relationship between tables. Does this need to all be scripted in one large script? Moving forward, any changes that I may apply to the db (e.g. new table, new index) will have to be saved to the db. Should I create scripts for any incremental changes? What is the best way to capture these changes? Is there something in sql server manager that will say "capture changes" and script just the changes?? I guess the advantage of scripting all of your incremental scripts would be to easily back out changes that may have caused problems with your code. Do you create one giant script with a bunch of ALTER statements for your VIEWS, SP's, FUNCTIONS, etc...? Thanks

I am new to SQL Server 2005...and was reviewing the following msdn url for creating logins and users: msdn.microsoft.com/en-us/library/aa337552.aspx Can someone explain what the difference is between a db login and a db user? From my understanding, you use the db login within SQL Server manager, or with your .NET code, correct? Then, you create a user and associate it to a login? Why? What's the relevance of knowing or having a user associated to a login, when the login is sufficient alone? Would I use the user logging into sql server mgr or within my .net code? Do I need to associate a login with a user? thanks!

hello, I'm currently in process of migrating Oracle db and tables to SQL Server 2005. Is there any ideas of best way to do this? My first thought was to somehow automate the db, table, views and stored procs creation. But then how tdo I run those SQL scrips in SQL Server db...since the commands are slightly different in syntax. Second, any data migration tools that will extract and map from Oracle to a SQL Server db? I'm open to any other ideas and thoughts also! Thanks

Hi We are planning on installing SQL Server 2008 on the same server that already has SQL Server 2005. The server is Server 2008. Any problems with loading both db's on the same server? We will use a completely different instance name for SQL Server 2008 than SQL Server 2005. Anyone encounter any problems with this? Thanks

I'm new to WCF and have simple question... Is it better to create a WCF service within the same webapplication/project solution as in your website...or should it be in a completely different project solution.

Has anyone experienced or have articles how to send email to a Novell mailserver from asp.net? Novell mail server is running pop3/imap. Thank you

I have a DetailsView control on my website, and I notice when I edit, insert or simply displaying a record, the width of the fields vary. To make them consisten, I converted all of the fields to templateField, and had to change the 'width' property for each field within each template (ItemTemplate, EditTemplate, InsertTemplate). Is this the best or most efficient way of standardizing the DetailsView field widths? Perhaps there is a way to simply state the width once and all fields within DetailsView will inherit that value? Thanks,

Sure...I basically have a linqdata source retrieving the Orders table from northwind. I then have a grid displaying the OrderId, Shipped Date and a new column that is a hyperlink. The hyperlink will build a DataNavigateURL to pass the orderID and customerId to a new page (HyperLinkOrderDetails.aspx?aOrderID={0}&CustomerId={1}). Any way that I can only display http://localhost/HyperLinkOrderDetails.aspx instead of http://localhost/HyperLinkOrderDetails.aspx?aOrderID=ABCD&CustomerId=12345?

    AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="OrderID" 
        DataSourceID="dsOrders" onrowcreated="GridView1\_RowCreated" 
        onrowdatabound="GridView1\_RowDataBound" 
        onrowcommand="GridView1\_RowCommand">
        ReadOnly="True" SortExpression="OrderID" >
            SortExpression="ShippedDate" >
            DataNavigateUrlFields="OrderId, CustomerId" 
                DataNavigateUrlFormatString="HyperLinkOrderDetails.aspx?aOrderID={0}&CustomerId={1}" 
                HeaderText = "Order Details"
                Text="View order details" /> 
  
    
    ContextTypeName="NorthwindDataContext" TableName="Orders">