[URL]
how do you handle null data on gridview? and also the white spaces, it seems that the white spaces are converting to " "
Note: i can't replace the because i have 1 column thats in html form.
In my Webapplication i am trying to export GridView data into PDF format and the application is working fine.But in the resulted PDF file i'm not getting GridView Headers.
View 1 RepliesI have a requirement that i need to remove the columns from gridview which are blank but at remove funtion it gives me error so i make that columns visible false now its working fine but at the time of exporting data from gridview to excel it also export that visible= false columns in spredsheet and i don't want that blank or hidden column in my excel sheet
View 2 Repliesi am unable to handle null values in while .even i tried to handle condition is breaking and coming null value comming inside loop.
[code]....
I've got a detailsview control on a page. The table that it interacts with has a DateTime column in it. This column is nullable, and a lot of the records have null for that value. In the EditItemTemplate I've got a calendar control. When I try to put the DetailsView into edit mode, I get the following error message:
System.InvalidCastException was unhandled by user code
Message=Specified cast is not valid.
Source=App_Web_srpmlyjd
StackTrace:
at ASP.entries_aspx.__DataBinding__control44(Object sender, EventArgs e) in c:inetpubwwwrootMediaLibraryEntries.aspx:line 103
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBindChildren()
I am convinced that the problem is the null values in the DateTime column of the table. I've done some web searches on this, and some have suggested placing some dummy values into that column, but that seems more like a kludge, rather than a solution. How do I keep nulls in the table, and yet not have that preceeding error come up when a user tries to edit the selected record?
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].....
My Header Text is always blank. Below is my code
Response.ContentType ="application/pdf"
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.pdf")
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Dim sw AsNew StringWriter()Dim hw AsNew HtmlTextWriter(sw)
gridview1.AllowPaging =False
[Code] ....
i am using a gridview in my web page,i used to bind the database records to the gridview..my columns are name,empid,company name,pl leave,sl leave,total leave taken here total leave taken is not a database fields,in the page i want to fill the records once loaded pl leave and sl leave is added and display in the total leave taken column..it working properly when all pl ans sl columns fill with numbers,if some pl and sl leave having blank values.it showing an error like input sting was not in correct format..this is my code
<Columns>
<asp:BoundField DataField="slno" HeaderText="SerialNo"
SortExpression="slno" />
<asp:BoundField DataField="ecode" HeaderText="Employee Code"
SortExpression="empcode" />
<asp:BoundField DataField="ename" HeaderText="Employee Name"
[code]....
I used your code over here [URL]
for creating a csv but the csv that gets created is blank. My gridview gets populated so I don't think any problem with that not getting data from Access database. I also tried the code sample you have on this website and checked my code against yours.
I'm used to using VB.net for web programming.Often, I have something like:
Dim s as string = Session("s")
I get a string value for s from the web session. If there is no value in the web session, I get a blank string.However, AFAIK, in C#, I have to have something like the code below to do the same thing.
string s;
try { s = Session["s"].ToString(); }
catch { s = ""; }
I want to know how to handle null values....
for eg i hav a datetime field called Completion date which temporarily has a null value and when i display the records using a gridview it displays a default date...how do i get rid of this default date.the completion Date gets entered at a later stage in the application following which the gridview should show this date....but initially it shouldn't show anything
I'm trying to use the DetailsView to make Updates. The problem is that it can't handle empty fields even though the underlying table field allows nulls.
I get a message like this if I change the "State" field to blank when doing an update
The parameterized query '(@Cust_ID int,@Cust_DL nvarchar(7),@DL_State nvarchar(2),@Last_N' expects the parameter '@State', which was not supplied.I'm using an object data source control which is calling the EditCustomer method in my Customer Class. I'm not sure how to fix this.
[Code]....
I am using this stored procedure with pivot.If i dont have data i am getting null with this stored procedure.Can u tell me how to handle null.below query is pivot.
[Code]....
I have a class with properties for stuff like FileNumber, OpenedDate, ClosedDate etc.When I Initialise the class I set the datetime variables to Date.MinValue.Then when I populate my textboxes I check if the value of the date variables are Date.Minvalue and I set the textbox text to an empty string.
Code:
If(File.OpenedDate = Date.MinValue, String.Empty, File.OpenedDate.ToString("yyyy/MM/dd"))
However whe I try to save the data to my sql server db I get a datetime out of range error. What is the correct way to handle these null values in my date columns?
Whenever you turn off the visibility of a column in Gridview, on Edit, the value becomes null because its never bound. The only way I know of stopping this behavoir is to put it in the DataKeyName list. Is there any other way to prevent this? I have quite a few columns that will not be displayed in this "release" but I want there for future extensibility. Also, in some cases these values will be used for calculations but the user should not see them. Is there no toggle property for "non-visible" items to remain "unchanged" or something of the sort?
View 3 RepliesI've finally figured out an issue I'm have with a zip code field being entered in a text box of a details view in edit mode. I'm trying to understand why i have the issue though. I don't understand why it keeps occurring.his what happens with the zip code field. I've been able to make it reoccur numerous times. If the details view is put in edit mode and the record is updated with the original 5 digit zip code, unaltered in any way, my regular expression validator catches it and doesn't let the update happen. If I change the replace the 5 digit zip code with a new one the update goes through fine. This new value can be a different or the same 5 digits and the update will work. If I don't change the value at all though the update will not go through.
View 8 RepliesI'm trying to retreive values entered by users in the textboxes in the footer of the gridview and insert these values into another sql table.My code is as follows :-
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(e.CommandName.Equals("addnew"))
{
TextBox t1 = (TextBox)GridView2.FooterRow.FindControl("tfrm");
string frm = t1.Text;
TextBox t2 = (TextBox)GridView2.FooterRow.FindControl("tsub");
string sub = t2.Text;
string cmd = "insert into suggestions values('" + frm + "','" + sub + "','c','c')";
con.Open();
SqlCommand com = new SqlCommand(cmd,con);
int a = com.ExecuteNonQuery();
GridView2.DataBind();
con.Close();
}
}
But the strings 'frm' and 'sub' returns null values.
How to deal with Null values in GridView Container.DataItem
[Code]....
I have a simple issue..the user types his/her name in a textbox. Accidentally if a space is entered after a name or before, is it possible for me to trim it while accepting and not raise any error (which actually arises when the textbox is empty)?
View 5 RepliesI want to prevent a user from entering blank spaces into a username textbox.
View 4 RepliesI am updating a gridview. Problem is that when I hide certain fields that I do not want the user to update, they lose their values ie. the data is wiped out in the field unless I show them on the grid and make them writeable. Is there a property I need to set for the field to retain the value when the grid is updated or is this in the sql statement?
View 7 RepliesIs there any built in option to avoid users to register with a username that has blank spaces in it? For example "John Smith". Or I have to check it with a validator?I'm using the createuserwizard.
View 1 RepliesI have a query that averages data in 15 minute increments that I display in a chart using Microsoft Chart Controls. Everything works fine except when there is no data for a 15 minute increment. How do I get the chart to show just the empty time slot?
Query:
[Code]....
On update the dropdown value shows NULL in database : here's structure for my gridview
<asp:TemplateField HeaderText="Construction Phase" SortExpression="Phase_Name">
<EditItemTemplate>
<asp:DropDownList ID="EditedDropDownInGrid" runat="server" CssClass="form-control" DataSourceID="PhaseSQLDataSource" DataTextField="pp_name" DataValueField="pp_id">
</asp:DropDownList>
</EditItemTemplate>
[Code] ....
It updates other controls in gridview but does not update my selected dropdowns item value in Integer format which is inside gridview...
I've updated a number of production sites from 3.5 to 4.0 and have found a really annoying problem where it will insert a blank space into Multi-Line text boxes
The tag is entered as....
<asp:TextBox
ID="AdvDayNotesTB"
runat="server"
TextMode="MultiLine"
CssClass="text"
Width="99%"></asp:TextBox>
<asp:TextBox
ID="AdvDayNotesTB"
runat="server"
TextMode="MultiLine"
CssClass="text"
Width="99%"
/>
The HTML is rendered as...
<TEXTAREA style="WIDTH: 99%" id="ctl00_C_FV1_AdvDayNotesTB" rows="1" cols="20">