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
Using a class component, an Object data source and a formview I am successfully pulliing data from a SQL database. In some cases the rows contain one or more Null values and I would like them to be ignored completely. My simple code follows:-
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?
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 have developed simple user registeration application form in that after press submit button i am sending mail to user for welcome template as well as i am also get on mail for user details like name email id, and ip address.my problem is the user can receive the mail form my site but i am receive the any user details mail it doesnot shows any exception what is the problem i donno please
I have SqlDataSource with a few parameters (code below). If I understand this code correctly if parameter is NULL I should receive all items from the query. It works fine with query editor. But when I try to use this query on my page - with DropDownList and Textbox controls as source of parameters - it doesn't work. I suspect that main reason of problem is value which these controls pass to the query. Instead of NULL this is an empty string. Is it possible to pass NULL value from DropDownList or TextBox to the SqlDataSource?
I was develop an application (ASP.Net) Using (VS.Net C# 2010 & SQL Server 2008)
And I was applying (3-tyer Basics) and I'm not using wizard forever in my application.
The problem is :
When I try to passing the parameters to database, some fields I don't type it But it's show in database (Empty like "Space") in text fields and (01-01-1900) in date fields
Although it's must be (Null) .
How I can pass parameters with Null Values for the fields that's not typed?
I need to know basically what are the use cases will comes for any applicatoin or project.I have project which is done in asp.net mvc control.. My requirement is to wriet the use cases for the entire asp.net mvc application..can any body tell me from where I need to start?and what are the differnt use cases will exists?
The user can provide a group of strings for a propert. ex:
DaysNeeded ="Sunday,Tuesday,Friday,Saturday";
In the actual UI, the days of the week are available as check boxes. I'm trying to provide a way so that the user can also set the days needed in the code behind through a property.
Now my query is, which strategy is the best way to execute certain pieces of code that are respective to the days that the user have provided. Meaning, the DaysNeeded property has sunday,Tuesday, Friday and Saturday. Each day has certain piece of code to be executed. If i have to have a forloop with a switch case for each day of the week, i feel it would cost more as i have to run the for loop, the number of days the user has given.
Is there a way that i can run a single code that matches all the set of days the user has given and run the respective code pieces?
I'm using a pager and want to include a query string in some cases, like search to have a search parameter in the query string. Everything works fine with the pager. So, I tried the following line of code in my controller action for including search:
I have a problem that if I pass a string that contain + in a query string and try to read it , it get the same string but by replacing + with empty charFor example if i pass query like ../Page.aspx?data=sdf1+sdf then in page load I read data by data = Request.QueryString["data"] it will get as below data ="sdf1 sdf" I solve the problem by replacing any empty char with + .. But Is there any problem that cause that ? and Is my solution by replacing empty char with + is the best solution in all cases?
I'm working on the MVC app where I've to generate the report in the form of HTML page. If the user click the print icon, I've to show the HTML page to user. If the user click on email icon, I've to send email with same HTML page attachment. I'm trying to find a way where I can use the same code to generate the HTML in both cases of email and print.
Have been stuck with this issue for a few days now, and really need, and would appreciate some help. My requirement is that I want to make a server side callback to clear off some objects when the user navigates away from our page, without clicking logout. For business reasons, our ASP.NET session timeout has to be set to a very high value. Further, I do not want to popup a alert/dialog to force the user to return to the page and click Logoff.The solution I have arrived at thus far is to make a AJAX callback by embedding this javascript in the page.
window.onunload = pageleave; function pageleave() { alert('test');
I have two different functions which are used to generate two different report on one gridview. In otherwords, in my design, I have a calendar event which is used to generate a report on the gridview and I have a dropdownlist which is used to generate a different report on the same gridview, so depending on the control that is clicked on depends on the report being generated. Now I would like a situation where my gridview rowdatabound is only applied to the dropdownlist report not the calendar event report. How can i go about doing so.