ASP.NET

Re: How to check the database the given value is in the database or not

10-Oct-06 20:16

What you need to do is to read the ADO.NET[^] tutorials to see how to connect to DB and execute a simple query with a simple where clause to check this thing.

dhulipudi31-Oct-06 18:37

dhulipudi

31-Oct-06 18:37

Thank Q

hai all please clarify mny doubts

Masterpage and Content page

Ken.A10-Oct-06 15:02

10-Oct-06 15:02

Hi. Regarding the relation between a Masterpage and some Content page I believe that sometimes it´s a bit difficult to decide where is the best place (Master or Content page) to put a Control. For example, I have a set of menu items (from a Menu control) that are displayed as Tabs. Suppose I have only 3 menu items that I call AAA,BBB,CCC ... when I click in AAA it should call the A.aspx page, the BBB > B.aspx and CCC > C.aspx ... The Menu control is in the masterpage named Master.master and A.aspx, B.aspx and C.aspx use this master page. I can think of 2 alternatives when building this Menu Items:

1st > I set the url attribute like AAA > url="~/A.aspx" and similar to the other menu items ... so when I click in any of these menu items I´ll be directed to the respective url

or

2nd > I don´t use the url attribute and catch the OnMenuItemClick event and then create code to switch to the proper url

Since I´m using Tabs, it would be nice to set the 'Active or Selected' Tab after the user clicks it. In the 2nd approach I can set the e.Item.Selected = true; but the Css used to mark the selected item will not work because after the click, the current page will be redirected to the proper page and the selected item will not be selected anymore. So I´ll have to end up creating complex code just to mark the selected item, probably in the current page (A,B or C.aspx) referencing the Menu control in the master page.

I believe there is a simple approach to this situation. What is the best way to set the selected/active tab? This is not hard when using plain html pages, but this master/content page relation are a bit confusing ... I already read this interesting article: http://www.dotnetslackers.com/XML/re-27950_Capture_Master_Page_Events_in_Content_Pages_ASP_NET_2_0.aspx, but I think there must have a simple approach to this situation which unfortunately I just don´t get.

minhpc_bk10-Oct-06 20:10

10-Oct-06 20:10

Because you go from the current page to a new one when a menu item is clicked, so the ViewState of the selected item gets lost, and IMO you may only need to write code in the Master Page to set the selected item of the menu control. All three pages use the same Master Page, so you don't need to write code to set the selected menu item in each web page. Another option might be that you can use a single web page instead of 3, and because you don't go to the new page so the selected menu item is persisted.

Ken.A10-Oct-06 22:41

10-Oct-06 22:41

Hi minhpc_bk,

You pointed 2 options:

1st: the one I´m using,eg navigating from current page to another, but with this option as you said, the ViewState of the selected item gets lost. What´s the solution for this option? Considering I want to navigate from one page to another ... Will I have to target the master page menu from each of the pages? That´s not a good solution ... too much coding

2nd: To use a single web page instead of 3, but this way I believe I´ll have to have views/panels hidden and showed according to the selected tab, right? This turn to concentrating too much logic in a single page. Suppose I have 100 tabs!!!

minhpc_bk11-Oct-06 1:54

11-Oct-06 1:54

Sohdubom wrote:
What´s the solution for this option? Considering I want to navigate from one page to another ... Will I have to target the master page menu from each of the pages? That´s not a good solution ... too much coding

Because you define the menu control in the Master Page and all the web pages use this Master Page, so I think you only need to write code to set the selected menu item in the master page only and no need to do that from each content page. For example, you have 3 web pages A.aspx, B.aspx, C.aspx and the menu control in the master page is defined with 3 items accordingly. At run time you can detect the url of the current requested page by checking the Request object or SiteMap (if you define web.sitemap file), you then can set the Selected propety of the right menu item. The sample code to select the menu item in the master page looks something like:

//You can either use the Request object or SiteMap to determine
//the current url.
//string url = SiteMap.CurrentNode.Url;
string url = Request.Url.AbsoluteUri;

if (url.Contains("A.aspx"))
    Menu1.Items[0].Selected = true;
else if(url.Contains("B.aspx"))
    Menu1.Items[1].Selected  = true;
else
    Menu1.Items[2].Selected = true;

Sohdubom wrote:
To use a single web page instead of 3, but this way I believe I´ll have to have views/panels hidden and showed according to the selected tab, right? This turn to concentrating too much logic in a single page. Suppose I have 100 tabs!!!

You're right, this option should only be used when you have just a few web pages.

Ken.A11-Oct-06 3:26

11-Oct-06 3:26

In my masterpage code behind, where should I put the code above? I´m asking it because, when creating a menu I have basically 2 options: if I set prior the url for each menu item then I will not be able to use the OnMenuItemClick event, if I want to use that event I must secify menu items without the url and with the selectable attribute set to true. My menu is built using a custom sitemap provider and it renders like:

If the intention is to use OnMenuItemClick then the render code will be:

Using the option above I can make the selectable link like:

minhpc_bk11-Oct-06 16:19

11-Oct-06 16:19

The sample code is used to set the Selected property of an item in the Menu Items collection, and this collection is built based on data bound to it, so you can use this code when data is bound to the menu control or after that. And one of events that you can put the sample code in is the MenuItemDataBound which is fired after a MenuItem is databound and you can check this item is selected or not. The sample code looks something like.

protected void Menu2_MenuItemDataBound(object sender, MenuEventArgs e)
{
    string url = Request.Url.AbsoluteUri;
	//Here I simply compare the url of the current request 
	//with the Text property of the Menu item.
    e.Item.Selected = url.Contains(e.Item.Text);        
}

You mean you use the AspNet-Menu-Link AspNet-Menu-Selected stylesheet class to set the selected menu item? If so, once you can keep the selected item as it is with code, the style class will be applied.

Ken.A11-Oct-06 23:51

display image in asp image control

11-Oct-06 23:51

Hi minhpc_bk,

That solved the issue in a simple way. I just changed the comparison to:

e.Item.Selected = url.Contains( e.Item.NavigateUrl.Remove( 0, 1 ) );

Because this way I don´t have to set the name of the page (navigate url) based on its title attribute, eg: url = "~/microsoft.com" and title="... Microsoft"

I can do something like: url = "~/a.com" and title="... Microsoft"

Then the string url = Request.Url.AbsoluteUri; > http://.../a.com will be compared to: e.Item.NavigateUrl.Remove( 0, 1 ) > "/a.com"

But either way, you gladly solved the problem!!!
Thanks for the patience Smile | :)

saravanan0510-Oct-06 12:07

saravanan05

10-Oct-06 12:07

hi friends

i stored 10 image in database like this (for ex images\logos\country\INN9.gif )

now i want to retrieve the image and display in asp image control

here one condition i have 10 buttons for 10 image i click corresponding button that image will be displayed in asp:image control

can anyone tell me

thanks in advance

regards

saravanan

Re: display image in asp image control

minhpc_bk10-Oct-06 15:09

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