DataSource Controls :: Error Msg "Null Reference Was Unhandled By User Code"

Jan 16, 2010

I downloaded a sample Rolodex from here: [URL] the file to download is at the bottom of the page and it is called 'RolodexDatalist.zip (6.71 kb)' So I changed the HTML to it points to my SQL Server DB. I changed the ConnectionString to this:

<connectionStrings>
<add name="CustomersConnectionString" connectionString="Data Source=EXCEL-4J2W8KYNPSQLEXPRESS;Initial Catalog=Customers;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

Now, everything points to my DB! I thought, ok great, this should be pretty easy. However, when I debug, I get this error message: 'Null reference was unhandled by user code. Object reference not set to instance of an object. Troubleshooting Tips: use the "new" keyword to set an instance of an object.' This line is yellow:

Dim conStr As String = ConfigurationManager _
.ConnectionStrings("conStr").ConnectionString
Here is the code-behind:
Imports System.Data
Imports System.Data.SqlClient
Imports System.Collections.Generic
Partial Class VB
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not IsPostBack Then
ViewState("CurrentAlphabet") = "ALL"
Me.GenerateAlphabets()
Me.BindDataList()
End If
End Sub
Private Sub BindDataList()
Dim conStr As String = ConfigurationManager _
.ConnectionStrings("conStr").ConnectionString
Dim con As New SqlConnection(conStr)
Dim cmd As New SqlCommand("spx_GetContacts")
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@Alphabet", ViewState("CurrentAlphabet"))
con.Open()
dlContacts.DataSource = cmd.ExecuteReader()
dlContacts.DataBind()
con.Close()
If ViewState("CurrentAlphabet").ToString().Equals("ALL") Then
lblView.Text = "all Contacts."
Else
lblView.Text = "Contacts whose name starts with " & _
ViewState("CurrentAlphabet").ToString()
End If
End Sub
Private Sub GenerateAlphabets()
Dim alphabets As New List(Of Alphabet)()
Dim alphabet As New Alphabet()
alphabet.Value = "ALL"
alphabet.isNotSelected = Not alphabet.Value _
.Equals(ViewState("CurrentAlphabet"))
alphabets.Add(alphabet)
For i As Integer = 65 To 90
alphabet = New Alphabet()
alphabet.Value = [Char].ConvertFromUtf32(i)
alphabet.isNotSelected = Not alphabet.Value _
.Equals(ViewState("CurrentAlphabet"))
alphabets.Add(alphabet)
Next
rptAlphabets.DataSource = alphabets
rptAlphabets.DataBind()
End Sub
Protected Sub Alphabet_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim lnkAlphabet As LinkButton = DirectCast(sender, LinkButton)
ViewState("CurrentAlphabet") = lnkAlphabet.Text
Me.GenerateAlphabets()
Me.BindDataList()
End Sub
End Class

View 8 Replies


Similar Messages:

DataSource Controls :: SqlException Was Unhandled By User Code

Mar 22, 2010

[Code]....

View 5 Replies

DataSource Controls :: OledbException Was Unhandled By The User Code

May 3, 2010

I'm stuck with this query. I've tried a lot but ended up with no clue. Here is my sql query which is worrying me.. sqlselect = "select qo.OrderDate,qo.RequiredDate,qo.ShippedDate" & _

View 13 Replies

DataSource Controls :: Connect To Sqlserver - Invalidoperationexception Was Unhandled By User Code

Jan 6, 2010

i am getting this error, trying to connect to sqlserver! senario! im trying to connect 2 tables with corresponding information.

eg: table 1 has (item no., picture and link) table 2 has (all the information pertaining to the item number and picture meaning when you click on the link it has to link you back to the same picture with more information about it! what could possibly be wrong??

View 3 Replies

DataSource Controls :: System.FormatException Was Unhandled By User Code - Input String Was Not In A Correct Format?

Jan 20, 2011

"System.FormatException was unhandled by user code - Input string was not in a correct format"
This is driving me crazy! Can anyone see what the problem is?

[Code]....

View 15 Replies

Forms Data Controls :: Throw The Exception Back To Page_Load Error: ArgumentNullException Was Unhandled By User Code

Nov 19, 2010

I'm trying to throw the exception back to Page_Load but the throw statement causes error: ArgumentNullException was unhandled by user code. How can that be fixed? Also, I can't see Label1.Text displayed on the page after the ArgumentNullException occurs because the page is not re-load. If there is no exception, it's fine to not reload the page. How can I see the Label1.Text displayed?

protected void Page_Load(object sender, EventArgs e)
{
try
{
...do something here...
}
catch (ArgumentNullException ae)
{
System.Diagnostics.Debug.Write(ae.Message);
Label1.Text = ae.Message;
Label1.Style.Add("visibility", "visible");
}
catch (Exception ex)
{
...do something here...
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)............................

View 3 Replies

DataSource Controls :: Reading Excel Files To Store Into Sqlserver Database - OleDbException Was Unhandled By User Code

Feb 1, 2010

i've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.

[Code]....

View 1 Replies

Error - FormatException Was Unhandled By User Code In Linq?

Apr 7, 2010

Look below this codes throw me : FormatException was unhandled by user code

Codes:

satis.KDV = Decimal.Parse((from o in genSatisctx.Urun where o.ID == UrunID select o.Kdv).ToString()); How can i rewrite linq query?

View 2 Replies

WCF / ASMX :: Call HTTPS Web Reference Through Another Web Reference - An Unhandled Exception Of Type Error?

Aug 6, 2010

I am trying to call web reference "A" in an application.

The web reference "A" will then call a function in another web reference "B" through HTTPS connection (require certificate).

Then I keep getting the following error:

An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in System.Web.Services.dll

View 3 Replies

VS 2005 Error Index Out Of Range / Exception Was Unhandled By User Code

Jul 11, 2012

You can for example enter the length and width of the web (VS.NET2005), when it runs out of range index error exception was unhandled by user code for chieudai

Code:
public class Tinh
{
private Int32 _quanhuyen;
private String _diachiNha;
private Double _chieudai;
private Double _chieurong;
private Double _dientichDat;
}

[Code] ....

View 3 Replies

Web Forms :: Try To Catch Error "Invalidoperationexception Was Unhandled By User Code"

Jul 29, 2010

I have text box get data from dataread. Here my code:

OleDbCommand com = new OleDbCommand("select sid from TableOne where pid = " + "'" + PID.SelectedValue + "'" + " and gid = " + "'" + GID.SelectedValue + "'" + " and unitid = " + "'" + tid.SelectedValue + "'");
........
........
Txtsid.Text = myDataReader[0].ToString().Trim();

I got the run time error at line: Txtsid.Text = myDataReader[0].ToString().Trim(); Invalidoperationexception was unhandled by user code. No data exists for the row/column. How to try catching those errors?

View 16 Replies

Forms Data Controls :: System.IndexOutOfRangeException Was Unhandled By User Code

Nov 30, 2010

I'm trying to do a master-detail by first search the database when a user click on the search button. Then display the result to a ListView control. After that, if the user click on the hyperlink, it displays the detail on the Formview control. Below are my code:

[Code]....

And here's the part that causes the error:

[Code]....

The error is on this line: string strID = ltvLusHmoob.DataKeyNames[e.Item.DataItemIndex].ToString();

View 9 Replies

DataSource Controls :: How To Handle Error Unhandled Exception Occurred During The Execution

May 31, 2010

string connectionstring = WebConfigurationManager.ConnectionStrings["AdventureWorks"].ConnectionString;
SqlConnection con = new SqlConnection(connectionstring);
DataSet ds = new DataSet();
DataRelation dr = new DataRelation("show", ds.Tables["HumanResources.Employee"].Columns["EmployeeID"], ds.Tables["HumanResources.EmployeeAddress"].Columns["EmployeeID"],false);
ds.Relations.Add(dr);
foreach (DataRow row1 in ds.Tables["HumanResources.Employee"].Rows)
{
Response.Write("customertitle:" + row1["Title"].ToString());
foreach (DataRow row2 in row1.GetChildRows(dr))
{
Response.Write("customer add" + row2["ModifiedDate"].ToString());
}
}

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:

[Code]....

Line 31: Line 32: DataSet ds = new DataSet();Line 33: DataRelation dr = new DataRelation("show", ds.Tables["HumanResources.Employee"].Columns["EmployeeID"], ds.Tables["HumanResources.EmployeeAddress"].Columns["EmployeeID"],false);Line 34: //ds.Tables["HumanResources.Employee"].ParentRelations.Add(dr);Line 35: ds.Relations.Add(dr);
Source File: d:databaseDataset showing selected
field of 2 tables.aspx.cs Line: 33
Stack Trace:

[Code]....

[NullReferenceException: Object reference not set to an instance of an object.] dataset__with_two_tables.Page_Load(Object sender, EventArgs e) in d:databaseDataset showing selected field of 2 tables.aspx.cs:33 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

View 5 Replies

Web Forms :: Code-Behind Null Reference Exception Accessing Controls With Derived PageBase?

Feb 16, 2010

I have a class that derives from System.Web.UI.Page and have set my pages to derive from this custom page class instead of Page. At runtime, the controls are never initialized and throw a NullReferenceException. I've changed some class names and namespaces in the pasted code to protect the innocent. The only thing that I currently override in my PageBase is OnPreLoad and I do call the base.OnPreLoad. I'll eventually add more functionality to this PageBase but for now all that it has is this:

[Code]....

I've tried putting this into a class library (with System.Web referenced) and I've also tried moving the class into the web application and had the same results either way. As another strange twist, I have another class with derives from PageBase called IndexPageBase and it doesn't have this problem:

[Code]....

[Code]....

[Code]....

View 7 Replies

Forms Data Controls :: Null Reference Exception Was Not Handled By User?

Sep 2, 2010

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

View 2 Replies

C# - SmtpException Was Unhandled By User Code

Apr 6, 2010

smtpException was unhandled by user code

void sendMail()
{
MailMessage mail = new MailMessage();
mail.To.Add("abc@gmail.com");
mail.From = new MailAddress("abc@gmail.com", txt_name.Text);
mail.Subject = txt_subject.Text;
mail.Body = txt_body.Text;
SmtpClient smtp = new SmtpClient("smtp.gmail.com");
smtp.EnableSsl = true;
NetworkCredential yetki = new NetworkCredential("abc@gmail.com", "11111111");
smtp.Credentials = yetki;
smtp.Send(mail);
Response.Write("mailiniz baÅŸarılı bir ÅŸekilde gÃnderilmiÅŸtir");
}
protected void btn_gonder_Click(object sender, EventArgs e)
{
sendMail();
}

View 4 Replies

Web Forms :: ArgumentOutOfRangeException Was Unhandled By By User Code

Jun 21, 2010

Specified argement was out of range of valid values. Parameter name i: That was my error see the code below:

[Code]....

Was is causing the error and how do I fix it?

View 3 Replies

C# - System.Web.HttpException Was Unhandled By User Code?

Apr 4, 2011

I am getting the below exception when I run my ASP.NET/C#/SQL project on an XP box:

[code]...

View 2 Replies

Web Forms :: NullReference Exception Unhandled By User Code?

Mar 18, 2011

I'm working on having two forms that communicate together. In order to do this, I am passing public value from the source page. Here's how I did it:

In the source page I have:

Public ReadOnly Property CurrentCity() As String
Get
Return txtboxfake.Text
End Get
End Property
Then under page_load of the page I have:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
txtteam.Text = PreviousPage.CurrentCity
txtboxdate.Text = Calendar1.SelectedDate
End Sub

For some reason I keep getting an error that says "NullReference exception unhandled by user code" that points to txtteam.text = PreviousPage.CurrentCity.

View 13 Replies

System.Data.EntityException Was Unhandled By User Code

Jan 6, 2011

I am doing the MVC Music Store on VS 2010 and I get this expection: System.Data.EntityException was unhandled by user code Message=The underlying provider failed on Open.

Source=System.Data.Entity

StackTrace:

at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source).....

It happens at the Album ablum line above. I checked and SQLExpress is running with login to Local system.

Complete code for Controller is:

[Code]....

View 1 Replies

Forms Data Controls :: Gridview Update Not Working / Giving Null Object Reference Error?

Jan 14, 2010

I have a gridview,when i do it is giving me null object reference error.

I am posting my code for your reference -

[Code]....

My gridview code is -

[Code]....

View 8 Replies

Web Forms :: User Controls Are Null When Referenced Inside The Code Behind For The User Control?

Sep 1, 2010

I have an ASP.NET 4.0 application with some simple user controls. The user controls work fine on the design surface (VS.NET 2010), but when they're loaded during application execution, nothing shows up.

Futhermore, the various child controls of the user controls are null when referenced inside the code behind for the user control.

The code behind for the user control executes as expected, but any reference to child controls are null.

It's like ASP.NET is never parsing the ASCX to create the instances of the child controls.

View 4 Replies

Web Forms :: System.servicemodel.protocolexception Was Unhandled By User Code

Oct 11, 2010

i am using the page asynchronousTask to call the wcf service which is reside in another project in same solution for that i am using following code

protected void Button1_Click(object sender, EventArgs e)
{
PageAsyncTask pat = new PageAsyncTask(BeginDoWork, EndDoWork, null, null);
Page.RegisterAsyncTask(pat);
//Page.ExecuteRegisteredAsyncTasks();
}
IAsyncResult BeginDoWork(object sender, EventArgs e, AsyncCallback acb, object extraData)
{
nor = new ServiceReference1.Service2Client();
return nor.BeginDoWork(acb ,extraData );//first null value is any call back method
//return nor.BeginProductList(acb, extraData);
}
void EndDoWork(IAsyncResult ar)
{
nor.EndDoWork(ar);
}

but in the endDoWork method it will show the following error

system.servicemodel.protocolexception was unhandled by user code

View 1 Replies

Sqlexception Was Unhandled By User Code Using Sqlexpress 2005 And VS 2008

Jun 1, 2010

I did executed a db - contact form page successfully in the same project with the same connection string, but for this page its doing error and so I commented the binary file saving codes and all and put just simple 2 fields to see if the db is connecting and surprisingly getting sqlexception error and no data is written to the db. I am using sqlexpress 2005 and VS 2008. After this code I am listing the error I got.

Imports System.Data.SqlClient
Imports System.IO.FileInfo
Imports System.Data
Partial Class picture2
Inherits System.Web.UI.Page
Protected Sub upButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles upButton.Click
'' SOME CODES ARE HERE
Dim ctr As Integer = 0
Dim fleName As String
Dim fleLength As Integer
fleName = FileUpload1.FileName
fleLength = FileUpload1.PostedFile.ContentLength
Dim fleDatasource As New SqlDataSource
fleDatasource.ConnectionString = ConfigurationManager.ConnectionStrings("CandidatesConnectionString").ToString()
fleDatasource.InsertCommandType = SqlDataSourceCommandType.Text
fleDatasource.InsertCommand = "INSERT INTO Picture (picLength,picName) values (&picLength, &picName)"
fleDatasource.InsertParameters.Add("picLength", fleLength)
fleDatasource.InsertParameters.Add("picName", fleName)
fleDatasource.Insert()
----------------------- executed and now the prg returns to my code with the following sqlexception error box and while expanded I got this info ------------------------
message - Incorrect syntax near "&"
Line number 1
Errorcode -2146232060

in order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. fleDatasource.Insert() the prg stops in the code with the green highlight on the fleDatasource.Insert().

View 1 Replies

Security :: CryptographicException Was Unhandled By User Code - Key Not Valid For Use In Specified State

Mar 1, 2011

private
static
void ReadKey(SymmetricAlgorithm
algorithm)
{
byte[] converted =
Convert.FromBase64String(ConfigurationManager.AppSettings["Key"]);
byte[] bytes =
UnicodeEncoding.ASCII.GetBytes(("$@|T"));
algorithm.Key = ProtectedData
.Unprotect(
converted,
bytes,
DataProtectionScope.LocalMachine);
}

I am getting the following exception "Key not valid for use in specified state"

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved