.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

aspnet_regsql results not showing in administration

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :ASP.Net


I'm trying to tie my login controls to my externally hosted database. I used the aspnet_regsql tool to create the appropriate tables in the database, but when I try to administer them through the "Administer Website" smart tag on the login control I cant connect to the new tables and such in the "Providers" tab.

Any ideas?

View Complete Post

More Related Resource Links

Excel file not showing in search results

We have a strange issue. I have one Excel document (or at least one that I am aware of) that will not show up in search results for content within the document. I can find the document by title just fine, but when I search for words within the document I do not see it. The document was originally a 2003 Excel document and was recently converted to 2007. Other than that there isn't really anything unusual about it (some formatting stuff, but mainly just background colors and whatnot, nothing fancy). The crawl log shows the document was crawled without error. Anyone know anything else I can check on?

Group Results By Month, showing each month as the column

I have to list 50 states and the # of population per month. right now my results look something like..   CA, June, 5000 CA, July, 6000 CA, August, 7000 CA, September, 7230 I want it to show.. State, June, July, August, September CA, 5000, 6000, 7000, 8000 NJ, 4013, 5030, 7020, 7310   I was going to use a PIVOT table but.. I want the columns to expand as the coming month  comes upon us.

Showing Solr XML results in gridview using xmldatasource

I have the XML below, generated by Apache Solr.I want to assign the results (2 <doc>nodes in this case) to a gridview using an XML datasource.<response>-<lst name="responseHeader">    <int name="status">0</int>    <int name="QTime">0</int>    <lst name="params">        <str name="facet">true</str>        <str name="fl">        id,title,city,score,location_rating,introtext,location_rating_total,themes,features,official,services        </str>        <str name="indent">on</str>        <str name="start">0</str>        <str name="q">*:*</str>        <arr name="facet.field">            <str>province_raw</str>            <str>services_raw</str>            <str>themes_raw</str>           &

Search results page showing random characters instead of item's description

I have an email-enabled document library that a few Japanese people email PDF files into (all external to the company). When I search for any PDF file sent from particular email addresses, the search results page displays random characters instead of the item's description. Here is an example: From Screen shots These characters don't appear for all email senders, just some of them. Our MOSS site is in English and we don't have any language packs installed. The PDF file contents are also in English. Can anyone point me towards a solution for this?

Reporting Services Sharepoint Add-in not showing links in Sharepoint Central Administration

Hi. I've just installed RS Sharepoint Add-in on Sharepoint farm and have the issue, that links to configure RS in Sharepoint are not showed in Central Administration Site->Application Management, and RS features can't be activated for web app. My configuration is: A separate DBMS on Windows 2008 SP2 x64, SQL 2008 SP1 x64, with MOSS and RS dbs. Web frontend: Win 2008 SP2 x64, Sharepoint 2007 SP2, RS 2008 SP1. What I did: installed RS and RS Sharepoint Add-in on web frontend, configured RS to Sharepoint mode (http://frontend:portnumber/Reportserver displays reports catalogs, reports shows message about configuring RS to Sharepoint mode), tried to set Sharepoint from central admin - links were not displayed. Reinstalled the add-in and tried to configure again - links not displayed. Reinstalled the add-in from the account used to install MOSS - links not displayed. Please help.

Search Results Web part not showing all results

Hello, I have an issue with the people search results web part not showing all the results that exist for a particular query. The query in question returns 106 results, and it is showing 50 per page, but the paging bar only goes up to page 2, and the results summary says it is showing "x of 100 results". If I manually change the query string to say start=61 instead of start=51 for page 2, it will show me the last 6 people, and the search summary will say "showing 57-106" Why is it not showing me the option for a page 2? When I perform a similar query that returns 140 results, it will show me all three pages correctly. I have tried turning duplicate trimming off but it makes no difference either. Any ideas why this is happening? Thank you

People search results showing members deleted from AD

Hi guysWe've configured a full nightly import of users from AD, but I'm seeing users who have been deleted showing up under the People Search function.  Does the import job delete accounts from SharePoint that no longer exist in AD?  If not, is there a way to change this?Tks,steven

Mysite profile pictures not showing in people and groups, or search results

My organization is running MOSS 2007 Enterprise with search.  Picture profiles uploaded to the user's mysite only appear while browsing from the Default zone.  When browsing the Internet zone, a broken link appears in place of the picture when viewing pages such as "People and Groups" or search results.  For example:

Default zone:

http://moss1:5154   <---- mysite
http://moss1:5155   <---- main sharepoint site

Internet zone:

https://mysite.domain.com  <---- extended mysite
https://domain.com             <---- extended main sharepoint site

The picture profile url that is appearing while browsing the Internet zone is:


Instead of:


All of the textual information is coming over fine, just the images have invalid urls for the current zone.
Does anyone know how to fix this?

Any insights appreciated,


Exporting to spreadsheet showing no results

Hi guys,

I have a list that contains a few columns including calculated fields. When I export to a spreadsheet (via Actions => Export to Spreadsheet), I get the usual authentication prompt and thereafter the column headers appear but not the data. I don't have item-level security or anything fancy running on that list.

This is really confusing me. Has anyone had this problem?


search results showing label text


I have a custom page layout where I have site columns. My search results shows site column names as part of description. Actually it should show data within those site columns. To dig into this I looked into managed property "Description" which is mapped to following different crawled properties - 


I don't know what are those crawled properties. Can anyone help here?

Thanks in advance.


Errors in the Crawl log and files not showing up in the search results


MOSS 2007:

Problem:  Errors in the Crawl log and files not showing up in the search results

Symptoms/ Error messages: "The filename or extension is too long. (The item was deleted because it was either not found or the crawler was denied access to it.)"

What I have done:  The file paths are under the limit imposed by MS, I already checked that.  The indexing account has access to the files security wise.

·          <

want to execute url without showing that page or url to client.


hello friends,

I need ur help,what i want to do is to execute a url ("To send a text message to client") on client registration but without showing that url page, in short executing url without displaying any page or url to the client.

please help and thanks in advance.

Trouble with UpdateProgress showing...


Recently I converted a project to VS.NET2010 and ASP.NET 4.0 (not convinced this is the problem, but regardless this is when the problem began) and now I am having an issue with an AJAX UpdateProgress showing. Here is the abrriviated code:

   <asp:UpdatePanel ID="UpdatePanelPostPageLoad" runat="server">
         <asp:Timer ID="tmrPostPageLoad" Enabled="false" Interval="100" OnTick="PostPageLoad_LoadData"
         <asp:Timer ID="tmrPostPageLoadPt2" Enabled="false" Interval="1" OnTick="PostPageLoad_LoadDataPt2"
         <%--Placing the UpdateProgress inside the UpdatePanel targeted--%>
         <asp:UpdateProgress ID="UpdateProgressPostPageLoad" runat="server" DisplayAfter="0" AssociatedUpdatePanelID="UpdatePanelPostPageLoad">
                       Updating blah blah....


Need Syntax To Make Results of LINQ Union Return Non-Generic Type



I have the below SQL which works just fine:

SELECT     Message, CreateDate, AccountId, AlertTypeId
FROM       dbo.Alerts
SELECT     TOP (100) PERCENT Status, CreateDate, AccountId,
                          (SELECT     10 AS Expr1) AS AlertTypeId
FROM         dbo.StatusUpdates
WHERE AccountId = PassedInParameter

I have been going about trying to convert the above into a LINQ method and am having problems with return types.
As the above SQL illustrates, I am querying two distinct LINQ tables - Alerts and StatusUpdates -
and then attempting to perform a Union on them. In order to do the union in LINQ, I have to have agreeing types. So, I
am using "var" to make the results of "alerts" and "updates" generic before the union.  

public IList GetStatusUpdatesAsAlertsByAccountId<T>(Int32 accountId)
            using (WorkbookDataContext dc = _conn.GetCont

DAL Dataset showing all the column


I follow the tutorial and create DAL with Dataset. I created a Table Adapter with many column, but when i Call a simple Get for 2 column only. The system display 2 column and the rest column with empty data.

My question is that will this affect the performance? because i only need 2 column.

example: Table with 40 column define in Dataset in DAL. I have GetMember from Dataset with 40 column, some request only 1 column (with 39 empty), some request 22 column (with 18 empty column). Will this affact the performance?

Should i create a seperate DatasetAllColumn, Dataset1Column, Dataset22Column ?? so system only return exact column i need. and hofully the performance is optimized to it best.

sqlDataReader dos not get results


I am trying to run a stored proc from this function. When I run it thorugh the debugger I can see that myReader.HasRows = true and myReader.FieldCount =14.

But the control does not go in the loop while (myReader.Read()) where I am trying to read Version field returned by the stored proc.

Pls check me code and suggest correction. Thank You.

private static int Get_CaseInfo(string CaseNum)
            int Ver = 0;
            String myConn = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString();
            SqlConnection conn = new SqlConnection(myConn);
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = System.Data.CommandType.Text;

            SqlDataReader myReader = null;
            String stmt1 = "EXEC [REPORTS].[CaseInfoByCaseNo_Get] @CaseNo = '" + CaseNum + "'"; 
            cmd.CommandText = stmt1;
            cmd.Connection = conn;
                myReader = cmd.ExecuteReader();
                while (myReader.Read())
                    Ver = (int)myReader["Version"];

            catch (Exception)
            return Ver;         

displaying xsl results in browser


Hi guys,

How can I test what my xsl spits out in the browser, rather than just viewing the xsl itself?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend