I have the following code. My program was hanging up. What I discovered that if street was null then the Trim() was not generating an error but the program would just hang.How could I test a record's street field to see if it is null? Is that the .HasValue property?
[Code]....
on VWD 2005 this code works fine, but on 2008 it says I haven't created an instance of the object. I want to convert the object connString (a connection string) into a string.
'This acceses the virtual directory web.config file for connection strings
'We have to convert the object to a connection string
Dim rootWebConfig As System.Configuration.Configuration
rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/VirtualDirec")
Dim connString
As System.Configuration.ConnectionStringSettings
connString = rootWebConfig.ConnectionStrings.ConnectionStrings("ConnectString1")
Dim strConnString
As
String = connString.ToString().......
I am using Query String in application.
I want to make Query string null when use F5 from Key board.
I'm using webservice to integrate asp.net app with PeopleSoft. Sometimes, the value that I get from a querystring (eg in url below, request id =7) and pass it to PeopleSoft via webservice is blank, although the querystring contains key value pair. This causes the webservice integration piece to fail. What can cause this issue where the querystring value is blank? and how can I fix it?
[URL]
I have been facing a problam with replace null datetime Field with String.
Like
My DB filed entrydate not mendetory DateTime is dataType.
Its return Entry date or Null.
When designing Crystal report Enrry date display but when it return null its simply display blankspace.
I want like
Enrry date
-----------
07-03-2011
Unavl
12-03-2011
13-03-2011
I'm having some problems with the interface I've created. After some searching, I've discovered that it is inserting an empty string into my database fields as opposed to an null value. I need my application to insert null values, not emptry strings. Can someone provide an example of how this is done?
View 2 RepliesPassing onto a stored procedure a value from a GridView. The particular fields are a date type, and numeric type. Problem is, its plausible and conceivable in this case one or both could be null or empty.
Through searching I've seen suggested such ideas as Convert.ToDate(value), CDate(value), and so on.
None of these work. You cannot convert an empty string or null value to a date. I don't know about the numeric value.
So, barring any non-working examples already given. What is standard. Its not like I've stumbled across some never afore seen problem.
Here is my code, but its quite typical.
Dim txtctlHireDate As TextBox = CType(gvEvaluatees.Rows(e.RowIndex).FindControl("txtHireDate"), TextBox)
Dim txtctlGradYear As TextBox = CType(gvEvaluatees.Rows(e.RowIndex).FindControl("txtGradYear"), TextBox)
Dim txtctlBU As TextBox = CType(gvEvaluatees.Rows(e.RowIndex).FindControl("txtBU"), TextBox)
Dim ddlctlEvalGroups As DropDownList = CType(gvEvaluatees.Rows(e.RowIndex).FindControl("ddlEvalGroupSelection"), DropDownList)
Dim chkctlActive As CheckBox = CType(gvEvaluatees.Rows(e.RowIndex).FindControl("chkActive"), CheckBox)
UpdateEvaluatees.MGEvalUpdateEvaluatee(gvEvaluatees.DataKeys(0).Value, txtctlHireDate.Text,
txtctlGradYear.Text, txtctlBU.Text,ddlctlEvalGroups.SelectedValue, chkctlActive.Checked)
gvEvaluatees.EditIndex = -1
gvEvaluatees.DataSource = EvaluateesForDataGrid.GetData
gvEvaluatees.DataBind()
I've bolded the parameters in question. A date value and numeric value are expected.
I am using IIS 7 and have URL rewrite turned on for a friendly URL.
The problem is that in side that pages repeater (right under the captcha) when I click on the images in there the page redirects to /null/ which then throws a 404 error. I have turned off url rewrite and removed all rules and that didnt solve the problem so I dont think its related to that.
I have also noticed that in my master page if I use <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
then the client side ajax fails to load, sys becomes undefined and that may be the problem here
I'm at a loss, this is the first time I have seen these problems occur.
How to Convert empty string to Null value - Insert into a DB
[Code]....
[Code]....
I have pass following SQL Query to the through ObjectDataSource
[Code]....
And I am passing parameter through QueryString and My idea is like when empty string is pass it should show me all records but when I am passing empty string ObjectDataSource is making NULL and I am not getting desire result
For coonverting Linq to DataTable I am using the following Extension Method(Taken from Stackoverflow)
L[code]....
The Extension Method creates XML file.But for null values no element is created in XML file.Say if Commission field is null then commission element is missing in Xml generation.
I want to insert element with empty string for null values (ref type) and (0.00) for decimals and (0) for integers. where do i need to make change?
developing a photogallery using datalist and custom numeric pagination.
I have assigned the CurrentPage Index of the PagedDataSource object by requesting "pid" value from QueryString .
On the pageload i hit the database once and store the filenames in ViewState but..
But the ViewState becomes null when the page is posted back with new query string value.
We have an ASP.NET web service that invokes a stored procedure on our DB (Oracle 11g). The problem is that the call to the procedure blows up every time an empty string is passed as one of the parameters. We're seeing an ORA-01084 error, which indicates to me that call is failing before the procedure is actually run.
Here's the procedure, minus some logic that I believe is not relevant:
[Code]....
As an experiment, I modified the web service to pass null rather than an empty strings. When null is passed in, I see an error indicating "wrong number or types of arguments in call to 'CREATEREPORT."
I also tried passing DBNull.Value whenever the params were null/empty, but that resulted in the error
Parameter 'p_column_id': No size set for variable length data type: String.
(Of course, p_column_id was the empty parameter in this case).
So, how can I successfully pass empty strings as parameters to my stored procedure? We definitely want to allow the p_column_id parameter to be empty.
Sql constraint to convert empty string to null
View 7 RepliesIf I have JSON like this and pass it to the engine I am using to create a PDF file, the word "null" appears on the PDF. This isn't really my example, but I googled "json replace null empty string" and this was a hit, which is a good representation of my data, also:
{
"relationship": {
"type": "relationship",
"id": null,
"followed_id": null
}
}
We use a rendering engine that creates a PDF from a fixed template and variable data in the form of a json string. But our customers don't want to read that the id is "null", they want to read that the id is blank. In my C# program, the json is just a string, so I can easily do something like this:
jsonString = jsonString.Replace("null,", ",");but the issue is I can't replace null-comma with a comma, because then it's invalid json.
how to I make the rendering engine *and* my customer both happy?
[URL] .....
I have an error with this tutorial.
Line 13:
Line 14: Private Sub BindGrid()
Line 15: Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Line 16: Using con As New SqlConnection(constr)
Line 17: Using cmd As New SqlCommand("Customers_CRUD")
Imports System.Data
Imports System.Configuration
Imports System.Data.SqlClient
Public Class tessatusatu
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code] ......
I have drop dowm menu as follow.
<asp:ListItem Value="">none</asp:ListItem>
<asp:ListItem Value="STO">Stock</asp:ListItem>
<asp:ListItem Value="ORD">Order</asp:ListItem>
If I chose none, it stores data as "Null" If I Query the data as below, I don't get the data has value of "Null" SELECT tabale From type Where type <> STO or type <> ORD I get data that has empty string but not Null.
1, How do I write dropdown menu value in oder to get empty string instead of Null?
I did <asp:ListItem Value="">none</asp:ListItem> but this stores Null.
2, Why this Query won't pick up Null?
SELECT mytabale FROM type WHERE type <> STO or type <> ORD
got a wired problem (well I find it a wired problem :P)
I have an order page done in asp.net c#, and which a user adds ingredients to a set of list boxes, once the user and finished adding items, they get combined to make a sandwich then added to another list box that shows the sandwiches and their ingredients. I also have a button to allow the user to remove the ighlighted sandwich from the order, this all works fine until the page loads up with a query string that skips the adding of ingredients and just shows the sandwiches on a order, the listbox of sandwiches populates fine but I then get an error when the remove button is clicked which is
[Code]
How to allow null value on my program?
for below statement, "WARNING_TYPE" IS NULL..
but when I run, it promp me error..what are the correct statement should i write. tq all
l_Connection.ConnectionString = constr
l_Command.Connection = l_Connection
l_Command.CommandType = CommandType.Text
l_Command.CommandText = " SELECT UNP.EMPLOYEE_ID, UNP.UNPAID_DAYS, ABST.ABSENT_DAYS, WARN.WARNING_TYPE " +
[code].....
I am very new to ASP .NET and am getting above error when trying to insert a new record into a SQL database. I have turned on Option Explicit On so the default date of 01/01/1900 does not get assigned to this field automatically. Since most of the people in the database will not have a date of death, I need to have "blank" deathDate. When I run the stored procedure within SQL and choose pass null value, the Insert Procedure works fine. When I attach to Web Form, however, I get String was not recognized as a valid DateTime error. How can I set it so Null values are accepted into this date field.
View 1 RepliesI have setup my business object to have a create_date and edit_date members both datetime datatypes. My company want to display the create_date and edit_date fields in a gridview for each transaction. The problem i have is that after insterting a record it will have a valid create_date but no edit_date and when displayed in the gridview it defaults to datetime.minvalue (My default). How on earth do i show an empty field in my gridview for a null datetime field in the database?
I am using similar architecture to the Imar Spaanjaars example of a tiered solution. With a few small tweeks it has worked well for me for ages. I am passing a List<Database> to my object datasource which connects to my gridview.
I have 2 table Table A, Table B.
Table A - Parent Table
ID - Uniqueidentifier not null(PK)
Table B -Child Table
ID - uniqueidentifier null(FK, TableA)
I have a stored procedure to insert data into Table B, but when I tried to insert a null value into column ID of table B, this error came up:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tableB_tableA". The conflict occurred in database "database name", table "table A", column 'ID'.
The statement has been terminated.
The insert statement in asp.net is like so:
sqlcommand.parameter.add(New Sqlparameter("ID", Nothing))
I am guessing adding nothing to the null value column is the problem, but i don't know how to fix it... The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tableB_tableA". The conflict occurred in database "database name", table "table A", column 'ID'.
I have a problem with a SessionVariable. I will explain what is happening:
1. From the default.aspx I send Session["LoginByAdmin"] = "Dummy"; and then redirect to this page where I have the code below. So the Page_Load sees that this Session["LoginByAdmin"] != null and enter this page. This works fine !
2. In the Page_Load, I later fill a ListBox1 with foldernames.
3. With Button1_Click1, I will now delete the choosen Folder in the ListBox1 wich works fine the first time and the ListBox updates the new existing folders in the ListBox. (I have wrapped this inside an updatepanel)
The problems comes now when I try to delete a choosen folder in the ListBox1 the second time in a row. When I select a Folder in the ListBox1 and now Press Button1, I will be redirected to "Default.aspx". This meens that this code is running: (That meens that Session["LoginByAdmin"] == null and I have not set this to null anywhere. This is my big question how this variable can be = null here?
if (Session["LoginByAdmin"] == null)
Response.Redirect("Default.aspx");
break;
[Code]....
I am using dropdownlist in my view page with some values which will display corresponding ID(primary key of other table) in my database.If i leave my dropdownlist blank and save it in database then its showing null parameter error. Can you explain how to use this reference type to overcome this error
View 2 Repliesi am using the following in a stored procedure.
[code]....
[Code]....Handling NULL...Field not updating when NULL?