i hav e1 drop down list where is is to filter shif code , ddl text field contaoins shift desc and value contains shift code.
when i select particular shift description it has to show all the 7 days shift description on text boxes iam using informix database
i have 1 dropdownlist which contains shiftcode & shift decription. where shift code is datavalue filed and desc is dat text field. ddl is conected to sql datasource.
i am getting this error:
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:
Line 31: Dim dr As DataRow
Line 32:
Line 33: qry = "select * from ta_shift_times where st_shift_code = '" & DDLSCODE.SelectedItem.Value.ToString & "' order by st_day_id"
Line 34: MsgBox(qry)
Line 35:
[NullReferenceException: Object reference not set to an instance of an object.]
Personnel_ShiftMaster.Bind_Shift() in C:\src\AicWapp\Personnel\ShiftTime.aspx.vb:33
Personnel_ShiftMaster.Page_Load(Object sender, EventArgs e) in C:\src\AicWapp\Personnel\ShiftTime.aspx.vb:55
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
Imports
System.Imports
System.Data.Imports
System.Data.Odbc
ImportS.aicdbo
Partial
Class
Personnel_ShiftMaster
Inherits System.Web.UI.
Page
Protected Sub DDLSCODE_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles
DDLSCODE.SelectedIndexChanged
Call Bind_Shift()
End
Sub
Protected SubBind_Shift()
Dim qry As
String
Dim dt As New DataTable
()
Dim dbo As New
devdbo
Dim dr As
DataRow
qry ="select * from ta_shift_times where st_shift_code = '" & DDLSCODE.SelectedItem.Value.ToString &
"' order by st_day_id"
MsgBox(qry)
dt = dbo.SelTable(qry)
Dim cnt As Int32
= 0
For Each dr In
dt.Rows
Select Case
cnt
Case 0 : txtDay0.Text = dr("st_day_name") : teTfm0.Text = dr("st_timefm") : teTto0.Text = dr("st_timeto" )
Case 1 : txtDay1.Text = dr("st_day_name") : teTfm1.Text = dr("st_timefm") : teTto1.Text = dr("st_timeto" )
Case 2 : txtDay2.Text = dr("st_day_name") : teTfm2.Text = dr("st_timefm") : teTto2.Text = dr("st_timeto" )
End
Select
cnt = cnt + 1
Next
End
Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me
.Load
If IsPostBack = False
Then
DDLSCODE.SelectedIndex = 0
Call
Bind_Shift()
End
If
End
Sub
End
Class
Imports System
Imports System.Data
Imports System.Data.Odbc
Imports aicdbo
Partial Class Personnel_ShiftMaster
Inherits System.Web.UI.Page
Protected Sub DDLSCODE_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DDLSCODE.SelectedIndexChanged
Call Bind_Shift()
End Sub
Protected Sub Bind_Shift()
Dim qry As String
Dim dt As New DataTable()
Dim dbo As New devdbo
Dim dr As DataRow
'qry = "select st_day_name, st_timefm, st_timeto from ta_shift_times where st_shift_code = '" & DDLSCODE.SelectedItem.Value.ToString & "' order by st_day_id"
qry = "select st_day_name, st_timefm, st_timeto from ta_shift_times"
'MsgBox(qry)
dt = dbo.SelTable(qry)
Dim cnt As Int32 = 0
For Each dr In dt.Rows
Select Case cnt
Case 0 : txtDay0.Text = dr("st_day_name") : teTfm0.Text = dr("st_timefm").ToString() : teTto0.Text = dr("st_timeto")
Case 1 : txtDay1.Text = dr("st_day_name") : teTfm1.Text = dr("st_timefm") : teTto1.Text = dr("st_timeto")
Case 2 : txtDay2.Text = dr("st_day_name") : teTfm2.Text = dr("st_timefm") : teTto2.Text = dr("st_timeto")
End Select
cnt = cnt + 1
Next
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack = False Then
DDLSCODE.SelectedIndex = 0
Call Bind_Shift()
End If
End Sub
End Class
chclt
Member
94 Points
65 Posts
regarding Exception Details: System.NullReferenceException: Object reference not set to an instan...
Mar 16, 2011 06:57 AM|LINK
iam new in asp.net in my page
i hav e1 drop down list where is is to filter shif code , ddl text field contaoins shift desc and value contains shift code.
when i select particular shift description it has to show all the 7 days shift description on text boxes iam using informix database
i have 1 dropdownlist which contains shiftcode & shift decription. where shift code is datavalue filed and desc is dat text field. ddl is conected to sql datasource.
i am getting this error:
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:
Source File: C:\src\AicWapp\Personnel\ShiftTime.aspx.vb Line: 33
Stack Trace:
here is my code..
shifttime.aspx
Page Title="" Language="VB" MasterPageFile="~/Aicmst1.master" AutoEventWireup="false" CodeFile="ShiftTime.aspx.vb" Inherits="Personnel_ShiftMaster" %> <%@ Register assembly="DevExpress.Web.v10.2, Version=10.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxRoundPanel" tagprefix="dx" %> <%@ Register assembly="DevExpress.Web.v10.2, Version=10.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPanel" tagprefix="dx" %> <%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %> <%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> <style type="text/css"> .style4 { width: 100%; } .style5 { } .style6 { width: 128px; height: 12px; } .style7 { height: 12px; } .style8 { width: 128px; height: 14px; } .style9 { height: 14px; } .style10 { width: 22px; } .style11 { width: 22px; height: 12px; } .style12 { width: 22px; height: 14px; } .style13 { width: 22px; height: 22px; } .style14 { width: 128px; height: 22px; } .style15 { height: 22px; } .style16 { width: 428px; } .style17 { height: 12px; width: 428px; } .style18 { height: 22px; width: 428px; } .style19 { height: 14px; width: 428px; } .style20 { width: 23px; } .style21 { width: 190px; } .style22 { width: 22px; height: 18px; } .style23 { height: 18px; } .style24 { width: 428px; height: 18px; } .style25 { width: 23px; height: 23px; } .style26 { width: 190px; height: 23px; } .style27 { height: 23px; } </style> </asp:Content> <asp:Content ID="Content5" ContentPlaceHolderID="ContentPlaceHolder4" Runat="Server"> <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional"> <ContentTemplate> <dx:ASPxRoundPanel ID="ASPxRoundPanel1" runat="server" HeaderText="Shifts-Times" Width="1200px"> <HeaderStyle Font-Size="Medium" HorizontalAlign="Center" /> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> <dx:ASPxPanel ID="ASPxPanel4" runat="server" BackColor="LightGray" ClientIDMode="AutoID" Width="1180px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> <table class="style4"> <tr> <td> </td> <td colspan="7" height="20"> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> <dx:ASPxPanel ID="ASPxPanel18" runat="server" ClientIDMode="AutoID" Width="25px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> </td> <td colspan="7"> <dx:ASPxPanel ID="ASPxPanel16" runat="server" BackColor="WhiteSmoke" ClientIDMode="AutoID" Height="350px" Width="810px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "> <span class="Apple-style-span" style="font-family: Arial, Helvetica, Geneva, SunSans-Regular, sans-serif; font-size: 11px; "> System.NullReferenceException: Object reference not set to an instance of an object.</span></span><table class="style4"> <tr> <td class="style10"> </td> <td class="style5"> Shift Code:</td> <td class="style16"> <asp:DropDownList ID="DDLSCODE" runat="server" DataSourceID="SqlDataSource1" DataTextField="desc" DataValueField="code" AutoPostBack="True" Width="200px"> </asp:DropDownList> </td> <td> </td> <td> <asp:Button ID="btnUpdate" runat="server" Text="Update Record" /> </td> <td> </td> <td> </td> </tr> <tr> <td class="style11"> </td> <td class="style6"> </td> <td class="style17"> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> </tr> <tr> <td class="style11"> </td> <td class="style6"> Grace Time</td> <td class="style17"> <dx:ASPxTextBox ID="ASPxTextBox8" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> </tr> <tr> <td class="style10"> </td> <td class="style5" colspan="5"> <dx:ASPxPanel ID="ASPxPanel20" runat="server" ClientIDMode="AutoID" Width="750px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> <table class="style4"> <tr> <td class="style20"> </td> <td class="style21"> Day</td> <td> Start Time</td> <td> End Time</td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay0" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm0" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="teTto0" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style25"> </td> <td class="style26"> <dx:ASPxTextBox ID="txtDay1" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td class="style27"> <dx:ASPxTimeEdit ID="teTfm1" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td class="style27"> <dx:ASPxTimeEdit ID="teTto1" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td class="style27"> </td> <td class="style27"> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay2" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm2" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="teTto2" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay3" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm3" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="teTto3" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay4" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm4" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="teTto4" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay5" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm5" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="ASPxTimeEdit12" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay6" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm6" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="teTto6" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> </table> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> </td> <td> </td> </tr> <tr> <td class="style11"> </td> <td class="style6"> </td> <td class="style17"> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> </tr> <tr> <td class="style10"> </td> <td class="style5"> </td> <td class="style16"> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td class="style22"> </td> <td class="style23"> Time From:</td> <td class="style24"> <br /> </td> <td class="style23"> </td> <td class="style23"> </td> <td class="style23"> </td> <td class="style23"> </td> </tr> <tr> <td class="style13"> </td> <td class="style14"> Time To:</td> <td class="style18"> </td> <td class="style15"> </td> <td class="style15"> </td> <td class="style15"> </td> <td class="style15"> </td> </tr> <tr> <td class="style12"> </td> <td class="style8"> <br /> </td> <td class="style19" align="center"> <dx:ASPxLabel ID="lblStat" runat="server" ClientIDMode="AutoID" ForeColor="#CC0000" Width="400px"> </dx:ASPxLabel> </td> <td class="style9"> </td> <td class="style9"> </td> <td class="style9"> </td> <td class="style9"> </td> </tr> </table> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> <asp:RoundedCornersExtender ID="ASPxPanel16_RoundedCornersExtender" runat="server" Corners="All" Enabled="True" Radius="15" TargetControlID="ASPxPanel16"> </asp:RoundedCornersExtender> </td> <td> </td> <td> <dx:ASPxPanel ID="ASPxPanel17" runat="server" BackColor="#BCBCBC" ClientIDMode="AutoID" Height="208px" Width="275px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> <table class="style4"> <tr> <td> </td> </tr> <tr> <td align="center"> <asp:Button ID="btnNew" runat="server" Text="Define New Record" /> </td> </tr> <tr> <td> </td> </tr> <tr> <td align="center"> <asp:Button ID="btnFirst" runat="server" Text="|<" /> <asp:Button ID="btnPrev" runat="server" Text="<" /> <asp:Button ID="btnNext" runat="server" Text=">" /> <asp:Button ID="btnLast" runat="server" Text=">|" /> </td> </tr> <tr> <td> </td> </tr> <tr> <td align="center"> <asp:Button ID="btnPrint" runat="server" Text=" Print List of Codes" /> </td> </tr> </table> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> <asp:RoundedCornersExtender ID="ASPxPanel17_RoundedCornersExtender" runat="server" Corners="All" Enabled="True" Radius="15" TargetControlID="ASPxPanel17"> </asp:RoundedCornersExtender> </td> <td> <dx:ASPxPanel ID="ASPxPanel19" runat="server" ClientIDMode="AutoID" Width="15px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td colspan="9"> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> </table> <br /> <br /> <br /> <br /> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> <br /> </dx:PanelContent> </PanelCollection> </dx:ASPxRoundPanel> <table class="style4"> <tr> <td> </td> <td> </td> </tr> <tr> <td> <asp:SqlDataSource ID="dsPermast" runat="server" ConnectionString="<%$ ConnectionStrings:DevCon1 %>" ProviderName="<%$ ConnectionStrings:DevCon1.ProviderName %>" SelectCommand="select * from ta_permissions" InsertCommand="insert into ta_permissions values(?,?,?,?,?,?,?,?)" UpdateCommand="update ta_permissions set perm_type =?, perm_desc=?, stat=?,upd_by=?,upd_dt=? where perm_code =?"> <InsertParameters> <asp:ControlParameter ControlID="txtPermCd" Name="newparameter" PropertyName="Text" /> <asp:ControlParameter ControlID="ddlType" Name="newparameter" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="txtPermDesc" Name="newparameter" PropertyName="Text" /> <asp:ControlParameter ControlID="ddlStat" Name="newparameter" PropertyName="SelectedValue" /> <asp:SessionParameter Name="newparameter" SessionField="UsrName" /> <asp:SessionParameter Name="newparameter" SessionField="Credt" /> <asp:SessionParameter Name="newparameter" SessionField="UsrName" /> <asp:SessionParameter Name="newparameter" SessionField="Credt" /> </InsertParameters> <UpdateParameters> <asp:ControlParameter ControlID="ddlType" Name="newparameter" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="txtPermDesc" Name="newparameter" PropertyName="Text" /> <asp:ControlParameter ControlID="ddlStat" Name="newparameter" PropertyName="SelectedValue" /> <asp:SessionParameter Name="newparameter" SessionField="UsrName" /> <asp:SessionParameter Name="newparameter" SessionField="Credt" /> <asp:ControlParameter ControlID="txtPermCd" Name="newparameter" PropertyName="Text" /> </UpdateParameters> </asp:SqlDataSource> </td> <td> </td> </tr> </table> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:devCon1 %>" ProviderName="<%$ ConnectionStrings:devCon1.ProviderName %>" SelectCommand="select shift_code as code , shift_desc as desc from ta_shifts "></asp:SqlDataSource> <br /> </ContentTemplate> </asp:UpdatePanel> </asp:Content> <asp:Content ID="Content6" ContentPlaceHolderID="ContentPlaceHolder5" Runat="Server"> <asp:Accordion ID="Accordion1" runat="server"> </asp:Accordion> </asp:Content>shifttime.aspx.vb
Imports System.Imports System.Data.Imports System.Data.Odbc ImportS.aicdbo Partial Class Personnel_ShiftMaster Inherits System.Web.UI. Page Protected Sub DDLSCODE_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DDLSCODE.SelectedIndexChanged Call Bind_Shift() End Sub Protected SubBind_Shift() Dim qry As String Dim dt As New DataTable () Dim dbo As New devdbo Dim dr As DataRow qry ="select * from ta_shift_times where st_shift_code = '" & DDLSCODE.SelectedItem.Value.ToString & "' order by st_day_id" MsgBox(qry) dt = dbo.SelTable(qry) Dim cnt As Int32 = 0 For Each dr In dt.Rows Select Case cnt Case 0 : txtDay0.Text = dr("st_day_name") : teTfm0.Text = dr("st_timefm") : teTto0.Text = dr("st_timeto" ) Case 1 : txtDay1.Text = dr("st_day_name") : teTfm1.Text = dr("st_timefm") : teTto1.Text = dr("st_timeto" ) Case 2 : txtDay2.Text = dr("st_day_name") : teTfm2.Text = dr("st_timefm") : teTto2.Text = dr("st_timeto" ) End Select cnt = cnt + 1 Next End Sub Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me .Load If IsPostBack = False Then DDLSCODE.SelectedIndex = 0 Call Bind_Shift() End If End Sub End Classs_selvan
Member
386 Points
79 Posts
Re: regarding Exception Details: System.NullReferenceException: Object reference not set to an in...
Mar 16, 2011 08:55 AM|LINK
can you post entire code here?? so that i can help u
chclt
Member
94 Points
65 Posts
Re: regarding Exception Details: System.NullReferenceException: Object reference not set to an in...
Mar 16, 2011 09:16 AM|LINK
timeshift.vb
aspx.code <%@ Page Title="" Language="VB" MasterPageFile="~/Aicmst1.master" AutoEventWireup="false" CodeFile="ShiftTime.aspx.vb" Inherits="Personnel_ShiftMaster" %> <%@ Register assembly="DevExpress.Web.v10.2, Version=10.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxRoundPanel" tagprefix="dx" %> <%@ Register assembly="DevExpress.Web.v10.2, Version=10.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPanel" tagprefix="dx" %> <%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %> <%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> <style type="text/css"> .style4 { width: 100%; } .style5 { } .style6 { width: 128px; height: 12px; } .style7 { height: 12px; } .style8 { width: 128px; height: 14px; } .style9 { height: 14px; } .style10 { width: 22px; } .style11 { width: 22px; height: 12px; } .style12 { width: 22px; height: 14px; } .style13 { width: 22px; height: 22px; } .style14 { width: 128px; height: 22px; } .style15 { height: 22px; } .style16 { width: 428px; } .style17 { height: 12px; width: 428px; } .style18 { height: 22px; width: 428px; } .style19 { height: 14px; width: 428px; } .style20 { width: 23px; } .style21 { width: 190px; } .style22 { width: 22px; height: 18px; } .style23 { height: 18px; } .style24 { width: 428px; height: 18px; } .style25 { width: 23px; height: 23px; } .style26 { width: 190px; height: 23px; } .style27 { height: 23px; } </style> </asp:Content> <asp:Content ID="Content5" ContentPlaceHolderID="ContentPlaceHolder4" Runat="Server"> <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional"> <ContentTemplate> <dx:ASPxRoundPanel ID="ASPxRoundPanel1" runat="server" HeaderText="Shifts-Times" Width="1200px"> <HeaderStyle Font-Size="Medium" HorizontalAlign="Center" /> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> <dx:ASPxPanel ID="ASPxPanel4" runat="server" BackColor="LightGray" ClientIDMode="AutoID" Width="1180px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> <table class="style4"> <tr> <td> </td> <td colspan="7" height="20"> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> <dx:ASPxPanel ID="ASPxPanel18" runat="server" ClientIDMode="AutoID" Width="25px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> </td> <td colspan="7"> <dx:ASPxPanel ID="ASPxPanel16" runat="server" BackColor="WhiteSmoke" ClientIDMode="AutoID" Height="350px" Width="810px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "> <span class="Apple-style-span" style="font-family: Arial, Helvetica, Geneva, SunSans-Regular, sans-serif; font-size: 11px; "> System.NullReferenceException: Object reference not set to an instance of an object.</span></span><table class="style4"> <tr> <td class="style10"> </td> <td class="style5"> Shift Code:</td> <td class="style16"> <asp:DropDownList ID="DDLSCODE" runat="server" DataSourceID="SqlDataSource1" DataTextField="desc" DataValueField="code" AutoPostBack="True" Width="200px"> </asp:DropDownList> </td> <td> </td> <td> <asp:Button ID="btnUpdate" runat="server" Text="Update Record" /> </td> <td> </td> <td> </td> </tr> <tr> <td class="style11"> </td> <td class="style6"> </td> <td class="style17"> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> </tr> <tr> <td class="style11"> </td> <td class="style6"> Grace Time</td> <td class="style17"> <dx:ASPxTextBox ID="ASPxTextBox8" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> </tr> <tr> <td class="style10"> </td> <td class="style5" colspan="5"> <dx:ASPxPanel ID="ASPxPanel20" runat="server" ClientIDMode="AutoID" Width="750px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> <table class="style4"> <tr> <td class="style20"> </td> <td class="style21"> Day</td> <td> Start Time</td> <td> End Time</td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay0" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm0" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="teTto0" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style25"> </td> <td class="style26"> <dx:ASPxTextBox ID="txtDay1" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td class="style27"> <dx:ASPxTimeEdit ID="teTfm1" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td class="style27"> <dx:ASPxTimeEdit ID="teTto1" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td class="style27"> </td> <td class="style27"> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay2" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm2" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="teTto2" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay3" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm3" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="teTto3" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay4" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm4" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="teTto4" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay5" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm5" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="ASPxTimeEdit12" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> <dx:ASPxTextBox ID="txtDay6" runat="server" ClientIDMode="AutoID" Width="170px"> </dx:ASPxTextBox> </td> <td> <dx:ASPxTimeEdit ID="teTfm6" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> <dx:ASPxTimeEdit ID="teTto6" runat="server" ClientIDMode="AutoID"> </dx:ASPxTimeEdit> </td> <td> </td> <td> </td> </tr> <tr> <td class="style20"> </td> <td class="style21"> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> </table> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> </td> <td> </td> </tr> <tr> <td class="style11"> </td> <td class="style6"> </td> <td class="style17"> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> <td class="style7"> </td> </tr> <tr> <td class="style10"> </td> <td class="style5"> </td> <td class="style16"> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td class="style22"> </td> <td class="style23"> Time From:</td> <td class="style24"> <br /> </td> <td class="style23"> </td> <td class="style23"> </td> <td class="style23"> </td> <td class="style23"> </td> </tr> <tr> <td class="style13"> </td> <td class="style14"> Time To:</td> <td class="style18"> </td> <td class="style15"> </td> <td class="style15"> </td> <td class="style15"> </td> <td class="style15"> </td> </tr> <tr> <td class="style12"> </td> <td class="style8"> <br /> </td> <td class="style19" align="center"> <dx:ASPxLabel ID="lblStat" runat="server" ClientIDMode="AutoID" ForeColor="#CC0000" Width="400px"> </dx:ASPxLabel> </td> <td class="style9"> </td> <td class="style9"> </td> <td class="style9"> </td> <td class="style9"> </td> </tr> </table> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> <asp:RoundedCornersExtender ID="ASPxPanel16_RoundedCornersExtender" runat="server" Corners="All" Enabled="True" Radius="15" TargetControlID="ASPxPanel16"> </asp:RoundedCornersExtender> </td> <td> </td> <td> <dx:ASPxPanel ID="ASPxPanel17" runat="server" BackColor="#BCBCBC" ClientIDMode="AutoID" Height="208px" Width="275px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> <table class="style4"> <tr> <td> </td> </tr> <tr> <td align="center"> <asp:Button ID="btnNew" runat="server" Text="Define New Record" /> </td> </tr> <tr> <td> </td> </tr> <tr> <td align="center"> <asp:Button ID="btnFirst" runat="server" Text="|<" /> <asp:Button ID="btnPrev" runat="server" Text="<" /> <asp:Button ID="btnNext" runat="server" Text=">" /> <asp:Button ID="btnLast" runat="server" Text=">|" /> </td> </tr> <tr> <td> </td> </tr> <tr> <td align="center"> <asp:Button ID="btnPrint" runat="server" Text=" Print List of Codes" /> </td> </tr> </table> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> <asp:RoundedCornersExtender ID="ASPxPanel17_RoundedCornersExtender" runat="server" Corners="All" Enabled="True" Radius="15" TargetControlID="ASPxPanel17"> </asp:RoundedCornersExtender> </td> <td> <dx:ASPxPanel ID="ASPxPanel19" runat="server" ClientIDMode="AutoID" Width="15px"> <PanelCollection> <dx:PanelContent runat="server" SupportsDisabledAttribute="True"> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td colspan="9"> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> </table> <br /> <br /> <br /> <br /> </dx:PanelContent> </PanelCollection> </dx:ASPxPanel> <br /> </dx:PanelContent> </PanelCollection> </dx:ASPxRoundPanel> <table class="style4"> <tr> <td> </td> <td> </td> </tr> <tr> <td> <asp:SqlDataSource ID="dsPermast" runat="server" ConnectionString="<%$ ConnectionStrings:DevCon1 %>" ProviderName="<%$ ConnectionStrings:DevCon1.ProviderName %>" SelectCommand="select * from ta_permissions" InsertCommand="insert into ta_permissions values(?,?,?,?,?,?,?,?)" UpdateCommand="update ta_permissions set perm_type =?, perm_desc=?, stat=?,upd_by=?,upd_dt=? where perm_code =?"> <InsertParameters> <asp:ControlParameter ControlID="txtPermCd" Name="newparameter" PropertyName="Text" /> <asp:ControlParameter ControlID="ddlType" Name="newparameter" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="txtPermDesc" Name="newparameter" PropertyName="Text" /> <asp:ControlParameter ControlID="ddlStat" Name="newparameter" PropertyName="SelectedValue" /> <asp:SessionParameter Name="newparameter" SessionField="UsrName" /> <asp:SessionParameter Name="newparameter" SessionField="Credt" /> <asp:SessionParameter Name="newparameter" SessionField="UsrName" /> <asp:SessionParameter Name="newparameter" SessionField="Credt" /> </InsertParameters> <UpdateParameters> <asp:ControlParameter ControlID="ddlType" Name="newparameter" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="txtPermDesc" Name="newparameter" PropertyName="Text" /> <asp:ControlParameter ControlID="ddlStat" Name="newparameter" PropertyName="SelectedValue" /> <asp:SessionParameter Name="newparameter" SessionField="UsrName" /> <asp:SessionParameter Name="newparameter" SessionField="Credt" /> <asp:ControlParameter ControlID="txtPermCd" Name="newparameter" PropertyName="Text" /> </UpdateParameters> </asp:SqlDataSource> </td> <td> </td> </tr> </table> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:devCon1 %>" ProviderName="<%$ ConnectionStrings:devCon1.ProviderName %>" SelectCommand="select shift_code as code , shift_desc as desc from ta_shifts "></asp:SqlDataSource> <br /> </ContentTemplate> </asp:UpdatePanel> </asp:Content> <asp:Content ID="Content6" ContentPlaceHolderID="ContentPlaceHolder5" Runat="Server"> <asp:Accordion ID="Accordion1" runat="server"> </asp:Accordion> </asp:Content>Imports System Imports System.Data Imports System.Data.Odbc Imports aicdbo Partial Class Personnel_ShiftMaster Inherits System.Web.UI.Page Protected Sub DDLSCODE_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DDLSCODE.SelectedIndexChanged Call Bind_Shift() End Sub Protected Sub Bind_Shift() Dim qry As String Dim dt As New DataTable() Dim dbo As New devdbo Dim dr As DataRow 'qry = "select st_day_name, st_timefm, st_timeto from ta_shift_times where st_shift_code = '" & DDLSCODE.SelectedItem.Value.ToString & "' order by st_day_id" qry = "select st_day_name, st_timefm, st_timeto from ta_shift_times" 'MsgBox(qry) dt = dbo.SelTable(qry) Dim cnt As Int32 = 0 For Each dr In dt.Rows Select Case cnt Case 0 : txtDay0.Text = dr("st_day_name") : teTfm0.Text = dr("st_timefm").ToString() : teTto0.Text = dr("st_timeto") Case 1 : txtDay1.Text = dr("st_day_name") : teTfm1.Text = dr("st_timefm") : teTto1.Text = dr("st_timeto") Case 2 : txtDay2.Text = dr("st_day_name") : teTfm2.Text = dr("st_timefm") : teTto2.Text = dr("st_timeto") End Select cnt = cnt + 1 Next End Sub Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If IsPostBack = False Then DDLSCODE.SelectedIndex = 0 Call Bind_Shift() End If End Sub End Classyehia softwa...
Member
256 Points
54 Posts
Re: regarding Exception Details: System.NullReferenceException: Object reference not set to an in...
Mar 16, 2011 09:20 AM|LINK
i think that the selectedItem.Value is null
if( DDLSCODE.SelectedItem.Value != null) or if (DDLSCODE.SelectedValue !=null)
then your query
else
msgbox("value that bind to this item is null")
s_selvan
Member
386 Points
79 Posts
Re: regarding Exception Details: System.NullReferenceException: Object reference not set to an in...
Mar 16, 2011 09:28 AM|LINK
Can you please debug the code and find out what is happening exactly.. so that you can easily fix the code
chclt
Member
94 Points
65 Posts
Re: regarding Exception Details: System.NullReferenceException: Object reference not set to an in...
Mar 22, 2011 04:36 PM|LINK
HI DUDE.
THANKS 4 LATE RPLY.
IT WAS GIVING NULL VALUE ..SO ERROR WAS FIREING..
THANKS 4 UR RPLY
yehia softwa...
Member
256 Points
54 Posts
Re: regarding Exception Details: System.NullReferenceException: Object reference not set to an in...
Mar 27, 2011 07:54 AM|LINK
don't mention it