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?
If 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:
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?
I have a form and stored procedure that inserts the data from the form. It works fine except that if a field isn't filled in it doesn't insert a NULL into sql it inserts "".
I've tried a few different ways but none seem to insert NULL, the one below still inserts "", can anyone point me in the right direction.
Here is the required part of the code, if you require more just let me know.
[code]....
So if I enter nothing into address1 field it should write NULL to screen but it always writes NOT NULL.
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
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.
I have a simple WCF service that returns the time from the server. I've confirmed that data is being sent by checking with Fiddler. Here's the result object xml that my service sends according to fiddler.
[Code]....
Literally the only difference is the namespaces within the application. But still the values being returned are null, empty or a .NET default.
this is my sql query and its work fine in my code but it only check ParentDeptID IS NULL it not working when ParentDeptID field is empty how can i check it
("select DeptID,DeptName,(select count(*) FROM HrDept " _ & "WHERE ParentDeptID=sc.DeptID) childnodecount FROM HrDept sc where ParentDeptID IS NULL ", _ objConn)
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
This is completely frustrating and probably embarrassing as well. A while back I posted a similar question and resolved the issue. [URL]...scope_identity The program has been working ever since, until yesterday when as it turns out SCOPE_IDENTITY() started returning an empty string even though a record is being inserted. I am not sure what has changed since the fateful day.
[Code]...
I am hoping that there is something I am just not seeing here. A lot of the information I have seen thus far indicates that there are problems with SCOPE_IDENTITY() but most of those are related to inserting multiple records. As you can see this should be fairly straight forward. The thing that really has got my goat is that it used to work and now it doesn't. If someone could take a look at the above code and comment on any anomalies it would be great. Also I have heard suggestions for switching to ADO.NET and it is beginning to look a lot more attractive every day. But I have a ways to go before making the switch so it is SqlDataSources for now
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?
I have a typical gridview/formview master control setup. When I try to update or insert I don't get any errors but it also doesn't work. When I try to insert data all I get are null values and when I update, none of the values are updated. The formview looks like its working, but just doesn't. The primary key is an identity and it auto-increments by one.
I have a page that lists products from a table based on the querystring. So if I say foo.aspx?fam=1 all the products from family 1 will be listed. How can I make my code list all the values if query string is empty? My SQL command would have to be different...can't really see how I can do this.
I have a formview on a web page, set to insert mode as default. The form view is bound to a SQLDatasource. This datasource has a custom query written to select the details for this formview. The query joins two tables to provide relevant detail and not just an ID for one of the elements on the form view.
The first tabe contains information regarding projects and the second table contains detail regarding Resources. First table has the following definition:
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 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 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.
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.
I have a SQL database. I am getting a datatable from SQL. In SQL Query the table is having null values in the output. But when it is coming to the front end, the null values are replaced by empty values.
So in the front end in the datatable i am having empty values in some cells. I am trying to insert this datatable into access. For this i am using following code...
OleAdpData.InsertCommand.Connection = OleConn; // OleConn is the OleDbConnection OleAdpData.InsertCommand.Connection.Open(); OleAdpData.Update(dtData); // dtData is the datatable OleAdpData.InsertCommand.Connection.Close();
It is inserting the datatable to access database. But it is inserting the empty spaces as present in the datatable. I want to insert NULL into the cells in access datatable where the cells are empty. Where should i add my logic for this.
As you can see, some nodes do not always contain data for ever member of staff; only Directors have biographies.
I access the values like this...
For Each staff In ( _ From matches In myXMLFile.Descendants("staff").Descendants("staffName") _ Where matches.Nodes(0).ToString.ToLower.Contains(LCase(search)) _ Order By matches.Value _ Select matches)......
Once it gets to staffBio I get an error saying "Object reference not set to an instance of an object." obviously because that node does not exist.
My question is how can I assign the value to a variable even when it is empty without having to do a conditional check before each assignment?
In my detailsview, I have an emptydatatemplate set up to allow users to enter new records. The code works. However, once the record is inserted, the detailsview defaults to a standard insert screen. I know this will cause confusion for the users. I would prefer the detailsview to either show in edit mode or a read-only mode. I have used detailsview.changemode and detailsview.currentmode in the custom sub created for the add new button of the emptydatatemplate- neither of which do what I was hoping. It would be even better if when there was no data, it defaulted to the insert screen (which seems like that should be an easy, no-brainer way for .net to function) but it doesn't. Or, I don't know how to accomplish it.
I don't want to force the user to click cancel after inserting an item through the emptydatatemplate just to be able to use the detailsview for other records.
