here is my code for selectiong some records from db table
string strSql = "select * from mtblNBD where SentTo=@SentTo and InternalStatus Is NULL order by DeadLine desc"; SqlCommand com = new SqlCommand(strSql, con); com.Parameters.Add("@SentTo", SqlDbType.NVarChar, 50).Value = (string)Session["uname"];
here I am using parameters for SenTo field but not for NULL so it is ok... or should I use parameters for this field where value is NULL , if yes then how can I use parameter for this
I have several models that implement a array property using null object pattern in the following manner:
[Code]....
The problem is that any time I attempt to bind to a property of this type the DefaultModelBinder.CollectionHelpers.ReplaceCollectionImpl method wants to call ICollection<T>.Clear() and then ICollection<T>.Add() on the zero length array.
The real issue seems to be in DefaultModelBinder.BindComplexModel() method however. The method contains an explicit check for arrays and special handling to account for the fact that they don't support clear/add functionality. The problem is that the check stipulates that the array model must also be null. If it is non-null, normal ICollection<T> handling ensues which presumes support for clear and add. Can any one explain why the null check is there? It seems to me that either 1) the null check should be removed to permit replacement based binding to non-null arrays or 2) an explicit error stating that non-null arrays are not supported should be thrown.
I vote for the former. I can understand that in general, replacing an existing model with a refrence to a different model would be considered a bad thing. The calling code would not expect this in general and it could lead to hard to find bugs. However, in the case of arrays, if the calling code expects the array property to be modified at all, then I think the normal expectation would be that such modification would occur via replacement of the array.
I am developing a website that display products and the users will be able to rate these products. At the end of the month a winner product will be highlighted on the website home page. What I need to know is how to determine the winner product if I have the following rating scenario, The user will rate for the product by choosing a value from 1 to 5 where 1 mean bad and 5 excellent.
If 10 users voted for the product A and the average rating was 4 and 1 user voted for product B and the average rating were 5 that mean product B will be the winner. I feel this is not the correct method to determine the winner. one has better method that take in consideration the number of voted users to determine the winner?
i want when user click in this item on jquery menu in Furniture.aspx will show all product in this item H_name is'nt important i want show all product with different H_name
I'd Like to be able to have my web service accept multiple POST parameters, some of which will be XML. Is this possible? The code below will generate a server error:
I am trying to go to a view with a speicifed batchId parameter wrapped in a ViewModel, pick a file to upload, get the uploaded file back and store the file data w/ the associated BatchId value in a database.When the form is submitted I don't know how to get back the viewmodel and the PostedFileBase so that I can get the BatchId value.I need the batchId value to associate it with the data I am storing in the database.I have the following Action Method in my Controller to allow adding new customers to the specified batch by means of a file upload and import:
public ActionResult AddCustomers(int batchId) { var viewModel = new AddCustomersViewModel() { BatchId = batchId, //other view
is possible to send an AJAX post with parameters and not querystring information? I have some sensitive information that I am not comfortable sending in a querystring.
Also, how does that change the deserialization of my data? Will I still be able to use code similar to below:
I get an exception when deleting a row that says "Value cannot be null. Parameter Name: Original_ProductName" When I check the locals window the value is null. The ProductID has a value, but all of the other fields that are prefaced with the "original_" are null. I don't see what the issue is. I checked the bll and the gridview itself and they seem to have the necessary things. I didn't post all of the gridview and objectdatasource for brevity.
the exception listed the Original_ProductName in caps. In the code it is listed as "original_productName". This seems to be done consistently throughout so I don't think it is a capitalization issue.
i have a stored procedure to update a table. not all fields are required and some can be blank.for example, title is not required, but when it's blank i get an error
Dim ptitle As New SqlParameter("@title", SqlDbType.NVarChar, 20) ptitle.Value = objFormat.CheckSQL(title) myCommand.Parameters.Add(ptitle) ex {"Procedure or Function 'sp_UpdateUser' expects parameter '@title', which was not supplied."} System.Exception
how can i fix it so that it allows for nulls if the data field is blank?
After upgrading our project to the .net 4.0 framework (from 3.5), we facing some problems with ajax calls with html in the parameters. As soon as the user enters some html in a text area the ajax call isn't executed anymore. If the user enters plain text only, there is no problem.
I want to parse and page that takes POST parameters. like this is my scenario. i have to parse some search results. but the search parameter are sent in post body to that page. To parse the search result i have to send parameters to that page in POST. how i can do that with agility pack ?
I have a new webpage "smile.aspx" with the web method "GetDate" that returns "current date as string".
I am using JQuery to make a Ajax call to that method, Right now i am using ASP.NET Version 2.0[.NET Framework 2.0,Visual Studio 2005].
The parameter returned by the Sucess function seem to return "undefined" .anyone Techhy, quick look at the ajax request code below will answer my problem.
In my Asp.net MVC app, I have two methods on a controller, one for when the user first arrives on the view and then one when they submit the form on said view.
public ActionResult Foo() {} [AcceptVerbs(HttpVerbs.Post)] public ActionResult Foo(string id, Account accountToFoo) {}
In the second action, there's a custom model binder that's assembling the account object that I'm acting on, though that's really not important. This all works fine in testing locally on a server.We try to be pretty good about writing unit tests to test all our different views are properly getting routed to, including those that are HTTP POST. To do so, we've been using mvccontrib's test helper.
My question is in testing POST routes, how do I write the lambda that I would use to verify the post is receiving accurate values, similar to the GET test above?
It's the something_something portion of my lambda that I'm having trouble with. Using arbitrary values doesn't work ("a => a.Foo(0, new Account()"). How would I specify the expected values as part of the test?EDIT I was hoping there was something akin to the way Moq has lambdas for statements such as foo.Setup(s => s.Foo(It.IsAny(), It.Is(i => i > 32)) and so on. Even I have to explicitly supply the values, that's workable--I just can't seem to grok the desired structure to pass those explicit values.
I have a "one page application" (ASP.NET 3.5, VS 2008, IE7) that uses Default.aspx as it's page, and holds an iFrame within "floating panel" (asp:Panel with extenders).
As the desired behavior is to allow users to reopen the application by refreshing the page,
I added this to the Default.aspx.cs: protected override void OnPreInit(EventArgs e) { if (!IsCallback && !IsPostBack) { Session.RemoveAll(); GeoApplication.DAL pDAL = new GeoApplication.DAL(); Session["DALinstance"] = pDAL; } }
However, when the iFrame page lifecycle starts, the Session["DALinstance"] parameter is null. I've tried to put some additional parameters and those were null as well.
I have a FormView which is bound to an SQLDataSource. When a user clicks on a save button the form, I need to write any changes made to the FormView back to the table.
I have a Stored Procedure on my MSSQL 2005 database that should be executed when the user clicks on the save button.
It appears the Update is firing, but when I trap the DbCommand object in the SQLDataSource's 'Updating' event, all of the parameters that should be passed to the Stored Procedure are coming through as NULLs. Consequently, the Stored Procedure isn't updating anything.
In the click event of the save button I'm explicitly firing the SQLDataSource's Update method:
[Code]....
The parameters in the SQLDataSource <UpdateParameters></UpdateParameters> section appear to be correct.
Can anyone give me an idea on what to investigate to figure out why it appears the Update is only picking up NULLs?
I am using an EntityDataSource with a FormView on VB.NET application. The FormView contains an AjaxControlToolKit TabContains with multiple tabs. Due to the fact that each tab is a naming container, Bind doesn't work properly for updating values (as discovered from reading other posts on stackoverflow). I instead have to declare UpdateParameters on my EntityDataSource. Example markup is as follows:
This works great, until a customer is edited and their name is set to nothing (assuming in this case, a null name is allowed). The Name UpdateParameter is set to Null but the ObjectStateEntry is not set to modified for Null properties, even if previously the Entity had a value specified. As long as the name is changed to something other than Null, everything is updated correctly.
I found a workaround by putting the following code in the Updating event of the EntityDataSource.
Dim ose As ObjectStateEntry = context.ObjectStateManager.GetObjectStateEntry(action) For Each p As Parameter In eds.UpdateParameters ose.SetModifiedProperty(p.Name) Next
This makes sure that each property in the UpdateParameters has its state set to modified. It works, but it seems like a hack and I can see it causing problems down the road. Is there anything else I could do?
I am attempting to call a RESTful service using an HttpWebRequest object via POST. I am attempting to pass 1 variable with the Request body which contains a url encoded string. I see the request when it hits the server; however, it shows 2 form variables. The first is Form[null] and the second is my variable.I am attempting to locate the source of this NULL key; however, I cannot. Any ideas on how I may be able to remedy this since it's throwing issues when I attempt to use it with the Nancy web framework for .Net.
Code:
var request = WebRequest.Create("http://localhost:8888/RouteName") as HttpWebRequest; request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded";[code]...
I am having a problem where when I form post to an action it gets null values in my hosted enviroment although if I use a model to bind to it works fine. Everything posts and works correctly when I run the project.
So far I have tried to pass the form fields back as parameters on the action and get the value through the context request. Both work fine but as soon as I publish it to the hosted enviroment, it doesn't work. in the view I have:
<%=Html.TextBox("subject") %>
<%=Html.TextBox("comment") %>
for the action Method:
[HttpPost]
[Authorize]
public ActionResult Reply(int? id, string subject, string comment)
{
//Some code...
}
I have verified that it is hitting the action but the subject and comment values are null. I am guessing I am missing something simple, maybe a security setting in the config, that is causing this since I am still fairly new with MVC. I am running VS 2008 with MVC2.