I got the following error when i tried to insert a new record after the run my project, so what does this error indicates?
"{"Cannot insert explicit value for identity column in table 'Articles' when IDENTITY_INSERT is set to OFF."} System.Exception {System.Data.SqlClient.SqlException}
"
When i click on the page that represents a controller the following error was displayed:-
"The null value cannot be assigned to a member with type System.Int32 which is a non-nullable value type"
On this link of code
var articleapproval = articletyperepository.FindAllArticlesRequireMyApproval().ToList();
while the FindAllArticlesRequireMyApproval execute the following LINQ statement :-
var articleapproval= articletyperepository.FindAllArticlesRequireMyApproval().ToList();
where this methods calls the following LINQ statement:-
My code:
[Code]....
If the value is null writes out that error.How to check if the value is null? And if the value is null, I want to store + 1
I am getting an exception on a linq to sql query:The null value cannot be assigned to a member with type System.DateTime which is a non-nullable value type.
[Code]...
I am making a website to store invoices so i can mail them to clients. So i got a table for clients, invoices and one with invoice products/services. When an invoice has no products/services added to them and it returns null i get the error "the null value cannot be assigned to a member with type System.Decimal which is a non-nullable value type."
I just started with linq. Before i always used mysql. Mostly i just had to call data from 1 table so forgive me if my linq query isn't really correct.
Dim invoices = From i In db.invoices _
Group Join p In db.products On i.id Equals p.invoiceId Into invoiceProducts = Group _
Select New With {i.client.naam, i.titel, (From iP In invoiceProducts Select iP.prijs).Sum}
i show the client's name, the title of the invoice and the total amount the clients will need to pay for products and services.
I am writing unit tests for fluent Nhibernate, when I run the test in isloation it passes, but when I run multiple tests. or run the test more than once it starts failing with the message below System.ApplicationException : For property 'Id' expected '1' of type 'System.Int32' but got '2' of type 'System.Int32'
[TextFixture]
public void Can_Correctly_Map_Entity()
{
new PersistenceSpecification<UserProfile>(Session)
.CheckProperty(c => c.Id, 1)
.CheckProperty(c => c.UserName, "user")
.CheckProperty(c => c.Address1, "Address1")
.CheckProperty(c => c.Address2, "Address2")
}
I am LINQ querrying against a datatable. However, I am unsuccessfull with catching null values. Here is my code that is giving me the following error.
[Code]....
I am checking to see if minperc is null. However to check that it still is trying to convert the value to double. Cant figure out a way around it. Here is the error: Cannot cast DBNull.Value to type 'System.Double'. Please use a nullable type.
I have a website I developed in VS 2008 targeting .net 3.5. It has worked well. I recently upgraded to VS 2010 and needed to make a few changes to the site. However, I'm receiving compile errors (haven't made any changes to the code yet--was just launching the site to make sure it worked ok). I get "Contains" is not a member of system.array. Everything I've read states that the contains method was added in .net 3.5, which I know to be correct because it was working in VS 2008. I've been targeting .net 3.5 in VS 2010, but it still isn't working. I also used linq quite a bit with linqkit to do dynamic queries and all of my linq queries were saying my queries weren't queryable (I don't have the actual error in front of me). Anyway, to fix that one, I had to import system.linq (I previously had system.data.linq and it was working fine). To reiterate, I haven't targeted my site to .net 4 in VS 2010, I've left it targeting .net 3.5.
I tried converting my arrays to arraylists since arraylists were still pulling up with a .contains method, but then it broke my linqkit queries when I ran it on the site.
Here is my linqkit query:
Dim str() As String = archlist.ToArray(GetType(String))
Dim str3 As New ArrayList
str3 = ArrayList.Adapter(str)
predicate = predicate.And(Function(l As CompatTesting) str3.Contains(l.application.cpuarchitecture))
Before, I didn't have the arraylist conversion, I just had str.contains and it worked great to generate a sql "in" statement. Now after using the code above, the site launches, but when I actually run the code, I get Method 'Boolean Contains(System.Object)' has no supported translation to SQL. I also tried upgrading my linqkit dll to the latest version but it didn't help.
My questions are, since I'm targeting the same .net 3.5 framework in 2010, why is it not allowing me to use array.contains anymore? Maybe if I can address that issue, it will fix my linqkit issue where it says "contains" has no supported translation to sql.
I keep getting this error
'IgnoreRoute' is not a member of 'System.Web.Routing.RouteCollection'.
even though I have included the required namespace
system.web.mvc
system.web.routing
I have following model class:
public class WebModel
{
public List<ArticleModel> Articles { get; set; }
}
public class ArticleModel
{
public int ID { get; set; }
public double ValueParam { get; set; }
}
Then I have the controller with the two actions:
[Authorize]
public ActionResult Index()
{
WebModel model = new WebModel();
ModelConverter.ConvertToModel(model, controller);
return View(model);
}
[Authorize]
[HttpPost]
[ValidateInput(false)]
public ActionResult Index(WebModel model, string saveButton)
{
ModelValidation.ValidateWebModel(model, ModelState);
if (ModelState.IsValid)
{
return RedirectToAction("Create", "Article");
}
ModelConverter.ConvertToModel(model, controller);
return View(model);
}
And this is my view:
<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage<Web.Models.WebModel>" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
<%var controller = Session["controller"] as Web.Code.SessionController; %>
<%Html.BeginForm(); %>
<div>
<table width="100%">
<%foreach (var article in Model.Articles)
{%>
<tr style="text-align: right">
<td>
<%:Html.DropDownListFor(m=>m.Articles.FirstOrDefault(f=>f.ID == article.ID).ID, new SelectList(controller.CurrentProdukt.Articles.AsEnumerable(), "ID", "Name", article.ID)) %>
</td>
<td>
<%:Html.TextBoxFor(m => m.Articles.FirstOrDefault(f => f.ID == article.ID).ValueParam)%>
</td>
</tr>
<%} %>
</table>
</div>
<table style="width: 100%">
<tr>
<td>
<input type="submit" name="saveButton" value="Save" />
</td>
</tr>
</table>
<%Html.EndForm(); %>
</asp:Content>
If I press the submit button, I get to the second action method in the controller (the one with the HttpPost attribute). In this action, the object model itself is not null, but the "Articles" list inside is null.
I have an EntityDataSource for a listview control. Based on the value of a query string, I want to be able to filter the data by the first letter of the last name. So what I need is something like this:
EntityDataSource1.Where = "it.LastName.StartsWith('A')"
but I'm getting an error: 'StartsWith' is not a member of type 'Edm.string' in the currently loaded schemes.
Code:
txtID = CType(GridView1.Rows(e.RowIndex).FindControl("TextBox1"), TextBox)
txtName = CType(GridView1.Rows(e.RowIndex).FindControl("TextBox4"), TextBox)
now i converted it into c# using the converter and i get this:
Code:
txtID = (TextBox)GridView1.Rows(e.RowIndex).FindControl("TextBox1");
txtName = (TextBox)GridView1.Rows(e.RowIndex).FindControl("TextBox4");
but i am getting this error:
Non-invocable member 'System.Web.UI.WebControls.GridView.Rows' cannot be used like a method
i work with visual studio 2005 and asp net 2.0. i have a method method as this :
[Code]....
this problem is follow if i run the web method and don't enter a string and a int a receive this message : System.ArgumentException: Cannot convert to System.Int32. ok when i arrive in the method i can check if lists is empty but how i can do if int is NULL because i don't want to returns a error if people run my web method and don't enter the parameters.
i am using this code for send data to view
[Code]....
Controller e 'System.Collections.Generic.IEnumerable [Code]....
by this code i am render view
[Code]....
after run the application i got this error
Unable to cast object of type 'System.String' to type 'System.Collections.Generic.IEnumerable`1[BentaAccounting.Models.Repository.AllData]'.
I seem to be having issues with posting forms with DropDownLists. I've looked all over the net and tried various solutions, but none seem to work for me.
I'm getting the following error: The parameter conversion from type 'System.String' to type 'Models.Organization' failed because no type converter can convert between these types.
Here's my ViewModel:
[Code]....
Here's my controller:
[Code]....
The objects are generated by ADO.NET Entity Framework. Organizations is its own object, but also a property of Profile (each user belongs to one organization). Now I understand what the error message is saying, just not sure how else I'm supposed to do this.
i have installed ajaxtoolkit 3.5 but when i debug i am getting this error Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' even i have changed my tags to
<asp:ToolkitScriptManager
ID="ToolkitScriptManager1"
EnablePartialRendering="true"
runat="server"></asp:ToolkitScriptManager>
I am binding SQL data to a GridView. The GridView's DataKeyNames property is set to the SQL column called "utID"
I know that within the SQL results, some of the utID values are NULL. After databinding to the GridView, I need to enumerate through the GridViewRows an read the DataKey values. However, when I try this I get the following error:
No default member found for type 'DBNull'. I am using the code below.
What object types are stored within DataKeys (I thought it was just integers or strings)
How to handle a NULL datakey value to prevent this error occurring?
I don't want to use Try Catch because it's too much of a 'hack'
[Code]....
I am declaring a list in my class, populating the list in page load and using the list in various methods in this class. But, I get this error at every instance where I use this list in the methods. Error: System.NullReferenceException: Object reference not set to an instance of an object.
public partial class ViewBG1 : HealthServicePage
Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.TextBox'.
[code]....
I want to do paging the API Membership without using the datacontrols, but I get this error "Unable to cast object of type '<TakeIterator>d__3a`1[System.Char]' to type 'System.Collections.IList'." when I do this,
[code]....
Basically, what I did is that: I have a table in SQL database and some of data fields allow null. I built Objectdatasource through dataset. When I built update page using dataset. It generate the following error before showing the update page correctly. It seems I have issue to retrieve the null value from the database through using objectdatasource through dataset. Any suggestions?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
View 6 RepliesI have defined an ODBC Command and ODBCdatareader as follows
OdbcConnection myConnection = new OdbcConnection(connectionString);
OdbcCommand myCommand = new OdbcCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = "select UOPGM from GREG.TUSROPTF";
OdbcDataReader myReader;
myConnection.Open();
myReader = myCommand.ExecuteReader();
When I try to retreive from the reader as follows:
while (myReader.Read())
{
string someString = myReader["UOPGM"];
lstNames.Items.Add(someString);
}
I get the following error
Error reading the database. Unable to cast object of type 'System.Byte[]' to type 'System.String'."
I have also tried string someString = (string)myReader["UOPGM"]; to no avail
I am trying to write a table output from SQL database to a gridview/ Data List through an Object Data Source. I am a new starter and your help will be useful.
public List<Staff> GetStaff()
cmd.CommandType =
SqlConnection con =
new
SqlConnection(connectionstring);SqlCommand cmd =
new
[code]...
I am trying to upload a picture into database using FormView insertItemTemplate. FormView is bounded by objectdatasource.To upload, I placed FileUpload control inside insertItemTemplate.In table the dataType is image.Error:Object of type 'System.Boolean' cannot be converted to type 'System.Byte[]'.
View 3 Replies[Code]....
Above is my code. The error I'm get is, Unable to cast object of type 'System.DateTime' to type 'System.String'.
The column "To" and column "Subject" are strings and column "Receive" is DateTime. I can't made any changes in the database, so I need to write some code to handle casting a string to datetime or if statement as a work around.