Re: Sql Query Inner Join - ASP.NET Discussion Boards

Re: using root web.config for application folder

Rahul Rajat Singh2-Aug-12 17:52

2-Aug-12 17:52

In fact if you don't provide separate web.config at each folder in your website it will continue to use the web.config of root level.

the folder level web.config is only required when we want some special configuration in any folder otherwise the root web.config should be fine.

Every now and then say, "What the Elephant." "What the Elephant" gives you freedom. Freedom brings opportunity. Opportunity makes your future.

to get the selected column index in a datagrid in a web app

Sh@Sh!K!r@n31-Jul-12 0:08

Sh@Sh!K!r@n

31-Jul-12 0:08

I am working on a web application in visual studio 2008 and have come accross a problem where in i am not able to get the column index of the selected cell. the properties like CurrentCell or SelectedCell are not present.kindly assist me in this regard.

Re: to get the selected column index in a datagrid in a web app

_Amy31-Jul-12 1:30

_Amy

31-Jul-12 1:30

Try this:

private void UsersDataGrid_SelectedIndexChanged(object sender, System.EventArgs e)
{
    LabelInfo.Text = UsersDataGrid.SelectedItem.Cells[1].Text;
}

Refer the links below:
MSDN : DataGrid.SelectedIndex Property [^]

Read the article "Table Valued Parameters".

--Amit

Re: to get the selected column index in a datagrid in a web app

vvashishta1-Aug-12 3:35

vvashishta

1-Aug-12 3:35

Workout on SelectedIndexChanged Event of Gridview, and pick up the SelectedIndex in that Event.

- Happy Coding -
Vishal Vashishta

asp.net session not always timing out within iFrame

djmurphy30-Jul-12 7:38

djmurphy

30-Jul-12 7:38

We have a web page designed to be embedded in an iFrame on a different host web site.

The session timeout in web.config for the iFrame page is 20 minutes.

In our testing, the iFrame page times out as expected in various browsers like IE, Chrome, Safari and with IE8/XP and IE9/Win7.

A customer with a classic asp site has embedded our web page in an iFrame on their site. OUr iFrame web page refuses to time out for them except for certain browsers. THey feel they have narrowed it down to IE in Win7 and Vista. It works otherwise. Confused | :confused:

Any idea why this might be happening? The customer indicates they aren't doing anything to refresh the page and it seems to only happen with IE.

Thanks in advance, Dan

Re: asp.net session not always timing out within iFrame

Vijay Selvaraj27-Aug-12 0:22

Vijay Selvaraj

27-Aug-12 0:22

you put TImer function in that timer funcation call Every 10 mins to IFrame control using Javascripts

Sql Query Inner Join

Samii4929-Jul-12 23:10

Samii49

29-Jul-12 23:10

How to use inner join in stored procedure..?
And use that data to show up in dropdownlist on my page..?

Re: Sql Query Inner Join

Karthik Harve30-Jul-12 1:04

Karthik Harve

30-Jul-12 1:04

Hi,

check these links to understand about INNER JOIN

http://sqltutorials.blogspot.in/2007/05/sql-inner-join-left-join-and-right-join.html[^]
http://www.w3resource.com/sql/joins/perform-an-inner-join.php[^]

So, use those concepts and frame the query which 1 or more columns for dropdownlist as DataMember and Value member.

Vande Matharam - Jai Hind

Re: Sql Query Inner Join

vvashishta1-Aug-12 3:37

vvashishta

1-Aug-12 3:37

INNER JOIN Table2 t2 ON t1.Column = t2.Column

and then take result from SP to a Dataset or Datatable and use .DataSource property of DropdownList

- Happy Coding -
Vishal Vashishta

Re: Sql Query Inner Join

Samii492-Aug-12 18:55

Samii49

2-Aug-12 18:55

Thanxxzz ..!!
This one helped me .. Smile | :)

Classic ASP

rock_monu28-Jul-12 0:17

rock_monu

28-Jul-12 0:17

How to hide url path in classic asp..?? Confused | :confused:

Re: Classic ASP

Sandeep Mewara29-Jul-12 8:56

Sandeep Mewara

29-Jul-12 8:56

Go through this: URL Rewriting (Classic ASP)[^]

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

ValidationSummary not displaying RegularExpressionValidator results?

jojoba201127-Jul-12 20:05

jojoba2011

27-Jul-12 20:05

I have a page with a few validation controls and a ValidationSummary control. Most of the validation controls are RequiredFieldValidator controls and the summary control displays these messages just fine.

I do have a RegularExpressionValidator that checks for the format of an email address. If the address isn't entered correctly my error message from this control isn't being displayed by my summary control.

I know the problem isn't with my regular expression as I can display the error message by the regex control if I change the Display setting.

ValidationSummary doesn't just work with RequiredFieldValidator does it? That would be less than helpful.

My code :

ASP

<asp:ValidationSummary ID="ValidationSummary1" ValidationGroup="Test" HeaderText="You must enter a value in the following fields:"
            DisplayMode="BulletList" EnableClientScript="False" runat="server" />

ASP

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ValidationGroup="Test" ControlToValidate="txtReqDuration"
                   ErrorMessage="Enter a valid number" Display="None" ValidationExpression="^([\d]{0,2})$"></asp:RegularExpressionValidator>

Thanks.

Re: ValidationSummary not displaying RegularExpressionValidator results?

_Amy31-Jul-12 1:34

_Amy

31-Jul-12 1:34

Hi,
Set the DisplayMode="Dynamic" and remove EnableClientScript attribute from your ValidationSummary.

Read the article "Table Valued Parameters".

--Amit

I want to create a Word document with dynamic graphs inserted

Lmathew27-Jul-12 0:29

Lmathew

27-Jul-12 0:29

I want to create a Word document with dynamic graphs (OpenFlashChart which is a third party control) on the asp.net page.

Is it possible to do it in asp.net.ON bank sites, i have seen different graphs get generated for each quarter in a word document.

SQL QUERY

rock_monu26-Jul-12 20:04

rock_monu

26-Jul-12 20:04

how to fire two select query together on empid basis with inner join..???

Re: SQL QUERY

Sandeep Mewara26-Jul-12 21:14

Sandeep Mewara

26-Jul-12 21:14

Use SQL Transactions or Stored Procedure to execute multiple queries in a batch.

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

Re: SQL QUERY

vvashishta1-Aug-12 3:38

vvashishta

1-Aug-12 3:38

Clearify your question again.. give us the scenario.

- Happy Coding -
Vishal Vashishta

Re: SQL QUERY

Vijay Selvaraj27-Aug-12 0:23

Vijay Selvaraj

27-Aug-12 0:23

you can use subquery..

Intelligencia.UrlRewriter

Jassim Rahma26-Jul-12 10:43

Jassim Rahma

26-Jul-12 10:43

I am using Intelligencia.UrlRewriter to rewite URLs, it works fine with root folder but with my sub folder /r it it doesn't work.. here is an example:

this is for my root about.aspx:

<rewrite url="~/about" to="~/about.aspx" />

and that's working perfect..

and here is my about.aspx in my arabic folder /ar/about.aspx:

<rewrite url="~/ar/about" to="~/ar/about.aspx" />

and when i try www.rmc.bh/ar/about it should go to www.rmc.bh/ar/about.aspx but it's actually going to www.rmc.bh/about.aspx

where is the problem?

Re: Intelligencia.UrlRewriter

Deflinek30-Jul-12 4:53

Deflinek

30-Jul-12 4:53

url part is handled as regualar expression. Try to set explicit boundaries for it using ^ and $ characters:

HTML

<rewrite url="^~/about$" to "~/about.aspx" />
<rewrite url="^~/ar/about$" to "~/ar/about.aspx" />

--
"My software never has bugs. It just develops random features."
http://www.naszeklocki.pl

best way to url rewrite

Jassim Rahma26-Jul-12 8:25

Jassim Rahma

26-Jul-12 8:25

Hi,

I am new to URL rewite, I want to know how and what's the best and easiest way to do it?

Are there any APIs or components which does the job or it's pior coding?

Re: best way to url rewrite

fjdiewornncalwe26-Jul-12 9:12

fjdiewornncalwe

26-Jul-12 9:12

Is google not working where you are today?
url rewrite[^]
got me 4.4 million results and looks like a great way to find reliable information.

I wasn't, now I am, then I won't be anymore.

Re: best way to url rewrite

Jassim Rahma26-Jul-12 9:35

Jassim Rahma

26-Jul-12 9:35

in this case this forums should be closed because google has answers for all questions here!

Re: best way to url rewrite

jkirkerx26-Jul-12 12:35

jkirkerx

26-Jul-12 12:35

I could of swore you asked a similar question somewhere else in CJ. I think it was a quick question, it which you were using asp.net framework 4.0, and you were not able to partially implement url rewriting.

There's no magic wand for url rewriting. It's difficult to implement, and requires full planning from the start, you can't just drop it in and go, for it is a combination of your asp.net code and work on behalf of server IIS 7.5 and up.

The server has to be able to pick up the rewrite, and your code has to translate it, and then your code has to create it, and pump it back out to the server. It's bi-directional in design.

I gave you some of the pieces for it, to get started, but help for full implementation requires more time than I'm willing to give here on the CJ, short of just writing a complete how-to on it.

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