From my experience in silverlight, their comboBoxItem can holds object data, so I can do like ComboBox.selectedItem and cast to the data object type and get the databinding object out. But in Asp.Net, the ComboBoxItem seems like only have Text and Value property for databinding. I wonder if there is a way that I can get the databinding object out? Not with searching the datasource and find the object by Text and Value...
View 1 Replies
I'm making a simple forum using MySQL and I use a repeater to display a list of all threads in it. I have two tables for posts, one for threads and one for replies, and I want to sort the threads by either when they were posted or when the last reply was posted in it. My SQL query is really long and hard to read so here's some psuedo code similar to it (easier to understand these column names, etc):
SELECT
threads.id,
threads.title,
threads.timestamp,
users.username,
(SELECT COUNT(*) FROM replies WHERE thread_id = threads.id) AS number_of_replies,
(SELECT COUNT(*) FROM views WHERE thread_id = threads.id) AS number_of_views,
(SELECT timestamp FROM replies WHERE thread_id = threads.id ORDER BY timestamp DESC LIMIT 1) AS last_reply_timestamp
FROM threads
LEFT JOIN users
ON threads.user_id = users.id
ORDER BY ************** DESC
What I do here is I fetch the values id, title, timestamp, the author's username, the number of replies and views for a specific thread, and I also get the timestamp for the last reply to this thread.
Then, what I want to do is sort the whole list so that the threads are displayed in an order matching when either it was posted or the last reply was posted in it (you know, like a normal forum) but I'm not sure how to accomplish this.
I tried this:
ORDER BY CASE WHEN last_reply_timestamp > threads.timestamp THEN last_reply_timestamp ELSE threads.timestamp END DESC
but that, I guess, maybe only looks at the first row and determines which one should be used so the order is not correct.
I'm not sure if it's possible to create a sort of variable that holds the value for each row of the timestamp that applies, if that's possible you could sort by that. For example:
(CASE WHEN last_reply_timestamp > threads.timestamp THEN last_reply_timestamp ELSE threads.timestamp END) AS last_activity_timestamp
...
ORDER BY last_activity_timestamp DESC
So each row has a field "last_activity_timestamp" containing either timestamp, whichever is the later than the other.
Can this be done somehow? How does everyone else solve this? It's so hard to search google because I just get lots of forums but no code.
How do I create a SortedList that holds multiple variables? I want to keep multiple instances of (date, height, weight).
View 2 RepliesI've got a form with a button on it. You have to be logged in to see this form. I use this code to check if the user is logged in and act appropriatley.
Dim isLoggedIn As Boolean = CType(Session("LoggedIn"), Boolean)
If isLoggedIn = False Then
Response.Redirect("Login.aspx")
End If
The button runs a report that takes anywhere from 0.5 to 20 seconds. For testing it just sleeps for 10 seconds.
Threading.Thread.Sleep(10000)
The problem is this. Say User1 comes to the form, logs in and runs the report. If User2 comes to the form, the page will not load until User1's report is done.
Now, the bonus is if I comment out the response.redirect line, everything works fine. But if that line is in there I will get this problem.
I have 3 drop boxes: 1.) Choose Operation 2.) Choose Site 3.) Choose Area. All three of them are linked to an SQL server database which has 3 tables following the same heiarchy of order. I.e. Areas belong to a Site and Sites belong to an operation. And there can only be one operation per site, or one site per area.
First you select an operation, then the page auto postbacks to filter the sites. Then you pick a site and again it autopostbacks to filter the areas. The issue I am having is that when an associated operation has no sites underneight it, and therefore no areas under that, the previous values that were in the boxes are displayed and the user can't click on the boxes anymore. I think this is kind of cheap looking and would like a way to make it so the boxes are clear (i.e. nothin in them). Is there anyway to check if they are going to freeze like that and assign them blank values?
Here is the situation:I have a Datagrid which is going to display a number of rows. I want to click a button on the datagrid and have the following occur
open a row underneath the row clicked, without hiding or replacing that row Open this row so that it spans all of the columns as one continuous row where i can put form fields and/or just data formatted as I would like and not just in columns.Be able to close that new row. While I do most of my work in VB.NET, don't think that is a requirement for answering this.I have managed to currently take the first column (with the "Edit" button) and when clicked to
Hide the rest of the cells in that row Expand the button column to run all the way across the table Unfortunately I loose the clicked row's data, and I've only started getting this to work so I haven't tried too much, or getting data to bind to fields "on the fly"
when I make restore to backup database display this error :
The backup set holds a backup of a database other than the existing 'elib' database. (Microsoft.SqlServer.Smo)
how I can solve this error ?
In the VS2005 environment, when I test my session to make sure the page redirects to the main page (itself) if the session is null, it works. There is no error.
The function I use for this is:
[code]....
However, when it is in the production environment in IIS 6.0, when the session has timed out, and I then do a postback by doing some slider control, I see the page reload but immediately thereafter, it throws a Server Error exception of : Object reference not set to an instance of object.
Looking at the stack trace, the event occured:
AJAXEnabledWebApplication1._Default.Slider1_TextChanged(Object sender, EventArgs e)
however, why is it that the Slider1_TextChanged event fired even even after during page_load, the page was told to do a response.direct ?? shouldn't the entire page have gone through a full-page refresh life cycle ? why did it continue on to attempt to raise the Slider1_TextChanged event?
im tryin to create a login form.
and am receiving the following error:
Object reference not set to an instance of an object
[Code]....
and heres my aspx page:
[Code]....
Stored procedure:
[Code]....
this works fine on my local site but as soon as i upload the site to my live server i get stem.NullReferenceException: Object reference not set to an instance of an object
on the first line of this:
if (!Page.User.Identity.IsAuthenticated)
{
pnlSignIn.Visible = true;
pnlSignOut.Visible = false;
}
can you please help me to brainstorm the possible causes of this error. I've got a paged repeater with localisation bound programitcally to an sqldatasource using a stored proc. I can post code if needs be but it's rather long. I'm looking for typical causes of this error + will make note for future reference!
erver Error in '/WebSite4' Application.
Object reference not set to an instance of an object.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
[Code]....
Line 233:Line 234: Repeater1.DataSource = PagedResultsLine 235: Repeater1.DataBind()Line 236: doPaging()Line 237: End Sub
I am trying to get the value of the id field in my gridview but I keep coming up with this error when i do selectedValue or selecteIndex
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
How do I get that id? What I am trying to do is when the user select that link it will delete that information from the database. Here's my code:
[Code]....
[Code]....
I'm new to programming in ASP.NET, but I'm making my way through Wrox's Beginning ASP.NET 3.5 in C# and VB.NET.
I'm at a section where I'm creating a BasePage. I successfully created a BasePage by creating a new class file in my App_Code folder called BasePage.cs with the following code:
[Code]....
If I run that code everything works out fine. The page loads and all is well. But, if I try to do the same thing to a page that uses my MasterPage.master file, I get the following error:
Object reference not set to an instance of an object.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Why is that? In the example code from the book (that also uses a MasterPage.master file), everything excutes and runs just fine. But in my test, I get the above error. I've tried comparing my pages to the books included source pages, but I can't find any differences.
In the same Code behind file I have:
// This works
Label lblTopNavBarInfo = (Label)Master.FindControl("lblTopNavBarInfo");
lblTopNavBarInfo.Text = "Currently Serving: + FirstName + " " + LastName ;
// This compiles but throws an error in the browser
LinkButton lnkBtnProductsOwned = (LinkButton)LeftNav_CustServ1.FindControl("ProductsOwned"); // The Control is visible
lnkBtnProductsOwned.Enabled = false; // Error: Object reference not set to an instance of an object.
I have a website written in C# that was running fine on one server. We moved it to another server and have a couple issues. I am mainly a VB.NET coder but can do a few things in C#. This is not a project - it is a website and can open it in VS2008 no problem. This is an admin site for the whole website where the user can add customer comments, etc. When logging in, it works fine. I can go to one of the admin pages after logging in and works. If I go to two other different pages, I get this error:
Object reference not set to an instance of an object.
[Code]....
It turns out this is in the main.master page and it is used by the other pages that load fine. The ApplicationTitle variable is set right in the web.config file and like I said, it shows on the other pages.
My question is why would this code work fine for some pages and not two others? All of these admin pages are under a folder called Admin and the web.config file is in the root folder of the website. Its almost like these two pages cannot see the web.config file in the root folder? Why would that be if thats the case?
We have an applicaiton that was converted to the new framework using the wizard in Visual Studio 2008. When we install the applicaiton in production and change the iis settings to use the 2.0 framework we start to see these errors in the event viewer on the web servers. We are using SQL Server Session State and have 3 web servers in a load balancer. Object reference not set to an instance of an object.</Message><StackTrace> at System.Web.SessionState.SessionStateModule.PollLockedSessionCallback...
View 1 RepliesI have a webservice, it has few webmethods. when i create a client proxy and invoke the methods to check its response, i am getting this error. Can someone tell me what things can i check to know the cause of this? The error is not saying much hence blocked on this.
View 1 Replies I am trying to implement the code URL...I have a database table with Integer type.Here is the running code line: Code in GridView:
<asp:TemplateField HeaderText="RegionNavn">
<ItemTemplate>
<%# Eval("RegionNavn")%>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="lblRegionNavn" runat="server" Text='<%# Eval("RegionNavn")%>' Visible = "false"></asp:Label>
[code]...
On Edit Click, the DropDownList in the GridView brings the previously selected value.On Update Click, the error is: "System.FormatException: Input string was not in a correct format."
dCmd.Parameters.Add("@KystverketRegionID", SqlDbType.Int).Value = int.Parse(ddKystverketRegionID.SelectedValue);
When I use the following code:
ddlRegionNavn.DataTextField = "RegionNavn";
ddlRegionNavn.DataValueField = "RegionID"; // from RegionNavn to RegionID
On Edit Click, the DropDownList values in the GridView is not firing and the following error shows.Object reference not set to an instance of an object. How to implement the code when having a value of type Int ?
I am getting object refernce error at line:if (Session["Tax"].ToString() == "9")
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Tax"].ToString() == "9")
{
lblTax.Text = Session["Tax"].ToString();
}
else
{
lblTax.Text = "0";
}
}
Is anything wrong I have done?
I have this part in the Gridview.
<asp:TemplateField HeaderText="Student">
<ItemTemplate>
<asp:DropDownList ID="ddl" OnSelectedIndexChanged="ddl_IndexChanged" runat="server">
</asp:DropDownList>
[Code]....
After the change, when it is to bind data, I get this Exception message. Why?Object reference not set to an instance of an object.
private void FillDetails(string pId, out string Name, out string Address)
[code]....
I have method called Filldetails(),This method uses stored procedure to retrieve information for product name and address based on productid passed from productdetails table.I am working on globalization project.We have this product information for US country but there is no product information for germany country.So dataset is empty for germany.As result I am getting error object reference not set to an instance of the object.
I have just recently converted my VB code to C# and now having this error when I try to add an item to my listbox, and the value is coming from the item page. I get the error at this segement:
lstboxCart.Items.Add(cartItem.Display());
My listbox is supposed to add the product's name, quantity, and price onto one row.
Here's what I have so far:
[code]...
[Code]....
[Code]....
My guess is that the source of the problem could be in the foreach loop from my cart class, shouldn't I be using that for arrays only? If I need to post any markup code or any other class, let me know.
I am receiving Object reference not set to an instance of an Object when binding Child dataGrid in the ItemCommandEvent of Parent dataGrid.
[code].....
I have a nested gridview
i get error:Object reference not set to an instance of an object
when i try to get the text in the footer template of the inner gridview when clicking on the linkbutton!!!
[code]....
Again, I am new to the ASP.NET world, and I come from a Windows Forms background. I'm working with an ObjectDataSource that retrieves a collection of business objects. With the collection, I am going to be binding it to a CheckBoxList and other various controls. The business object that I am using is an Employee.
To get all of the employees, I create an ObjectDataSource and set the "Select" method. I then set the DataSourceID of the CheckBoxList to be that of the ObjectDataSource. When I load the page for the first time, I see all of the employees. Now, the user goes through this page and selects all the employees they want to see information about (by checking the box next to the employee name). Finally, the user hits the button called "Display." Upon postback how do I get a list of those employees? I've tried the following solution, but I'm not sure if it's the best practice in obtaining all those employees again. Here's my solution...
In the CheckBoxList, I set the DataTextField to the Employee's name. I also set the CheckBoxList's DataValueField. This property is a little different. I set this to be a UNIQUE IDENTIFIER, which can distinguish this employee from other employees. Now, when the user hits the button "Display" I use my ObjectDataSource again and MANUALLY call ObjectDataSource.Select(). I cast the returned value as a List<Employee>. Finally, I iterate through all list items in the CheckBoxList...
[Code]....
If the item is selected, I parse through my list of employees that was returned from the bjectDataSource.Select(). I use the item.Value and compare it to each employee's "key." If the key is found, I know that the employee is selected. I put this employee in another list called EmployeesSelected.
Finally, I take EmployeesSelected (which is a List) and set my GridView's .DataSource and call .DataBind() on the GridView.
Is this the "best practice" of re-obtaining the Employees that are selected on my page, or am I making this too complicated?
