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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Disposing DbConnection variable of an object used as a local instance

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :.NET Framework
 

Hi,

I have a class with a property of type DbConnection.
That class is instanciate inside a method as a local variable.
Do I need to dispose the DbConnection property value when disposing the entire object?

Thanks, 




View Complete Post


More Related Resource Links

Local variable scoping in C#

  
In my previous post, Compiler-generated scopes for local variable declarations, I briefly touched on the issue of multiple meanings applied to the same name. In this post, I'll aim to flush out the compiler's rules with regards to binding names in their local scopes.

Compiler-generated scopes for local variable declarations

  
I was tasked with understanding and fixing a bug on error reporting with foreach iteration variables the other day, and it got me thinking about local variable scoping rules in C# in general. First, the bug.

How to connect to local instance of SQL Server 2008 Management Studio Express ?

  

I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

-----------------------------
Cannot connect to PC-NAME\SQLEXPRESS. 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
----------------------------


VS2010 Silverlight 4 - Getting "Object reference not set to an instance of an object" when loading a

  
In Visual Studio 2010 I'm trying to use the Blacklight Controls (http://blacklight.codeplex.com/releases/view/37652) in my own project (and actually included the Blacklight.Controls project in my solution so that I could debug what was going on) and... after making all the XAML changes needed to incorporate the Blacklight navigation menu with my stuff in the innermost grid... everything compiled ok when doing a Build.  When I run it there's a reference to a resource dictionary in the XAML that fails with the object reference error above.  The XAML is as follows:       <UserControl.Resources>       <controls:ResourceDictionaryManager x:Key="ResourceDictionaryManager">       <controls:ResourceDictionaryManager.ResourceDictionaries>       <controls:ResourceDictionaryCollection>       <controls:ResourceDictionary Path="/Blacklight.Showcase;component/ResourceDictionaries/DavesGlossyControls.xaml">       <controls:ResourceDictionary.ResourceKeys>       <controls:ResourceKeyCollection>       <controls:ResourceKey ResourceName="GlossyBlackScrollViewer" />       </controls:ResourceKeyCollection>     &

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local appl

  
Hi ,From the last few days I am struggling with the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."I hav created an asp.net web application with membership shcema. It works fine an my developement machine but when I published it on my web server. It is giving me above error for which I searched but not found any help.Can anyone help me with this.

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local appl

  
Hi,I spend two days looking for an anwser to this problem but no luck. I have a simple ASP.NET 2.0 application which run correctly on my local machine. But After uploading all files including web.config file on a Windows 2003 Server with SQLEXPRESS installed. I have this error. Please Help!!!!!! Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. 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: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

Can I dehydrate the Workflow object as well as the instance?

  
Hiya All Can I dehydrate the workflow object (i.e. not an instanciation of it) into SQLServer?  I want to save all versions created of a workflow so that I can chose to instanciate the workflow from any of the previous versions if I need to. This is due to a compliancy issue - being able to reconstruct the data created by a previous version of a workflow to prove accuracy. ThanksMichelle x

reference not set to an instance of an object.

  
Hi friends,I got this error. This application for  delete  multiple record in gridview using Check Box.Please verify it. I tried before one application, that one finally worked,That application also error occurred, but after some time it execute(automatic I didnt do anything) correctly,Please tell me why this type of error occurred.  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: Line 153: if (chkdelete != null) Line 154: { Line 155: chkall.Checked = array.Contains(grideviewsasmple.DataKeys[i].Value); Line 156: Line 157: if (!chkdelete.Checked) Source File: c:\Inetpub\wwwroot\AdditionUpdate\Default.aspx.cs    Line: 155

SSIS Deployment Reads local Environment Variable and not Server

  
Hi All, I have an SSIS package that uses an Environment variable to hold the connection string for the local SSISConfiguration table.  This works properly on my local machine.  However, when I import the package to Integration Services(through SSMS) it reads the environment variable from the local machine and not the server it is deployed to.  If I log on to the server remotely and do the same process it uses the the correct environment varible... (SQL Server 2005) Is there a way to deploy the package to the server and get it to use the correct Env variable without having to log-in to the server and import it?  Let me know if anyone is looking for additional information.   Thanks!

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local appl

  
Hello everybody.I am working on Login control and I am new in ASP.NET. So far what I did is :1. In Website->ASP.NET Configuration I change the form authentication to internet.2. I created a user profile3. This gave me a ASPNETDB.mdf database.4. I added this code :<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/> </connectionStrings> in web.config file.4. I added login control to my login page :<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" Title="Untitled Page" %><asp:Content ID="MainContent" ContentPlaceHolderID="MainContentPlaceHolder" Runat="Server"> <h1>Please Login</h1> <asp:Login ID="LoginAuth" runat="server" > </asp:Login></asp:Content> 5. And the login.aspx.cs file has :using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.W

Object Reference not set to an instance of an object

  
Hi All,While using listview to upload images I get the error message. "Object Reference not set to an instance of an object".Gallery.aspx is suppose to call ManagePhotoAlbum.aspxError generatedLine 5: Protected Sub LinqDataSource1_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.LinqDataSourceStatusEventArgs) Handles LinqDataSource1.Inserted Line 6: Dim myPhotoAlbum As PhotoAlbum = CType(e.Result, PhotoAlbum) Line 7: Response.Redirect(String.Format("ManagePhotoAlbum.aspx?PhotoAlbumId={0}", _ Line 8: myPhotoAlbum.Id.ToString())) Line 9: End SubCode Behind Gallery.aspx.vbPartial Class Photo_Gallery    Inherits System.Web.UI.Page    Protected Sub LinqDataSource1_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.LinqDataSourceStatusEventArgs) Handles LinqDataSource1.Inserted        Dim myPhotoAlbum As PhotoAlbum = CType(e.Result, PhotoAlbum)        Response.Redirect(String.Format("ManagePhotoAlbum.aspx?PhotoAlbumId={0}", _            myPhotoAlbum.Id.ToString()))    End Sub    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load    End S

Object reference not set to an instance of an object.

  
This one has been killing me for 2 days now, and it should be so simple.I have a button on a page with an onClick that calls a web service.  I get the above error (on Line 938, Sys.WebForms.PageRequestManagerServerErrorException) as soon as the button is clicked.  The error seems to occur the second that the service is called - I have verified that every step of  the client-side code works and does not contain null values.  When remote debugging, the exception hits as soon as it jumps over to the web service's source code, an indication that the reference to the server itself is also valid.The code: (bad spelling and formatting not mine... I inherited this and have been cleaning it up as I go)'btnClick event - removed the log-writing lines for clarity's sake Private Sub btnSendCIS_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSendCIS.Click Dim dt As DataTable Dim retr As String = "" dt = createOrderTable() Dim client As New ProdEndpoints.CISPRODUCTIONClient() retr = client.CompleteOrders(dt) client.Close() tmRecive.Interval = tickinterval getallrecive() End Sub 'createOrderTable - creates the dt that is sent to the service, also with log-writing lines removed. verified this is not returned Null as the log-writing includes pulling ou

Null Reference Exception was not handled by user Object Reference not set to instance of an object

  
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Security.Principal;using System.Data;using System.Data.SqlClient;using System.Windows;using System.Collections; public partial class Default2 : System.Web.UI.Page{    protected void Page_Load(object sender, EventArgs e)    {     }    private bool tableCopied = false;    private DataTable originalDataTable;     protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)    {         if (e.Row.RowType == DataControlRowType.DataRow)        {            //string sValue = e.Row.Cells[3].Text;             if (!tableCopied)            {                originalDataTable = ((System.Data.DataRowView)e.Row.DataItem).Row.Table.Copy();                ViewState["originalDataTable"] = originalDataTable;      &nbs

Using a Variable in SSIS - Error - "Command text was not set for the command object.".

  
Hi All, i am using a OLE DB Source in my dataflow component and want to select rows from the source based on the Name I enter during execution time. I have created two variables, enterName - String packageLevel (will store the name I enter) myVar - String packageLevel. (to store the query) I am assigning this query to the myVar variable, "Select * from db.Users where (UsrName =  " + @[User::enterName] + " )" Now in the OLE Db source, I have selected as Sql Command from Variable, and I am getting the variable, enterName,. I select that and when I click on OK am getting this error.   Error at Data Flow Task [OLE DB Source [1]]: An OLE DB error has occurred. Error code: 0x80040E0C.An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E0C  Description: "Command text was not set for the command object.". Can Someone guide me whr am going wrong? myVar variable, i have set the ExecuteAsExpression  Property to true too. Please let me know where am going wrong? Thanks in advance.

Object reference not set to an instance of an object.

  
can anybody help me with this error??the error occurs in the first line of the if statement...i really dont know how to fix this problem.. please help..Dim GW1 As new GridView            GW1 = CType(Me.LoginView1.FindControl("GridView1"), GridView)            If GW1.PageCount < 1 Then                lblFromDept.Visible = True                ddlFromDept.Visible = True                SelectedFromDept.Visible = False                btnOK.Visible = True            Else                lblFromDept.Visible = False                ddlFromDept.Visible = False                SelectedFromDept.Visible = False                btn

Object reference not set to an instance of an object.

  
When  can debugg the code it will give the error "Object reference not set to an instance of an object.". The code is--     using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using SMC.AlphaAccounting.EntryControls; using SMC.AlphaAccounting.PlugIns; using SMC.PlugInContracts; using SMC.BusinessObjects; using SMC.Utils; using SMC; using SMC.AlphaAccounting; using SMC.AlphaAccounting.DataEntry; using Infragistics.Win.UltraWinEditors; using Infragistics.Win.UltraWinMaskedEdit; using Infragistics.Win.UltraWinToolbars; namespace WindowsApplication3 {     public partial class FormCountry : SmcDataEntry     {         private boGlChart boLocalGlChart;         private boVendors boLocalVendors;         public FormCountry()         {             InitializeComponent();             this.ultraNumericUniqueID.KeyDown += new KeyEventHandler(ultraNumericUniqueID_KeyDown);             this.ultraNumericUniqueID.KeyPress &

Object reference not set to an instance of an object.

  
Protected Sub CreateUserWizard1_CreatedUser(ByVal sender As Object, ByVal e As System.EventArgs)         Dim CUW1 As New CreateUserWizard         CUW1 = CType(Me.LoginView1.FindControl("CreateUserWizard1"), CreateUserWizard)         Dim p As ProfileCommon = DirectCast(ProfileCommon.Create(CUW1.UserName, True), ProfileCommon)         p.SelectFromDept = DirectCast(CUW1.CreateUserStep.ContentTemplateContainer.FindControl("ddlSelectFromDept"), DropDownList).SelectedValue         p.Save()     End Subanybody can help me with this error?? that error occurs in the p.SelectFromDept line...Protected Sub CreateUserWizard1_CreatedUser(ByVal sender As Object, ByVal e As System.EventArgs)        Dim CUW1 As New CreateUserWizard        CUW1 = CType(Me.LoginView1.FindControl("CreateUserWizard1"), CreateUserWizard)        Dim p As ProfileCommon = DirectCast(ProfileCommon.Create(CUW1.UserName, True), ProfileCommon)        p.SelectFromDept = DirectCast(CUW1.CreateUserStep.ContentTemplateContainer.FindControl("ddlSelectFromDept"), DropDownList).SelectedValue        p.Save()    End S
Categories: 
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