ADO.NET :: Check For Null Values From DataReader
Feb 16, 2011
I have the following code
public class ProductDetails
{
private string _productid;
public string ProductID
{
get { return _productid; }
}
private string _description;
public string Description
{
get { return _description; }
}
private string _image;
public string Image
{
get { return _image; }
}
public ProductDetails(string productid, string description, string image)
{
_productid = productid;
_description = description;
_image = image;
}
}
public class DataAccess
{
private static string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
public ProductDetails GetProductDetails()
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("ProductDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
string productid = HttpContext.Current.Request.QueryString["productid"];
cmd.Parameters.Add(new SqlParameter("productid", SqlDbType.NVarChar)).Value = productid;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
ProductDetails pro = new ProductDetails(
(string)reader["ProductID"], (string)reader["Description"], (string)reader["Image"]);
reader.Close();
return pro;
}
}
protected void PopulateControls()
private DataAccess da = new DataAccess();
{
ProductDetails product = da.GetProductDetails();
if (product.Description == String.Empty)
{
lblDescription.Visible = false;
}
else
{
lblDescription.Text = product.Description;
}
}
In the last piece i want to check if the Description field is null or empty in order to hide the label control but i get an error if i write: if (product.Description == DBNull.Value) and can only use ring.Empty. But i want to check for NULL values as well..
View 3 Replies
Similar Messages:
Feb 10, 2011
I have an aspx page which allows a user to submit modified entries into the database, but when the user clicks Submit to fire the stored procedure I want to first run a check to see if a modified row with the same relationship exists.I am passing the results of the following query:
SELECT SwitchRoom.ModifiedID FROM SwitchRoom WHERE
SwitchRoomID = @ChkSwitchRmID", constring;
into a DataReader to determine if that relationship exists.I need it to determine whether the reader returns NULL to allow the procedure to execute, if it doesn't, then don't allow the user to save the information.I've tried the following:
if (dbreader = NULL)
{
Fire Procedure
}
else
{
"Error Message"
}
and I've even tried passing the reader into a datatable and running it against that without any luck.
View 5 Replies
Apr 4, 2011
So I took over this project and one page is throwing a lot of errors. I would need to refactor the whole thing but as always time is an issue.
In one case the code check's whether a datareader has any rows and if not go to an error page. However as the code is now the datareader can be null (didn't successfully connect to db) and in those cases I can't use
if (!dr.HasRows)
//
becasuse it obviously gives me 'nullreferenceexception was unhandled by code'. I tried with !dr.Read but same thing.
A part of the code is something like
SqlDataReader dr = null;
try
{
//connect to db etc
dr = DbHelper.GetReader("sp_GetCustomer", param);
}
catch
{
//show an error message
}
// and then:
if (!dr.HasRows)
{
}
View 2 Replies
Apr 3, 2013
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]....
View 1 Replies
Mar 14, 2012
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)
View 1 Replies
Feb 28, 2011
I have a Sql Data Source that queries my class database. What I'm trying to do to save myself some landscape is to check a checkbox if any of the pre-requisite fields are not empty. I have this laying inside a gridview. My code doesn't error out but it doesnt' do anything either.
[Code]....
My query is like this:
[Code]....
So in a nutshell, if there is any value in PR1 - PR7, I want to check my checkbox in the gridview.
View 9 Replies
Nov 1, 2010
Why can I not call the global variables CatCode and CompanyName which are equated in the first procedure GetCompanyCatID And use their new values in the second procedure UpdateCompanyCounts as parameter values. When I hard code them code their values at the end of the GetCompany CatID procedure the following procedure updates properly.
string CatCode; - delcared global
string CompanyName; - delcared global
protected void GetCompanyCatID()
{
LinkID2 = Request.QueryString["linkid"].ToString();
string L_ID = LinkID2;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString001"].ConnectionString);
SqlCommand cmd = new SqlCommand("GetCID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@L_ID", L_ID);
try
{
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader["CG_ID"] != System.DBNull.Value)
CatCode = (string)reader["CG_ID"];
CompanyName = (string)reader["CG_Name"];
}
}
}
catch (SqlException exc)
{ }
finally
{ con.Close(); }
// ******* HARD CODED to test below update procedure, it works. When commented out the following update procedure does not update.
CatCode = "55555"
CompanyName = "Test";
UpdateCompanyCounts();
}
protected void UpdateCompanyCounts()
{
LinkID2 = Request.QueryString["linkid"].ToString();
string L_ID = LinkID2;
string CatCode2 = CatCode;
string CompanyName2 = CompanyName;
// string CatCode2 = "23456";
// string CompanyName2 = "TEST";
SqlConnection con2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString001"].ConnectionString);
SqlCommand cmd2 = new SqlCommand("UpdateCatCounter", con2);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@L_ID", LinkID2);
cmd2.Parameters.AddWithValue("@CG_ID", CatCode2 );
cmd2.Parameters.AddWithValue("@CG_Name", CompanyName2 );
try
{
con2.Open();
cmd2.ExecuteNonQuery();
}
catch (SqlException exc)
{
// ErrorBox.Text += string.Format("Error: {0}<br/>", exc.Message);
}
finally
{
con2.Close();
}
}
View 5 Replies
Feb 3, 2011
I have a form with a checkbox list, the values of which are value = "1" value = "2' ...etc (amount of boxes not fixed). These values correspond to an id field in a database and are stored when a new user is entered. When reloading this info I want to populate the checkboxes according to how the user originally checked them.
What is the correct way to do this?
while (reader.Read())
(
i = Convert.ToInt16(reader["Id"]);
CheckboxList1.Items.FindByValue[i].Selected = true;
}
doesn't work....
View 3 Replies
Nov 15, 2010
I'm having a method that exports content from the database to excel files. The method taks as paramaters a DataReader param and a int param - the number of rows. For the number of rows i'm using a dataset, wich i fill using the same query as for the datareader. So I'm executing it twice... Is there a way I can avoid that? get the number of rows from the datareader?
View 1 Replies
Jul 28, 2010
I am getting an error that an open DataReader associated with this Command, when I'm not using datareader(though probably executereader() is the same thing) how would I close this if I don't have a datareader present?
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand("spSelectAllTypes",conn);
cmd.CommandType = CommandType.StoredProcedure;
[code]...
I just want to be able to databind a bunch of dropdownlist in one open connection. (before I had multiple open and closes for each control)
View 2 Replies
Aug 24, 2010
I have Check Box list in Asp.Net, contains week days like as (Monday to Sunday)
I want to store the checked values as 1, non checked values as 0, as Binary format.
Say for example: 0000011 (Monday ,Tuesday selected)
[code]
View 1 Replies
Mar 29, 2011
var pq = attributes.SingleOrDefault(a => a.AttributeName == PasswordQuestion").AttributeValue;
The above code will throw an error if null. What is the best way to handle this?The below code would work, but I can't help but feel there's a more graceful way?
var pq = (attributes.SingleOrDefault(a => a.AttributeName == "PasswordQuestion") != null) ? attributes.SingleOrDefault(a => a.AttributeName == "PasswordQuestion").AttributeValue : null;
View 1 Replies
Oct 21, 2010
I know for a fact that the SQL statement below returns NULL but my code statement "if (obj != null)" is not working.When I debug it I see a value of {} ... not sure what that is. Here is my code:
[Code]....
So, even if SQL returns NULL, it still validates obj as NOT NULL !
View 3 Replies
Feb 11, 2010
I have Sub that requires EventArgs as below.
Sub Testing(ByVal sender As Object, ByVal e As EventArgs)
If I want to call the Sub from PageLoad event, I wrote like this Testing(nothing,nothing)
Then, in the Sub, I would like to check If Argment is Nothing or not
Dim testID As String
If (CType(sender, LinkButton).CommandArgument) = Nothing
testID=Request.QuerySting("myID")
ELSE
testID=(CType(sender, LinkButton).CommandArgument).ToString
End If
I get Null error at if statement (If (CType(sender, LinkButton).CommandArgument) = Nothing)
View 1 Replies
Apr 4, 2011
How do you check for null with HtmlAgilityPack? I'm getting "Property or indexer 'HtmlAgilityPack.HtmlNode.HasChildNodes' cannot be assigned to -- it is read only" with the following.
if (Node.Element("TD").HasChildNodes = DBNull.Value)
I"m getting "Object reference not set to an instance of an object. " with
if (Node.Element("TD").HasChildNodes)
View 1 Replies
Aug 27, 2013
If i have a page in which I want to check whether session is null.
If it is null it will redirect to other page.
But i also have a if (!Page.IsPostBack)
so i will check the session inside this if (!Page.IsPostBack) or outside it?
View 1 Replies
Jun 26, 2010
I cant seem to figure out what is wrong with my check digit code!
At times, it produces 2 length check digit values
Example
1277531815000110 <-- check digit is double value??????
1277532495000110 <-- check digit is double value???????
1277534649000110 <-- check digit is double value???????
127753185300011 <-- good!
127753208500019 <-- good!
All generated numbers are valid, it can be checked at http://www.ee.unb.ca/cgi-bin/tervo/luhn.pl?N=127753224800013
CODE: http://tinyurl.com/352acpj
View 1 Replies
Jan 26, 2011
How can i check if an output parameter is null before i bind it to a asp literal, and if it is null i want to just make the literal
hname1.Text = cmd.Parameters("@hotel1").Value
hname1.DataBind()
hname2.Text = cmd.Parameters("@hotel2").Value
[code]...
View 1 Replies
Aug 17, 2010
I have set the value of an int parameter to the attribute of a textbox.The textbox can be empty or null, how to check whether the parameter is empty or null?
View 5 Replies
Mar 28, 2011
Actually i have a table with 7 columns
1) Title varchar(100)
2)Description varchar(300)
3)ProfilePicture varbinary(max)
4) Image1 varbinary (max)
5)Image2 varbinary(max)
6)Image3 varbinary(max)
7)Image4 varbinary(max)
Image1,2,3,4 are not a mandatory fields so, when i inserted, i check it if it is not there then i insert null value, Now problem is when i retrive them if there is a row contain image1,2 are image content and 3,4 are null values dataset also filling as it is in database but when i checking like
[code]....
it shows error like
Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.
View 3 Replies
Feb 4, 2011
Inside a function I need to check to see if a variable value is null, how to do this? I implemented the code but its not returning the value I thought it would return.If it's null I want to set the value of the variable, else I want to query the value from a table
[Code]....
View 5 Replies
Mar 12, 2011
Right now I have an error if f.ParentID is null:
DataSet1.TreeItemRow[]
TreeItemRows = (from f
in tidt
where (f.ParentID == TreeItemId)
select f).ToArray();
I must continue if f.ParentID is null, I don't want to include null fileds in the array. What is the right syntax for that is linq sql?
View 17 Replies
Jun 25, 2012
How to check the query string value null, if null then display the default value instead of object reference error.
View 1 Replies
Apr 12, 2010
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.
[Code]....
View 3 Replies
May 28, 2010
I'm experimenting with validating forms in the asp.net MVC framework. I'm focusing on server side validation for the time being. I've come across an error that I'm not sure how to rectify. System.NullReferenceException: Object reference not set to an instance of an object. The code that throws the error is:
[AcceptVerbs(HttpVerbs.Post)]
public ActionResult Create([Bind(Exclude="ID")] MembersCreate mc )
{
mc.Modules = ModuleListDataContext.GetModuleList();
ViewData.Model = mc;
//Validation using ModelState
//
//
//line below errors when form field is empty
//
if ((string)mc.Member.Username.Trim() == "")
ModelState.AddModelError("Member.Username", "Username is required.");
if (!ModelState.IsValid)
return View();
try
{
// TODO: Add insert logic here
return RedirectToAction("Index","Home");
}
catch
{
return View();
}
}
When I put spaces in the field it performs exactly as i want, but if I leave the field blank and press submit I get the error. What's the best way to avoid this error and still validate blank form fields?
View 1 Replies