Unable to re-enable a radio button if disabled server-side - ASP.NET Discussion Boards

shrihit17-Sep-07 10:27

17-Sep-07 10:27

I try to display data of all employees weekly report. I am using nested gridview, where i need to pass Userid from parent to child gridview so that it display the data according to Userid.

Can some help me on this to pass the values?

Here is my code:

Protected Sub btnook_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnOOk.Click
Dim strsql As String = ""
Dim strsdate As String = String.Format("{0 Big Grin | :-D

}", TextBox1.Text)
Dim stredate As String = String.Format("{0 Big Grin | :-D

}", TextBox2.Text)

parentgrid(strsdate, stredate)
MsgBox("after function called")

End Sub

Public Function parentgrid(ByVal stsdate As String, ByVal stedate As String) As DataSet

Dim strsdate As String = String.Format("{0 Big Grin | :-D

}", stsdate)
Dim stredate As String = String.Format("{0 Big Grin | :-D

}", stedate)
'Dim struser As String = user

Try
strsql = "SELECT b.Userid, sum(format(b.Time2 - a.Time1, ""h.mm"")) AS TotalTime FROM " _
& "(select Userid, num,TimeStamp as time2, pdate from PunchClock " _
& "where InOut='IN' AND PDate >= #" & strsdate & "# And PDate <= #" & stredate & "# " _
& " ORDER BY timestamp) AS b INNER JOIN " _
& "(select Userid, num,TimeStamp as time1, pdate from PunchClock " _
& "where InOut='OUT' AND PDate >= #" & strsdate & "# And PDate <= #" & stredate & "# " _
& "ORDER BY timestamp) AS a ON (b.num = a.num) AND (b.pdate=a.pdate) and (b.Userid=a.Userid) group by b.userid;"

'Opening the database
cmd.CommandType = CommandType.Text
cmd.CommandText = strsql
cmd.Connection = con
con.Open()
MsgBox("Main" & strsql)

objReader = cmd.ExecuteReader
MsgBox("Out2:" & strsql)

da = New OleDbDataAdapter(strsql, con)
ds = New DataSet("Userdetail")
dt = ds.Tables.Add(strsql)
da.Fill(ds, strsql)
con.Close()

ParentGridView.DataSource = ds
ParentGridView.DataBind()

Catch ex As Exception
MsgBox("oops: " & ex.Message, MsgBoxStyle.OkOnly, "Error")
con.Close()
End Try

Return ds

End Function

Protected Sub ParentGridView_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles ParentGridView.RowDataBound

Dim strsdate As String = String.Format("{0 Big Grin | :-D

}", TextBox1.Text)
Dim stredate As String = String.Format("{0 Big Grin | :-D

}", TextBox2.Text)

If e.Row.RowType = DataControlRowType.DataRow Then
Dim gv As GridView
gv = e.Row.FindControl("ChildGridView")
Dim struser As String
struser = e.Row.FindControl("EmpName").ToString()
Try

strsql = "SELECT b.Userid, Format([b.PDate],""m/d/yyyy"") AS PDate, b.Time2, " _
& "b.InOut as TIN, a.Time1, a.InOut as TOUT, format(b.Time2 - a.Time1, ""h.mm"") AS TotalTime FROM " _
& "(select Userid, PDate, num, TimeStamp as time2, InOut from PunchClock " _
& "where Userid='" & struser & "' AND InOut='IN' AND PDate >= #" & strsdate & "# And PDate <= #" & stredate & "# " _
& "ORDER BY PDate, timestamp) AS b INNER JOIN " _
& "(select Userid, PDate, num, TimeStamp as time1, InOut from PunchClock " _
& "where Userid='" & struser & "' AND InOut='OUT' AND PDate >= #" & strsdate & "# And PDate <= #" & stredate & "# " _
& "ORDER BY PDate, timestamp) AS a ON (b.num = a.num) AND (b.pdate=a.pdate) " _
& "group by b.userid, b.PDate, b.time2, a.time1, a.InOut, b.InOut " _
& "ORDER BY b.PDate, b.time2, a.time1;"

'Opening the database
cmd.CommandType = CommandType.Text
cmd.CommandText = strsql
cmd.Connection = con
con.Open()
MsgBox("Parent" & strsql)

objReader = cmd.ExecuteReader
MsgBox("Out2:" & strsql)

da = New OleDbDataAdapter(strsql, con)
ds = New DataSet("Fulldeatils")
dt = ds.Tables.Add(strsql)
da.Fill(ds, strsql)
con.Close()

gv.DataSource = ds
gv.DataBind()

Catch ex As Exception
MsgBox("oops: " & ex.Message, MsgBoxStyle.OkOnly, "Error")
con.Close()
End Try
End If
End Sub

HTML:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %>

<title>Untitled Page

<asp:label id="Label8" runat="server" text="Start Date:" width="104px">
<asp:textbox id="TextBox1" runat="server" width="112px">
<asp:imagebutton id="ImageButton1" runat="server" imageurl="~/Images/calendar.jpg"
="" width="24px"> <asp:calendar id="Calendar1" runat="server" height="120px" visible="False"
="" width="176px">
<todaydaystyle backcolor="Transparent" forecolor="Red">
<weekenddaystyle backcolor="#FFC0C0" forecolor="#804040">

<asp:label id="Label9" runat="server" text="End Date:" width="104px">
<asp:textbox id="TextBox2" runat="server" width="112px">
<asp:imagebutton id="ImageButton2" runat="server" imageurl="~/Images/calendar.jpg"
="" width="24px">

<asp:calendar id="Calendar2" runat="server" height="120px" visible="False" width="176px">
<todaydaystyle backcolor="Transparent" forecolor="Red">
<weekenddaystyle backcolor="#FFC0C0" forecolor="#804040">

<asp:button id="btnOOk" runat="server" font-bold="True" forecolor="Black" text="OK"
="" width="56px">

<asp:button id="Button3" runat="server" font-bold="True" forecolor="Black" text="Cancel">

<asp:button id="Button1" runat="server" text="Button">

<asp:gridview id="ParentGridView" runat="server" style="z-index: 100; left: 27px; position: absolute;
top: 509px" autogeneratecolumns="False" backcolor="White" bordercolor="#336666" borderstyle="Double"
="" borderwidth="3px" cellpadding="3" gridlines="Horizontal" allowpaging="False" datakeynames="Userid" onrowdatabound="ParentGridView_rowDataBound">
<footerstyle backcolor="White" forecolor="#333333">
<rowstyle backcolor="White" forecolor="#333333">
<selectedrowstyle backcolor="#339966" font-bold="True" forecolor="White">
<pagerstyle backcolor="#336666" forecolor="White" horizontalalign="Center">
<headerstyle backcolor="#336666" font-bold="True" forecolor="White">
<columns>
<asp:templatefield headertext="Employee Name">
<itemtemplate>
<asp:label id="EmpName" runat="Server" text="<%# Bind("Userid") %>">

<asp:boundfield datafield="TotalTime" dataformatstring="{0:n}" headertext="TotalTime">

<asp:templatefield headertext="Weekly Report" insertvisible="False">
<itemtemplate>
<asp:gridview id="ChildGridView" runat="server" autogeneratecolumns="False">

<columns>
<asp:boundfield datafield="PDate" headertext="Date" htmlencode="False">
<asp:boundfield datafield="Time2" dataformatstring="{0:t}" headertext="TimeIn" htmlencode="False">
<asp:boundfield datafield="TIN" headertext="In" htmlencode="False">
<asp:boundfield datafield="Time1" dataformatstring="{0:t}" headertext="TimeOUT" htmlencode="False">

<asp:templatefield headertext="TOUT">
<itemtemplate>
<asp:label id="Label2" runat="server" text="<%# Bind("TOUT", "{0:t}") %>">

<footertemplate>
<asp:label id="Label7" text="Total:" font-bold="True" width="50" borderstyle="Solid"
="" borderwidth="0" style="padding:2px; margin-top:5px" runat="Server">

<asp:label id="Label4" text="OverTime:" font-bold="True" width="50" borderstyle="Solid"
="" borderwidth="0" style="padding:2px; margin-top:5px" runat="Server">

<asp:templatefield headertext="TotalTime">
<itemtemplate>
<asp:label id="Label3" text="<%# FormatNumber(Get_Time(Eval("TotalTime"))) %>" runat="Server">

<footertemplate>
<asp:label id="TotalTime" text="<%# FormatNumber(Get_Total_Time()) %>" width="80" runat="Server"
="" font-bold="True" borderstyle="Solid" borderwidth="1" bordercolor="#C0C0C0" style="padding:2px; margin-top:5px">

<asp:label id="Label5" text="<%# FormatNumber(Get_Over_Time()) %>" runat="Server">

<itemstyle horizontalalign="Right">
<footerstyle borderwidth="0px" font-bold="True" horizontalalign="Right">

Shrihit

Re: Pass values in nested gridview

ChrisKo17-Sep-07 10:58

ChrisKo

17-Sep-07 10:58

No one will probably help until you put the code within <pre> </pre> tags.

gridview/datatable with grouped data

sanjay_tutu17-Sep-07 8:09

sanjay_tutu

17-Sep-07 8:09

type priortity status
---------------------------------------
bug low postponed
bug low yy
bug medium xx
bug1 low xx
bug1 high postponed

---------------------------------------
The above table's data is required in following format as grouped data and needs to be displayed in a datatable or gridview.
Can anyone give me code.

---------------------------------------
low postponed
bug yy
---------------------------------
medium xx
----------------------------------------
low xx
bug1
--------------------------------
high postponed

sanjay kumar samantaray

Re: gridview/datatable with grouped data

ChrisKo17-Sep-07 10:56

ChrisKo

17-Sep-07 10:56

Get the Data into a DataSet and then use multiple GridView's that use Data Filters to filter the data needed.

http://quickstart.developerfusion.co.uk/QuickStart/howto/doc/adoplus/FilterData.aspx[^]

Membership.GetUser() fails in Modal dialog

snir_ya17-Sep-07 7:13

snir_ya

17-Sep-07 7:13

Hi,

I'm using window.showModalDialog to open a modal dialog.
The modal dialog needs get the current user's name. To do this i use
Membership.GetUser().UserName;
But when the dialog is posted back Membership.GetUser() return null
and i can't get the user's name.

Does anybody have a clue how to get the user's name?

Thanks.

Re: Membership.GetUser() fails in Modal dialog

Saksida Bojan17-Sep-07 11:21

Saksida Bojan

17-Sep-07 11:21

I don't know how with the post back. Bat you could try Session or Cookie

Re: Membership.GetUser() fails in Modal dialog

VenkataRamana.Gali17-Sep-07 19:56

VenkataRamana.Gali

17-Sep-07 19:56

try with this

http://www.codeproject.com/useritems/How_to_NT_User_Name.asp[^]

Ramana

Unable to re-enable a radio button if disabled server-side

WSonck17-Sep-07 6:55

WSonck

17-Sep-07 6:55

Hello,

I'm having some problems to enable radiobutton in ie7 by javascript. I was googling all day, but I only found one post with the same problem I have. I paste it here to explain what my problem is:

Hi All,

I've come across the problem of not being able to re-enable a radio
button with javascript if its initial state has been disabled in the
Page_Load() method of the code behind.

Might i add that it behaves fine in Firefox, but IE is unable to
re-enable the radio button. IE is fine if the radio button starts in an
enabled state.

Version of IE i'm using is 6, and i have also tried with IE7 and got
the same result.

Is this a bug specific to IE ?

This post has only one answer, which is:

Hi There

function enable()
{
var controls = document.getElementsByTagName("input");
NumElements = controls.length;

for (i=0;i<NumElements;i++)
{
if(controls[i].name=="rdEnable")
{
controls[i].setAttribute("disabled" , false);
ParentSpanControl = controls[i].parentElement;
ParentSpanControl.setAttribute("disabled" , false); break;
}
}

return false;
}

Explanation:
============
A DotNet Radio Button Control will result in creation of the following
three controls

1.Span Control
2.Input Type=Radio
3.Label

So using javascript , do identify all the controls that radio button is
rendered to and set their disabled propery to false;

Please find the above code which does the same

I tried to enable by javascript the input (this works in Firefox, Opera and Netscape, but not in IE), the span, and the label, but I have not get the solution. Here I put the code I try with:

function habilitarPr2IDI(){<br />
<br />
var controls = document.getElementsByTagName("input");<br />
NumElements = controls.length;<br />
<br />
for (i=0;i<NumElements;i++)<br />
{<br />
if(controls[i].name=="InputName")<br />
{<br />
controls[i].disabled = false;<br />
ParentSpanControl = controls[i].parentNode;<br />
label = ParentSpanControl.lastChild;<br />
ParentSpanControl.disabled = false;<br />
label.disabled = false;<br />
}<br />
}<br />
}

Can anyone help me? Thanks a lot.

Re: Unable to re-enable a radio button if disabled server-side

ChrisKo17-Sep-07 10:52

ChrisKo

17-Sep-07 10:52

Check the HTML source of the page rendered when the radio buttons are disabled. My guess is that the radio buttons aren't rendered with just a disabled atteribute but in another way all together for IE. I've never actually looked at it myself, but it's the first guess in my head.

Re: Unable to re-enable a radio button if disabled server-side

WSonck17-Sep-07 21:01

WSonck

17-Sep-07 21:01

This is the HTML source of a disabled radio button:

<td><span disabled="disabled"><input id="radioId" type="radio" name="radioName" value="Text" disabled="disabled" /><label for="radioId">Text</label></span></td>

and this is the HTML of a non-disabled radio button:

<td><input id="radioId" type="radio" name="radioName" value="Text" /><label for="radioId">Text</label></td>

I think the problem is in the tag span. I try to disabled the span too, but didn´t work in IE.

Menu control flyouts don't appear where the should

eggsovereasy17-Sep-07 6:12

eggsovereasy

17-Sep-07 6:12

I recently rolled out a change where I changed the old javascript menu (that only worked in IE) to a new menu using the ASP.NET menu control (so it works in other browsers). I have one user with Windows XP and IE6 where the flyouts on the menu appear at the top of the page rather than next to the menu control like it does on every other computer/browser combination I tested on (and that other users are using). I installed all the patches for IE6 from windows update, but I can't move to IE7 since the company has other internal apps that don't work on IE7. This same computer can do another application I built with the ASP.net menu control perfectly.

Any idea why this happens? I might just go with a pure CSS menu, but its hard to beat the simplicity of the menu control.

GridView Row updating : e.NewValues is null

ss.mmm17-Sep-07 5:20

ss.mmm

17-Sep-07 5:20

In my Gridview rowUpdating event, am not able to retrieve e.NewValues.
e.NewValues and e.OldValues everything returns empty.
Can you please help?

Thanks.

Re: GridView Row updating : e.NewValues is null

DavidNohejl17-Sep-07 5:56

DavidNohejl

17-Sep-07 5:56

Are they by any chance keys? I run into this problem once:

"This property does not contain the key fields. To access the key fields, use the Keys property. You can also access the original field values by using the OldValues property."

msdn[^]

[My Blog]
"Visual studio desperately needs some performance improvements. It is sometimes almost as slow as eclipse." - Rüdiger Klaehn
"Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe

Re: GridView Row updating : e.NewValues is null

ss.mmm17-Sep-07 11:05

ss.mmm

17-Sep-07 11:05

e.Keys.Count , e.NewValues,e.OldValues, even e.RowIndex everything returns 0.
What I want to do is, store the grid in the dataset and then when the row is edited,

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) is called.

now after all rows are updated, the updated grid will be stored in the dataset and finally everything will be pushed into db on Save button click.

Can you please help me how to do this?

Thanks

VS 2003 - Asp.Net Project Settings

matthias s.17-Sep-07 4:55

matthias s.

17-Sep-07 4:55

Hi there,

it worked fine. For almost decades now:

I create a C# Webproject and set the project options to Debugging->Always
use IE = false (translated from german). When starting to debug the project
it fires up with Firefox since this is my standard browser.

Since a couple of days it does not work this way anymore. Eventhough Firefox
is still my standard browser (yes, I checked tripple), IE will fire up when
pressing F5.

Any ideas on how to solve this?

Greetings from Berlin, Matthias

/matthias

I love deadlines. I like the whooshing sound they make as they fly by.
[Douglas Adams]

Re: VS 2003 - Asp.Net Project Settings

monu nair18-Sep-07 17:33

monu nair

18-Sep-07 17:33

right click the web project and select Browser With option

Re: VS 2003 - Asp.Net Project Settings

matthias s.19-Sep-07 4:58

matthias s.

19-Sep-07 4:58

thanks a lot. that helped.

/matthias

I love deadlines. I like the whooshing sound they make as they fly by.
[Douglas Adams]

Static Method to get Data from DB?

error140817-Sep-07 4:49

error1408

17-Sep-07 4:49

Hi,

if i make a static method, that gets Data from my DB, will the method be threadsafe? I mean while one user requests some data and the method is running, can another user that wants to do the same, read/write the variables in this static method?

I know it's a beginners question, i searched a lot but i didn't find an answer.

Thanks for helping me in advance.

Re: Static Method to get Data from DB?

Guffa17-Sep-07 5:52

Guffa

17-Sep-07 5:52

Variables declared locally in a static method are thread safe. Static variables declared in a class or structure are not thread safe.

---
single minded; short sighted; long gone;

Re: Static Method to get Data from DB?

error140817-Sep-07 7:32

error1408

17-Sep-07 7:32

Thank you very much! Big Grin | :-D

iframe problem

g_f_r17-Sep-07 4:43

g_f_r

17-Sep-07 4:43

:(I have web site developed using asp.net 2003 with code behind C#
the main page of the web site contains header,
also has a menu (vertical) and footer .
in the center of that page i have iframe that all pages in the web must open in it. and that happened well when you use the menu
BUT when search engines list my web pages and open them they are oppend alone without header, menu or footer (not in their iframe)

any solution Frown | :(

Re: iframe problem

Brent Lamborn17-Sep-07 6:37

Brent Lamborn

17-Sep-07 6:37

IFrames are bad stuff as far as SEO.

What I would do is add some logic to the pages that are being iframed that will check the referer. If the referrer is Google, Yahoo, etc. then do a 301 redirect (Response.Redirect will do that) to the main page with a parameter in the query string telling which page to load in the iFrame. The main page that has the menu will need to check for that param in the query string and load the iframe with that page.

After that, redesign the site to not include iFrames and use MasterPages instead.

"Half this game is ninety percent mental." - Yogi Berra

If you can read thank a teacher, if you can read in English, thank a Marine.

Re: iframe problem

Guffa17-Sep-07 6:39

Guffa

17-Sep-07 6:39

Preferred solution: Don't use an iframe. Using an iframe in that way is just like using a frameset, which has exactly the same problem.

If you absolutely want to use an iframe, you have to put a Javascript on each page that checks if the page is opened in an iframe or not, and redirect to the main page if it's not. In the main page you have to add code to handle when the page redirects with the Javascript, so that you open up the correct page in the iframe.

This solution will of course not work if Javascript is disabled. Then there is no solution at all. Other than the preferred solution, of course.

---
single minded; short sighted; long gone;

Need Help. filtering a SQLDataAdapter with a girdview selected.value [modified]

orsini17-Sep-07 4:07

orsini

17-Sep-07 4:07

i have a grid view with bind to a sqlDatasource
and I have a repeater that i want populate, according with the selected item in the grid view. and the data comes from a relational tables. here is the grid view and and the sqldataadapter, I know i am doing something wrong, but i dont know what it is, help please

asp:GridView ID="GridView1" <br />
                             runat="server" <br />
                             AutoGenerateColumns="False" <br />
                             DataKeyNames="EventId"<br />
                            DataSourceID="SqlDataSource1" <br />
                            SelectedIndex="1">

<Columns><br />
            <asp:CommandField ShowSelectButton="True" /><br />
            <asp:BoundField DataField="EventName" <br />
                                        HeaderText="EventName" <br />
                                        SortExpression="EventName" /><br />
        </Columns>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:vpx_newConnectionString %>"
SelectCommand="SELECT * FROM [Events]"></asp:SqlDataSource>

and here is the the sqldataadpter

 Sub BindData()<br />
        'Read sample item info from XML document into a DataSet<br />
        Dim cnn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("vpx_newConnectionString").ToString)<br />
        cnn.Open()<br />
        Dim cmd As SqlDataAdapter = New SqlDataAdapter("select * from mediaphotos Where EventID =" & GridView1.SelectedValue, cnn)<br />
<br />
        Dim ds As New DataSet()<br />
        cmd.Fill(ds)

-- modified at 10:13 Monday 17th September, 2007

Re: Need Help. filtering a SQLDataAdapter with a girdview selected.value

monu nair17-Sep-07 18:08

monu nair

17-Sep-07 18:08

I think u want to filter your data in GridView.
so for that u have to use DataView concept .
u can use dataview.filter=Expression.

MBMB

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