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..
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.
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) { }
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
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)
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.
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(); } }
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; }
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?
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)
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?
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 !
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)
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
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?
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[]'.
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
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'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?