protected void rptNavigation_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e){
if (!((e.Item.ItemType == ListItemType.AlternatingItem) || (e.Item.ItemType == ListItemType.Item)))
{return;
}string Name = string.Empty;
if (IsDBNull(e.Item.DataItem["FullName"])) {
Name = String.Empty;}
else {Name = (string)(e.Item.DataItem["FullName"]);}
Literal ltlLiteral = (Literal)(e.Item.FindControl("ltlLiteral"));
ltlLiteral.Text = Name.ToString();
I get error for IsDbNull - Error 1 The name 'IsDBNull' does not exist in the current context. What's the best way to check for null values returned from db? also I get errors on both lines where (e.Item.FindControl(ltlLiteral")); is present ERror: Cannot apply indexing with [] to an expression of type 'object'
I am making a class with an optional paramiter which will be a List<> paramiter. I want to set it's default value to null so I have used List<Params> Param = null. What am not 100% sure is checking the list to see if it was set to null or not. Is using:
.NET noob here (as in I know next to nothing, I'm trying to pick up some of the scraps left by my developer). Ok, I am getting this error on a number of my .aspx pages: Error while checking url '/': Key cannot be null. Parameter name: key Interestingly, I get this on my homepage on which the only .NET code is in the form of two includes, e.g: <% Response.WriteFile("/includes/footer.aspx") %> These includes in themselves only contain HTML, so I assume the issue can only be related to these or a configuration issue?
I use the following code to get the file name out of the URL.
[Code]....
This works fine if there is actually a page that shows up after a '/', I would also like to check for when there is nothing showingup after the '/'. My alert above shows nothing to be there, but how do I chack for the nothing. I have tried the folloiwng, but for some resaon it just ignores me. If I do an if statement, it doesn't pick up that there isn't anything there.
if (sPage = '') { alert(sPage);}
Even though there isn't anything there, it won't show the alert and acts as if there is actually something there.
Is there one simple test that a person can do that covers all options where there could be a null, or "" value. When I google, I see so many options. I see:
if txtBox1.text IsNot nothing if txtBox1.text.toString isNot nothing if txtBox1.text <> "" if txtBox1.text.toString <> "" if isNull(txtBox1) Is there on test that can cover them all?
I have a FormView that is loaded with a records from my DB. Some of the fields may be blank or null. I am trying to check the value of some of the text boxes to verify that the user has updated the fields prior to allowing a DB update from the Edit Template.
I can not seem to get the correct syntax on the if statment to check the value of the text box....
I would like to know the fastest/easiest way to check if a CheckBoxList control has any checked items or not, I'm talking about an entire checkbox list as a whole, not a single checkbox.
I want to know which fields were edited in a form in the Edit Action. I have a Log field in a table named "someTable" which I wish to add the change to, along with the Username of the current user. This is a simple implementation:
[Code]....
Can someone tell me where I am going wrong, because the getChangedAttributes function always returns an empty list (assuming because "backupTable" and "form" contain the same values? But shouldn't they be different?
I'm using C# and SQL Server. I have one gridview which contain 3 columns "ID, COMPLETED (either yes or no), BY (adminID that completed)" and adminID can be null.
If user selected "yes" in COMPLETED column then how can I make sure that adminID in BY column is NOT empty or adminID entered is EXIST in database.
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
I have a checkboxlist (cblTeamMates) with a sqldatasource (sqlTeamMates) that has 3 columns (ID, FullName and Status ). The datavaluefield and datatextfield for cblTeamMates is "FullName" and the 2 status values possible are "Available" and "Absent". How do I go about, in the page load event, checking all the names (FullName) whose Status is "Available"?
I have a .net 3.5 application in c# with sql server 2008 at back end. The application is about assigning jobs to supervisors and then these supervisors have to write remarks about the job progress from time to time. There are two tables ; a JobAssign table with JobOrderNo and Supervisor columns, and a JobUpdate table with jobOrderNo,Date And Remarks(nvarchar) column.
When a supervisor is assinged a job he is sent an email but sometimes the supervisors do not write remarks about a job for some time. i want a stored procedure through which if the remarks of a job are not written for say 5 days an email is sent to the supervisor to do so? in my job update table there are multiple entries for a job so the stored procedure will have to check the Top Remarks Date for each jobOrderNo. then compare it to today date if the difference is difference is 5 days then send email. i have read posts on sending email through job scheduler but i'm new to stored procedure so have no idea how to write such.
I'm trying to make a .Net, c# application for online creating surveys. I have a few types of questions, and than I dynamicly put labels, combos, textboxes ... on the form. Up to this point, I somehow managed to get. Than, on click on add button, I write down the responses in html format using stringBuffer and append function. Example.
public string RetOptionalQuestion(string seq_numm, string question, string answersOpt) { StringBuilder _output = new StringBuilder();
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.
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 am writing an ASP.Net web application. I have listview, it's datasource is a LinqDataSource. In my database, I have a staff table and I am trying filter for records by their team using a dropdownlist. This works fine, until I select "All" in the dropdownlist. It returns all staff except for the ones where the teamID is null. How can I return the records where teamID is null?
