Click here to Skip to main content
15,867,704 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionbookmark Pin
Member 1441910022-May-19 4:00
Member 1441910022-May-19 4:00 
AnswerRe: bookmark Pin
User 418025428-May-19 10:37
User 418025428-May-19 10:37 
QuestionEmail Based OTP Verification for new user registration Pin
VIRENDRA TEMBHARE20-May-19 20:19
VIRENDRA TEMBHARE20-May-19 20:19 
AnswerRe: Email Based OTP Verification for new user registration Pin
Richard MacCutchan20-May-19 21:02
mveRichard MacCutchan20-May-19 21:02 
AnswerRe: Email Based OTP Verification for new user registration Pin
Richard Deeming21-May-19 0:37
mveRichard Deeming21-May-19 0:37 
QuestionCannot insert the value NULL into column 'Status_Id', table 'ITInventory.dbo.Workstations'; column does not allow nulls. INSERT fails. Pin
SuperJWP20-May-19 7:32
SuperJWP20-May-19 7:32 
AnswerRe: Cannot insert the value NULL into column 'Status_Id', table 'ITInventory.dbo.Workstations'; column does not allow nulls. INSERT fails. Pin
Richard Deeming20-May-19 8:43
mveRichard Deeming20-May-19 8:43 
QuestionAjax ToolKit File Upload CAN NOT upload AutoCAD files Pin
Member 1253746817-May-19 11:33
Member 1253746817-May-19 11:33 
AnswerRe: Ajax ToolKit File Upload CAN NOT upload AutoCAD files Pin
Richard Deeming21-May-19 0:39
mveRichard Deeming21-May-19 0:39 
Questionkeep web form drop down list from chagning Pin
dcof16-May-19 10:09
dcof16-May-19 10:09 
AnswerRe: keep web form drop down list from chagning Pin
User 418025428-May-19 10:41
User 418025428-May-19 10:41 
QuestionRedirecting a user (vb.net) Pin
Member 876166712-May-19 23:22
Member 876166712-May-19 23:22 
AnswerRe: Redirecting a user (vb.net) Pin
Richard Deeming13-May-19 8:02
mveRichard Deeming13-May-19 8:02 
GeneralRe: Redirecting a user (vb.net) Pin
Member 87616679-Jun-19 23:56
Member 87616679-Jun-19 23:56 
QuestionEncountering error 401 1 2148074254 while accessing the webservice in NLB environment Pin
vinod koti7-May-19 3:22
vinod koti7-May-19 3:22 
QuestionData Reader only producing one row of records. Any ideas why? Pin
samflex3-May-19 3:14
samflex3-May-19 3:14 
AnswerRe: Data Reader only producing one row of records. Any ideas why? Pin
Richard Deeming3-May-19 3:29
mveRichard Deeming3-May-19 3:29 
GeneralRe: Data Reader only producing one row of records. Any ideas why? Pin
samflex3-May-19 3:51
samflex3-May-19 3:51 
GeneralRe: Data Reader only producing one row of records. Any ideas why? Pin
Richard Deeming3-May-19 5:27
mveRichard Deeming3-May-19 5:27 
GeneralRe: Data Reader only producing one row of records. Any ideas why? Pin
samflex3-May-19 7:06
samflex3-May-19 7:06 
AnswerRe: Data Reader only producing one row of records. Any ideas why? Pin
jkirkerx3-May-19 9:18
professionaljkirkerx3-May-19 9:18 
GeneralRe: Data Reader only producing one row of records. Any ideas why? Pin
samflex3-May-19 9:51
samflex3-May-19 9:51 
GeneralRe: Data Reader only producing one row of records. Any ideas why? Pin
jkirkerx3-May-19 10:16
professionaljkirkerx3-May-19 10:16 
GeneralRe: Data Reader only producing one row of records. Any ideas why? Pin
jkirkerx3-May-19 10:34
professionaljkirkerx3-May-19 10:34 
GeneralRe: Data Reader only producing one row of records. Any ideas why? Pin
samflex10-May-19 4:39
samflex10-May-19 4:39 
Hello,

Still having issues with the code from @jkirkerx. It is me, not the code, I am sure.

So, I decided to go the Richard route by switching back to binding to ListView datasource.

However, the code is not giving an error but when enter a vaue say for Caller List and click "Generate Report", nothing happens.

I just flickers for a second.

I know I am missing something critical but have been looking at this now for two days with no success.

I have decided to post some relevant HTML markup and some VB. Hopefuly, you guys can put me out of my misery.

Thank you very much.

//HTML

             <table class="criteria" runat="server">
 		      <tr id="row_0" class="evenRow">
			   <th>UUID</th>
			   <td>
				<asp:TextBox id="suuid" style="width:150px;" class="form-control" runat="server" />
			   </td>
		</tr>
		<tr id="row_1" class="oddRow">
			<th>Call List ID</th>
			<td>
              <asp:TextBox id="caller_list_id" style="width:150px;" class="form-control" runat="server" />
			</td>
		</tr>
		<tr id="row_2" class="evenRow">
			<th>Phone Number</th>
			<td>
				<asp:TextBox id="phonenumber" style="width:150px;" class="form-control" runat="server" />
			</td>
		</tr>
		<tr id="row_3" class="oddRow">
			<th>Start Date</th>
			<td>
				<asp:TextBox id="date_start" style="width:150px;" class="form-control" runat="server" />
		 </td>
		</tr>
		<tr id="row_4" class="evenRow">
			<th>End Date</th>
			<td>
			  <asp:TextBox id="date_end" style="width:150px;" class="form-control" runat="server" />
		 </td>
		</tr>
		<tr class="oddRow">
			<th>Call Type</th>
			<td>
			  <asp:DropDownList id="call_type" runat="server">
		        <asp:ListItem SELECTED="True" value="">All</asp:ListItem>
		        <asp:ListItem value="0" Text="0 ">Unknown</asp:ListItem>
		        <asp:ListItem value="1" Text="1">Outbound Progressive</asp:ListItem>
		        <asp:ListItem value="2" Text="2">Outbound Predictive</asp:ListItem>
		        <asp:ListItem value="3" Text="4">Inbound</asp:ListItem>
		        <asp:ListItem value="4" Text="8">Blaster</asp:ListItem>
		        <asp:ListItem value="5" Text="16">Personal Inbound</asp:ListItem>
		        <asp:ListItem value="6" Text="32">Nailin</asp:ListItem>
		        <asp:ListItem value="7" Text="64">External Transfer</asp:ListItem>
		        <asp:ListItem value="8" Text="128">PBX Outbound</asp:ListItem>
		        <asp:ListItem value="9" Text="256">PBX Inbound</asp:ListItem>
		        <asp:ListItem value="10" Text="512">Snoop</asp:ListItem>
             </asp:DropDownList>
			</td>
		</tr>
      </table>
    <div class="menuToolbar" style="padding-bottom: 30px;">
      <asp:Button runat="server" id="btnSubmit" Text="Generate Report" OnClick="btnSubmit_Click" />
      <asp:Button runat="server" id="btnExport" Text="Export to CSV" OnClick="btnExport_Click" />
    </div>
 <asp:ListView ID="ProductsListView" runat="server" DataKeyNames="uuid" DataSourceID="SqlDataSource1">
     <LayoutTemplate>
        <table runat="server" border="0" style="">
          <tr>
                <th style="border-left: 1px solid #557799" class="reportHeader">
				Dialed Phone Number
		</th>
		<th class="reportHeader">
				Caller ID
		</th>
		<th class="reportHeader">
				Call List ID
		</th>
		<th class="reportHeader">
				Start Time
		</th>
		<th class="reportHeader">
				Connect Time
		</th>
		<th class="reportHeader">
				End Time
		</th>
		<th class="reportHeader">
				Duration
		</th>
		<th class="reportHeader">
				Full Duration
		</th>
		<th class="reportHeader">
				Campaign Name
		</th>
		<th class="reportHeader">
				Queue Name
		</th>
		<th class="reportHeader">
				Call Type
		</th>
		<th class="reportHeader">
				Employee
		</th>
		<th class="reportHeader">
				ISDN Cause Code
		</th>
		<th class="reportHeader">
				Disposition
		</th>
		<th class="reportHeader">
				Telephony Server
		</th>
		<th class="reportHeader">
				Trunk Name
		</th>
		<th class="reportHeader">
				UUID
		</th>
		<th class="reportHeader">
				Recording
		</th>
		<th class="reportHeader">
				Details
		</th>
	</tr>
    <tr runat="server" id="itemPlaceholder">
      <td colspan="19">
        There is no data!
      </td>
    </tr>
   </table>
</LayoutTemplate>
   <SelectedItemTemplate>
  <table runat="server" border="0" style="">
  	 <tr>
	  <td><asp:Label ID="lblphonenumber" Text='<%# Eval("phone_number") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblcallerid" Text='<%# Eval("callerid") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblcallerlist" Text='<%# Eval("call_list_id") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblstarttime" Text='<%# Eval("startttime") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblconnectime" Text='<%# Eval("connecttime") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblendtime" Text='<%# Eval("endtime") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblduration" Text='<%# Eval("duration") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblfullduration" Text='<%# Eval("fullduration") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblampaignname" Text='<%# Eval("camapign_id") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblqueuename" Text='<%# Eval("queue_id") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblcalltype" Text='<%# Eval("call_type_id") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblemployee" Text='<%# Eval("roll_id") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblisdn" Text='<%# Eval("cause_code") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lbldisposition" Text='<%# Eval("cause_code") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lbltelephony" Text='<%# Eval("box_id") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lbltrunkname" Text='<%# Eval("trunk_name") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lbluuid" Text='<%# Eval("uuid") %>' runat="server"></asp:Label></td>
	  <td><asp:Label ID="lblrecording" Text='<%# Eval("customer_id") %>' runat="server"></asp:Label></td>
	  <td><a href="#"></a></td>
	</tr>
  </table>
  </SelectedItemTemplate>
  </asp:ListView>
  <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:test %>" 
  SelectCommand="SELECT phone_number, callerid, call_list_id, startttime,connecttime, endtime, duration, fullduration,
             camapign_id, queue_id, name, roll_id, cause_code, uuid, box_id, trunk_name, uuid, customer_id FROM cti.qpcdr, cti.call_types
             WHERE cti.qpcdr.call_type_id = cti.call_types.id">
  <SelectParameters>
   <asp:ControlParameter ControlID="suuid" Name="uuid" PropertyName="Text" Type="String" DefaultValue="%" />
   <asp:ControlParameter ControlID="caller_list_id" PropertyName="Text" Name="callerlist" />
   <asp:ControlParameter ControlID="phonenumber" PropertyName="Text" Name="phone" />
   <asp:ControlParameter ControlID="date_start" PropertyName="Text" Name="start" />
   <asp:ControlParameter ControlID="date_end" PropertyName="Text" Name="end" />
  <asp:ControlParameter ControlID="call_type" PropertyName="SelectedValue" Name="calltype" />
  </SelectParameters>
 </asp:SqlDataSource>
 
 
 //VB
    Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
        If Not Me.IsPostBack Then
         'TODO
        End If
    End Sub 
     Protected Sub btnSubmit_Click(sender As Object, e As EventArgs) Handles btnSubmit.Click
         'ProductsListView.DataSource = SqlDataSource1
         ProductsListView.DataBind()
     End Sub
     Protected Sub btnExport_Click(sender As Object, e As EventArgs)
         ProductsListView.DataBind()
    End Sub

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.