ASP.NET Discussion Boards

http://www.systemnetmail.com/faq/3.4.1.aspx[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Thanks, but I need the user to select the path from his local PC. In your code you are already mentioning the path

Hi guys. i have just started to use Tiny MCE and i need to use its save button. But i couldnt find any example on the net. I have an sql database and i need to write this data after pressing save button. Do you have any code snippet with it.

And another question. Do you know tiny mce supports undeletable constant strings.

The button may be fake, and requires to be wired up using the form tag's submit behavior.

In other words, you have to write a function to capture the data from the javascript object, using form submit, and modify the form tag to fire the function on submit.

That's how it works for ckEditor, I assumeit may be the same for tiny MCE.

On ckEditor, the toolbar save button is fake, so you have to make your own button, and function, or wire up the form tag to make the toolbar button work.

i'm using asp.net for my capstone project i need a print out code to excel but when the output comes out changes in my desired output changes in excel. we really need your professional help thanks

Hi,
In my web project crystal reports in built print option was used
and on print a new web window gets opened in which All or Pages option is selected
If pages option selected values in From and To text box can be entered
I want to get these values to enter in to my database but could not find any event for crystal reports inbuilt print button.if there is any please suggest

So i decided to go with my own print button
which will open a new window from where i will select ALL or Pages
and if Pages is selected values in From and To textbox
that is from which page to which page i want my records in pdf

I used solution 1 from below url
http://www.codeproject.com/Questions/55975/Convert-rpt-in-to-pdf-xls-file.aspx
to convert my report in to PDF on click of ok button in popup window
this converts all the records which are opened in report(.rpt)
i want to convert only few records like
4th to 8th only
Please suggest.

Regards
Ankit

Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"

Hi All,

I have web application in vs2008(.net framework 3.5) which uses crystal reports

I have to convert it in to vs2010

I just opened the application to vs2010 solution and visual studio itself migrated the application everything runs fine except crystal reports.
Reports are opening but images are not visible like for printer or next or back button red "x" is visible

i installed sap crystal reports for vs2010 and tried to refer new dll's but code is still referring old dll's of crystal report.
Steps followed
right clicked and removed old reference dll
again right clicked-> add referece and added new crystal reports dll
but it is still refering old ver10 dll's instead of ver13
Do we also need to do something else.Please advise.

Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"

There seems to be a grave issue with reference to connection string encryption using aspnet_regiis tool. I believe it is somehow locked to the particular host on which the application is running because it is expecting us to run the tool on that box.

However, I feel if we can run it on a STAGING box and just XCOPY to PROD without any changes it would be desirable. Any takes/experience/workarounds suggested?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

I've never used that but do use a custom application that encrypts/decrypts connection strings which is, of course, totally portable. Feel it a better solution as have complete control though does mean a little extra work in the target application.

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

I am Nani , I got a requirement i,e,Integrate Tally with .Net
It is Possible Then Please Tell me How?

Please send answer

What have you tried for yourself? Have you searched on Google? Here? Why should we help you if you haven't bothered to even attempt to solve your own problem?

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

I searched in google and i get the some information about tally.
that tally take xml and odbc sql request, and response for that request but that raise a error i.e, collection tdl not available please help me because i am new to tally and tdl

modified 16-Oct-12 23:13pm.

What? I've read that post 3 times now and I'm still no nearer understanding what you are saying. Could you repeat this without using text speak, as it's not very professional and is frowned upon on this site.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

There is a commercial bridging software called RTSLink (http://www.rtslink.com/rtslink.html[^]) which seems to help here.

Alternatively, you may like to explore if Tally itself has any API for the data within it.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

Thanks for sending .
is it any way for integration to tally ith out using rtslink libraries

I am designing some crystal reports in visual studio 2012. Everything works fine except it doesn't render text position properly. Click here to see the problem

Anyway once we print it out, it works fine Click here to see the print output

Please help

Thanks,

Hi,

I want create a client application for an asmx webservice. I want to know which one is better, is it creating proxy manually using wsdl.exe tool or adding web reference of the asmx service to my application and using the automatically created proxy.
Performance wise which is better? Do I have to disconnet and dispose manually if I use wsdl proxy. Or is it automatically done in my if I use web reference. I am asking because I did web services a little only and some time before.

Please help me by giving some information. Thanks in advance. Any kind help is great any link or etc. I am also trying get from other sources too.

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

Neither.
Make WCF service with proxy from IoC container or handcoded.

No more Mister Nice Guy... >: |

I prefer wsdl.exe myself. Mainly because it reduces reliance on a proprietary setup in Visual Studio. I'm guessing Visual Studio will keep supporting web references in the future, but when I have the option of using a simple code file instead, I opt for the code file.

Also, after I generate the proxy using wsdl.exe, I clean out all the unnecessary stuff I don't use (namely, the async stuff).

Thou mewling ill-breeding pignut!

Olá,

Estou usando FormsAuthentication pra logar em uma aplicação.

Em meu ambiente local, a aplicação autentica normalmente e na página restrita o Request.IsAuthenticated retorna true, o que já era esperado.

Porém no ambiente da hospedagem, o mesmo login autentica com o FormsAuthentication normalmente, mas o Request.IsAuthenticated retorna false.

Agora querem algo mais bizzaro? Se eu colocar qualquer parametro na QueryString: ?id=xpto ou ?xpto=xpto, qualquer coisa mesmo, o Request.IsAuthenticated retorna true.

Exite alguma relação do Request.IsAuthenticated com QueryString?

Preciso fazer isso funcionar. Ajudem aê!!

Eu não acredito que seja a hospedagem, pois tenho outra aplicação que autentica normalmente no mesmo servidor.

Since this is primarily an English speaking site, you will get a better response if you formulate your question in English.

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

Hello,

I am using FormsAuthentication to log into an application.

In my local environment, the application authenticates the page and usually restricted to Request.IsAuthenticated returns true, which was expected.

But in the hosting environment, it authenticates with the FormsAuthentication login normally but Request.IsAuthenticated false.

Now they want something more Bizzaro? If I put any parameters in QueryString:? Id = foo or? Foo = foo, anything at all, the Request.IsAuthenticated returns true.

Exite some relationship with the Request.IsAuthenticated QueryString?

I need to make it work. Aê help!

I do not believe it is hosting, because I have another application that authenticates usually on the same server.

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

XML

Can Some One help me to resolve this error that i am geting on my application

I am using autogenerated code from Object Relational designer that is Name.designer.cs to connect to my sql database but i am getting this error

Default.aspx

<asp:GridView ID="GridView1" runat="server" Width="100%"
AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="Trandate" HeaderText="Tran Date">
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="deposit" DataFormatString="{0:F2}"
HeaderText="Deposit">
<ItemStyle HorizontalAlign="Right" />
</asp:BoundField>
<asp:BoundField DataField="withdraw" HeaderText="Withdraw" DataFormatString="{0:F2}" >
<ItemStyle HorizontalAlign="Right" />
</asp:BoundField>

<asp:BoundField DataField="remarks" HeaderText="Remarks" />
</Columns>
</asp:GridView>

the code Behind (default.aspx.cs)
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

NameDataContext bdc = newNameDataContext();
GridView1.DataSource = bdc.RecentTransactions(
Decimal.Parse(Session["Number"].ToString()));
GridView1.DataBind();

Error 4 'NameDataContext' does not contain a definition for 'RecentTransactions' and no extension method 'RecentTransactions' accepting a first argument of type 'NameDataContext' could be found (are you missing a using directive or an assembly reference?) C:\Users\Default.aspx.cs 21 40

Is it that i have not referenced an assembly or dll file that is making me have that error of RecentTransactions....thanks

I am Grateful

Intellisense shows this error? Right?
If yes: then from where you get this method?
If not: check from what assembly is this method and add reference to that assembly.

No more Mister Nice Guy... >: |

Having problems updating INT field in MS SQL Server 2008 database from .NET web application using ASP and VB.net.

Server Error in '/DISCuSS' Application.
--------------------------------------------------------------------------------

Input string was not in a correct format. 
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.FormatException: Input string was not in a correct format.

Source Error: 


Line 81:         Dim strfldRankNew As Int32 = RTrim(LTrim(e.NewValues("fldRank")))
Line 82: 
Line 83:         Dim strfldOnCallAnalystOld As Int32 = RTrim(LTrim(e.OldValues("fldOnCallAnalyst")))
Line 84:         Dim strfldOnCallAnalystNew As Int32 = RTrim(LTrim(e.NewValues("fldOnCallAnalyst")))
Line 85: 
 

Source File: C:\Users\gns1497\Documents\Visual Studio 2008\WebSites\DISCuSS\Dictionaries.aspx.vb    Line: 83 

Stack Trace: 


[FormatException: Input string was not in a correct format.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat) +204
   Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +99

[InvalidCastException: Conversion from string "" to type 'Integer' is not valid.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +257
   Dictionaries.GvOnCall_Update(Object sender, GridViewUpdateEventArgs e) in C:\Users\gns1497\Documents\Visual Studio 2008\WebSites\DISCuSS\Dictionaries.aspx.vb:83
   System.Web.UI.WebControls.GridView.OnRowUpdating(GridViewUpdateEventArgs e) +133
   System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +720
   System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +704
   System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +95
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +123
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.ImageButton.OnCommand(CommandEventArgs e) +111
   System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +176
   System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

My VB.net Code:

XML

Function SendSQLCommand(ByVal tsSQLCmd As String, ByVal tsqlConn As SqlConnection) As Integer
        Dim iRetVal As Integer = -1
        Dim sqlCmd As New SqlCommand(tsSQLCmd, tsqlConn)
        If tsqlConn.State <> ConnectionState.Open Then
            tsqlConn.Open()
        End If
        Try
            iRetVal = sqlCmd.ExecuteNonQuery()
        Catch ex As Exception
            Throw ex
        End Try
        Return iRetVal
    End Function
    Protected Sub GvOnCall_Update(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs)
        'Dim MgrPass As String
        Dim keyValue As Integer = e.Keys("fldOCID")

        Dim strfldOnCallGroupOld As String = RTrim(LTrim(e.OldValues("fldOnCallGroup").ToString()))
        Dim strfldOnCallGroupNew As String = RTrim(LTrim(e.NewValues("fldOnCallGroup").ToString()))

        Dim strfldStartOnCallOld As String = RTrim(LTrim(e.OldValues("fldStartOnCall").ToString()))
        Dim strfldStartOnCallNew As String = RTrim(LTrim(e.NewValues("fldStartOnCall").ToString()))

        Dim strfldEndOnCallOld As String = RTrim(LTrim(e.OldValues("fldEndOnCall").ToString()))
        Dim strfldEndOnCallNew As String = RTrim(LTrim(e.NewValues("fldEndOnCall").ToString()))

        Dim strfldRankOld As Int32 = RTrim(LTrim(e.OldValues("fldRank")))
        Dim strfldRankNew As Int32 = RTrim(LTrim(e.NewValues("fldRank")))

        Dim strfldOnCallAnalystOld As Int32 = RTrim(LTrim(e.OldValues("fldOnCallAnalyst")))
        Dim strfldOnCallAnalystNew As Int32 = RTrim(LTrim(e.NewValues("fldOnCallAnalyst")))



        'MgrPass = InputBox("Please enter the manager password.", "Password Required")

        'If MgrPass = "manage" Then
        gvOnCall_Updated(keyValue, strfldOnCallGroupNew, strfldStartOnCallNew, strfldEndOnCallNew, strfldRankNew, strfldOnCallAnalystNew)
        'Else
        'MsgBox("Only CSS managers may edit DISCuSS.", MsgBoxStyle.Critical, "Authentication Failed")
        'End If

        'http://support.microsoft.com/kb/301248
        'http://www.codeproject.com/Questions/334429/how-to-create-a-combobox-in-grid-view-control

    End Sub

    Protected Sub gvOnCall_Updated(ByVal fldOCID As Integer, ByVal fldOnCallGroup As String, ByVal fldStartOnCall As String, ByVal fldEndOnCall As String, _
                                   ByVal fldRank As Integer, ByVal fldOncallAnalyst As Integer)
        Dim sqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("DiscussSQLConnectionString").ConnectionString)
        Dim sSql As XElement
        sSql = <sql>
            Update [tblOncallAnalystSchedule] SET [fldOnCallGroup] = '<%= fldOnCallGroup %>',
                   [fldStartOnCall] = '<%= [fldStartOnCall] %>',[fldEndOnCall] = '<%= [fldEndOnCall] %>',
                   [fldRank] = '<%= [fldRank] %>', [fldOnCallAnalyst] = '<%= [fldOncallAnalyst] %>'
            Where  [fldOCID] = '<%= [fldOCID] %>' </sql>

        'MsgBox(Err.Description, MsgBoxStyle.Critical, "SQL Error")

        SendSQLCommand(sSql.Value, sqlConn)
        sqlConn.Close()
    End Sub

I use this same "SendSQLCommand" function with another form and it works fine. I pass the values from one sub to the other in the other form as well and that works fine. It just doesn't work on this form when performing an update and it appears that its due to the INT field. In SQL Server 2008 Mgmt Studio the field shows as type "INT", but I cant define the field as "INT" on the asp side. I have to use INT16, INT32, etc.

ASP Code for the Data Source:

XML

<asp:SqlDataSource ID="dsOncallGroup" runat="server"
        ConnectionString="<%$ ConnectionStrings:DiscussSQLConnectionString %>"

        SelectCommand="SELECT tblOnCallAnalystSchedule.fldOnCallGroup, tblOnCallAnalystSchedule.fldStartOnCall,
                        tblOnCallAnalystSchedule.fldEndOnCall, tblOnCallAnalystSchedule.fldRank, tblOnCallAnalystSchedule.fldOnCallAnalyst,
                        tblOnCallAnalystSchedule.fldOCID, tblEmployee.fldEmpLastName +', ' + tblEmployee.fldEmpFirstName as 'Analyst'
                       FROM tblEmployee INNER JOIN tblOnCallAnalystSchedule
                       ON tblEmployee.fldEmpID = tblOnCallAnalystSchedule.fldOnCallAnalyst
                       WHERE (tblOnCallAnalystSchedule.fldOnCallGroup = @fldOnCallGroup)
                       AND (tblOnCallAnalystSchedule.fldEndOnCall &gt; GETDATE())
                       ORDER BY tblOnCallAnalystSchedule.fldOnCallGroup, tblOnCallAnalystSchedule.fldEndOnCall,
                       tblOnCallAnalystSchedule.fldRank"
        OldValuesParameterFormatString="original_{0}"
        ConflictDetection="CompareAllValues"
        DeleteCommand="DELETE FROM [tblOnCallAnalystSchedule] WHERE [fldOnCallGroup] = @original_fldOnCallGroup"
        InsertCommand="INSERT INTO [tblOnCallAnalystSchedule] ([fldOnCallGroup], [fldStartOnCall], [fldEndOnCall], [fldRank], [fldOnCallAnalyst]) VALUES (@fldOnCallGroup, @fldStartOnCall, @fldEndOnCall, @fldRank, @fldOnCallAnalyst)"



        UpdateCommand="UPDATE [tblOnCallAnalystSchedule] SET [fldOnCallGroup] = @fldOnCallGroup, [fldStartOnCall] = @fldStartOnCall,
                       [fldEndOnCall] = @fldEndOnCall, [fldRank] = @fldRank, 'Analyst' = @'Analyst'
                       WHERE [fldOCID] = @fldOCID">

        <SelectParameters>
            <asp:ControlParameter ControlID="cboOncallGroup" Name="fldOnCallGroup"
                PropertyName="SelectedValue" Type="String" />
        </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="original_fldOnCallGroup" Type="String" />
            <asp:Parameter DbType="DateTime2" Name="original_fldStartOnCall" />
            <asp:Parameter DbType="DateTime2" Name="original_fldEndOnCall" />
            <asp:Parameter Name="original_fldRank" Type="Int32" />
            <asp:Parameter Name="original_fldOnCallAnalyst" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="fldOnCallGroup" Type="String" ConvertEmptyStringToNull="false" />
            <asp:Parameter DbType ="DateTime2" Name="fldStartOnCall" />
            <asp:Parameter DbType ="DateTime2" Name="fldEndOnCall" />
            <asp:Parameter Name= "fldRank" Type="Int32" />
            <asp:Parameter Name= "fldOnCallAnalyst" Type="Int32" />
            <asp:Parameter Name="original_fldOnCallGroup" Type="String" ConvertEmptyStringToNull="false" />
            <asp:Parameter DbType="DateTime2" Name="original_fldStartOnCall" />
            <asp:Parameter DbType="DateTime2" Name="original_fldEndOnCall" />
            <asp:Parameter Name= "original_fldRank" Type="Int32" />
            <asp:Parameter Name= "original_fldOnCallAnalyst" Type="Int32" />
            <asp:Parameter Name= "fldOCID" Type="Int32" />
            <asp:Parameter Name= "original_fldOCID" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="fldOnCallGroup" Type="String" />
            <asp:Parameter DbType="DateTime2" Name="fldStartOnCall" />
            <asp:Parameter DbType="DateTime2" Name="fldEndOnCall" />
            <asp:Parameter Name="fldRank" Type="Int32" />
            <asp:Parameter Name="fldOnCallAnalyst" Type="Int32" />
        </InsertParameters>
    </asp:SqlDataSource>

Here's the ASP code for my gridview that I am using to display the data:

XML

<asp:Gridview ID="gvOnCallSchedule" runat="server" AllowSorting="True" AllowPaging="True" showfooter="true"
            OnRowUpdating="GvOnCall_Update" onRowCommand="gvOnCallSchedule_RowCommand" DataKeyNames="fldOCID"
            BackColor="Aqua" DataSourceID="dsOncallGroup" Font-Bold="True"
            Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
            Font-Underline="False" ForeColor="#333333" HorizontalAlign="Justify"
            CellPadding="4" GridLines="None" PageSize="20" AutoGenerateColumns ="false" Allowusertoaddrows="true"
            OnSelectedIndexChanged="cboOnCallGroup_SelectedIndexChanged">

            <Columns>
                <asp:TemplateField ShowHeader="false">
                    <FooterTemplate>
                        <asp:ImageButton ID="AddButton" runat="server" CommandName="Insert" ImageURL="~/images/New.png"
                             Text="Add" ToolTip="Add New On Call Record" />
                    </FooterTemplate>

                    <EditItemTemplate>
                            <asp:ImageButton ID="UpdateButton" runat="server" CausesValidation="False" CommandName="Update"
                                    ImageUrl="~/images/Save.png" Text="Update" ToolTip="Update" />
                                    &nbsp;
                            <asp:ImageButton ID="CancelButton" runat="server" CausesValidation="false" CommandName="Cancel"
                                    ImageURL="~/images/Cancel.png" Text="Cancel" ToolTip="Cancel" />
                    </EditItemTemplate>

                    <ItemTemplate>
                        <asp:ImageButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
                                    ImageUrl="~/images/Edit.gif" Text="Edit" ToolTip="Edit" />
                                    &nbsp;
                        <asp:ImageButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"
                                    ImageUrl="~/images/Delete.png" Text="Delete" ToolTip="Delete" />
                    </ItemTemplate>
                    <ItemStyle Wrap="false" />
                </asp:TemplateField>

                <asp:TemplateField headertext="On Call Group">
                    <ItemTemplate>
                        <asp:DropDownList ID="ddlOCGroup" width="250px" runat="server" datavaluefield="fldOnCallGroup" Enabled="false"
                            DataSourceID= "dsListbox" SelectedValue="<%# Bind('fldOnCallGroup') %>">
                        </asp:DropDownList>
                    </ItemTemplate>
                    <FooterTemplate>
                        <asp:DropDownList ID="ftrddlOCGroup" width="250px" runat="server" datavaluefield="fldOnCallGroup"
                            DataSourceID= "dsListbox" SelectedValue="<%# Bind('fldOnCallGroup') %>">
                        </asp:DropDownList>
                    </FooterTemplate>
                </asp:TemplateField>


                <asp:TemplateField headertext="Start Date/Time">
                    <ItemTemplate>
                        <asp:Textbox ID="txtStartOnCall" runat="server" Text='<%# Bind("fldStartOnCall") %>'>
                            </asp:Textbox>
                        <asp:Image ID="calpopup" runat="server" ImageUrl="~/images/calendar2.png" />
                        <asp:CalendarExtender ID="StartOnCallCal" runat="server" TargetControlID="txtStartOnCall"
                                PopupButtonID="calpopup" PopupPosition="Right" format="MM/dd/yyyy hh:mm:ss tt">
                        </asp:CalendarExtender>
                    </ItemTemplate>
                    <FooterTemplate>
                        <asp:Textbox ID="txtStartOnCallFtr" runat="server" Text='<%# Bind("fldStartOncall") %>'>
                            </asp:Textbox>
                        <asp:Image ID="calpopupFtr" runat="server" ImageUrl="~/images/calendar2.png" />
                        <asp:CalendarExtender ID="StartOnCallCalFtr" runat="server" TargetControlID="txtStartOnCallFtr"
                                PopupButtonID="calpopupFtr" PopupPosition="Right" format="MM/dd/yyyy hh:mm:ss tt">
                        </asp:CalendarExtender>

                    </FooterTemplate>
                </asp:TemplateField>

                <asp:TemplateField headertext="End Date/Time">
                    <ItemTemplate>
                        <asp:Textbox ID="txtEndOnCall" runat="server" Text='<%# Bind("fldEndOnCall") %>'>
                            </asp:Textbox>
                        <asp:Image ID="calpopup2" runat="server" ImageUrl="~/images/calendar2.png" />
                        <asp:CalendarExtender ID="EndOnCallCal" runat="server" TargetControlID="txtEndOnCall"
                                PopupButtonID="calpopup2" PopupPosition="Right" format="MM/dd/yyyy hh:mm:ss tt">
                        </asp:CalendarExtender>
                    </ItemTemplate>
                    <FooterTemplate>
                        <asp:Textbox ID="txtEndOnCallFtr" runat="server" Text='<%# Bind("fldEndOnCall") %>'>
                            </asp:Textbox>
                        <asp:Image ID="calpopup2Ftr" runat="server" ImageUrl="~/images/calendar2.png" />
                        <asp:CalendarExtender ID="EndOnCallCalFtr" runat="server" TargetControlID="txtEndOnCallFtr"
                                PopupButtonID="calpopup2Ftr" PopupPosition="Right" format="MM/dd/yyyy hh:mm:ss tt">
                        </asp:CalendarExtender>

                    </FooterTemplate>
                </asp:TemplateField>


                <asp:TemplateField headertext="Call Order">
                    <ItemTemplate>
                        <asp:Textbox ID="lblCallOrder" runat="server" Text='<%# Bind("fldRank") %>'>
                            </asp:Textbox>
                    </ItemTemplate>
                    <FooterTemplate>
                        <asp:Textbox ID="txtCallOrderFtr" runat="server" Text='<%# Bind("fldOnCallGroup") %>'>
                            </asp:Textbox>
                    </FooterTemplate>
                </asp:TemplateField>


                <asp:TemplateField HeaderText="On Call Analyst">
                    <ItemTemplate>
                        <asp:DropDownList ID="ddlAnalyst" runat="server" datavaluefield="Analyst"
                            DataSourceID= "dsAnalyst" SelectedValue="<%# Bind('Analyst') %>">
                        </asp:DropDownList>
                    </ItemTemplate>
                    <FooterTemplate>
                        <asp:DropDownList ID="ddlAnalyst" runat="server" datavaluefield="Analyst"
                            DataSourceID= "dsAnalyst" SelectedValue="<%# Bind('Analyst') %>">
                        </asp:DropDownList>
                    </FooterTemplate>
                </asp:TemplateField>



            </Columns>
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#7C6F57" />
            <AlternatingRowStyle BackColor="White" />

        </asp:Gridview>