I want to recongize that a nvarchar variable in stored procedure is null or not null.
and this example :
DECLARE @Count int;
SET @Count = (SELECT Count(Fld) FROM Tbl)
if there is no row how much whould be the value of @Count?????
zero or null?
how to check var variable is empty
View 3 RepliesCan i initialize var with null or some empty variable.
View 7 RepliesI have this code in a button click event:
[Code]....
When the page is first opened, Session("LeverancieFilterExpression")) is supposed to be blank or empty so the next statement should be executed but this is not happening. Can anyone explain why? I have the .IsNullOrEmpty method elsewhere in the program and it seems to work. Also, I have
[Code]....
in the page load.
How i do check whether DateTime data type variable is null/empty in asp.net ?
View 5 RepliesI'm evaluating two options of accessing a server side data on client side. Little bit confused about the efficiency or may be you can call it as finding best approach to do it.
I need to access a server side data may be an integer value in javascript on client side. I know about two options to do it.Create a public variable or property on server side and set it to javascript variable on client side as below:
var value = eval(<% =value %>);
Create a asp hidden variable and set value in this hidden variable from server side and access it through javascript using document.getElementById().
Which is the best approach and what are the pros and cons?
We recently migrated a web app from one Prod server (Prod 1) to another server (Prod 2). There is a session varialbe checked inside the page load event of the default master page. I have enabled session state both in web.config as well inside the pagedirective. The compilation went through without any issue. The web app is also running just fine on the server but the log file keeps logging a warning message. There is no run time error.
"System.Web.HttpException: Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration><system.web><httpModules> section in the application configuration."Any idea why this is happening on one server vs other?
I have a gridview with two bound fields. On clicking a button i want to display the values in first row of gridview in two textboxes. But if gridview cell is empty i am getting the text in textbox to which the value of cell is given as -' 'i know my problem will be solved if i use the template fields instead. But i want a solution while maintaining the bound fields ,if any.
View 2 RepliesI have a sql database that on some field will have a empty string/field. I am using a Datalist to display my results. How do I not make the labels that are empty not display? Currently if the field is empty it will leave a space there which my goal is if the field is empty do not leave a white space instead move the other colunms up.
View 2 RepliesI am working with a gridview that pulls data from a SQL database based on selections in dropdown lists. The source table has six columns for attributes of the selection, but depending on what is chosen, there could be anywhere from one to six of those that are empty (all null values). When the column is empty, I would like to have it hidden so the page is less clunky and confusing.
I've searched around for an answer for the past couple days, but what I have found so far is either related to hiding columns that you know are empty which I will not know or removing them in the SQL code which I think doesn't work if the column is called for in the gridview code and doesn't exist in the query.
i always got the empty string in form data posting. can you describe what the hell happened in my code? always got the empty string to insert to SQL server even it is drop down list selected value is empty. Is this the error in visual studio cause sometimes i can get the value and sometimes can't (inconsistent!!!)
Protected Function sqlparameter_insert_newscat() As SqlParameter()
Dim sqlparam(4) As SqlParameter
Dim ddlstatus As Boolean
If rbActive.Items(0).Selected = True Then
[code]...
When i insert empty datepicker value, database is inserting this value '1/1/1900 12:00:00
How can i stop that and insert null values to empty date pickers
i have done like this, but it didnt work
[code]....
I'm trying to delete some data in my database where no data is inside the field name and field id
select freelancer.id, freelancer.name FROM [bewerber].[dbo].[freelancer] WHERE freelancer.id = 'NUll' and freelancer.name = 'NUll' ORDER BY freelancer.vorname
but it seems to be wrong.
I'm kind of at my wits end here as it appears not many others have had this problem so it's possible that I'm missing something very simple but what is it?
I'm using SQL Express 2008 R2, Visual Web Devel Express 2010, .NET framework 4 and tell me whatever else you need to know.
I'm not being able to use add new item feature to insert an empty SQL database into my little project. It tells me connection to a .mdf file require SQL server to be installed and running on local computer. Well I can connect to server with management studio and connect to it inside VS. Database explorer will show me a database when I manually connect using tools>connect to database then data source = Microsoft SQL Server. It then shows up in database explorer. So why isn't the add new item feature working for me? What gives?
I've got stuck for this for a long time. I always got empty value for the posted data. Here is my code:
Protected Function sqlparameter_insert_newscat() As SqlParameter()
Dim sqlparam(4) As SqlParameter
Dim ddlstatus As Boolean
If rbActive.Items(0).Selected = True Then
ddlstatus = True
Else
ddlstatus = False
End If
sqlparam(0) = New SqlParameter("@username", SqlDbType.VarChar, 30, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, Session("user.id"))
sqlparam(1) = New SqlParameter("@news_category", SqlDbType.VarChar, 255, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, news_category.Text)
'Response.Write(HttpContext.Current.Request.Form(name))
sqlparam(2) = New SqlParameter("@news_category_desc", SqlDbType.Text, 1000000, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, HttpUtility.HtmlEncode(news_category_desc.InnerText))
sqlparam(3) = New SqlParameter("@news_category_status", SqlDbType.Bit, 1, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, ddlstatus)
sqlparam(4) = New SqlParameter("@news_category_parent", SqlDbType.BigInt, 100, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, ddlRoot.SelectedValue)
Return sqlparam
End Function
the news_category.text always the empty string even the dropdownlist selected value return empty string. Is this an error of bug in Visual Studio 2010? I 've got stuck for this for long time and i have been nearer to deadline. I just made change "ValidateRequest = False" to aspx file to permit html tag to be posted.
After deploying a ASP.NET WebForms application to a production server some of the ajax calls has stopped working for me. After some debugging I found out that the following statement (in the internal client-method WebForm_DoCallback) was causing the problem:
xmlRequest.open("POST", action, true);
The problem seemed to be that the action-variable was empty so after checking the rendered html I found out that the form-tag rendered on the production server looks like:
<form method="post" action="" id="Form1">
However, on my developer machine I get the following:
<form method="post" action="default.aspx" id="Form1">
So, why would the action-attibute render on my dev.machine but not on the production server? This seems to be the case only for one specific web form, when I look on other pages the action-attribute renders correctly.
I have a MyLinkButton : LinkButton.
In any event I override I don't have any attributes in my "base.Attributes or this.Attributes" collection. How's that possible? The rendered output clearly shows an id and an href attribute.
I'm trying to get rid of the href part and put in my own. Unfortunately Attributes.Remove("href") won't work.. because there's no such attribute. Or any attribute for that matter.
i want my query to return results where the field address is not empty or null
however, the query i have is still returning results where address is empty i.e. ' ' .
I have this code, how will I write the code so I can check if a textbox i empty? This way want work. Now it goes in if cellPhone != null all the time.
[Code]....
I'm using a custom ashx handler to handle a file upload. When run locally, the file uploads fine.When I use the same setup on the web server I get a "Index out of range" error.In firebug I see the binary contents of the file in the post data and the file name is also passed in the query string.Any one seen this before?I`m sure its something minor, but its driving me up the wall.
Request header:
Key Value
Request POST /Secured/UploadHandler.ashx? HTTP/1.1
Accept text/html, application/xhtml+xml, */*
Referer http://cms.webstreet.co.il/Secured/fileUpload.aspx
Accept-Language he-IL
User-Agent Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)
Content-Type multipart/form-data; boundary=---------------------------7db13b13d1b12
Accept-Encoding gzip, deflate
[code]...
In reference to this question that I just asked, [URL] it appears that for some reason, an empty text box's value is not being fed to SQL Server as NULL, as it ought to be.
View 6 RepliesI have an ASP .Net TreeView control that I am dynamically adding tree nodes to from my codebehind on Page_PreRender. The TreeView is populated nicely and the appropriate checkboxes are where they are expected to be. For each of these nodes the SelectAction=TreeNodeSelectAction.None. However, when accessing the TreeView CheckedNodes() collection in my codebehind after selecting a few nodes (checkboxes are selected) and clicking a submit button to post back to the server in the button click event, my CheckedNodes.count() = 0. I can not figure out why my CheckedNodes collection in the codebehind does not contain the nodes that I have checked from the GUI.
View 8 RepliesIf SubTotal is more than 500 I want @freightPrice to be 0. How can I do that?
[Code]....
I want to use a local sql variable in XQuery.
Following is my table structure with columns and data type.
Orders
ID
Uniqueidentifier
UserID
Uniqueidentifier
OrderDetail
XML
OrderDate
DateTime
OrderDetail column contains XML in the following form.
<Books>
<Book BookID="033ba62a-3bbe-48cc-ad15-c3f28ff86306" Title="XYZ" Price="120" />
<Book BookID="805BC2BE-A91E-4E0E-A99E-C290D2EEEFF6" Title="XYZ" Price="120" />
</Books>
I want to select Orders (rows) which have BookID = "033ba62a-3bbe-48cc-ad15-c3f28ff86306". I am able to achive it through the following query.
Select * From Orders Where OrderDetail.exist('//Book[@BookID = "033ba62a-3bbe-48cc-ad15-c3f28ff86306"]') = 1
Now the issue is I want to use an sql local variable (@BookID) instead of the hardcoded BookID.
So How I can use a sql variable in a XQuery.
I need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)