ASP.NET

Using MS Access database with medium trust level

10-Oct-06 15:09

Here are the basic steps that you may need to do:
+ Create an event handler for 10 buttons' Click event.
+ In the handler, use the ADO.NET[^] to connect to the database to query the image url.
+ Set the image url to the Image.ImageUrl Property [^]

Fedor Hajdu10-Oct-06 10:05

Fedor Hajdu

10-Oct-06 10:05

Hi everybody Smile | :)

I've written an ASP.NET application which has to use ms access database (It was a clients request) on my development server everything works fine, but on a live server it is not possible to connect to database.
Their technical support told me that the problem is in the medium trust level!
Can anyone help me with configuration?

Thanks, Fedor

(Sorry if this is double post, but search on messages works painfully slow on my connection)

Re: Using MS Access database with medium trust level

minhpc_bk10-Oct-06 15:12

Re: Using MS Access database with medium trust level

10-Oct-06 15:12

Hi there,
What you might need to do is to grant the OleDbPermission to the application, you can see the details from the links:

http://msdn2.microsoft.com/en-us/library/wyts434y.aspx[^]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/PAGHT000020.asp[^]

Fedor Hajdu11-Oct-06 8:34

Fedor Hajdu

11-Oct-06 8:34

Great! That's it!
Thank you very much, you saved my day Wink | ;)

Export GridView to Word

RadioButton10-Oct-06 9:55

RadioButton

10-Oct-06 9:55

Hello,

I am using the basic export to Word code for my GridView below. I am trying to figure out how to remove the hidden input field that gets added to the output from the StringWriter.

Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=TheFile" + FileDateTime("doc"));
Response.Buffer = true;
Response.ContentType = "application/vnd.word";
Response.Charset = "";
this.EnableViewState = false;

System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
HtmlForm fakeForm = new HtmlForm();
this.Controls.Add(fakeForm);
fakeForm.Controls.Add(gvMine);
fakeForm.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());

Thanks for the help.
RB

Re: Export GridView to Word

minhpc_bk10-Oct-06 15:17

Radio Button in a Repeater Question...Urgent!

10-Oct-06 15:17

You can use the regular expression with the Regex class to get rid of the hidden html markup in the output result (oStringWriter.ToString()) before sending out to the output stream of the Response object.

just3ala210-Oct-06 8:37

10-Oct-06 8:37

Dear All

I have created a repeater and in it i have radio buttons ... I want to get the checked radio buttons from each row, make some calculations then insert the output in a database row by row.
(It's like a survey form that have 5 values for each row "strongly agree .... Do not agree)

If any1 can help me doing that or giving me a clue how to start...

Thanx in advance Smile | :)

-- modified at 7:47 Wednesday 11th October, 2006

Best Regards
3ala2 Smile | :)

minhpc_bk10-Oct-06 15:21

10-Oct-06 15:21

You can walk through the Repeater.Items[^] property to get reference to the radiobutton from each row with the FindControl method, then depending on the checked state of the radio you can decide to insert the row data to DB.

just3ala210-Oct-06 19:48

10-Oct-06 19:48

thanx ... but when i use the find control i get one row data. I want to loop through the whole repeater to get the radio buttons that are checked. How can i do that?

Best Regards
3ala2 Smile | :)

minhpc_bk10-Oct-06 20:04

10-Oct-06 20:04

The Items collection of the Repeater control contains the data RepeaterItem objects only, so if you want to get reference to a radio button or a child control in general in the header, footer, you can use the ItemCreated event of the Repeater control. In this event handler, you can try to access the child control of each item with the FindControl method.

just3ala210-Oct-06 20:32

10-Oct-06 20:32

Guess u didn't get me right.
Now my app is a form like the survey form
each question has five answers options (radio buttons)
i want to save all the user answers (the checked radio buttons only) when the user clicks submit... Is this possibe?

Best Regards
3ala2 Smile | :)

minhpc_bk10-Oct-06 21:53

10-Oct-06 21:53

Okay, am I correct in thinking that you have a repeater control to represent the survey questions, and each question with 5 answers are displayed in the ItemTemplate of the Repeater. You now want to get all the checked radios of the questions in the survey, and to do that you'll have to walk through the Items collection and for each RepeaterItem you get reference to 5 radios and check their checked property to see which one is selected. Another simpler option is that you can use the RadioButtonList instead of 5 seperate radiobuttons, and you can use the SelectedXXX properties of the control to access the selected answer.

just3ala211-Oct-06 0:15

11-Oct-06 0:15

This is exactly what i want Smile | :)

I guess i'll use the radio button way but how to split in 5's in the loop?
i mean can u give me a hint line of code or something to know where to start or what to look for? cause i've been trying to make that loop in more than one way and i couldn't, and the repeater item collection need an ArrayList which i don't have !

I really appreciate your quick response Wink | ;)

Best Regards
3ala2 Smile | :)

minhpc_bk11-Oct-06 2:00

Re: Radio Button in a Repeater Question... [modified]

11-Oct-06 2:00

Basically, with multiple radio buttons you need to set the GroupName property of all 5 buttons to the same value so that the user is only allowed to choose a single item. The RadioButtonList control help you easily define a group of radiobuttons without setting the GroupName and the control will do that for you. For more information on how to use these controls you can see RadioButton and RadioButtonList Web Server Controls[^]

just3ala211-Oct-06 2:26

11-Oct-06 2:26

I know the group prperty but although thisseem silly, i'm new to this...

Now my repeater works fine in only displaying stuff, i meant how to group the 5's in the loop that checks which radiobuttons are checked and which are not.

what loop do i need to get all the controls

i tried this code

Dim rd as RadioButton = e.Item.FindControl("rd...")
this only works if i put a button next to each group (raw). And gives an exception when i tried to use it for all items :s

but if i put a button in the footer template for example it doesn't work Frown | :(

I donno what to do with it!

P.S. the radio button list creates an error when used because i can't give it the Name or Value by using the DataBinder.Eval(...)

-- modified at 8:33 Wednesday 11th October, 2006

Best Regards
3ala2 Smile | :)

minhpc_bk11-Oct-06 2:46

11-Oct-06 2:46

Can you post some code snippets on how to define the repeater control and how to bind data to it?

just3ala211-Oct-06 3:02

11-Oct-06 3:02

Yeah sure man...

<asp:repeater id="rptrPA" runat="server" EnableViewState="False">
<ItemTemplate>
<table style="FONT-WEIGHT: normal; FONT-SIZE: x-small; COLOR:003399; BORDER-TOP-STYLE: none; FONT-FAMILY: Tahoma; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: whitesmoke; BORDER-BOTTOM-STYLE: none" width="100%" border="1">
<tr align="center">
<td width="30%" rowspan="2" valign="top">
<asp:Label ID="lblEF" Font-Name="Tahoma" Runat="server" ForeColor="003399">
<%#DataBinder.Eval(Container.DataItem,"FACTOR_DESC")%></asp:Label></td>

<td width="12%" valign="top">
<asp:radiobutton id="rdNA" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"NA")%>' GroupName="rdGroup"></asp:radiobutton></td>

<td width="12%" valign="top"><asp:radiobutton id="rdBelow" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"BELOW_AVERAGE")%>' GroupName="rdGroup"></asp:radiobutton></td>

<td width="12%" valign="top"><asp:radiobutton id="rdAverage" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"AVERAGE_PERFORMANCE")%>' GroupName="rdGroup"></asp:radiobutton></td>

<td width="12%" valign="top"><asp:radiobutton id="rdAbove" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"ABOVE_AERAGE")%>' GroupName="rdGroup"></asp:radiobutton></td>

<td width="12%" valign="top"><asp:radiobutton id="rdExceeds" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"EXCEEDS_REQUIREMENTS")%>' GroupName="rdGroup"></asp:radiobutton></td>

<tr align="center">
<td width="100%" colspan="6">
<div id="ddd">
<%#DataBinder.Eval(Container.DataItem,"GRADES_DESC")%>
</div>
</td>
tr>
</table>
</ItemTemplate>
<HeaderTemplate>
<table style="FONT-WEIGHT: bold; FONT-SIZE: x-small; COLOR: white; BORDER-TOP-STYLE: none; FONT-FAMILY: Tahoma; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #003399; BORDER-BOTTOM-STYLE: none" width="100%" border="1">
<tr align="center">
<td width="30%">Evaluation Factor</td>
<td width="12%">NA</td>
<td width="12%">Below Average</td>
<td width="12%">Average Performance</td>
<td width="12%">Above Average</td>
<td width="12%">Exceeds Requirements</td>

</tr>
</table>
</HeaderTemplate>
<FooterTemplate>
<table border="0" align="center" width="100%">
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="center">
<asp:Button ID="btnFill" Text="Go" Runat="server" CommandName="Go"></asp:Button></td>
</tr>
</table>
</FooterTemplate>
</asp:repeater>

And in the code behind i made a class to get the questions and options values for the radio buttons from the database.

Now what i need is the code that loops through "all" the repeater and fills anything "array" for example with the results that were made so that i can insert them in the database again. (Guess it should be put in the reapeater item command)

U seem very helpful ... I'm really thankful for u

Best Regards
3ala2 Smile | :)

minhpc_bk11-Oct-06 16:56

11-Oct-06 16:56

Because the button is placed inside the Repeater control, so you can use the ItemCommand event of the control as the Command event of the button is bubbled up to the repeater:

protected void rptrPA_ItemCommand(object source, RepeaterCommandEventArgs e)
{
    if (e.CommandName == "Go")
    {
        foreach (RepeaterItem item in rptrPA.Items)
        {
            if(IsSelected(item, "rdNA"))
                continue;

            if (IsSelected(item, "rdBelow"))
                continue;

            if (IsSelected(item, "rdAverage"))
                continue;

            if (IsSelected(item, "rdAbove"))
                continue;

            if (IsSelected(item, "rdExceeds"))
                continue;
        }
    }
}

private bool IsSelected(RepeaterItem item, string radioButtonID)
{
    RadioButton radioButton = item.FindControl(radioButtonID) as RadioButton;
    if (radioButton.Checked)
    {
        Response.Write(string.Format("Anwser for the question number {0} is {1} <br>", item.ItemIndex + 1, radioButton.Text));
    }

    return radioButton.Checked;
}

just3ala211-Oct-06 20:52

11-Oct-06 20:52

Hi man ...
I donno what to say man
I'm so happy now, i'm really thankful for u. Everything is working fine Wink | ;)

Now i added another column to the repeater, it has a label that shows the factorID (questionID)
i can display it but i can't get it when i use the loop i can't reach it

i thought of a workaround but i don't think it's that good. i would save the checked values in the first dimension of a 2-dimensional array and get the label just in a seperate loop and add the factorID value to the second dimension

Do u think this is fine? or there is a better way?

Best Regards
3ala2 Smile | :)

minhpc_bk12-Oct-06 0:51

12-Oct-06 0:51

just3ala2 wrote:
i can't get it when i use the loop i can't reach it

What do you mean by you can't get it? You cannot access the Label control or the label gives you empty. I don't think you need one loop to access the radios and another loop to access the label control which is also placed in the ItemTemplate.

just3ala212-Oct-06 4:29

12-Oct-06 4:29

I solved that problem Big Grin | :-D

i made 2 loop but guess i'll drop one

Now the final touches ... In my database i save the score for the selected answer (the value of the answer). So how can i load the survey with the old filled data?
i made the sql statement and it works fine but i want the radio button that contains the value that i got from the db to be selected only.

//I want to mark the selcted values in the repeater radio buttons

Thank u very much

Best Regards
3ala2 Smile | :)

minhpc_bk12-Oct-06 15:11

12-Oct-06 15:11

What you need to do is to compare the radio's value with the selected answer and depending on the result you should set the Checked property of the control accrodingly. Basically, there are two options to do what you want:
+ You can use the data binding expression to set the Checked property in the web page aspx, in the expression you can use the ? : operator to compare the values. You can see more about this in MSDN.
+ You can use the ItemDataBound event of the Repeater control to do the checking and setting for the radio button of each RepeaterItem.

just3ala213-Oct-06 6:36