DataSource Controls :: Error Accessing SQL Server Db From User Control In SharePoint
Jan 15, 2010
I'm developing an ASP.NET user control in VS2008 that writes to a SQL Server 2005 database. I've published the control to a SharePoint 2007 MOSS page using the SmartPart addon. The control consists of a few text fields and a submit button that writes the contents of the text fields to the database. When I test the control in the Visual Studio debugger, it works fine. When I try to submit data from the SharePoint page, I get the error shown at the end of this post. Last time I saw this, it was a database permissions error, but I've granted my site's default application pool read/write access to my database. Does anyone have any idea what else the problem might be? Also, how can I double-check the credentials that the SharePoint page is using to access the database, since I still suspect that this is a permissions issue?
[ERROR TEXT FOLLOWS]
Server Error in '/' Application.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
ConnectionHandler.ClientDataConnect() +103
ClientData.ClientData.Page_Load(Object sender, EventArgs e) +1426
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +24
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +41
System.Web.UI.Control.OnLoad(EventArgs e) +131
System.Web.UI.Control.LoadRecursive() +65
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2427
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
View 2 Replies
Similar Messages:
Dec 10, 2010
I have a piece of code that is just HTML. It was previously created as a user control. Within the application i'm working with there are two seperate websites that are interlinked to make one website. There is a documents section where users do not need to login and a data section where users need to login. The design was implemented long before I was hired. My problem is I want to use the code from the documents website with the data website but I can't seem to register the control. I only one this piece of code in one place so when it is updated it doesn't have to be in multiple places. I tried setting "src=http://website/doc/doc.ascx" but this errors out saying
<%@ Register Src="http://website/doc/doc.ascx" TagName="docs" TagPrefix="temp" %>
Parser Error Message: The file '/documents/http://website/doc/doc.ascx' does not exist.
It adds the directory as part of the src. How can I have it point to this location http://website/doc/doc.ascx ?
View 7 Replies
Mar 8, 2010
If the answer to this question exists somewhere, I'm no good at searching for it. This is sort of a simple question, the response being two parts: (1) is it possible? (2) if so, how?
I've created a web user control for my site's footer. In my web.config I have it registered like this:
[Code]....
Then, within the pages on my site, I simply insert it like this:
[Code]....
But obviously, that didn't work. I get this error: The type or namespace name 'FooterControl' could not be found (are you missing a using directive or an assembly reference?)
So I'm really not sure what to do at this point. I can put all of my code in the ASPX file and make my life easier, but I would kind of prefer not to.
View 11 Replies
Jan 29, 2010
I'm trying to remove Sharepoint in its entirety from my server (2003). I've uninstalled Sharepoint, but in SQL Server Management Studio, I still have a reference to the OfficeServers database, in the dropdown, though I can't find it anywhere in the SQL Server folder hierarchy
View 1 Replies
Jun 15, 2010
while i was using sql server authentication, it was running a quite good but suddenly it starts showing an error 'Login Failed for user sa'
Here is my error-Login failed for user 'sa'.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'.
Here is my code-
<add name="MyDB" connectionString="Data Source=ERPTEST;Initial Catalog=LoginDatabase;User ID=sa;Password=sa"
providerName="System.Data.SqlClient" />
View 2 Replies
Jul 27, 2010
I'm programming a webpage in ASP.NET which displays a list of students not listed as participants in something, and upon clicking a student name shows you a brief summary of their details, so the user can ensure they're selecting the right person. Each student is identified by a unique ID.
My code currently correctly obtains their ID, adds it as a parameter to my stored procedure and executes the procedure;
[Code]....
However, when I try to access the results, with say dv.Table.Rows[0], I get the following error:
[Code]....
Upon debugging, there don't seem to be any results returned... when running just the stored procedure in SQL Server with the same data, it does return a single row, as expected.
View 2 Replies
Sep 10, 2010
I've got a web site that has a master page and that master page (mpMaster that has a user control ucControl1) which has a sub user control (ucControl2), this user control has a property which accepts a value. Now, I have a page that uses the master page
and on this page I have another user control (ucPageControl), I need to find a way of setting the value in ucControl2 from ucPageControl. Is this possible at all?
View 5 Replies
Oct 27, 2010
I've built a new sharepoint site page using the example I found here:
http://blogs.msdn.com/b/kaevans/archive/2010/06/28/creating-a-sharepoint-site-page-with-code-behind-using-visual-studio-2010.aspx.The purpose of the page is to add a new user to the aspnet membership database that serves as the authentication provider for my sharepoint site,which uses forms based authentication.I've slightly customized the asp createuser control.The sharepoint site is forms based but the top level site is accessible anonymously, and I've created a subsite for members (hence the user registration page). The site page is in the top level site so that people can register.If I'm already logged in and fill out the form, the user is successfully added to the membership store, however if I access the page anonymously and fill out the form, the user is successfully added to the membership database, but I can no longer navigate the website,I keep getting http 500 page cannot be displayed errors until I clear the browser cache and cookies.
View 1 Replies
Jul 31, 2010
I have created a web user control (MemberDetails.ascx) which is loaded dynamically on a page (Member.aspx) for my website. The control has some TextBoxes. I want to store the values inputted by a user in these TextBoxes to a database on the click event of a button that is on the Member.aspx page (i.e. not a part of user control).
I'll use a small code for example.
Member.ascx page:
[Code]....
View 1 Replies
Mar 3, 2010
I am working on a page called Edit.aspx and on that page is a User Control.
Note: I need to access the User Control from a button that is on the Edit Page. Once I get a handle of the User Control then I need to access a DataList on that user control and finally I need to get the ID of a dropDownList
on the User Control
This is all the code I have,Goal: From the Edit page I want to drill backwards to the UserControl/DataList/DropDownList
'Geting the user control
Dim ctrl2 As UC_SiteTemplate2 = CType(Page.LoadControl("~/UC/SiteTemplate2.ascx"), UC_SiteTemplate2)
'accessing drop down list from user control
Dim xListNumber1 As DropDownList = New DropDownList()
xListNumber1 = ctrl2.FindControl("DDLOrderList1")
View 6 Replies
Jun 4, 2010
I don't think I understand fully how ASP.NET does inheritance of controls.I have a user control, ucBase, which has an asp.net label in the ascx file. Code behind references the label and it works fine during run time if the control is not a parent for another user parent.
If I have another user control, ucChild, inheriting from ucBase, the label in ucBase's code is always null. ucChild has no controls in its ascx fileThe server controls (like the label) needs to be declared in the ascx file and not created programmatically.What needs to be done for ucBase to see its own controls when it's a parent user control?
View 1 Replies
Jan 13, 2010
I am attempting to write my very first ASP.NET application, it will simply display the contents of an SQL server database table in a Gridview. This is just a first step, my eventual intention is rewrite a set of VB6 applications I wrote some years ago. But I need to walk before I can run.
I have already created an SQL Server database containing all the tables used by the VB6 applications.
How do I link this database to my ASP.NET application. Previously (on another computer) I have simply opened "My Computer" and then navigated to the .mdf file (e.g. northwnd.mdf) and then dragged and dropped it into App_Data in Visual Studio. However when I try that on my own machine, with my own data, I get an "Access Denied" message.
How can I not have access to my own data on my own computer? What am doing wrong?
I am running Visual Studio 2008 on a Windows 7 Ultimate machine, with SQL Server 2005 Compact Edition (or which ever one installs with VS 2008).
View 13 Replies
May 4, 2010
I know it's usually the other way around, but I have some extenuating requirements that must be met (read as "No one bothered to do the research and now I have to bail them out")
I have a standard user control (ascx) that is to be imported into a SharePoint 2007 website. Due to a design constraint, a sharepoint web part that is also needed has to be nested inside of this user control.
So in other words, the user control would have to look something like this:
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="foo.ascx.cs" Inherits="foo" %>
<div id="container">
...snipped...
<!-- SharePoint web part goes here -->
...snipped...
</div>
View 1 Replies
Nov 4, 2010
I have an asp.net control that contains a grid view sitting on top of an Ajax update panel. The control has been added to a sharepoint page. When a button is clicked, some server code is called to store the contents of the grid. If the server code throws an error, I want to spit out a javascript alert displaying the error message, but for some reason the error that bubbles up from the server is the generic 500 server error, which doesn't contain any details of the original error.
View 1 Replies
Feb 4, 2011
We have a MOSS 2007 custom web part based on a user control that queries a database cluster. When the connection to the database is made, we regularly experience the error below and have had to create a work-around in the code to retry the connection. We have 3 environments - development, staging and production; the error only occurs in production. The difference in the production environment is it is a farm with 3 WFEs and a SQL cluster, where development and staging are single machine instances. All are MOSS 2007 & SQL Server 2008. We cannot find what is causing this issue and I'm hoping someone else has experienced a similar problem and knows the cause.
This is the error that occurs frequently when the query is executed:
System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at [Our Namespace.OurMethod](String someParam)
More than one method will generate this, but this is typical code, note the retry work-around:
public static DataTable OurMethod(string someParam) {
const string query = "sp_OurStoredProcedure";
var resultsTable = new DataTable();
var connection = new SqlConnection { ConnectionString = OurDatabaseConnection };
var command = new SqlCommand(query, connection) { CommandType = CommandType.StoredProcedure };
var dataAdapter = new SqlDataAdapter(command);
var retry = 5; SqlConnection.ClearPool(connection);
while (retry > 0) { try { command.Parameters.Clear();
command.Parameters.AddWithValue("@someParam", someParam);
connection.Open(); dataAdapter.Fill(resultsTable); retry = -1;
} catch (Exception ex) { retry--; if (retry <= 0) {
LogError("Exception: DataAccess:OurMethod: *RETRIES EXCEEDED* " + ex, "error");
} else { SqlConnection.ClearPool(connection);
LogError("Exception: DataAccess:OurMethod: ATTEMPTS REMAINING " + retry + ". " + ex, "warning");
} } finally { dataAdapter.Dispose(); command.Dispose(); connection.Dispose();
} } return resultsTable; }
View 5 Replies
Feb 15, 2011
I am creating one new silverlight webpart from VS Sharepoint 2010. If i am creating the silverlight application its asking for the sharepoint local site url, i gave the valid url but its showing the ["could not contact sharepoint server for list of document libraries. check your sharepoint URl"].
how to resolve this error.
View 1 Replies
Feb 25, 2011
currently investigating SharePoint for our company as a means to make Excel processing accessible through our web application without relying on the Office Interop DLL files. (our sysadmin doesnt want to install Office on the production server, for good reason)I'm aware that Sharepoint has an Excel Webservice that can be enabled and used by the application. The problem, if it is a problem, is that I need to make a class that wraps all the logic for transforming an Excel into HTML.So I need to add the references to this webservice to the application.
But what if we need to deploy the application with a customer that has no SharePoint server available, will this cause a problem in the application? We will use checks to make stuff visible and invisible depending on whether a parameter is set, but I'm looking for a means to ensure that I can for example add the required references at runtime when I need them for Sharepoint.
View 1 Replies
Mar 10, 2011
I have a web user control that represents a simple message box. It is used to display simple messages like "Item has been deleted", or "The item was saved successfully".
On the other hand, I have another web user control that represents the item in the form of an editable form (I made this a user control because this is used in two different pages). I want to embed an instance of the message box user control inside the editable form. I am writing this right after the @Control directive:
[Code]....
Instead of using @Register directives, I register the user controls in web.config and so far this has worked just fine.
With the above markup, the project compiles, but whenever I try to navigate to a page that contains this construct, I get an HttpParseException exception. Furthermore, Visual Studio states that the tack w7rc9:MessageBox doesn't represent a known control.
What am I doing wrong?
View 2 Replies
Oct 23, 2010
I have created a web user control I want to change the iframe' src value when the user click on the link but the problem is that I dont have access to iframe inside the page from web user control I think there is a way because my control is in the page they have some relation perhaps I like to find something like this :
[code]...
View 1 Replies
May 3, 2010
I have a User Control with a multiple number of link buttons.
What I want to achieve is to change the Background colour of one of the link button control in the page load event of one of the pages. I am finding it difficult to access the link button in user control .
View 3 Replies
Jun 15, 2010
Following error comes when creating a WebPart In sharePoint 2010 Server.
Web Part Error: Unhandled exception was thrown by the user code wrapper's Execute method in the partial trust app domain: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.TypeLoadException: Could not load type 'Microsoft.SharePoint.WebControls.SPGridView' from assembly 'Microsoft.SharePoint, Version=14.900.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. at ListMenuSample.ListMenuSample.ListMenuSample.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at Microsoft.SharePoint.UserCode.SPUserCodeWebPartWrapper.ExecuteHttpRequest(SPUserCodeWebPartHttpRequestContext webPartExecutionContext, SPUserCodeWebPartHttpResponse httpRequestResponse) at Microsoft.SharePoint.UserCode.SPUserCodeWebPartWrapper.Execute(SPUserCodeExecutionContext executionContext) at Microsoft.SharePoint.UserCode.SPUserCodeApplicationHostAppDomainRef.Execute(Type userCodeWrapperType, SPUserCodeCachedAssemblyGroup userAssemblyGroup, Guid siteCollectionId, Byte[] binaryUserCodeToken, Byte[] proxyOperationToken, SPUserCodeExecutionContext executionContext)
View 1 Replies
Apr 15, 2010
im working with visualstudio 2005 and sql server 2005 c#,and i tried to insert an items to the sql but it gave me this error
Application server error '/ WebSite6'.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_StudentToCourse_Students".The conflict occurred in database "TopseaUser", table "dbo.Students", column 'id'.
The statement has been terminated.Description: The exception is unhandled occurred during the implementation of the current web request. the stack trace for more information about the error and where the source code.
Details exception: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_StudentToCourse_Students". The conflict occurred in database "TopseaUser", table "dbo.Students", column 'id'.The statement has been terminated.
This error: Line 243: sql_comm.Parameters.AddWithValue ("@ studentId", Convert.ToInt32 (id));
Line 244: sql_comm.Parameters.AddWithValue ("@ CourseId", Convert.ToInt32 (ListBox3.Items [j]. Text.ToString
()));
Line 245: sql_comm.ExecuteNonQuery ();
Line 246: split_listbox2 ();
Line 247: sql_conn.Close ();
Source File: c: Documents and Settings Ronen My Documents Visual Studio 2005 WebSites WebSite6 SiteMembers CourseSignUp.aspx.cs line: 245
this it the code :[Code].... !
View 7 Replies
Nov 21, 2012
Microsoft sql server error 18456 in sql server 2008 r2login failed for user sasql server was working properlyi just restarted the system and then i started getting the above errorhow do i resolve iti am able to login with windows authentication but not sql authentication....
View 1 Replies
Mar 31, 2010
Surprised that i havent been able to find this myself, but anyway. Let's say i use my web user control like this:
<myprefix:mytag userid="4" runat="server">Some fancy text</myprefix:mytag>
How would i be able to access the text inside the tags from its codebehind ("Some fancy text")? Was expecting it to be exposed through this.Text, this.Value or something similar.
EDIT:
I even get the following warning on the page where i try to user it:
Content is not allowed between the opening and closing tags for element 'mytag'.
EDIT2:
public partial class mytag: UserControl
{
public int ItemID { get; set; }
protected void Page_Load(object sender, EventArgs e)
{
}
}
View 1 Replies
Apr 22, 2010
Following is the error I am getting while accessing some of the pages on my website.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
It is trowing an exception and giving the about mentioned error.
View 5 Replies
