Forms Data Controls :: Replace An Empty Concatenated Field With "unknown"?
Apr 16, 2010
I should probably post this question to a different forum but I've had such good luck on this one, I hate to leave...I have an SQLDataSource which has a concatenated field of FirstName + ' " + LastName AS FullName. That datasource is used to populate a Primary Contact combobox in the GridView based on the dsOrganizations datasource. ComboBox datasource = dsContacts, TextField = FullName, ValueField = ContactID, ValueType = Int32
nfortunately, not all the Organizations have Primary Contacts listed yet so the above substitution breaks and doesn't even show the Primary Contacts when they existWhat I need is someway to either leave the Primary Contact row blank in the DataGrid or replace it with "[none selected]"
I have a listview control bound to an SqlDataSource. As part of the formatting I want to add a title to the data returned from my database. For instance if the data base returns a phone number I want to add 'Tel.' first. However I do not want to diplay this title if the datafield is empty. Here is what I have done so far.
Business is a phone number. If the data field contains a number I get: Tel. 1234 123456. If the field is empty I get Tel. If Business is null I want nothing dsplayed, how do I do this?
When I try to edit a field of a GridView or DetailsView on the WebServer I have to highlight the area I want to edit instead of just clicking into and empty field and start typing What setting did I forget to set to allow easy editing without having to highlight the are first?
I have a detailsview on my page binding a table with information about the employees. They can update their information. Some info should be visible but not updateable. I could change the update command not updating but I like the control where I can set the column to read only. In that way the employee will find the data visible and they will see that the field/column cannot be changed. But having the column read only will return a null-value into that column when editing and updating anything. Why is that? Shouldn't it just update it's read only value?
I have a gridview which is binded to a Sqldatasource. I would like to replace a column data field value to 'Not Applicable' if that column has got a value of 2 in database.
I have a LinkButton in a DataList which displays personID from personOrders table. This field referenced personID from persons table. Now I need to replace the personID here with personName field. How do I go about it?
I have a vb.net page that has a editable detailsview. When a user wants to erase the data for a field, they highlight the data, and delete/backspace over it, and click update. However, the original data is still saved. If they are replacing the current data with new data, that works fine and updates/saves correctly. This problem only happens when the current data needs to be removed.
I have a aspx page with a ascx control inside an ascx control and the required field validator is not hit on the action of the page.
The issue is with the 2nd nested ascx control. The field validators in the first ascx control validate correctly, but with the ascx control inside the ascx control there are issues.
The nested ascx control is a repeater control and this may be the reason, but I am unsure.
I'm not exactly sure what question to ask, but I'll list a few below.
How do I attach the field validators up a level to the 1st ascx control?
Is it possible to put required fields into a nested ascx control?
I 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.
I have two Drop Down Lists (DDL), DDL1 & DDL2 respectively. DDL1 gets populated with "State" from a backend database where as DD2 gets populated with TWO fields "LATA" & "LATA Name" concatenated together. Here are the codes for the DDL2 :
[Code]....
The code behind the Submit button is using Querystring and directing to the next page:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Response.Redirect(String.Format("Option1_result.aspx?ddl2={0}& ddl3={1}", HttpUtility.UrlEncode(DropDownList2.SelectedValue), HttpUtility.UrlEncode(DropDownList3.SelectedValue))) End Sub
My problem is: How to retrieve data from a Querystring which contains data from two concatenated SQL columns? I want to selectively retrieve only the first three digits in the ddl2 Querystring which will give me the LATA number.
I have a table called 'products'. In each table there is a column named 'description' of type ntext (sql server 2000). The description conains a ton of text and within that text there is an ip address many times. I need to replace every instance of the ip address with the actual domain name, 123.45.678.990 with http://domain.com.
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 string. There are no items to show in this view of the "Personal Documents" then assign to string str variable string str ="There are no items to show in this view of the "Personal Documents" library" Now planning to replace "" and make it to actual string to str object. I tried below, but did not worked
str = str.Replace(@"",string.Empty);
I want str value should be string str ="There are no items to show in this view of the "Personal Documents" library" I need to find this string in another string. While searching into that string. I couldn't found because str contains "".
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 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
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?
When I click on the Alphabets it will show the details of a player...however, when that particular letters has no details of the player..I want to show."No results can be found"..Is there anyway to do it?
I have a gridview with 2 columns. the first column is a textbox an the other column depending of some conditions (it may be dropdownlist, textbox or checkbox column)
I am fresh to asp.net. I m using vb to write it. Could someone who is professional guide me? I want to input data from textbox to "unknown size" array or arraylist, and bind it to gridview. I have more than 1 data to input. Do i need to use loop to bind?
I have a gridview with two textboxes (first name & last name) and a linkbutton to search results inside the gridview.
I have made select parameters as well and the search works if i write in both textboxes. However, if I leave one textbox blank, i don't get any results.
[code]...
How can I get results from searching only one textbox?
